# Process shipment emails with route calculation and automated confirmation
This automation handles incoming shipment requests from email by extracting key data, calculating truck routes, and sending professional HTML confirmations — all without manual input. Designed for logistics teams that need fast, accurate responses to transport inquiries.
## Who it´s for
- Logistics companies processing transport requests via email
- Freight operators working with retailers like E.Leclerc
- Client managers in freight forwarding
- Companies automating order intake without a CRM
## What the automation does
- Monitors Gmail for new shipment request emails
- Uses an AI agent (GPT-4o-mini) to extract structured data: pickup/delivery addresses, time, cargo type, contact info
- Logs extracted data into Google Sheets for tracking
- Geocodes addresses and calculates driving distance/time for HGV using OpenRoute API
- Generates and sends an HTML confirmation email as a reply in the same thread
## What´s included
- Ready-to-use n8n workflow
- Trigger and handler logic based on new Gmail messages
- Integrations with Gmail, Google Sheets, OpenRoute API, and OpenAI
- Basic written instructions for setup and adaptation
## Requirements for setup
- n8n instance with access to HTTP nodes and LangChain support
- Gmail account with IMAP/SMTP or API enabled
- Google Sheet for storing shipment records
- OpenRoute API key
- OpenAI API key (for GPT-4o-mini)
## Benefits and outcomes
- Eliminates manual data entry from emails
- Reduces request processing time to minutes
- Professional confirmation emails improve client trust
- Centralized record of all shipments with route metrics
- Accurate HGV-specific route calculations
- Scalable operations without hiring additional staff
## Important: template only
Important: you are purchasing a ready-made automation workflow template only. Rollout into your infrastructure, connecting specific accounts and services, 1:1 setup help, custom adjustments for non-standard stacks and any consulting support are provided as a separate paid service at an individual rate. To discuss custom work or 1:1 help, contact via chat
No feedback yet