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

⚡ 501 views · 🔧 Miscellaneous

Description

🚀 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 needed.

⚙️ How it works

1. Schedule trigger — runs Monday–Friday at 17:30
2. Data ingestion — reads student_attendance.csv and filters to today’s records only
3. Absence check — splits students into Absent / Present branches
4. Contact merge — matches absent students with parent data from student_contacts.csv
5. Alert logic — calculates risk level, attendance %, consecutive streak, and trend (Improving / Stable / Worsening)
6. Parent email — sends a colour-coded HTML alert via SMTP for each absent student
7. Dashboard builder — generates dashboard.html with 5 tabs: Today, Weekly, Monthly, Full History, and At-Risk
8. Report update — appends records to attendance_report.csv for historical tracking

🛠 Setup steps

1. Upload student_attendance.csv to the n8n files folder
2. Upload student_contacts.csv to the n8n files folder
3. Create an empty attendance_report.csv in the n8n files folder
4. Add smtp_user in Settings → Variables
5. Configure SMTP credentials in the Send Email node
6. Adjust the cron schedule if needed (default: 17:30 Mon–Fri)

🔧 Required CSV formats

student_attendance.csv

student_contacts.csv

📊 Dashboard Preview

🔗 Nodes Used

Send Email, Spreadsheet File, Schedule Trigger, Filter, Read/Write Files from Disk, Convert to File

📥 Import

Download workflow.json and import into n8n: Workflow menu → Import from File

📖 Importing guide · 🔑 Credential setup