Track student attendance from CSV, email parents, and build an HTML dashboard — n8n 工作流
概览
🚀 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
Schedule trigger — runs Monday–Friday at 17:30 Data ingestion — reads student_attendance.csv and filters to today's records only Absence check — splits students into Absent / Present branches Contact merge — matches ab
使用的节点
Send EmailCode
工作流预览
No Absences Today
⚡
R
Recurring Time Trigger
S
Student Attendance Data
E
Extract Attendance CSV
I
IF: Is Absent?
S
Students Contacts
E
Extract Contacts CSV
M
Merge Absent + Contacts
Alert Logic Block
Generate Absence Email
Build Dashboard and Report
Send Email
E
Existing Report History
E
Extract History CSV
Combine History + Build …
C
Convert Data
B
Build Visual Report and …
D
Date Filter
18 nodes19 edges
工作原理
- 1
触发器
工作流由 定时 触发器启动，按预定计划运行。
- 2
处理
数据流经 18 个节点, connecting code, converttofile, emailsend。
- 3
输出
工作流完成自动化并将结果发送到配置的目标。
节点详情 (18)
SE#1
Send Email
emailSend
CO#2
Code
code
如何导入此工作流
- 1点击右侧 下载 JSON 按钮保存工作流文件。
- 2打开你的 n8n 实例，依次点击 工作流 → 新建 → 从文件导入。
- 3选择下载的
track-student-attendance-from-csv-email-parents-and-build-an-html-dashboard文件并点击导入。 - 4为每个服务节点配置 凭证（API 密钥、OAuth 等）。
- 5点击 测试工作流 验证一切正常，然后激活它。
或直接在 n8n → 从 JSON 导入 中粘贴：
{ "name": "Track student attendance from CSV, email parents, and build an HTML dashboard", "nodes": [...], ...}
集成
codeconverttofileemailsendfilterifmergereadwritefilescheduletriggerspreadsheetfile
创建者
Tejasv Makkar
@tmakkar
标签
codeconverttofileemailsendfilterifmergereadwritefilescheduletriggerspreadsheetfile