The Scenario
A location-services engineer needs to audit all geofences in a Radar project before migrating to a new environment. The project has grown to 400 geofences and nobody has a complete inventory. The migration script will use external IDs as the join key — so before anything runs, the engineer needs all geofences, with their tags, radii, and external IDs, documented in an Excel workbook that the team can verify and annotate.
The bad version:
- Log into Radar's dashboard, navigate to geofences, and start copying data from the list. The list paginates at 100 per page. Four pages.
- Copy page 1: 100 rows, pasted into the workbook. The column order from the dashboard doesn't match the migration template, so spend time rearranging columns.
- Copy page 2. Realize that Radar's dashboard sorted the list differently between page 1 and page 2 loads, possibly due to a background update. Now the page numbering may have shifted and you might have a gap or a duplicate somewhere in the middle.
The migration is tomorrow. The inventory needs to be verified before end of business today.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Excel workbook. It calls Radar's geofence list API, handles pagination automatically, and writes every geofence into the workbook with the fields you need for the migration — in one consistent pull, no page-order drift.
Fetch all Radar geofences and paste them into this Excel workbook — one row per geofence — with columns for Radar ID, tag, external ID, center coordinates, and radius
What You Get
- One row per geofence, all 400 resolved across pages
- Radar ID, tag, external ID, center latitude, center longitude, and radius in separate columns
- The inventory is ready to cross-reference against the migration template immediately
What If the Data Is Not Quite Ready
You only need geofences with a specific tag for the migration scope
List all Radar geofences with the tag "production" and write each geofence's ID, external ID, tag, and radius to columns A through D of this workbook
You need the description field included for the migration validation
Fetch all Radar geofences and write ID, description, tag, external ID, center lat, center lng, and radius to columns A through G of this workbook
The inventory needs to be sorted by external ID for the migration join
Fetch all Radar geofences and write ID, tag, external ID, and radius to columns A through D — then sort all rows by external ID in column C alphabetically before writing
Pull all geofences, flag any with missing external IDs, and mark migration readiness in one pass
Fetch all Radar geofences and write ID, description, tag, external ID, and radius to columns A through E — add a Migration Status column F: "Ready" if column D (external ID) is non-empty, "Missing External ID" if blank
The status column tells you exactly which geofences will break the migration join before the script runs.
Try It
Get the 7-day free trial of SheetXAI and open any Excel workbook — ask it to pull all Radar geofences and write the complete inventory into the workbook in one pass. To create new geofences from a workbook, see bulk geofence creation, or return to the Radar integration overview.