The Scenario
A marketing technologist spent the past six weeks managing a seasonal promotion. It ran across 60 store locations, each with a custom Radar geofence tied to proximity triggers. The campaign ended yesterday. The geofence IDs are already in a Google Sheet from when they were created. Now those 60 geofences need to be deleted from Radar before they pollute the next campaign's analytics.
The bad version:
- Open Radar's dashboard, find the geofence list, search for the first ID, click into it, click delete, confirm. Repeat 59 more times.
- Radar doesn't have a bulk delete in the UI, so each deletion is its own three-click sequence.
- Halfway through, a colleague asks if geofence ID "abc-789" from the list is actually supposed to stay — it belongs to a different campaign that's still active. Spend ten minutes cross-referencing the spreadsheet to figure out if it's safe to delete.
Sixty deletions, one at a time, while fielding interruptions about which ones are safe to remove.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Google Sheet. It reads the ID column, calls Radar's deletion API for each one, and writes the result — "Deleted" or the error message — back into the sheet so you have a clean audit trail.
For each geofence ID in column A of this sheet, delete it from Radar and write Deleted or the error message to column B
What You Get
- Column B: "Deleted" for every successfully removed geofence
- Any geofence that couldn't be deleted gets the specific error message from Radar in column B — so you know exactly which ones need attention and why
- The column serves as a deletion audit log for the campaign wrap-up report
What If the Data Is Not Quite Ready
Some geofences in the sheet are flagged as "keep" and should not be deleted
For each row in this sheet where column B is "Delete": delete the geofence ID in column A from Radar and write Deleted or the error to column C — skip all rows where column B is "Keep"
You want to confirm the geofence tag before deleting to avoid accidentally removing wrong-campaign fences
For each ID in column A: fetch the Radar geofence to confirm its tag matches "seasonal-promo-2026" before deleting — write Deleted if confirmed and deleted, Skipped (wrong tag) if the tag doesn't match, or the error message if deletion failed
The list includes some IDs that may no longer exist in Radar
For each geofence ID in column A: attempt deletion via Radar and write Deleted to column B if successful, Already Gone if Radar returns a 404, or the error detail for any other failure
Validate the list, filter to safe deletions, delete, and log results in one pass
In this sheet: for each row where column A has a geofence ID and column B is "Confirmed Delete" — call Radar to delete that geofence and write the outcome to column C (Deleted, Already Gone, or the error message), then add a summary at the bottom: total deleted, total already gone, total errors
The summary row at the bottom gives you what you need for the campaign close-out checklist without a manual count.
Try It
Get the 7-day free trial of SheetXAI and open any Google Sheet with a column of Radar geofence IDs — ask it to delete each one and write the outcome back into the row. To rebuild geofences for a new campaign, see bulk geofence creation, or return to the Radar integration overview.