Track student attendance from CSV, email parents, and build an HTML dashboard

by Tejasv Makkar ✓ · 488 views · created 2026-03-15 · Miscellaneous, AI Summarization

What this workflow does

This workflow has 18 nodes and runs on a schedule (cron 30 17 * * 1-5). It uses only n8n's built-in nodes.

How it runs

Trigger: On a schedule (cron 30 17 * * 1-5).

1. Student Attendance Data (Read/Write Files from Disk): reads a file from disk
2. Extract Attendance CSV (Spreadsheet File): reads or writes a spreadsheet file (legacy node)
3. Date Filter (Filter): keeps only the items that match a condition
4. If: checks a condition and branches into true / false
5. Students Contacts (Read/Write Files from Disk): reads a file from disk
6. Merge: merges the data from its input branches
7. No Absences Today (Code): runs custom JavaScript code
8. Extract Contacts CSV (Spreadsheet File): reads or writes a spreadsheet file (legacy node)
9. Alert Logic Block (Code): runs custom JavaScript code
10. Existing Report History (Read/Write Files from Disk): reads a file from disk

…plus 7 more steps. See the full node list below.

Before you upgrade to n8n 3.0

Nodes used (9)

• Coden8n-nodes-base.code
• Schedule Triggern8n-nodes-base.scheduleTrigger
• Read/Write Files from Diskn8n-nodes-base.readWriteFile
• Spreadsheet Filen8n-nodes-base.spreadsheetFile
• Ifn8n-nodes-base.if
• Mergen8n-nodes-base.merge
• Send Emailn8n-nodes-base.emailSend
• Convert to Filen8n-nodes-base.convertToFile
• Filtern8n-nodes-base.filter

From the author

🚀 Overview Automatically monitors daily student attendance from CSV files, identifies absent students, sends parent email alerts via SMTP, calculates risk scores, and generates an interactive HTML dashboard — all on a weekday schedule with no manual work…

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