Erfassung der Baustellenanwesenheit von Bauarbeitern per GPS bei der Eincheckung

• •HTTP Webhook-Endpunkt (wird von n8n automatisch generiert)
• •Google Sheets API-Anmeldedaten

{
  "id": "zgVjyTFdUx4JfRnv",
  "meta": {
    "instanceId": "dd69efaf8212c74ad206700d104739d3329588a6f3f8381a46a481f34c9cc281",
    "templateCredsSetupCompleted": true
  },
  "name": "Track site attendance when construction worker checks in by GPS",
  "tags": [],
  "nodes": [
    {
      "id": "e15aaea0-7665-41dd-b05a-eda638e0550e",
      "name": "Webhook",
      "type": "n8n-nodes-base.webhook",
      "position": [
        -320,
        40
      ],
      "webhookId": "thaltej-attendance-webhook",
      "parameters": {
        "path": "geofence-thaltej-attendance",
        "options": {},
        "httpMethod": "POST"
      },
      "typeVersion": 1
    },
    {
      "id": "9958bc29-4e65-4996-86cb-a3cb9fc2cf3b",
      "name": "Geofence & Logformat validieren",
      "type": "n8n-nodes-base.function",
      "position": [
        -100,
        40
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "b0803efa-f662-4071-8752-c47dec49eb98",
      "name": "E-Mail senden",
      "type": "n8n-nodes-base.emailSend",
      "position": [
        340,
        40
      ],
      "webhookId": "e3d3059b-ff06-4978-b548-7cd0da1bbc59",
      "parameters": {
        "text": "=Hello,\n\nThe attendance sheet has been successfully updated for today.\n\nPlease review the latest punch-in and punch-out entries to ensure everything is in order.\n\n🗓️ Date: {{new Date().toLocaleDateString()}} \n📍 Location: Construction Site (Geofenced)\n\nYou can access the updated sheet here: [Insert Sheet Link]\n\nRegards,  \nn8n Automation System  \n",
        "options": {},
        "subject": "📋 Daily Attendance Updated – Please Review",
        "toEmail": "abcd@gmail.com",
        "fromEmail": "abc@gmail.com",
        "emailFormat": "text"
      },
      "credentials": {
        "smtp": {
          "id": "G1kyF8cSWTZ4vouN",
          "name": "SMTP -test"
        }
      },
      "typeVersion": 2.1
    },
    {
      "id": "ab599b4d-b6da-458b-967f-8c7a7ad1214e",
      "name": "Daten in Tabelle anhängen",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        120,
        40
      ],
      "parameters": {
        "range": "Attendance!A:D",
        "options": {},
        "sheetId": "your_google_sheet_id",
        "operation": "append"
      },
      "credentials": {
        "googleApi": {
          "id": "ScSS2KxGQULuPtdy",
          "name": "Google Sheets- test"
        }
      },
      "typeVersion": 1
    },
    {
      "id": "4930e9c8-9e6a-4b31-bcef-717b09c2ef51",
      "name": "Notiz",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -360,
        -160
      ],
      "parameters": {
        "color": 6,
        "width": 180,
        "height": 340,
        "content": "Receives check-in/check-out requests from mobile input (e.g., Google Form or WhatsApp). Carries GPS coordinates and worker info."
      },
      "typeVersion": 1
    },
    {
      "id": "9a36eeaf-b4c8-4e0f-a96b-b4fee8e3be52",
      "name": "Notiz1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -140,
        -160
      ],
      "parameters": {
        "color": 4,
        "width": 180,
        "height": 340,
        "content": "Validates if the worker’s location is within the geofenced construction site area using Google Maps API.\nAlso formats the log with punch type, time, and date."
      },
      "typeVersion": 1
    },
    {
      "id": "5ed902d5-ce69-4b2b-a532-3cd5c2a8e271",
      "name": "Notiz2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        80,
        -160
      ],
      "parameters": {
        "color": 3,
        "width": 180,
        "height": 340,
        "content": "Appends the validated punch-in/out record to a Google Sheet for attendance tracking and reporting.\n\n"
      },
      "typeVersion": 1
    },
    {
      "id": "ab0ecb3a-53cf-4d58-9196-de9e4134a0e7",
      "name": "Notiz3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        300,
        -160
      ],
      "parameters": {
        "color": 5,
        "width": 180,
        "height": 340,
        "content": "Sends a notification email with attendance details or alerts if the location is invalid.\n\n"
      },
      "typeVersion": 1
    }
  ],
  "active": false,
  "pinData": {},
  "settings": {
    "executionOrder": "v1"
  },
  "versionId": "8d45bac2-3103-430c-a9ab-9f12168e48f2",
  "connections": {
    "e15aaea0-7665-41dd-b05a-eda638e0550e": {
      "main": [
        [
          {
            "node": "9958bc29-4e65-4996-86cb-a3cb9fc2cf3b",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "ab599b4d-b6da-458b-967f-8c7a7ad1214e": {
      "main": [
        [
          {
            "node": "b0803efa-f662-4071-8752-c47dec49eb98",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "9958bc29-4e65-4996-86cb-a3cb9fc2cf3b": {
      "main": [
        [
          {
            "node": "ab599b4d-b6da-458b-967f-8c7a7ad1214e",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}