The Scenario
A product analyst at a location-based app company is building a regional engagement report for next quarter's investor update. The data she needs is in Radar: all users, their last-seen timestamps, their countries, and which geofences they are currently inside. She needs it in a Google Sheet so the data team can slice it by region before the deck gets assembled.
The bad version:
- Log into Radar's dashboard and navigate to the Users section. The list paginates — 50 users per page, 2,000 users total. Forty pages.
- Start copying user IDs and geofence membership data by hand. After page 3 the pattern is clear: this is going to take the rest of the morning.
- Ask the engineering team for a data export. They write a script over the next two days, but by the time the CSV arrives, two more sprint ceremonies have eaten into the analysis window.
The investor deck is being assembled Friday. Today is Tuesday.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Google Sheet. It calls Radar's user list API, handles pagination, and writes every user record into the sheet with the fields you need for segmentation.
List all Radar users and write each user's Radar ID, external user ID, last seen timestamp, and current geofence tags to columns A through D of this sheet
What You Get
- One row per Radar user, all pages resolved
- Column A: Radar internal user ID
- Column B: external user ID (your app's user identifier)
- Column C: last seen timestamp — sortable for recency analysis
- Column D: geofence tags the user is currently inside, comma-separated
What If the Data Is Not Quite Ready
You only need users currently inside a specific geofence for a targeted segment
List all Radar users currently inside the geofence with tag "premium-zone" and write their Radar user ID, external user ID, and last known coordinates to columns A through D of this sheet
You need to join the Radar user IDs to an existing user table in column E
List all Radar users and write Radar ID and external user ID to columns A and B, then match the external user ID against the user table in Sheet2 (external ID in A, subscription tier in B) and write the subscription tier to column C
The last-seen timestamp needs to be formatted as a date only (not datetime) for the pivot
List all Radar users and write Radar ID, external user ID, and last seen timestamp to columns A through C — format the timestamp in column C as YYYY-MM-DD date only
Pull all users, segment by geofence membership, and summarize by region in one pass
List all Radar users and write Radar ID, external user ID, last seen timestamp, and geofence tags to columns A through D, then add a summary table starting at row 2005: count of users per geofence tag, sorted by count descending
The summary table saves the pivot step and gives the data team a head start on the regional breakdown.
Try It
Get the 7-day free trial of SheetXAI and open any Google Sheet — ask it to export all Radar users with their geofence membership and last-seen data into the sheet. For trip-level data, see exporting active Radar trips, or return to the Radar integration overview.