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

> 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 emailing the approved notification batch to parents and teachers. How it works 1. Runs on a scheduled trigger at 08:00 Monday–Saturday. 2. Reads the latest attendance rows from a Google Sheets spreadsheet (Sheet1) using formatted values. 3. Calculates, for each student marked absent today, their consecutive school-day absence streak (skipping Sundays and configured holidays) and their total absences in the current month. 4. Creates alert items when a student reaches 3 consecutive absences (reminder) and/or 5 absences in the month (warning), suppressing repeats if the sheet’s notification field already includes the threshold marker. 5. Builds a single batch message with all alerts and sends a Gmail “send and wait” approval request to

- **Domain**: `n8n-workflow-19978.n8n.io`
- **Provider**: n8n.io (https://n8n.io)
- **Kind**: workflow
- **Live-responds (last probe)**: None
- **Signed card**: False
- **Streaming**: False
- **Quality score**: 40%

## URLs
- Agent card: https://n8n.io/workflows/19978
- Page (HTML): https://agenstry.com/agents/n8n-workflow-19978.n8n.io
- Documentation: https://n8n.io/workflows/19978