Student absence alerts via email & WhatsApp with attendance tracking

by Oneclick AI Squad ✓ · 1,440 views · created 2025-08-06 · Document Extraction

What this workflow does

This workflow has 10 nodes and runs on a schedule (every day at 10:00). Along the way it connects Microsoft Excel 365. It also calls graph.facebook.com over HTTP.

How it runs

Trigger: On a schedule (every day at 10:00).

1. Read Today's Attendance (Microsoft Excel 365): work with worksheet
2. Read Student Contacts (Microsoft Excel 365): work with worksheet
3. Process Absent Students (Code): runs custom JavaScript code
4. Prepare Absence Email (Code): runs custom JavaScript code
5. Prepare Absence SMS (Code): runs custom JavaScript code
6. Generate Attendance Report (Code): runs custom JavaScript code
7. Send Absence Email (Send Email): sends an email over SMTP
8. Send Absence WhatsApp (HTTP Request): calls graph.facebook.com
9. Save Attendance Report (Microsoft Excel 365): append (worksheet)

Services it uses

Microsoft Excel 365

HTTP calls to: graph.facebook.com

Before you upgrade to n8n 3.0

Nodes used (5)

• Schedule Triggern8n-nodes-base.scheduleTrigger
• Microsoft Excel 365n8n-nodes-base.microsoftExcel
• Coden8n-nodes-base.code
• Send Emailn8n-nodes-base.emailSend
• HTTP Requestn8n-nodes-base.httpRequest

From the author

📘 Student Absence Alerts & Attendance Tracking Automation Automatically alerts parents about student absences and tracks 30-day attendance patterns to identify risks and trends. 🔧 Main Components Daily Attendance Check – 10:30 AM Triggers the workflow every…

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