The Scenario
The dispatcher at a courier company has a Google Sheet with eight delivery stop addresses in column A, listed in the order the driver should visit them. The driver's shift starts in forty minutes. Before the briefing, the dispatcher needs the turn-by-turn route, total kilometers, and estimated travel time — everything a driver needs on a single page.
The bad version:
- Paste all eight addresses into Google Maps as waypoints, get the route, screenshot the directions.
- Realize Google Maps doesn't export step-by-step instructions to text, so start typing each turn by hand from the screen.
- The total distance is on one part of the screen, the duration on another, and three of the steps wrap awkwardly across the screenshot, making it impossible to read in the driver briefing doc.
The shift starts in forty minutes. There are two other routes to brief.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Google Sheet. It reads the stop column, calls Radar's routing API with the addresses in sequence, and writes the step-by-step instructions along with the total summary figures back into the sheet — ready for the briefing.
Using the 8 stop addresses in column A in order, get Radar route directions via car and write the step-by-step instructions, total distance (km), and total duration (min) into this sheet
What You Get
- Each routing step written into a new row in column B, in order
- Total route distance in kilometers in a labeled summary row
- Total estimated travel time in minutes in a labeled summary row
- The sheet is formatted so you can paste or print it directly into the driver briefing without reformatting
What If the Data Is Not Quite Ready
The stops include some that are marked optional — skip them based on a flag column
Get Radar car route directions for all stops in column A where column B is "Required", in row order — write each step to column C and add the total distance (km) and duration (min) at the bottom
The addresses have typos and inconsistent formatting
Clean up each address in column A — fix obvious typos, standardize city-state format — then get Radar car route directions for all 8 stops in order and write each step to column B with total distance and duration at the bottom
You need each leg broken out separately, not just the totals
Get Radar car route directions for the 8 stops in column A in order, and for each leg (each stop-to-stop segment) write the leg distance (km) and leg duration (min) into columns B and C, then add a total row at the bottom
Clean the stops, fetch the route, and generate a driver summary in one shot
For the 8 stops in column A: standardize address formatting, call Radar's car routing API in stop order, write the step-by-step turn instructions to column B, write per-leg distance and time to columns C and D, and add a formatted summary section at the bottom with total distance, total time, and the stop count
That last prompt hands you a completed driver briefing sheet without a separate formatting pass.
Try It
Get the 7-day free trial of SheetXAI and open any Google Sheet with an ordered list of delivery stops — ask it to fetch the Radar route directions and write every leg and summary into the sheet. For a related task, see building a driving-time matrix, or return to the Radar integration overview.