The Scenario
A compliance analyst has 100 field agent check-in locations in an Excel export, now pasted into a Google Sheet. Each location is a lat/lng pair. The compliance question is whether each agent was inside the correct service zone when they checked in — because pricing tiers are determined by territory, and the audit committee wants documented evidence. The service zones are geofences in Radar.
The bad version:
- Take the first coordinate pair, open Radar's dashboard, use the location search to see what geofences it falls inside, note the zone name, paste it into the sheet. Repeat 99 more times.
- Radar's dashboard doesn't have a "which geofences is this point inside" lookup — you'd need to use the API or the search in a way it wasn't designed for.
- Ask the engineering team for help. They're three sprints deep and this gets added to the backlog. The audit committee deadline is in two weeks.
The documentation has to exist before the committee meeting. Waiting on a sprint is not a plan.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Google Sheet. It reads the coordinate pairs, calls Radar's geofence search API for each row, and writes the matching geofence names and tags back into the sheet — producing the compliance documentation in one pass.
For each coordinate pair in this sheet (lat in A, lng in B), search Radar for geofences within 500 meters and write the matching geofence names and tags to columns C and D
What You Get
- Column C: name of the geofence covering each coordinate, or "None" if no match was found
- Column D: the geofence tag — which is the territory label used in the pricing tier system
- The "None" rows immediately identify agents whose check-in locations fall outside all defined service zones
What If the Data Is Not Quite Ready
You need the external ID of the matching geofence rather than the name
For each coordinate pair in this sheet (lat in A, lng in B), search Radar for geofences within 500 meters and write the matching geofence external ID and tag to columns C and D — write None if no geofence matches
Some rows are flagged as already reviewed and should be skipped
For each row where column E is blank: search Radar for geofences covering the coordinate pair in columns A and B (within 500m), write the geofence name to column C and tag to column D, then mark column E as Reviewed
You need to know if a location falls inside multiple geofences — not just the first match
For each coordinate pair (lat A, lng B), search Radar for all geofences within 100 meters and write all matching geofence names (comma-separated) to column C and all matching tags (comma-separated) to column D
Validate coordinates, look up geofence membership, and assign a compliance status in one pass
For each of the 100 rows (lat in A, lng in B): validate the coordinates are in plausible range, search Radar for geofences covering the point within 100 meters, write the matching geofence external ID to column C and tag to column D, then add a Compliance Status in column E: "In Zone" if a match was found, "Out of Zone" if none, "Invalid Coordinates" if the input was bad
That status column is the documentation the committee asked for.
Try It
Get the 7-day free trial of SheetXAI and open any Google Sheet with coordinate pairs — ask it to check which Radar geofences cover each point and write the zone names and tags into the sheet. To search for nearby places instead, see finding places near coordinates, or return to the Radar integration overview.