The Scenario
Your company runs eight distribution centers and the ops team is redesigning last-mile delivery zones. The question on the table: which geographic area can each depot realistically serve within 30 minutes of drive time? You're the logistics manager. You have the depot coordinates in a Google Sheet. You need TomTom's reachable-range calculation run for each one — but there's no straightforward way to do that from a spreadsheet without writing API calls.
The bad version:
- Open TomTom's developer documentation, find the reachable-range endpoint, set up an API call for the first depot, parse the polygon response, manually extract the bounding box coordinates, type them into columns C through F
- Repeat for all eight depots
- Realize you're not sure whether the bounding box you extracted is in the right coordinate order, so the coverage maps your GIS team draws end up covering the wrong areas
The zone redesign presentation is next week. The GIS team needs the bounding boxes now to start drawing.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It reads the depot coordinates, calls TomTom's reachable-range API for each one, and writes the coverage results back into the sheet.
For each depot lat/lng in columns A and B of this sheet, calculate the TomTom reachable range within 30 minutes of driving time and write the bounding box coordinates of the reachable area into columns C through F
What You Get
- Column C: minimum latitude of the reachable bounding box
- Column D: maximum latitude
- Column E: minimum longitude
- Column F: maximum longitude
- Results for all eight depots in one pass
What If the Data Is Not Quite Ready
Time budget varies by depot
For each depot in this sheet, use the lat/lng in columns A and B and the time budget in minutes in column C. Calculate the TomTom reachable range and write the bounding box coordinates into columns D through G.
You need area estimate alongside the bounding box
For each vehicle starting point in column A of my sheet and the fuel budget in column B, calculate the TomTom reachable range and write the polygon area in km squared and maximum reachable distance in km into columns C and D
Only calculate for depots flagged as active
For all rows in this sheet where column C says "active", use the lat/lng in columns A and B to calculate the TomTom 30-minute reachable range. Write bounding box coordinates into columns D through G and skip rows where column C is anything other than "active".
Full coverage analysis in one shot
For each depot in columns A and B, calculate the TomTom reachable range within 30 minutes. Write the bounding box into columns C through F. Calculate the approximate coverage area in km squared and write it into column G. Then sort the sheet by column G descending so the largest coverage depots appear first.
One prompt calculates all eight ranges, extracts the bounding boxes, estimates the area, and sorts the output.
Try It
Get the 7-day free trial of SheetXAI and open the Google Sheet with your depot coordinates, then ask it to calculate reachable ranges using TomTom. If you're also working on full route calculations between depot and customer pairs, see the driving distance and time spoke.