Track repeat absences and send approval-based alerts via Google Sheets and Gmail

by AYLA BATOOL ✓ · 2 views · created 2026-09-27 · Document Extraction

What this workflow does

This workflow has 12 nodes and runs on a schedule (cron 0 8 * * 1-6). Along the way it connects Google Sheets and Gmail.

How it runs

Trigger: On a schedule (cron 0 8 * * 1-6).

1. Read Attendance from Google Sheets (Google Sheets): uses Google Sheets
2. Calculate Absence Thresholds (Code): runs custom JavaScript code
3. Build Approval Batch (Code): runs custom JavaScript code
4. Request Administrator Approval (Gmail): send and wait for a reply
5. Is Initial Approval Granted (If): checks a condition and branches into true / false
6. Merge: merges the data from its input branches
7. Retry Approval Request (Gmail): send and wait for a reply
8. Send Approved Gmail Notifications (Gmail): uses Gmail
9. Is Retry Approved (If): checks a condition and branches into true / false
10. Log Approval Outcome (Code): runs custom JavaScript code

…plus 1 more step. See the full node list below.

Services it uses

Google SheetsGmail

Before you upgrade to n8n 3.0

Nodes used (6)

• Schedule Triggern8n-nodes-base.scheduleTrigger
• Google Sheetsn8n-nodes-base.googleSheets
• Coden8n-nodes-base.code
• Gmailn8n-nodes-base.gmail
• Ifn8n-nodes-base.if
• Mergen8n-nodes-base.merge

From the author

Quick overview This workflow runs every morning at 8:00 (Mon–Sat, Asia/Karachi), reads attendance records from Google Sheets, detects repeat absences based on consecutive days and monthly totals, and sends a Gmail approval request to an administrator before…

View the original on n8n.io → Check your own copy