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 —
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.

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
Download the workflow JSON file after purchase.
Open n8n → click the menu → Import from File.
Select the downloaded JSON and import.
Set up credentials for each node that requires them.
Click Execute Workflow to test, then activate.
Setup guide included
Purchase to unlock the full step-by-step guide
Discover business leads with Gemini, Brave Search and web scraping
Analyze Landing Page with OpenAI and Get Optimization Tips
Prevent duplicate webhook executions with AARI idempotency gate
Generate trend-based marketing videos with Seedance AI, Perplexity, and GPT
Build a knowledge base chatbot with Jotform, RAG Supabase, Together AI & Gemini
Gmail smart auto-responder with GPT-4o and Google Drive context memory
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.
Need help setting this up?
Book a 3-hour live setup session with an Agility consultant.