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 Excel workbook, columns A through D.
You need a live traffic incident snapshot before routing anyone.
The bad version of this morning:
- You open a traffic app and check zone 1, count incidents, write the number somewhere
- The app refreshes mid-way through zone 3 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 Excel workbook 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 descriptions back into the workbook. 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
Sort column F descending and the worst zones surface immediately.
What If the Data Is Not Quite Ready
Zone definitions change and sometimes you need more detail. SheetXAI handles the variations in the same prompt.
When bounding boxes are stored as a single cell string
Your workbook stores each zone's bounding box as one string, "40.70,-74.02,40.73,-73.99".
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 accidents, road closures, and construction counted separately.
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. 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 a flag indicating which zones need rerouting.
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. Add a flag in column G: write "Reroute" if column F is greater than 2, otherwise write "Clear". Sort 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 Excel workbook with zone 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 in Excel or the HERE in Excel overview.