The Scenario
A GIS analyst at a retail chain needs to set up proximity marketing for the upcoming product launch. There are 150 store locations in a spreadsheet — each with a store ID, name, and coordinates. Each store needs a 200-meter circular geofence in Radar, tagged so the marketing team can trigger push notifications when customers enter the zone. The geofence IDs need to come back into the sheet so the marketing platform can reference them.
The bad version:
- Open Radar's dashboard, find the geofence creation form, fill in store 1's name, tag, lat, lng, and radius, submit, copy the returned ID, paste it into column E. Repeat 149 more times.
- Midway through you realize the tag is wrong for the first 40 stores — you used "retail" instead of "retail-store" — and the marketing team's trigger filter won't match.
- Go back and delete those 40 geofences, recreate them with the correct tag, update the spreadsheet. The launch window is in three days.
This is supposed to be a setup task, not a project in itself.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Google Sheet. It reads the store data, calls Radar's geofence creation API for each row with the correct parameters, and writes the returned geofence IDs back into the sheet. One prompt handles all 150.
For each row in this sheet (store ID in A, store name in B, lat in C, lng in D), create a Radar circular geofence with 200-meter radius tagged retail-store and write the returned geofence ID to column E
What You Get
- Column E: the Radar geofence ID for each store, ready to share with the marketing platform
- Any rows where creation failed get a clear error message in column E so you know exactly which stores need a retry
- The geofences are live in Radar immediately — no separate confirmation step needed
What If the Data Is Not Quite Ready
The radius should vary by store type rather than being a flat 200 meters
For each row in this sheet (store ID in A, name in B, lat in C, lng in D, store type in E), create a Radar circular geofence with a radius of 150 meters for "express" stores and 300 meters for "flagship" stores, tag each with retail-store, and write the returned geofence ID to column F
Some stores are flagged as inactive and should be skipped
For each row where column F is not "Inactive": create a Radar circular geofence (store ID in A, name in B, lat in C, lng in D) with 200-meter radius tagged retail-store and write the returned Radar geofence ID to column G
You need a different external ID format for the marketing platform
For each row in this sheet, create a Radar circular geofence using store ID in A prefixed with "store-" as the external ID, name in B as the description, lat in C, lng in D, 200-meter radius, tag retail-store — write the returned Radar geofence ID to column E
Validate coordinates, create geofences, and mark any errors for retry in one pass
For each of the 150 store rows (ID in A, name in B, lat in C, lng in D): verify lat/lng are non-empty and within plausible bounds, then create a Radar circular geofence with 200-meter radius tagged retail-store — write the returned geofence ID to column E, or write the specific error message if creation fails
That last prompt surfaces validation failures and API errors in the same column, so you can sort by column E and batch-retry the failed rows.
Try It
Get the 7-day free trial of SheetXAI and open any Google Sheet with location coordinates — ask it to create Radar geofences for every row and write the returned IDs back into the sheet. To audit existing geofences, see exporting all geofences to a sheet, or return to the Radar integration overview.