The Scenario
A security compliance officer received a request from the audit committee on a Monday morning: produce a complete access log of all geofence entry and exit events from the past 30 days, formatted as a spreadsheet, by end of week. The data lives in Radar. The officer has no API access and the engineering team is heads-down on a release.
The bad version:
- Ask the engineering team for a data export. They're in code freeze. The request goes into a queue.
- Find Radar's dashboard event log — it shows events but doesn't export them. Start copying: user ID, event type, geofence name, timestamp. One row at a time.
- After an hour you have 80 rows out of what looks like several thousand. The pagination is confusing and you're not sure if you've missed any events between page loads.
The audit committee deadline is Friday. It is Monday.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Google Sheet. It calls Radar's event list API with a date range filter, retrieves all events across pages, and writes the complete log into the sheet — ready for the committee without involving engineering.
List all Radar events from the past 30 days and write each event's type, user ID, geofence name, and timestamp to columns A through D of this sheet
What You Get
- One row per event, all pages resolved — no pagination gaps
- Column A: event type (e.g., "user.entered_geofence", "user.exited_geofence")
- Column B: user ID
- Column C: geofence name
- Column D: event timestamp in ISO format
- The complete log is in the sheet, sortable and filterable, ready for the committee review
What If the Data Is Not Quite Ready
You only need entry and exit events, not location update events
List all Radar events from the past 30 days where event type is user.entered_geofence or user.exited_geofence and write event type, user ID, geofence name, geofence tag, and timestamp to columns A through E
You need device ID included alongside user ID
List all Radar geofence entry and exit events from the past 30 days and write user ID, device ID, event type, geofence name, geofence tag, and timestamp to columns A through F of this sheet
The committee only cares about events for a specific geofence tag
List all Radar events from the past 30 days where the geofence tag is "secure-facility" and write event type, user ID, geofence name, and timestamp to columns A through D
Pull all events, flag after-hours entries, and add a risk classification column in one pass
List all Radar geofence entry events from the past 30 days and write user ID, geofence name, and timestamp to columns A through C — then add a Risk column D: "After Hours" if the event timestamp falls outside 07:00-19:00 local time, "Normal Hours" otherwise
That column turns the raw log into a prioritized review list for the audit committee.
Try It
Get the 7-day free trial of SheetXAI and open any Google Sheet — ask it to pull all Radar location events for a date range and write the complete access log into the sheet. For enriching coordinates with geofence context, see enriching GPS coordinates with Radar context, or return to the Radar integration overview.