Track employee attendance with analytics, email reports & Slack alerts using Google Sheets
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
What this workflow does
This workflow has 11 nodes and runs on a schedule (every hour). Along the way it connects Google Sheets and Slack.
How it runs
Trigger: On a schedule (every hour).
- Fetch Attendance Records (Google Sheets): uses Google Sheets
- Fetch Employee Master Data (Google Sheets): uses Google Sheets
- Analytics Engine (Code): runs custom JavaScript code
- Records Available (If): checks a condition and branches into true / false
- Critical Alerts (If): checks a condition and branches into true / false
- Format Slack (Code): runs custom JavaScript code
- Log Summary (Google Sheets): append
- Format Email (Code): runs custom JavaScript code
- Post to Slack (Slack): uses Slack
- Send Email: sends an email over SMTP
Services it uses
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (6)
- Schedule Trigger
n8n-nodes-base.scheduleTrigger - Google Sheets
n8n-nodes-base.googleSheets - Code
n8n-nodes-base.code - If
n8n-nodes-base.if - Send Email
n8n-nodes-base.emailSend - Slack
n8n-nodes-base.slack
From the author
Transform your attendance management with this enterprise-grade automated workflow featuring AI-powered analytics, multi-dimensional insights, and intelligent alerting. Running hourly, it integrates multiple data sources (attendance logs + employee master…