Samir Saci This workflow corresponds to n8n.io template #4564 — we link there as the canonical source.
This workflow follows the Google Sheets → HTTP Request recipe pattern — see all workflows that pair these two integrations.
The workflow JSON
Copy or download the full n8n JSON below. Paste it into a new n8n workflow, add your credentials, activate. Full import guide →
{
"nodes": [
{
"id": "4660840a-499a-4d44-be7c-1d0edfee9634",
"name": "Loop Over Items",
"type": "n8n-nodes-base.splitInBatches",
"position": [
660,
420
],
"parameters": {
"options": {}
},
"typeVersion": 3
},
{
"id": "4401f929-3ad6-4b8d-90bf-2edc58d4b381",
"name": "Extract Results",
"type": "n8n-nodes-base.set",
"position": [
1220,
440
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "4d0acd1a-c049-4353-9fb7-8eb08c138b9c",
"name": "distance",
"type": "string",
"value": "={{ $json.features[0].properties.segments[0].distance }}"
},
{
"id": "2a6ff46a-f620-4dad-a60a-018b8add76d5",
"name": "duration",
"type": "string",
"value": "={{ $json.features[0].properties.segments[0].duration }}"
},
{
"id": "de20932f-4eb5-4372-ad6d-64679df104cb",
"name": "n_steps",
"type": "number",
"value": "={{ $json.features[0].properties.segments[0].steps.length }}"
},
{
"id": "540df5ea-cf63-47cc-8d63-3d6fcac825af",
"name": "",
"type": "string",
"value": ""
}
]
}
},
"notesInFlow": true,
"typeVersion": 3.4
},
{
"id": "14165f3a-104a-415a-b84b-86e903f86be8",
"name": "Request Open Route API",
"type": "n8n-nodes-base.httpRequest",
"position": [
980,
440
],
"parameters": {
"url": "https://api.openrouteservice.org/v2/directions/driving-hgv",
"options": {
"response": {
"response": {
"responseFormat": "json"
}
}
},
"sendQuery": true,
"sendHeaders": true,
"queryParameters": {
"parameters": [
{
"name": "api_key"
},
{
"name": "start",
"value": "={{ $json.longitude_departure }}, {{ $json.latitude_departure }}"
},
{
"name": "end",
"value": "={{ $json.longitude_destination }}, {{ $json.latitude_destination }}"
}
]
},
"headerParameters": {
"parameters": [
{
"name": "Content-Type",
"value": "application/json; charset=utf-8"
},
{
"name": "Accept",
"value": "application/json, application/geo+json, application/gpx+xml, img/png; charset=utf-8"
}
]
}
},
"notesInFlow": true,
"typeVersion": 4.2
},
{
"id": "27f17e62-6528-4c29-b10e-38f79dc50811",
"name": "Collect Routes",
"type": "n8n-nodes-base.googleSheets",
"position": [
300,
420
],
"parameters": {
"options": {},
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "",
"cachedResultName": "Distance"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1NLNviRoVMEj2z78KiueruB5sd2CnvAb80DS7J2melVs",
"cachedResultUrl": "",
"cachedResultName": "Open Route Service"
}
},
"typeVersion": 4.6
},
{
"id": "0ceec3de-34c0-4361-b6fc-527d2108cd4d",
"name": "Save Results",
"type": "n8n-nodes-base.googleSheets",
"position": [
1440,
440
],
"parameters": {
"columns": {
"value": {
"id": "={{ $('Loop Over Items').item.json.id }}",
"n_steps": "={{ $json.n_steps }}",
"distance": "={{ $json.distance }}",
"duration": "={{ $json.duration }}"
},
"schema": [
{
"id": "id",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "id",
"defaultMatch": true,
"canBeUsedToMatch": true
},
{
"id": "city_departure",
"type": "string",
"display": true,
"required": false,
"displayName": "city_departure",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "longitude_departure",
"type": "string",
"display": true,
"required": false,
"displayName": "longitude_departure",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "latitude_departure",
"type": "string",
"display": true,
"required": false,
"displayName": "latitude_departure",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "city_destination",
"type": "string",
"display": true,
"required": false,
"displayName": "city_destination",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "longitude_destination",
"type": "string",
"display": true,
"required": false,
"displayName": "longitude_destination",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "latitude_destination",
"type": "string",
"display": true,
"required": false,
"displayName": "latitude_destination",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "distance",
"type": "string",
"display": true,
"required": false,
"displayName": "distance",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "duration",
"type": "string",
"display": true,
"required": false,
"displayName": "duration",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "n_steps",
"type": "string",
"display": true,
"required": false,
"displayName": "n_steps",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "row_number",
"type": "string",
"display": true,
"removed": true,
"readOnly": true,
"required": false,
"displayName": "row_number",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"id"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "update",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "",
"cachedResultName": ""
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "",
"cachedResultUrl": "",
"cachedResultName": ""
}
},
"notesInFlow": true,
"typeVersion": 4.6
},
{
"id": "40e078a1-4cd5-46f0-938d-756c4a5d150d",
"name": "Sticky Note2",
"type": "n8n-nodes-base.stickyNote",
"position": [
0,
0
],
"parameters": {
"color": 7,
"width": 540,
"height": 640,
"content": "### 1. Trigger the workflow\nThis starts by collecting all the routes (Departure, Destination) that need distance and driving time by **truck**.\n\n#### How to setup?\n\n- **Load records in the Google Sheet Node**:\n 1. Add your Google Sheet API credentials to access the Google Sheet file\n 2. Select the file using the list, an URL or an ID\n 3. Select the sheet in which you want to record your working sessions\n 4. Map the fields: **city_departure**, **longitude_departure** , **latitude_departure**, **city_destination**, **longitude_destination**, **latitude_destination**, **distance**, **duration**, **n_steps**\n [Learn more about the Google Sheet Node](https://docs.n8n.io/integrations/builtin/app-nodes/n8n-nodes-base.googlesheets)\n\nThe last three fields must be left empty as they will be filled with the API outputs.\n"
},
"typeVersion": 1
},
{
"id": "b723a6a2-6504-47f4-9ced-f84617a62dbe",
"name": "When clicking \u2018Test workflow\u2019",
"type": "n8n-nodes-base.manualTrigger",
"position": [
80,
420
],
"parameters": {},
"typeVersion": 1
},
{
"id": "3b5fa269-e880-4552-8b39-a9eccd8d0d4d",
"name": "Sticky Note",
"type": "n8n-nodes-base.stickyNote",
"position": [
580,
0
],
"parameters": {
"color": 7,
"width": 1240,
"height": 640,
"content": "### 2. Loop to collect all driving distances and time \nThis starts by collecting all the routes (Departure, Destination) that need distance and driving time by **truck**.\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 the API key in the HTTP request node\n 3. Select the driving mode (**driving-car**: individual truck) or (**driving-hgv**: commercial truck)\n- **Load records in the Google Sheet Node**:\n 1. Add your Google Sheet API credentials to access the Google Sheet file\n 2. Select the file using the list, an URL or an ID\n 3. Select the sheet in which you want to record your working sessions\n 4. Map the fields: **city_departure**, **longitude_departure**, **latitude_departure**, **city_destination**, **longitude_destination**, **latitude_destination**, **distance**, **duration**, **n_steps**\n [Learn more about the Google Sheet Node](https://docs.n8n.io/integrations/builtin/app-nodes/n8n-nodes-base.googlesheets)\n\nThe last three fields must be left empty as they will be filled with the API outputs.\n"
},
"typeVersion": 1
},
{
"id": "e0e79eea-04f0-462a-a930-01a0df4a0058",
"name": "5 sec",
"type": "n8n-nodes-base.wait",
"position": [
1660,
440
],
"parameters": {},
"typeVersion": 1.1
},
{
"id": "53d7aefb-6ecc-465f-8b1e-6141312a80e8",
"name": "Sticky Note4",
"type": "n8n-nodes-base.stickyNote",
"position": [
0,
660
],
"parameters": {
"width": 580,
"height": 380,
"content": "### [Check the Tutorial](https://www.youtube.com/watch?v=uJtp2NsmR2E)\n"
},
"typeVersion": 1
}
],
"connections": {
"5 sec": {
"main": [
[
{
"node": "Loop Over Items",
"type": "main",
"index": 0
}
]
]
},
"Save Results": {
"main": [
[
{
"node": "5 sec",
"type": "main",
"index": 0
}
]
]
},
"Collect Routes": {
"main": [
[
{
"node": "Loop Over Items",
"type": "main",
"index": 0
}
]
]
},
"Extract Results": {
"main": [
[
{
"node": "Save Results",
"type": "main",
"index": 0
}
]
]
},
"Loop Over Items": {
"main": [
[],
[
{
"node": "Request Open Route API",
"type": "main",
"index": 0
}
]
]
},
"Request Open Route API": {
"main": [
[
{
"node": "Extract Results",
"type": "main",
"index": 0
}
]
]
},
"When clicking \u2018Test workflow\u2019": {
"main": [
[
{
"node": "Collect Routes",
"type": "main",
"index": 0
}
]
]
}
}
}
Pro
For the full experience including quality scoring and batch install features for each workflow upgrade to Pro
About this workflow
*Tags: Supply Chain, Logistics, Route Planning, Transportation, GPS API*
Source: https://n8n.io/workflows/4564/ — original creator credit. Request a take-down →
Related workflows
Workflows that share integrations, category, or trigger type with this one. All free to copy and import.
TrackCollect_deeper. Uses googleSheets, httpRequest, @n-octo-n/n8n-nodes-json-database, itemLists. Event-driven trigger; 80 nodes.
Google Sheets, HTTP Request, @N Octo N/N8N Nodes Json Database +1
This template is ideal for solo store owners, eCommerce marketers, automation beginners, or anyone using Shopify and Gmail who wants to recover lost revenue without coding.
HTTP Request, Gmail, Twilio +3
PCN. Uses googleSheets, httpRequest, @n-octo-n/n8n-nodes-json-database, itemLists. Event-driven trigger; 60 nodes.
Google Sheets, HTTP Request, @N Octo N/N8N Nodes Json Database +3
Product Ad Machine. Uses googleDrive, googleSheets, httpRequest, @ffmpeg-micro/n8n-nodes-ffmpeg-micro. Event-driven trigger; 60 nodes.
Google Drive, Google Sheets, HTTP Request +2
Basic AI SEO KW Research n8n DataForSEO Gumroad 030125. Uses googleSheets, googleDrive, httpRequest. Event-driven trigger; 56 nodes.
Google Sheets, Google Drive, HTTP Request