Back to Templates

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

Last update

Last update 2 days ago

Categories

Share


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