The Scenario
A local government department is rebuilding its public services map. You have a spreadsheet with 200 community facility names — libraries, health centres, community halls, sports grounds — collected from four different council datasets with inconsistent naming conventions. The mapping team needs a verified address, GPS coordinates, and LINZ ID for each one before they can place the pins.
The mapping team's deadline is next Friday. The data you've been handed is a list of names. Not addresses.
The bad version:
- Google each facility name individually, copy the address from the search result, paste it into the sheet.
- Realise that "Northcote Community Hall" returns three different results depending on how you phrase the search and that one of them is in a different suburb entirely.
- Manually verify the ambiguous ones against council records, then run the confirmed addresses through the Addressfinder NZ API to get the LINZ IDs and coordinates.
- Merge the API output back into the sheet row by row.
200 names, many of them ambiguous, with a manual lookup step before you can even run the verification. There's no clean version of this that doesn't eat most of the week.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It reads the POI names in your column and through its built-in Addressfinder NZ POI integration it can look up each facility, retrieve the matched address and coordinates, and write the results directly back into the columns you specify.
Look up each POI name in column A using the Addressfinder NZ POI API and write the matched address, latitude, and longitude to columns B, C, and D
What You Get
- Column B: verified address for the matched point of interest
- Column C: GPS latitude (decimal degrees)
- Column D: GPS longitude (decimal degrees)
- Rows where the POI name doesn't return a confident match are flagged REVIEW in column B so you can investigate them before the mapping import
What If the Data Is Not Quite Ready
Some facility names have trailing "(closed)" or "(relocated)" notes
For POI names in column A that contain parenthetical notes like "(closed)" or "(relocated)", strip the note before querying Addressfinder NZ POI, then write the matched address and lat/lng to columns B, C, and D. Flag any closed facilities as INACTIVE in column E.
You also need the LINZ ID for each result
For every point-of-interest name in this sheet, fetch the full NZ POI metadata from Addressfinder and add the address, GPS coordinates, and LINZ address identifier to columns B, C, D, and E
Some rows have the suburb in column B to help disambiguate
For POI names in column A, use the suburb in column B as a disambiguation hint when querying the Addressfinder NZ POI API — write the matched address, lat, lng, and LINZ ID to columns C, D, E, and F
Look up, enrich, flag ambiguous matches, and produce a map-ready export in one pass
For all 200 POI names in column A: use the suburb in column B as a disambiguation hint, query the Addressfinder NZ POI API for each one, write the matched address, lat, lng, and LINZ ID to columns C, D, E, and F. Flag any row where the match confidence is below 90% as REVIEW in column G. Then add a summary row at the bottom showing how many POIs were matched, how many need review, and how many returned no result.
One prompt produces the enriched dataset and the quality flags — ready for the mapping import without a week of manual lookups.
Try It
Get the 7-day free trial of SheetXAI and open your facilities list, then ask it to run an Addressfinder NZ POI lookup on your name column and write back the addresses and coordinates. For verifying plain-text NZ street addresses against LINZ instead, see verifying NZ addresses with LINZ coordinates, or return to the hub overview.