Automate construction site attendance tracking with geofencing, Google Sheets & email alerts

This n8n workflow automates attendance tracking for construction workers at a designated site in Thaltej, Ahmedabad (GPS coordinates: 23.0489, 72.5118). Using geofencing technology, it logs "Punch In" and "Punch Out" times when workers enter or exit a predefined 100-meter radius around the site, requiring no manual input. Attendance data is stored in Google Sheets for easy access and reporting, and error notifications are sent via email to ensure reliable operation. Good to Know - Fully Automated: Tracks attendance without worker intervention using GPS data from a mobile app. - Geofence-Based: Only logs entries/exits within the Thaltej, Ahmedabad site radius. - Structured Logs: Stores data in Google Sheets with columns for User ID, Punch Type, Punch Date, and Punch Time. - Error Handling: Sends email notifications for any issues in the workflow. - Scalable: Supports multiple workers with unique IDs sent by the GPS app. - Real-Time: Processes location updates instantly for accurate time tracking. How It Works Attendance Tracking Flow 1. Webhook Trigger: - Listens for POST requests from a GPS tracking app at the endpoint /webhook/geofence-thaltej-attendance. - Expects a JSON payload with: json { "latitude": 23.0489, "longitude": 72.5118, "event": "enter", // or "exit" "userId": "worker123" } 2. Validate Geofence & Format Log: - Validates the received payload for required fields (latitude, longitude, event, userId). - Uses the Haversine formula to check if the coordinates are within 100 meters of Thaltej, Ahmedabad (23.0489, 72.5118). - Maps event ("enter" to "in", "exit" to "out") and formats the log with current date and time (e.g., Punch Type: "in", Punch Date: "2025-08-01", Punch Time: "11:53:07"). - Skips invalid or out-of-geofence data. 3. Save to Google Sheets: - Appends the formatted log to a Google Sheet in the "Attendance" tab, under columns: User ID, Punch Type, Punch Date, Punch Time. 4. Error Notification via Email: - Sends an email to a specified address if the workflow encounters errors (e.g., invalid payload or geofence mismatch). - Includes error details for troubleshooting. Example Log Output in Google Sheets | User ID | Punch Type | Punch Date | Punch Time | |------------|------------|-------------|------------| | worker123 | in | 2025-08-01 | 11:53:07 | | worker123 | out | 2025-08-01 | 13:30:20 | | worker123 | in | 2025-08-01 | 13:50:21 | How to Use 1. Import Workflow: - Copy the workflow JSON (provided below) and import it into n8n via the "Import Workflow" feature. 2. Configure GPS Tracking App: - Use a GPS app (e.g., allGeo, Truein, or a custom solution) that supports geofencing and webhook integration. - Set the geofence to Thaltej, Ahmedabad (latitude: 23.0489, longitude: 72.5118, radius: 100 meters). - Configure the app to send POST requests to the n8n webhook URL (/webhook/geofence-thaltej-attendance) with the payload: json { "latitude": 23.0489, "longitude": 72.5118, "event": "enter", // or "exit" "userId": "worker123" } - Ensure the app is installed on workers’ devices and running in the background. 3. Set Up Google Sheets: - Create a Google Sheet with a tab named "Attendance". - Add headers in columns A to D: User ID, Punch Type, Punch Date, Punch Time. - Copy the Sheet ID from the URL (e.g., https://docs.google.com/spreadsheets/d/yoursheetid/edit). - In n8n, configure Google Sheets OAuth2 credentials and update the sheetId in the workflow. 4. Configure Email Notifications: - Set up an email service (e.g., Gmail, SendGrid) in n8n with appropriate credentials. - Update the email node with your recipient email address and SMTP settings. 5. Activate Workflow: - Save and activate the workflow in n8n. - Test by simulating a webhook call or using the GPS app to send a sample payload. 6. Monitor and Verify: - Check Google Sheets for attendance logs after workers enter/exit the geofence. - Verify error emails are received if issues occur. Requirements - n8n Instance: Self-hosted or cloud-based n8n setup. - G