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 —
At a glance
Track student attendance from CSV, email parents, and build an HTML dashboard is a ready-made n8n workflow you import as a workflow JSON file — no build required. It connects UNSUPPORTED_SLUG_FORMAT. It's free to download. Follow the 5-step import below to go live in minutes.
- Platform
- n8n
- Connects
- UNSUPPORTED_SLUG_FORMAT
- Modules
- 18
- Price
- Free
- Version
- v1.0

About this workflow
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) --- 🔧 Required CSV formats studentattendance.csv | StudentID | Date | Status | Class | Subject | Teacher | |-----------|------|--------|-------|---------|---------| | S101 | 12-01-2026 | Absent | Grade 6 | Math | Mr Singh | studentcontacts.csv | StudentID | ParentName | Email | Phone | |-----------|------------|-------|-------| | S101 | Anita Kumar | parent@email.com | +919999999999 | 📊 Dashboard Preview
How to import this n8n workflow
- 1
Download the workflow JSON file after purchase.
- 2
Open n8n → click the menu → Import from File.
- 3
Select the downloaded JSON and import.
- 4
Set up credentials for each node that requires them.
- 5
Click Execute Workflow to test, then activate.
Setup guide
Setup guide included
Purchase to unlock the full step-by-step guide
Related N8n workflows
Create a REST API for PDF digital signatures with webhooks
Register notes in Capsule CRM new Toky calls
Close tickets faster 🛠️ Zammad tool MCP server 💪 all 20 operations
Create Pipefy cards from new Copper leads
Upload File to SharePoint Using Microsoft Graph API
Build your own N8N workflows MCP server
Automated 🤖🎵 AI music generation with ElevenLabs, Google Sheets & Drive
Automate data extraction with Zyte AI (Products, Jobs, Articles & More)
Reviews
No reviews yet
Be the first to buy and share your experience.
Leave a review
Sign in to share your experience with this workflow.
Create a free account to purchase workflows.
- JSON blueprint — instant download
- Setup guide PDF included
- 5 downloads · valid 30 days
- Works with n8n
Need help setting this up?
Book a 3-hour live setup session with an Agility consultant.
- Configure live on Google Meet / Zoom
- Free follow-up if workflow has defects
- Platform expert assigned to you