The Scenario
A GIS analyst at a retail chain has an Excel workbook with 150 store locations — each row has a store ID, name, latitude, and longitude. The marketing team is launching a proximity campaign next week and needs a 200-meter circular geofence in Radar for each store. The geofence IDs need to come back into the workbook so the campaign platform can reference them. The launch window is in four days.
The bad version:
- Open Radar's dashboard, navigate to geofence creation, fill in store 1's fields, submit, copy the returned ID, paste into column F. Repeat 149 more times.
- Discover at store 23 that the tag was entered as "retail" but the campaign platform expects "retail-store" — all 23 need to be deleted and recreated.
- The deletion and recreation loop takes a full day. The launch is now two days away and there are still 127 geofences to create.
The geofence setup was supposed to take a morning. It has now consumed two days and introduced a tagging error that has to be manually undone.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Excel workbook. It reads the store rows, calls Radar's geofence creation API for each one with the correct parameters, and writes the returned geofence IDs back into the workbook in one pass.
Create Radar geofences for all 150 store rows in this Excel workbook (ID in A, name in B, lat in C, lng in D, radius in E) and write each returned Radar geofence ID to column F
What You Get
- Column F: the Radar geofence ID for each store — ready to hand to the campaign platform
- Any rows where geofence creation failed get the specific error message in column F, not a blank, so you know exactly which stores need a retry
- All 150 geofences created with consistent parameters in one pass
What If the Data Is Not Quite Ready
Radius should vary by store format rather than coming from a column
For each row in this workbook (ID in A, name in B, lat in C, lng in D, store type in E): create a Radar circular geofence with 150-meter radius for "express" store type and 300-meter radius for "flagship" — tag each as retail-store and write the returned Radar ID to column F
Some stores are flagged as excluded from the campaign
For each row where column G is not "Excluded": create a Radar circular geofence using store ID in A, name in B, lat in C, lng in D — 200-meter radius, tagged retail-store — and write the returned geofence ID to column H
You need a custom external ID format for the campaign platform integration
For each store row (ID in A, name in B, lat in C, lng in D): create a Radar circular geofence with external ID formatted as "store-{ID}", description as the store name, 200-meter radius, tag retail-store — write the returned Radar geofence ID to column E
Validate coordinates, create geofences, and log outcomes for the launch checklist in one pass
For all 150 store rows (ID in A, name in B, lat in C, lng in D): confirm lat/lng are non-empty and within plausible bounds, then create a Radar circular geofence with 200-meter radius tagged retail-store — write the Radar geofence ID to column E if successful, or the specific error to column E if not, and add a count summary at the bottom: total created, total failed
The summary row is what you need for the campaign launch sign-off.
Try It
Get the 7-day free trial of SheetXAI and open any Excel workbook with store location coordinates — ask it to create Radar geofences for every row and write the returned IDs into the workbook. To audit existing geofences, see exporting all geofences to a workbook, or return to the Radar integration overview.