Delivery Route Optimization & Driver Dispatch
Groups today's ready orders into routes, picks an available truck, calculates distance and time, checks the weather on the route and sends the driver a WhatsApp brief with a map link.

On this page
How it works
- On schedule, orders ready for delivery are read from Airtable.
- Orders are grouped and an available truck is found, and the team is alerted if none is free.
- Route distance, duration and a map link are generated.
- Weather along the route is summarized.
- The driver gets a WhatsApp message and the records are updated.
Use cases
- Distribution and FMCG delivery
- Local logistics fleets
- Construction material suppliers
What you need
This workflow connects to these apps.
- n8n
- Airtable
- Slack
You'll need an n8n instance, on n8n Cloud or self-hosted, and these credentials. Our credentials guide shows how to create each one.
- Airtable account
- OpenWeatherMap account
- Slack account
- Twilio account
Data setup
Create these tables with these exact column names before the first run.
| Table | Columns |
|---|---|
| Route & Load Optimization → OrdersAirtable | Order IDStatus |
| Route & Load Optimization → FleetAirtable | Truck IDAvailability |
| Route & Load Optimization → RoutesOutputAirtable | Order IDRoute IDDateTruck IDDriver NameDriver PhoneTotal Weight kgTotal StopsEst Total kmEst Total Time MinWeather SummaryRoute Link |
Setup
- Download the JSON and import it into n8n with Import from File, or copy it and paste it onto an empty canvas. The import guide walks through both.
- Connect the credentials listed above.
- Point the Sheets, Airtable, Drive, and Slack nodes at your own files and channels.
- Replace placeholder emails, phone numbers, and form links with your own.
- Times use the America/New York timezone and dates use MM/DD/YYYY. Change them if you need to, then test and activate. The setup guide covers this step by step.
Nodes
| Node | Type |
|---|---|
| Grouped Route | code |
| Get Route Details | code |
| Split Order IDs | code |
| Schedule Trigger | scheduleTrigger |
| Get Today Ready For Delivery Records | airtable |
| Loop Over Delivery Records | splitInBatches |
| Generate Formula | code |
| Get Available Truck | airtable |
| If Check Truck Availability | if |
| Alert to Team for truck not available | slack |
| Get Google Maps Route | httpRequest |
| Find a Distance & Duration | httpRequest |
| Generate Route Link | code |
| Search Route Weather | openWeatherMap |
| Generate Weather Summary | code |
| Generate Whatsapp Message & Payload | code |
| Send WhatsApp to Driver Notify | twilio |
| Notify to Supplier Team | slack |
| Append Payload Data | airtable |
| Update Order Status | airtable |
| Update Truck Status | airtable |
Frequently asked questions
Groups today's ready orders into routes, picks an available truck, calculates distance and time, checks the weather on the route and sends the driver a WhatsApp brief with a map link. It's a 22-node n8n workflow.
An n8n instance, on n8n Cloud or self-hosted, and credentials for Airtable, OpenWeatherMap, Slack, and Twilio. It uses only nodes that ship with n8n, so there's nothing else to install.
It works with 3 tables in Airtable. Create them with the column names listed under Data setup on this page before the first run.
Download the JSON, then in n8n create a new workflow, open the menu in the top right, and choose Import from File. You can also copy the JSON and paste it onto an empty canvas.
Yes. It's free to download, import, and change, with no sign-up. You only pay for the apps it connects to, where those aren't free on your plan.



