Automated Multi-Stop Shipment Scheduling with n8n

This workflow automates the process of handling customer shipment requests received via email, extracting logistical data, geocoding addresses to GPS coordinates, and optimizing delivery routes. Triggered by new emails in Gmail, the system uses AI-based parsing to extract pickup locations, collection times, and request IDs. It then fetches GPS data and calculates the most efficient route using OpenRouteService API, updating Google Sheets with detailed schedules, distances, and durations. Finally, it generates a professional confirmation email with the complete pickup sequence and estimated travel time, streamlining multi-stop logistics management for transportation companies.