Attendance Exceptions to Managers (Excel)
Every workday morning, reads the attendance export from your Excel table, picks the employees marked Late or Absent, and emails each one's manager. No employee is contacted directly.
Steps in this flow
- Every workday 9:00
- Excel: read today's attendance
- Name the columns
- For each attendance row
- Late or absent?
- Email the manager
- Record the notice