Track Student Arrival with iOS Automation, Google Sheets & Email Alerts

This workflow automates real-time student tracking using iOS Shortcuts and geolocation data , notifying both teachers and parents based on geofenced logic.

🎯 What This Workflow Does

• Receives student location updates via webhook (iOS Shortcuts)
• Detects if the student has arrived at school
• Logs arrival data to Google Sheets
• Sends email alerts to teacher and/or parent based on location

🔄 Workflow Steps

Step	Description
Location Update Webhook	Triggered via iOS Shortcut when student location updates
Process Location Data	Extracts coordinates and metadata
Student Arrived?	Checks if student entered school zone
Log School Arrival	Adds arrival data to Google Sheet
At School?	Double-checks geofence condition before notifying
Notify Teacher	Sends email if student is confirmed at school
Notify Parent	Sends email to parent (can vary based on geofence logic)
Success Response	Returns a 200 response to the triggering device

🧠 How the Logic Works

1. The student’s phone runs a shortcut when near school.
2. Sends coordinates to webhook.
3. Workflow compares coordinates with predefined geofence (e.g., radius around school).
4. If inside school zone:
   • Log arrival
   • Notify teacher and/or parent
5. Else:
   • Optionally notify parent only

📱 iOS Shortcut Sample (Trigger Setup)

• Automation Trigger : Arrive at Location (e.g., School)
• Action : Run Shortcut → Make Web Request (POST)

POST URL:

https://your-n8n-instance.com/webhook/location-update

Body Example:

{
  "student_id": "STU042",
  "student_name": "Anaya Joshi",
  "lat": 19.0760,
  "lng": 72.8777,
  "timestamp": "2025-08-06T08:05:00"
}

📊 Google Sheets Logging

Student ID	Name	Date	Time	Status
STU042	Anaya Joshi	2025-08-06	08:05	Arrived

⚙️ Setup Requirements

• n8n Instance with webhook support
• Google Sheet with appropriate columns
• iOS Shortcut setup on student device
• Teacher and Parent Email Addresses configured in workflow