n8n Attendance Alerts: Google Sheets Repeat Absences + Gmail Approval

n8n Attendance Alerts: Google Sheets Repeat Absences + Gmail Approval

This n8n workflow automatically checks student attendance every morning, detects repeat absences from Google Sheets, and then sends an administrator-approved alert batch to parents and teachers via Gmail.

What this workflow does

• Scheduled run: Triggers at 08:00 (Mon–Sat) using the Asia/Karachi timezone.
• Reads attendance data: Fetches the latest attendance rows from a Google Sheets spreadsheet (from Sheet1) using formatted values.
• Calculates absence patterns: For each student marked absent today, it computes:
  • Consecutive school-day absence streak (skips Sundays and any configured holidays).
  • Total absences in the current month.
• Generates alerts with thresholds: Creates reminder/warning items when students reach:
  • 3 consecutive absences (reminder)
  • 5 absences in the month (warning)
  It also suppresses repeats if the sheet’s notification field already contains the corresponding threshold marker.
• Administrator approval via Gmail: Builds one batch message and sends a Gmail “send and wait” approval request to the administrator before any notifications go out.
• Approval outcomes: If approved, the workflow emails the approved batch to parents and teachers (and the administrator). If not approved, it sends a retry approval request; if the retry is also not approved, it escalates to the administrator.

Use cases

• Schools that want automated, rules-based attendance escalation without spamming guardians.
• Education ops teams that require human confirmation before parent/teacher notifications.
• Operators running n8n to manage compliance-style approval flows using Gmail.

Technical details

• Integrations / nodes: Schedule Trigger, Google Sheets, Code, if, Gmail.
• Configuration: Add Google Sheets OAuth2 credentials, set the correct Attendance Google Sheet ID, ensure data is on Sheet1, and include the required sheet headers for processing.
• Core logic: Streak counting (skipping Sundays + configured holidays) and monthly absence totals with threshold-based suppression.