The Scenario
A location-services engineer is preparing to migrate a Radar project to a new environment. Before doing anything, she needs a full inventory of the 400 geofences currently in the project — tags, radii, external IDs, center coordinates — so she can validate that the migration carried everything over correctly. The audit needs to live in a Google Sheet that the team can review and annotate.
The bad version:
- Open Radar's dashboard, navigate to the geofences list, scroll through pages of geofences, and manually copy ID, tag, radius, and coordinates for each one into a spreadsheet.
- Radar paginates at 100 geofences per page. Four pages, each requiring its own copy-paste session, trying to keep track of which page you're on.
- After pasting page 3 you close the wrong browser tab and have to start page 3 over. The inventory takes most of the morning.
The migration is scheduled for tomorrow. There is still a test plan to write.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Google Sheet. It calls Radar's geofence list API, handles pagination automatically, and writes every geofence into the sheet — one row per geofence, all fields in the columns you specify.
Try this yourself — free for 7 days
SheetXAI installs in your Google Sheet in about a minute. Paste the prompt below and watch it run.
List all geofences from Radar and write each geofence's ID, description, tag, external ID, and radius into columns A through E of this sheet
What You Get
- One row per geofence, no pagination gaps
- Column A: Radar geofence ID
- Column B: description
- Column C: tag
- Column D: external ID
- Column E: radius in meters
- The sheet is ready to share with the team for annotation and migration validation immediately
What If the Data Is Not Quite Ready
You only need geofences with a specific tag for the audit scope
List all Radar geofences with the tag "production" and write each geofence's ID, description, external ID, and radius to columns A through D of this sheet
You need center coordinates included alongside the metadata
List all Radar geofences and write ID, description, tag, external ID, radius, center latitude, and center longitude into columns A through G of this sheet
The inventory needs to be sorted by tag for the migration checklist
List all Radar geofences and write ID, tag, external ID, radius, and description to columns A through E, then sort all rows by tag in column B alphabetically
Fetch all geofences, flag any missing external IDs, and add a migration status column in one pass
List all Radar geofences and write ID, description, tag, external ID, and radius to columns A through E — add a "Status" column F that says "Missing External ID" for rows where column D is empty, and "Ready" for all others
That last prompt gives you an actionable migration checklist without a separate review pass.
Try It
Get the 7-day free trial of SheetXAI and open any Google Sheet — ask it to pull all Radar geofences and write the complete inventory into the sheet in one pass. To create geofences from a sheet, see bulk geofence creation, or return to the Radar integration overview.