Track Student Attendance with Mobile App, Google Sheets & Email Alerts

This n8n workflow automates student attendance tracking by receiving check-in data from a mobile app or QR code scanner via a webhook trigger. It formats the incoming JSON data (e.g., student name, ID, class), appends or updates a row in a Google Sheet with timestamped entries, sends an instant email notification to the class teacher, and returns a success response to the app.

Key benefits include real-time visibility for educators, reduced manual entry errors, and seamless integration without coding. It's lightweight, scalable for multiple classes, and ensures data persistence in a familiar spreadsheet format for easy reporting and analysis.

Use cases: Schools and tutoring centers for daily attendance, event check-ins, or hybrid learning environments. Setup requires a public n8n instance, Google Sheets with predefined columns, and SMTP email credentials. Example input: {'student_name': 'Aarav Mehta', 'student_id': 'STU025', 'class_name': 'Grade 6B'} generates a sheet row like | Aarav Mehta | STU025 | Grade 6B | 2025-08-06 | 08:35 |.