The Scenario
You're writing property listing summaries for a commercial real estate firm. Fifteen target neighborhoods are in the sheet. For each one, the brief says to include the nearest hospital, pharmacy, and primary school — distances included. It's the kind of enrichment that makes a listing look researched and thorough, and the account manager wants the draft by 3 PM.
It's 11 AM. You have 15 locations and 3 POI types per location. That's 45 TomTom searches you have no efficient way to run.
The bad version:
- Go to TomTom's POI search developer page, enter the first neighborhood's coordinates, search for "hospital," read the first result's name and distance, paste them into the sheet
- Repeat for pharmacy, then primary school, then move to neighborhood 2
- 45 searches at 2–3 minutes each is a full morning, and you still have to write the summaries after
The copy is due at 3. The research phase was supposed to take an hour.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It reads the neighborhood locations, calls TomTom POI search for each named place type, and writes the results back into the columns you specify.
For each neighborhood address in column A, use TomTom POI search to find the nearest hospital, pharmacy, and school, and write their names and distances in metres into columns B through G
What You Get
- Column B: nearest hospital name
- Column C: distance to nearest hospital in metres
- Column D: nearest pharmacy name
- Column E: distance to nearest pharmacy in metres
- Column F: nearest school name
- Column G: distance to nearest school in metres
What If the Data Is Not Quite Ready
Addresses need geocoding first
For each neighborhood address in column A, geocode it using TomTom and write lat/lng into columns B and C. Then use those coordinates to find the nearest hospital, pharmacy, and school using TomTom POI search. Write each name and distance in metres into columns D through I.
You need EV charging stations instead of the standard three types
For each lat/lng pair in columns A and B of my sheet, search for EV charging stations within 2km using TomTom and write the number found and the nearest station's name and distance into columns C, D, and E
Results need to be formatted for direct use in listing copy
For each neighborhood address in column A, find the nearest hospital, pharmacy, and school using TomTom POI search. Write a single formatted sentence for each row into column B, e.g. "Within 400m: St. Mary's Hospital, Boots Pharmacy, Greenfield Primary School."
Full neighborhood scorecard in one shot
For each neighborhood in column A, geocode the address using TomTom, then find the nearest hospital, pharmacy, school, and supermarket. Write each name and distance in metres into columns B through I. Then write a one-sentence summary combining all four results into column J.
One prompt handles the geocoding, the four POI lookups, and the summary text.
Try It
Get the 7-day free trial of SheetXAI and open the Google Sheet with your neighborhood list, then ask it to find the nearest named POIs using TomTom. For scoring locations by POI category counts rather than named results, see the nearby POI enrichment spoke.