The Scenario
You are a fleet dispatcher. It is 6:50 AM. Drivers clock in at 7:30 AM and expect zone assignments when they walk through the door. You monitor 5 delivery zones across the metro area. Each zone has a bounding box defined in rows 2–6 of your Google Sheet, columns A through D.
You need to know right now which zones have active traffic incidents before you route anyone into them.
The bad version of this morning:
- You open a traffic app on your phone
- You zoom into zone 1, count the incidents, write the number on a sticky note
- You zoom into zone 2, do the same
- You check zone 3 but the app refreshes and loses your place
- By 7:30 AM you have three zones covered, two guesses, and six drivers waiting.
The fast version is one prompt.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your spreadsheet that reads your zone bounding boxes and calls HERE Traffic for each one, writing the results back before your drivers arrive.
Open the SheetXAI sidebar and type:
For each of the 5 delivery zones defined in rows 2–6 (bounding boxes in columns A–D as min_lat, min_lng, max_lat, max_lng), fetch current HERE traffic incidents and write the count of all incidents to column E, the count of high-severity incidents to column F, and the most recent incident description to column G.
SheetXAI reads the five bounding boxes, calls HERE Traffic for each zone, and writes incident counts and the most recent description back into the sheet. By 7:15 AM you have a live snapshot across all five zones.
What You Get
A pre-dispatch incident summary across all zones:
- Column E — total incident count per zone
- Column F — high-severity incident count per zone
- Column G — most recent incident description per zone, so you know what type of disruption to expect
Sort column F descending and the worst zones surface immediately. Pull drivers from zone 2, redirect zone 4 drivers through the bypass, send the rest on standard routes.
Want incident type broken out into separate columns (accident, construction, congestion)? Ask SheetXAI to restructure the output in a follow-up prompt.
What If the Data Is Not Quite Ready
Zone definitions change, bounding boxes need adjusting, and sometimes you need more detail than a count. SheetXAI handles the variations in the same prompt.
When bounding boxes are stored as a single cell string
Your sheet stores each zone's bounding box as one string, "40.70,-74.02,40.73,-73.99", not in four separate columns.
Parse the bounding box string in column A (format: min_lat,min_lng,max_lat,max_lng) and use HERE Traffic to fetch current incidents for each zone. Write total incident count to column B and high-severity count to column C.
When you want incidents grouped by type
Your ops team needs to distinguish between accidents, road closures, and construction, not just a total count.
For each zone bounding box in columns A–D, fetch current HERE traffic incidents and write the count of accidents to column E, road closures to column F, and construction incidents to column G. Leave the column blank if none of that type are found.
When you only want to check zones with active routes today
Column H has a "Routes Active" flag. On some days certain zones have no assigned drivers.
For rows where column H equals "Yes", fetch current HERE traffic incidents for the bounding box in columns A–D and write total incident count to column E and high-severity count to column F. Skip rows where column H is not "Yes".
When you need traffic data and a routing decision in one pass
You want the incident count and you want SheetXAI to flag which zones should trigger a route change, based on a threshold you set.
Fetch current HERE traffic incidents for each zone bounding box in rows 2–6 (columns A–D). Write incident counts to column E and high-severity counts to column F. Then add a flag in column G: write "Reroute" if column F is greater than 2, otherwise write "Clear". Sort the result by column F descending so the highest-risk zones appear first.
The pattern: pull the data and apply the decision rule in one prompt, so you walk into the 7:30 AM briefing with a prioritized list, not a raw count.
Try It
Get the 7-day free trial of SheetXAI and open any sheet with geographic zones defined as bounding boxes, then ask it to fetch HERE traffic incidents. The HERE integration is included in every SheetXAI plan. See also how to optimize a multi-stop delivery route or the HERE in Google Sheets overview.