The Scenario
You inherited a logistics sheet from someone who left the company. Column A has waypoints — GPS coordinates for 150 delivery stops collected from a field team's GPS devices over the past quarter. Column B has a label for each stop. That's it. No addresses. No suburbs. No postcodes.
The driver manifest for next week needs street addresses, not coordinates. Your operations manager has asked for it by end of day.
The bad version:
- Copy the coordinates from column A, paste them into a mapping tool or reverse-geocode API one by one.
- Manually transfer the returned addresses into the sheet row by row.
- Discover that 12 of the coordinates are in areas the mapping tool doesn't cover precisely and return a nearest-road address rather than a specific property address.
- Re-check those 12 manually against a satellite view before adding them to the manifest.
150 rows, one at a time, before end of day. You'd rather not.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It reads the coordinate data and through its built-in Addressfinder NZ Reverse Geocode integration it can convert every coordinate pair to a verified NZ address and suburb — writing the results directly into the columns you specify.
Use the Addressfinder NZ Reverse Geocode API on the coordinates in columns B and C and write the nearest official address and suburb into columns D and E
What You Get
- Column D: nearest verified NZ address to each coordinate (LINZ-matched)
- Column E: suburb for the matched address
- Any coordinate that falls outside the NZ address coverage area is flagged as UNMATCHED in column D so you can review it before finalising the manifest
What If the Data Is Not Quite Ready
Latitude and longitude are in a single column separated by a comma
The coordinates in column A are formatted as "lat,lng" — split them, then run Addressfinder NZ Reverse Geocode on each pair and write the nearest address and suburb to columns B and C
You also need the postcode and LINZ ID for each result
Reverse-geocode all 150 coordinate pairs in this sheet using Addressfinder NZ and add the matched address, city, and LINZ ID to columns D, E, and F
Some coordinates are clustered within the same property
For rows in columns B and C where multiple coordinate pairs resolve to the same Addressfinder NZ result, write the address once in column D and note the number of waypoints at that location in column E
Geocode, enrich, flag outliers, and format the manifest in one prompt
Reverse-geocode all coordinate pairs in columns B and C using Addressfinder NZ — write the matched address, suburb, and postcode to columns D, E, and F. Flag any row where the nearest address is more than 100 metres from the coordinate as REVIEW in column G. Then create a driver manifest table below row 152 with stop number, address, and suburb sorted by row order.
One prompt produces the addresses, the quality flags, and the formatted manifest — ready for the driver briefing.
Try It
Get the 7-day free trial of SheetXAI and open your waypoint sheet, then ask it to run a reverse-geocode pass using Addressfinder NZ and write back the verified addresses and suburbs. For verifying plain-text NZ addresses against LINZ instead, see verifying NZ addresses with LINZ coordinates, or return to the hub overview.