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 teachers and/or parents 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:** ```json { "student_id": "SU042", "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 | | ---------- | ----------- | ---------- | ----- | ------- | | SU042 | 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