The Scenario
You are an HR and logistics coordinator. Every Monday before the week's routes are generated, the payroll team sends a message: they need an up-to-date driver roster to cross-reference against hours logged in the payroll system. Name, status, contact info, vehicle assignment. It takes you 15 minutes to pull this out of OptimoRoute every single week, and the payroll team has started asking for it by 8 AM, which means it is the first thing on your plate before you have had coffee.
This week a new driver was added to OptimoRoute on Friday afternoon, after last week's roster was sent. Payroll does not know she exists yet.
The bad version:
- You log into OptimoRoute, navigate to the Drivers section, and start scrolling through the driver list. OptimoRoute shows you 30 drivers. You copy names and phone numbers by hand into a spreadsheet template.
- Halfway through, you realize the template expects email addresses and OptimoRoute's driver screen does not show them in the main list — you have to click into each individual driver profile to find it.
- 30 drivers, 30 profile clicks. It is 8:45 AM. Payroll has already sent a follow-up.
Every week the same task. Every week the same 15 minutes.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It can pull the entire driver roster from OptimoRoute and write it into the sheet in one call — no clicking through individual profiles.
Open the SheetXAI sidebar and ask:
Fetch all drivers from OptimoRoute and write their name, status, phone number, and vehicle assignment into this sheet starting at row 2.
What You Get
- Every driver in OptimoRoute is written into the sheet — one row per driver.
- Columns: name, status, phone number, vehicle assignment.
- Rows start at row 2, leaving row 1 for the headers you already have.
- Drivers with no vehicle assignment have that cell left blank rather than populated with a placeholder.
- Newly added drivers — like the one added Friday — are included automatically.
What If the Data Is Not Quite Ready
Payroll also needs email addresses, which require individual profile lookups
Get the full driver list from OptimoRoute and populate the 'Drivers' tab with columns: driver ID, name, email, phone, and current status — sort by status so active drivers appear first.
The roster needs to be compared against last week's version to flag new additions and departures
Fetch the current driver roster from OptimoRoute and write it into the 'Current Roster' tab — then compare it against the names in the 'Last Week' tab and write any new additions into column F of 'Current Roster' marked as "new" and any names present last week but missing now into a 'Departures' tab.
Payroll wants the roster sorted differently — by last name, then by depot
Pull the full driver roster from OptimoRoute and write it into this sheet sorted alphabetically by last name within each depot group — include name, status, phone, email, and vehicle.
You need the roster, payroll cross-reference, and a count of drivers per vehicle type in one pass
Fetch all drivers from OptimoRoute and write them into the 'Roster' tab with name, status, phone, email, and vehicle — then in the 'Summary' tab write a count of drivers per vehicle type and a count of active vs. inactive drivers, and flag any driver whose vehicle field is blank.
The summary and roster land together. Payroll gets what it needs; you get what you need.
Try It
Get the 7-day free trial of SheetXAI and open the driver roster sheet you send to payroll each week, then ask it to pull the current driver list from OptimoRoute and populate it. Also see how to bulk-update driver parameters before the planning cycle, and how to export route assignments after planning runs.