🤖🚚 AI agent for transportation orders management with GPT-4o and Open Route API
Needs changesNeeds changes. This template uses 1 thing(s) that n8n 3.0 removes: AI Agent v1 (old agent modes). 1 breaking item(s) found. Static check, last run 2026-10-19.
What this workflow does
This AI workflow has 21 nodes and runs on Gmail events. Along the way it connects Gmail, Google Sheets and OpenAI Chat Model. It also calls api.openrouteservice.org over HTTP.
How it runs
Trigger: On Gmail events.
- AI Agent: runs an AI agent, with model: OpenAI Chat Model; output parser: Structured Output Parser
- Collect Coordinates (Google Sheets): uses Google Sheets
- Record Email Content (Google Sheets): append or update
- Collect Addresses (Google Sheets): uses Google Sheets
- Collect Shipment Information (Google Sheets): uses Google Sheets
- Request Open Route API (HTTP Request): calls api.openrouteservice.org
- Query Open Route API Pickup (HTTP Request): calls api.openrouteservice.org
- Query Open Route API Delivery (HTTP Request): calls api.openrouteservice.org
- AI Agent: runs an AI agent, with model: OpenAI Chat Model
- Driving Time & Distance (Edit Fields (Set)): sets 3 fields: distance, duration, n_steps
…plus 7 more steps. See the full node list below.
Services it uses
HTTP calls to: api.openrouteservice.org
Before you upgrade to n8n 3.0
1 thing in this workflow is removed in n8n 3.0. Fix it before you upgrade:
- AI Agent v1 (old agent modes) in AI Agent Parser (v1.9), AI Agent Reply (v1.9): replace with Latest AI Agent node (Tools Agent). For SQL Agent, use a Postgres or MySQL tool with a recent AI Agent.
- Also check Gmail Trigger below v1.4 runs as v1.4 (drafts skipped, max emails per poll).
| Removed in 3.0 | Replace with |
|---|---|
| AI Agent v1 (old agent modes) AI Agent Parser (v1.9), AI Agent Reply (v1.9) | Latest AI Agent node (Tools Agent). For SQL Agent, use a Postgres or MySQL tool with a recent AI Agent. |
Nodes used (9)
- Gmail Trigger
n8n-nodes-base.gmailTrigger - Structured Output Parser
@n8n/n8n-nodes-langchain.outputParserStructured - AI Agent
@n8n/n8n-nodes-langchain.agent - Google Sheets
n8n-nodes-base.googleSheets - Wait
n8n-nodes-base.wait - HTTP Request
n8n-nodes-base.httpRequest - Edit Fields (Set)
n8n-nodes-base.set - OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi - Gmail
n8n-nodes-base.gmail
From the author
Tags: AI Agent, 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…