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

🚀 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 studentattendance.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 studentcontacts.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 attendancereport.csv for historical tracking

---

🛠 Setup steps

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