The Scenario
It is 6 AM Tuesday. You are a field service operations manager and the 8 AM driver briefing starts in two hours. OptimoRoute finished planning overnight — routes are assigned, stops are sequenced, arrival times are calculated. Your job is to get that plan out of OptimoRoute and into a format team leads can actually use before the briefing.
The operations team does not work out of the OptimoRoute interface. They work out of Google Sheets. They need one row per stop, sorted by driver, with the address and scheduled arrival time visible. Every time someone asks you for the "route sheet," you produce it from scratch.
The bad version:
- You log into OptimoRoute, navigate to tomorrow's plan, and start exporting. The export gives you a single flat file with all drivers combined.
- You open the file in Sheets, sort by driver name, and manually split the data across separate tabs — one per driver.
- The scheduled times come through in UTC. You convert them to local time by hand for the eight drivers on tomorrow's run.
- It is 7:40 AM when the sheet is ready. The team leads have been in the channel asking for it since 7:15.
The route plan was ready hours ago. The delay was entirely in the data extraction and reformatting.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It reads OptimoRoute's route plan directly and writes the stop data into whatever structure you specify — flat list, one tab per driver, sorted and formatted.
Open the SheetXAI sidebar and ask:
Fetch all planned routes from OptimoRoute for tomorrow's date and write each stop into this sheet with columns: driver name, order number, address, scheduled arrival time, and time window.
What You Get
- Every stop from tomorrow's plan is written into the sheet — one row per stop, in scheduled sequence.
- Columns land as: driver name, order number, address, scheduled arrival time, time window.
- Stops are ordered by driver, then by stop sequence within each driver's route.
- If a stop has no scheduled time yet — because planning is still running — that cell is left blank with a note in a status column.
What If the Data Is Not Quite Ready
The team wants one tab per driver, not a flat list
Get the full route plan from OptimoRoute for tomorrow's date and create one tab per driver in this workbook — list each driver's stops in sequence with columns for order number, address, and scheduled arrival time, and name each tab after the driver.
The date for the plan should come from the sheet, not be hardcoded
Fetch the route plan from OptimoRoute for the date in cell A1 and write each stop into the 'Route Sheet' tab with driver name in column A, order number in column B, address in column C, and scheduled arrival in column D.
Stops need to be filtered to a specific geographic zone
Pull the full route plan from OptimoRoute for tomorrow and write only the stops whose address contains "Brooklyn" or "Queens" into this sheet — include driver name, stop sequence, address, and scheduled arrival time.
The team needs the route plan plus a summary count per driver before the briefing
Fetch tomorrow's route plan from OptimoRoute, write all stops into the 'Stops' tab with driver and scheduled time, then create a 'Summary' tab showing each driver's name, total stop count, and first scheduled stop time — sorted by start time.
The summary and the detail write in one pass. No separate pivot or formula work needed.
Try It
Get the 7-day free trial of SheetXAI and open the sheet your ops team uses for driver briefings, then ask it to pull tomorrow's route plan from OptimoRoute and populate the sheet. Also see how to export completion data after the routes run, and how to trigger optimization before the plan is ready.