The Scenario
A compliance analyst at a logistics company is three days before an audit. The committee wants evidence that 100 field agents were in their assigned service zones when they submitted their check-ins last quarter. The check-in coordinates are in an Excel workbook. The service zones are geofences in Radar. The analyst needs to know which geofence — if any — covers each coordinate, and the answer has to be documented in the workbook before the audit starts.
The bad version:
- Ask the data engineering team for a script that can do the lookups. They have a sprint in progress and this goes to the bottom of the queue.
- Try to use Radar's dashboard to look up coordinates one at a time. The dashboard has a geocoder but not a "which geofence is this point inside" tool.
- Start doing it manually via Radar's API in Postman. The first 10 rows take 25 minutes. There are 90 more rows and the audit starts Thursday.
The audit committee doesn't care about sprint priorities. The documentation has to exist.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Excel workbook. It reads the coordinate pairs, calls Radar's geofence search API for each row, and writes the matching geofence external ID and tag back into the workbook — the compliance documentation, produced without touching the engineering team.
Look up which Radar geofences cover each of the 100 coordinates in this Excel workbook (lat in A, lng in B) and write the matching geofence external ID and tag to columns C and D
What You Get
- Column C: external ID of the geofence covering each coordinate, or "None" if no geofence matched
- Column D: the geofence tag — which maps to the territory or pricing tier in the compliance framework
- The "None" rows immediately flag agents whose check-in locations fell outside all defined service zones
What If the Data Is Not Quite Ready
You need the geofence name rather than the external ID for the audit report
For each coordinate pair in this workbook (lat in A, lng in B), search Radar for geofences within 100 meters and write the matching geofence name and tag to columns C and D — write None if no match found
Some rows have already been reviewed and should be skipped
For each row where column E is blank: search Radar for geofences covering the coordinates in columns A and B (within 100m), write the geofence external ID to column C and tag to column D, then mark column E as Reviewed
A coordinate might fall inside multiple overlapping geofences — you need all of them
For each coordinate pair (lat A, lng B), search Radar for all geofences within 100 meters and write all matching external IDs (comma-separated) to column C and all matching tags (comma-separated) to column D
Validate coordinates, check geofence membership, and generate a compliance status column in one pass
For each of the 100 rows (lat in A, lng in B): validate that the coordinates are in a plausible geographic range, search Radar for geofences within 100 meters, write the geofence external ID to column C and tag to column D — then add a Compliance column E: "In Zone" if a geofence matched, "Out of Zone" if none, "Invalid Coordinates" if the input failed validation
That compliance column is the documentation the audit committee asked for.
Try It
Get the 7-day free trial of SheetXAI and open any Excel workbook with coordinate pairs — ask it to check which Radar geofences cover each point and write zone membership into the workbook. To search for nearby places instead, see finding nearby places for coordinates, or return to the Radar integration overview.