{
  "name": "🚛🗺️ Geocoding for logistics with Open Route API and Google Sheets",
  "nodes": [
    {
      "id": "b1d00cd4-b9e8-4d84-b580-08368fbb9396",
      "name": "Sticky Note2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        20,
        -160
      ],
      "parameters": {
        "width": 540,
        "height": 640,
        "content": "### 1. Trigger the workflow\nThis starts by collecting all the addresses (with the country code) that need geocoding information.\n\n#### How to setup?\n\n- **Load records in the Google Sheet Node**:\n   1."
      }
    },
    {
      "id": "32f84996-0480-4c0b-aab7-3f5ebca9dd4e",
      "name": "When clicking ‘Test workflow’",
      "type": "n8n-nodes-base.manualTrigger",
      "position": [
        60,
        260
      ]
    },
    {
      "id": "fe628240-0550-42dd-a375-7ecba134fd6c",
      "name": "Sticky Note",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        600,
        -160
      ],
      "parameters": {
        "width": 1120,
        "height": 640,
        "content": "### 2. Loop to collect GPS coordinates\n\n#### How to setup?\n- **Setup API Credentials**\n  1. Get your free API key: [Open Route API Documentation](https://openrouteservice.org/dev/#/api-docs)\n  2. Fill"
      }
    },
    {
      "id": "eac06796-f40d-4c94-96b2-4ad672053295",
      "name": "Collect Addresses",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        340,
        260
      ]
    },
    {
      "id": "13198c2c-cdca-4a5e-893a-1fac24090f33",
      "name": "Query Open Route API",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        960,
        280
      ]
    },
    {
      "id": "d0ad6f7e-8049-45c4-8022-8c16a8f71392",
      "name": "Loop Over Addresses",
      "type": "n8n-nodes-base.splitInBatches",
      "position": [
        760,
        260
      ]
    },
    {
      "id": "c84f27c6-3905-455a-b8a7-bb1d6bffafe0",
      "name": "Save Results",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        1380,
        280
      ]
    },
    {
      "id": "6fa85604-4db7-431d-b0fd-b6cbb1773c12",
      "name": "Extract Results",
      "type": "n8n-nodes-base.set",
      "position": [
        1180,
        280
      ]
    },
    {
      "id": "71c85728-f291-4a67-8d0d-8c7fcd38905d",
      "name": "5 sec",
      "type": "n8n-nodes-base.wait",
      "position": [
        1560,
        280
      ]
    },
    {
      "id": "7ca2b5ea-9af8-425d-958e-2f6ffe01656e",
      "name": "Sticky Note4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        20,
        500
      ],
      "parameters": {
        "width": 580,
        "height": 380,
        "content": "### [Check the Tutorial](https://www.youtube.com/watch?v=IlblIlKcL0k)\n![Thumbnail](https://www.samirsaci.com/content/images/2025/06/image-10.png)"
      }
    }
  ],
  "connections": {
    "5 sec": {
      "main": [
        [
          {
            "node": "Loop Over Addresses",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Save Results": {
      "main": [
        [
          {
            "node": "5 sec",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Extract Results": {
      "main": [
        [
          {
            "node": "Save Results",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Collect Addresses": {
      "main": [
        [
          {
            "node": "Loop Over Addresses",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Loop Over Addresses": {
      "main": [
        [],
        [
          {
            "node": "Query Open Route API",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Query Open Route API": {
      "main": [
        [
          {
            "node": "Extract Results",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "When clicking ‘Test workflow’": {
      "main": [
        [
          {
            "node": "Collect Addresses",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}