This n8n workflow automates the process of tracking student attendance, identifying unexcused absences, and sending timely alerts to parents via email and WhatsApp. Scheduled daily at 10:30 AM, it reads attendance records and student contact information from Excel files stored in Microsoft Excel. The workflow then processes the data to identify students absent without valid reasons and calculates recent absence patterns to determine alert levels: High, Medium, or Low. Based on these alerts, personalized notification emails and WhatsApp messages are generated and sent to parents, ensuring prompt communication. Additionally, the system compiles a comprehensive daily attendance report, highlighting at-risk students, overall absence statistics, and pattern insights, which is stored in an Excel workbook for ongoing monitoring. This workflow is especially useful for schools aiming to improve attendance management, proactively address attendance issues, and maintain detailed records for administrative and parent communication purposes.
Automated Student Absence and Attendance Tracking System
| Node Count | 11 – 20 Nodes |
|---|---|
| Nodes Used | code, emailSend, httpRequest, microsoftExcel, scheduleTrigger, stickyNote |
Be the first to review “Automated Student Absence and Attendance Tracking System”
Reviews
There are no reviews yet.