AutomationMart
Home/Browse/Track student attendance from CSV, email parents, and build an HTML dashboard
n8n

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

n8nn8n18 modulesv1.0
UNSUPPORTED_SLUG_FORMAT

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
Track student attendance from CSV, email parents, and build an HTML dashboard workflow diagram

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

n8n

How to import this n8n workflow

  1. 1

    Download the workflow JSON file after purchase.

  2. 2

    Open n8n → click the menu → Import from File.

  3. 3

    Select the downloaded JSON and import.

  4. 4

    Set up credentials for each node that requires them.

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

Overview An automation workflow that creates a complete REST API for digitally signing PDF documents using n8n webhooks. This service demonstrates how to implement secure document signing functionality through standardized API endpoints with file upload and download capabilities. Use Case This workflow is designed for developers and automation specialists who need to implement digital document signing. It's particularly useful for: - Integrating PDF signing capabilities into existing document wo

Free

Register notes in Capsule CRM new Toky calls

Every time a new call is received on Toky, Make will automatically create a new note (entry) in Capsule CRM.

Free

Close tickets faster 🛠️ Zammad tool MCP server 💪 all 20 operations

Need help? Want access to this workflow + many more paid workflows + live Q&A sessions with a top verified n8n creator? Join the community Complete MCP server exposing all Zammad Tool operations to AI agents. Zero configuration needed - all 20 operations pre-built. ⚡ Quick Setup 1. Import this workflow into your n8n instance 2. Activate the workflow to start your MCP server 3. Copy the webhook URL from the MCP trigger node 4. Connect AI agents using the MCP URL 🔧 How it Works • MCP Trigger: Serv

Free

Create Pipefy cards from new Copper leads

Every time a new lead is created in Copper, Make will automatically create a new card in Pipefy.

Free

Upload File to SharePoint Using Microsoft Graph API

This n8n workflow template allows you to upload a photo to a SharePoint folder using the Microsoft Graph API. The workflow includes steps for authentication, retrieving a photo for testing purposes, setting the destination folder and file name, and uploading the photo. Who is this for? This workflow is ideal for users who need to automate the process of uploading images to SharePoint. It is particularly useful for developers, IT administrators, and anyone managing digital assets within a SharePo

Free

Build your own N8N workflows MCP server

This n8n template shows you how to create an MCP server out of your existing n8n workflows. With this, any MCP client connected can get more done with powerful end-to-end workflows rather than just simple tools. Designing agent tools for outcome rather than utility has been a long recommended practice of mine and it applies well when it comes to building MCP servers; In gist, agents to be making the least amount of calls possible to complete a task. This is why n8n can be a great fit for M

Free

Automated 🤖🎵 AI music generation with ElevenLabs, Google Sheets & Drive

This workflow automates the creation, storage, and cataloging of AI-generated music using the Eleven Music API, Google Sheets, and Google Drive. --- Key Advantages ✅ Fully Automated Music Generation Pipeline Once started, the workflow automatically: Reads track parameters Generates music via API Uploads the file Updates your spreadsheet No manual steps needed after initialization. ✅ Centralized Track Management

Free

Automate data extraction with Zyte AI (Products, Jobs, Articles & More)

Automated AI Web Scraper This workflow uses the Zyte API to automatically detect and extract structured data from E-commerce sites, Articles, Job Boards, and Search Engine Results (SERP) - no custom CSS selectors required. It features a robust "Two-Phase Architecture" (Crawler + Scraper) that handles pagination loops, error retries, and data aggregation automatically, ens

Free

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.

Log in to review
Free
No ratings yet

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.

₹2,499/ session
3 hrs · video call
  • Configure live on Google Meet / Zoom
  • Free follow-up if workflow has defects
  • Platform expert assigned to you
Book installation session
Free