The Scenario
You're on the city transport operations team and every shift starts the same way: someone opens an Excel workbook of 10 district bounding boxes and manually queries TomTom's incident API for each one, copies the JSON, pastes the relevant fields into a growing log, and tries not to miss a row. The control room expects the incident list to be current. The current process means it's always 20 minutes stale by the time it's usable.
The bad version:
- Query TomTom's incident endpoint for district 1, read the JSON response, extract incident type, severity, description, and coordinates for each incident, type them into the log sheet row by row
- Move to district 2, repeat, losing your place twice because the JSON is long and the incidents are numbered inconsistently
- Miss two incidents in district 4 because their coordinates were at the edge of the bounding box and the response paginated
The control room dashboard shows what you've typed. What you've typed is already 20 minutes old.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It reads the bounding box definitions, calls TomTom's traffic incident endpoint for each district, and writes every incident's details into the results sheet in one pass.
Fetch all active traffic incidents within the bounding box in cells A1:D1 using TomTom and write each incident's category, start time, delay in seconds, and road name into this Excel sheet
What You Get
- One row per incident in the results sheet
- Columns for incident category, start time, delay in seconds, and road name
- District identifier carried through so you can filter by district
- Empty results for clean districts — not an error, just nothing active
What If the Data Is Not Quite Ready
Bounding boxes are stored as a single polygon string, not four columns
For each row in this workbook, parse the bounding box string in column A into min-lat, max-lat, min-lng, max-lng, then fetch TomTom traffic incidents for that area and write each incident's type, severity, and coordinates into new rows in the "Incidents" sheet
You only want incidents above a certain severity
For each bounding box in columns A through D, fetch TomTom traffic incidents and write only incidents where severity is "major" or "critical" into the results sheet. Include type, severity, description, and coordinates.
You need all districts in one consolidated log
For each bounding box defined by the min/max lat/lng values in columns A through D of this workbook, fetch TomTom traffic incidents and write each incident's type, severity, description, and coordinates into new rows in a results sheet, with district name from column E included in each row.
Full incident digest with summary by district
For each district bounding box in columns A through D, fetch TomTom incidents and write all incidents into the "Log" sheet with district name, type, severity, description, and coordinates. Then write a summary table in the "Summary" sheet showing each district name and its incident count, sorted by count descending.
One prompt pulls all incidents across all districts and builds both the log and the summary.
Try It
Get the 7-day free trial of SheetXAI and open the Excel workbook with your district bounding boxes, then ask it to pull live TomTom traffic incidents into the log sheet. For road-level speed data rather than incidents, see the live traffic flow spoke.