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

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!