The Scenario
You are a fleet manager. It is Friday at 3 PM. Monday's routes are generated over the weekend, which means driver parameters — work start times, vehicle assignments — need to be in OptimoRoute before Sunday's optimization run. You have a prepared schedule: 20 drivers across columns for driver ID, date, start time, vehicle ID, and end time. The schedule was finalized in a planning meeting this morning.
Updating driver parameters in OptimoRoute is a one-at-a-time operation through the UI. Last time you did this by hand, you transposed two vehicle IDs and a driver went out in the wrong truck.
The bad version:
- You open OptimoRoute, navigate to Drivers, click into the first driver's profile, update start time and vehicle, and save.
- Repeat 19 times, keeping one eye on the Excel schedule and one on the screen.
- Around driver 12, you enter 07:30 instead of 07:00. You do not notice until the route plan comes back with one driver's first stop scheduled before their start time.
- You fix it Sunday evening.
The schedule was correct. The manual entry introduced the error.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It reads the driver schedule and updates all rows in OptimoRoute in one pass.
Open the SheetXAI sidebar and ask:
For each row in columns A through D — driver ID, date, work start time, vehicle ID — update the driver parameters in OptimoRoute and write the update status into column E.
What You Get
- All 20 rows are processed in a single batch operation.
- Column E is written with "updated" or the specific error for each row.
- Rows with a blank driver ID in column A are automatically skipped.
- Unrecognized driver IDs return an error in column E rather than failing silently.
What If the Data Is Not Quite Ready
The schedule includes end times as well as start times
Bulk-update driver work hours and vehicle assignments for all rows in the 'Driver Schedule' worksheet — driver ID in column A, date in column B, start time in column C, end time in column D, vehicle in column E — write the update status into column F.
Some rows have a "skip" flag
For each row in the 'Driver Schedule' worksheet where column F is not marked "skip," update the driver's work start time, end time, and vehicle assignment in OptimoRoute using driver ID from column A — write the update result into column G.
Drivers are split across two worksheets for two depots
Process both the 'Depot A' and 'Depot B' driver schedule worksheets — update all rows in OptimoRoute using driver ID in column A, date in column B, start time in column C, and vehicle in column D — write the update status into column E of each worksheet.
Validate first, update, then pull a confirmation roster
Check the 'Driver Schedule' worksheet for rows where start time is before 05:00 or after 10:00 and flag them in column F before processing — then update all non-flagged rows in OptimoRoute and write results into column G — finally, pull the current driver roster from OptimoRoute into the 'Verification' worksheet to confirm the changes landed correctly.
Validation, update, and verification in one prompt.
Try It
Get the 7-day free trial of SheetXAI and open the driver schedule workbook you use before each planning cycle, then ask it to push all parameter updates to OptimoRoute and write the result status back. Also see how to export the driver roster for payroll cross-referencing, and how to trigger route optimization after parameters are set.