AI Agent for Transportation Orders with GPT-4o & OpenRoute API
Automates shipment request email processing: extracts logistics data with AI, geocodes addresses, computes truck routes via OpenRouteService, stores in Google Sheets, and sends confirmations.
This n8n workflow is designed for small transportation companies managing delivery requests via email. It uses two AI Agent nodes powered by GPT-4o to parse unstructured email content into structured data like pickup/delivery addresses and contacts. Addresses are geocoded to GPS coordinates, then queried against OpenRouteService API using the truck (driving-hgv) profile to retrieve accurate driving distance in km and estimated time in minutes.
The workflow enriches orders with real-time route data, stores everything in a Google Sheet for easy tracking, and automatically sends a professional confirmation email to customers. This eliminates manual data entry, reduces errors, and provides quick quotes on travel time and distance, optimizing operations for carriers.
Benefits include cost savings from automation, minimized environmental impact through efficient routing, and scalability for handling high email volumes. Ideal use cases: freight brokers, local delivery services, or logistics firms starting with AI-driven order management. Created by supply chain expert Samir Saci.
New buyers can create an account from the cart to unlock a controlled $10 first-purchase credit on eligible orders of $25+.
Secure checkout powered by Stripe
Tags
Support
How to import this workflow into n8n
- 1Purchase or download the workflow to get the n8n workflow JSON file.
- 2In your n8n instance, open Workflows and choose "Import from File" (or paste the JSON with Ctrl+V on the canvas).
- 3Open each node marked with a credential warning and connect your own accounts and API keys.
- 4Run the workflow once manually to verify the data flow, then toggle it to Active.
Related File & Document Management workflows
- Automate Invoice Data Extraction to Airtable with OCR and AI$14.99
- Save new Gmail attachments to Google Drive$3.99
- Automate PDF Invoice Creation from Google Sheets Using PDF.co$4.99
- Create Custom PDF Documents from Templates with Gemini & Google Drive$24.99
- Automatically Save and Organize Outlook Email Attachments in OneDrive Folders$9.99
- Automate Invoice Data Extraction from Google Drive to Google Sheets with Mistral OCR$14.99
More from Andre Ulrich
Need this deployed? We'll set it up for you.
Our automation experts deploy this workflow in your stack, connect your accounts, and verify it works — or build a custom solution from scratch.