Content: 02528.zip (44.87 KB)
Uploaded: 15.01.2026

Positive responses: 0
Negative responses: 0

Sold: 0
Refunds: 0

$6.95
# 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