The Scenario
A security compliance officer at a facilities management company has an audit requirement landing this week: produce an Excel log of all Radar geofence entry and exit events for the past 30 days, including user ID, device ID, event type, geofence name, and timestamp. The audit committee needs it by Thursday. It is Monday. The engineering team is in code freeze through Wednesday.
The bad version:
- Open Radar's dashboard, navigate to the Events section. The events log shows recent events but there is no "export to Excel" button.
- Try to copy events from the dashboard by hand: user ID, event type, geofence name, timestamp. One row at a time.
- After 90 minutes you have 200 rows. Radar has thousands of events in the 30-day window. The pagination resets when the session times out, forcing you to start the page count over.
Engineering is in code freeze. The audit doesn't care about code freeze.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Excel workbook. It calls Radar's event list API with a date filter, retrieves all events across pages, and writes the complete log into the workbook — the full 30-day record, no session timeouts, no manual row copying.
Fetch all Radar geofence entry and exit events for last month and paste user ID, device ID, event type, geofence tag, and event timestamp into this Excel workbook
What You Get
- One row per event, all pages resolved across the 30-day window
- User ID, device ID, event type, geofence tag, and timestamp in separate columns
- The complete log is in the workbook, ready for the audit committee — sortable by timestamp, user, or geofence
What If the Data Is Not Quite Ready
You only need entry events, not exits
List all Radar geofence entry events from the past 30 days and write user ID, device ID, geofence name, and event timestamp to columns A through D of this Excel workbook
You need to filter to a specific geofence tag for the audit scope
List all Radar events from the past 30 days where the geofence tag is "restricted-area" and write user ID, event type, geofence name, and timestamp to columns A through D
The committee wants ISO-formatted timestamps for the log
List all Radar geofence entry and exit events for the past 30 days and write user ID, device ID, event type, geofence tag, and timestamp (formatted as ISO 8601) to columns A through E of this workbook
Pull all events, flag after-hours access, and add a risk classification 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 is outside 07:00-19:00 local time, "Normal Hours" otherwise, and a blank Reviewer Notes column E for the committee to annotate
The annotatable notes column turns the raw log into a review-ready document for the audit session.
Try It
Get the 7-day free trial of SheetXAI and open any Excel workbook — ask it to pull all Radar geofence events for a date range and write the complete access log into the workbook. For enriching GPS coordinates with geofence context, see enriching coordinates with Radar context, or return to the Radar integration overview.