Mandatory Training Tracker (Google Sheets)
Every Sunday, reads your training sheet, emails employees whose mandatory course is due within 14 days, and also emails the manager when it is overdue. Every reminder is written to a log tab.
Steps in this flow
- Every Sunday 9:00
- Google Sheets: read pending courses
- For each pending course
- Due within 14 days?
- Email the employee
- Google Sheets: log the reminder
- Already overdue?
- Email the manager