Workflow
The system:
- Receives new shipment requests through webhooks or forms
- Validates shipment, customer, route, cargo, and delivery information
- Creates shipment records and dedicated Google Drive folders
- Calculates routes, travel distance, and estimated transit time
- Searches approved carriers based on service region, capacity, equipment, and compliance
- Sends quotation requests to suitable carriers
- Receives, normalizes, and compares carrier quotations
- Calculates carrier scores using price, availability, reliability, damage rate, and on-time performance
- Generates recommended carrier summaries using AI
- Routes shipments for manager approval when required
- Creates confirmed carrier bookings automatically
- Generates shipping documents and sends required documents through DocuSign
- Sends booking confirmations to carriers and customers
- Monitors upcoming pickups and sends driver reminders
- Processes pickup confirmations, delays, failed pickups, and shipment-not-ready conditions
- Retrieves carrier tracking data and recalculates delivery ETA
- Detects at-risk and critically delayed shipments
- Sends customer ETA updates and operations alerts automatically
- Creates structured exception records for delivery problems
- Receives delivery confirmation, signatures, photos, and proof of delivery
- Reconciles expected and delivered shipment quantities
- Routes partial, damaged, or rejected deliveries to claims handling
- Closes successfully delivered shipments
- Generates final shipment summaries and sends POD documents to customers
- Calculates carrier performance after each completed shipment
- Performs weekly audits for late shipments, missing PODs, open exceptions, and claims
- Updates logistics analytics in Google Sheets



