Fixed-Term Contract Radar (Google Sheets)
Every Sunday, reads your contracts sheet and finds fixed-term contracts ending within 60 days that have no decision yet. HR gets one email per contract and types the renew-or-end decision into the sheet.
Steps in this flow
- Every Sunday 8:00
- Google Sheets: read contracts
- For each contract
- No decision yet?
- Ends within 60 days?
- Email HR: contract decision needed