The Scenario
You are a logistics coordinator. It is 6 AM and the incident reporting window closes at 8 AM. You have a dump of 1,200 GPS pings from last night's delivery vehicles in a Google Sheet, latitude in column A, longitude in column B, column C blank.
Your compliance team needs every ping converted to a street address for the incident report. The three pings flagged as anomalous are buried somewhere in the range, and the team cannot look up coordinates by hand.
The bad version of this morning:
- You paste the first coordinate pair into a mapping app
- You read the address, type it into column C
- At row 30 you realize 1,200 rows at two minutes each is 40 hours
- You ask the developer to write a script, who says they can look at it next week
- The 8 AM deadline passes with 1,170 rows still blank.
The fast version is one prompt.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your spreadsheet that reads your coordinate columns and calls HERE Reverse Geocoding for every row, writing street addresses back directly.
Open the SheetXAI sidebar and type:
For each latitude/longitude pair in columns A and B, use HERE Reverse Geocoding to get the full street address and write it to column C. Also write the city name to column D and the postal code to column E.
SheetXAI reads the coordinate pairs, calls HERE for each row, and writes street address, city, and postal code back into columns C, D, and E. All 1,200 rows. Before 8 AM.
What You Get
A fully reverse-geocoded incident log:
- Column C — full street address for each GPS ping
- Column D — city name
- Column E — postal code, for grouping by delivery zone
The flagged anomalous rows now have human-readable addresses, which is what the compliance report actually requires. Filter column C for the three anomalous pings and the addresses are right there.
If you need to add a timestamp column or cross-reference against a list of known delivery zones, ask SheetXAI to do that in a follow-up prompt without re-running the geocoding.
What If the Data Is Not Quite Ready
Real GPS dumps have noise, duplicates, and edge cases. SheetXAI handles them in the same prompt.
When coordinates are in a non-standard format
Your export recorded latitude as "N 40.7128" and longitude as "W 74.0060" with direction prefix letters instead of signed decimals.
Convert the latitude values in column A from "N XX.XXXX" format to signed decimal (positive for N, negative for S) and write to column C. Convert column B longitude from "W XX.XXXX" to signed decimal (negative for W, positive for E) and write to column D. Then reverse-geocode each pair in columns C and D using HERE and write the street address to column E.
When you have duplicate coordinate pairs
The GPS system pinged the same location multiple times. You only need one address per unique coordinate pair.
Identify duplicate lat/lng pairs across columns A and B. For unique pairs only, reverse-geocode using HERE and write the address to column C. For duplicate rows, copy the address from the first occurrence rather than calling HERE again.
When you only need addresses for flagged rows
Column C has an "Anomaly" flag for the incidents that need reporting. You do not want to reverse-geocode 1,200 rows for a 15-row report.
For rows where column C equals "Anomaly", reverse-geocode the coordinates in columns A and B using HERE and write the full address to column D and the postal code to column E. Skip all other rows.
When you need reverse geocoding and then zone matching in one pass
You want addresses and you want to know which delivery zone each ping falls into, based on a zone reference table in the "Zones" tab.
Reverse-geocode all coordinate pairs in columns A and B using HERE, writing the street address to column C and the postal code to column D. Then look up each postal code in the Zones tab (postal code in column A, zone name in column B) and write the matching zone name to column E. Flag rows where no zone match is found with "Unzoned" in column E.
The pattern: instead of reverse-geocoding, then manually doing zone lookups, you describe both operations in one prompt and SheetXAI runs them together.
Try It
Get the 7-day free trial of SheetXAI and open any sheet with GPS coordinates, then ask it to convert them to addresses using HERE. The HERE integration is included in every SheetXAI plan. See also how to pull live traffic incidents for delivery zones or the HERE in Google Sheets overview.