Attendance analytics: a chat summary, alerts by email
The scenario regularly merges the timesheet and the employee directory from таблица, computes the numbers, posts a summary to Google Chat and emails SendGrid when something serious shows up.
- Timesheet and staff data merged automatically
- Departments and habitual lateness become visible
- No empty summaries land in your chat
- A history of totals builds up in таблица
Google Sheets
Made with Scriptera