The Scenario
You're an insurance adjuster. A batch of 400 new claims came in this morning, each with a claim site address and an assigned service center. You need the driving distance and approximate travel time between each pair for the mileage reimbursement calculations — by end of business today.
The claims team used to have someone whose entire job included this step. That person retired.
The bad version:
- Open Google Maps Directions, type the first claim address as the starting point and the service center as the destination, read the driving distance and time from the route summary
- Switch to the workbook, find the right row, type the distance in column C and the minutes in column D
- Repeat for claim 2, claim 3 — hit claim 15 and realize you've been using the wrong service center for the last four rows because the assignment column wasn't sorted the way you assumed
400 pairs. Typed one at a time. That's the kind of task that gets delegated to a temp, except the budget for a temp doesn't exist right now.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Excel workbook that calls the Google Maps Directions API for each origin–destination pair and writes the route summary back to the workbook.
Calculate the driving directions between the origin and destination address pairs in my Excel sheet using Google Maps, and fill in distance, estimated travel time, and the primary route name for each pair
What You Get
- The distance column fills with driving distance in kilometers for each pair
- The duration column fills with estimated travel time in minutes
- The route name column fills with the primary route identifier (highway or road name)
- Rows where routing fails (unresolvable address, no road connection) get a flag rather than a blank
What If the Data Is Not Quite Ready
The workbook has service center names, not addresses — need to resolve them first
In my Excel workbook, column A has claim site addresses and column B has service center names. Look up each service center name against the Centers worksheet (column A = name, column B = address) to get the address, then compute the Google Maps driving distance and duration between each claim site and its matched center. Write distance (km) into column C and duration (min) into column D.
Some claim addresses are incomplete — missing city or state
For each row in my Excel workbook, check if the address in column A contains a city and state. If not, append the state from cell F1 before computing the Google Maps route to the destination in column B. Write distance into column C and duration into column D. Flag incomplete addresses in column E.
The reimbursement policy uses miles, not km, and rounds up to the nearest half-mile
Compute the Google Maps driving route for each origin–destination pair in my Excel workbook. Convert the distance from km to miles and round up to the nearest 0.5 miles. Write the rounded distance into column C, the travel time in minutes into column D, and apply the reimbursement rate in cell H1 ($/mile) to compute the total reimbursement amount in column E.
Full reimbursement pipeline: route lookup, distance conversion, rate application, and tier flag — one prompt
For each row in my Excel workbook where column A is an origin and column B is a destination, get the Google Maps driving route. Convert distance to miles. Compute reimbursement using the rate in H1 ($/mile). Write miles into column C, minutes into column D, reimbursement amount into column E. Flag "High mileage" in column F if distance exceeds 50 miles.
One prompt covers the route math, the unit conversion, and the business logic.
Try It
Get the 7-day free trial of SheetXAI and open your claims or logistics workbook — ask SheetXAI to compute the route summary for every origin–destination pair. For large routing datasets, also see how to build a full driving distance matrix across multiple depots and destinations.