🚚 Estimate driving time and distance for logistics with Open Route API
Ready for 3.0What this workflow does
This workflow has 7 nodes and runs manually, when you click “Execute workflow”. Along the way it connects Google Sheets. It also calls api.openrouteservice.org over HTTP.
How it runs
Trigger: Manually, when you click “Execute workflow”.
- Collect Routes (Google Sheets): uses Google Sheets
- Loop Over Items (Loop Over Items (Split in Batches)): loops over the items in batches
- Request Open Route API (HTTP Request): calls api.openrouteservice.org
- Extract Results (Edit Fields (Set)): sets 3 fields: distance, duration, n_steps
- Save Results (Google Sheets): update
- 5 sec (Wait): pauses before continuing
Services it uses
HTTP calls to: api.openrouteservice.org
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (6)
- Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - Edit Fields (Set)
n8n-nodes-base.set - HTTP Request
n8n-nodes-base.httpRequest - Google Sheets
n8n-nodes-base.googleSheets - Manual Trigger
n8n-nodes-base.manualTrigger - Wait
n8n-nodes-base.wait
From the author
Tags: Supply Chain, Logistics, Route Planning, Transportation, GPS API Context Hi! I’m Samir, a Supply Chain Engineer and Data Scientist based in Paris, and founder of LogiGreen Consulting. I help companies improve their logistics operations using data, AI,…