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

Description

A lightweight no-code workflow that captures student check-in data via a mobile app or webhook, stores it in a Google Sheet, and instantly notifies the class teacher via email.

🎯 What This Does

Students check in using a mobile app or QR code
Their data is formatted and saved to a Google Sheet
A notification email is sent to the class teacher in real time

🔧 Workflow Steps

| Step | Description |
| ------------------------------ | ----------------------------------------------------------- |
| Student Check-in (Webhook) | Triggered via POST request from mobile app or QR scanner |
| Format Data | Cleans and prepares incoming JSON into structured format |
| Append or Update Row | Saves student check-in data into Google Sheets |
| Email Teacher | Sends formatted check-in email to the class teacher |
| Success Response | Returns a confirmation response to the mobile app or system |

📱 Example Check-in Input (Webhook Body)

{
"student_name": "Aarav Mehta",
"student_id": "STU025",
"class_name": "Grade 6B"
}

📊 Google Sheets Format

| Student Name | Student ID | Class | Date | Time |
| ------------ | ---------- | -------- | ---------- | ----- |
| Aarav Mehta | STU025 | Grade 6B | 2025-08-06 | 08:35 |

Date and time are added dynamically in the workflow.

⚙️ Setup Requirements

n8n Instance** – Deployed with public webhook support
Google Sheets** – Sheet with columns as shown above
Email SMTP Settings** – For sending teacher notification

✅ Quick Setup Instructions

Import the workflow into your n8n instance
Replace the webhook URL in your mobile app
Set your Google Sheet ID and range
Enter the teacher’s email in the “Email Teacher” node
Test with mock data
Deploy and use live!