The Scenario
A last-mile delivery operations manager runs a daily standups with her dispatch team. This morning's meeting is in 20 minutes and someone on the team just Slack-messaged asking where the live trip status sheet is. It doesn't exist. The manager needs a current snapshot of all active Radar trips — external IDs, statuses, destinations, modes, and ETAs — pulled into a Google Sheet before the room fills up.
The bad version:
- Log into Radar's dashboard, navigate to the Trips section, look at the list — but the dashboard doesn't export to a sheet directly.
- Start copying trip IDs and statuses by hand. There are 34 active trips. By the time you've copied 10, the meeting has started.
- Ask an engineer to pull the trips via API and send a CSV. They're currently in a different meeting and the CSV arrives 45 minutes after the standup ended.
The standup happened without the data. The dispatch team made decisions on memory.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Google Sheet. It calls Radar's trips API, retrieves every active trip, and writes the full snapshot into the sheet — ready before the meeting starts.
List all current Radar trips and write each trip's external ID, status, destination, mode, and scheduled arrival into columns A through E of this sheet
What You Get
- One row per trip in the current Radar project
- Column A: external trip ID
- Column B: status (e.g., "started", "approaching", "arrived")
- Column C: destination label or address
- Column D: travel mode
- Column E: scheduled arrival time
- The snapshot is timestamped by when the prompt was run — refresh it by running the same prompt again
What If the Data Is Not Quite Ready
You only want trips with a specific status for the operations review
List all Radar trips with status "started" or "approaching" and write trip ID, external ID, status, destination address, and mode to columns A through E of this sheet
You need to join trip data with a driver roster in column G
List all Radar trips and write external ID, status, destination, and mode to columns A through D, then match each external ID against the driver assignment table in Sheet2 (external ID in A, driver name in B) and write the driver name to column E
The snapshot needs to include only trips assigned to a specific fleet
List all Radar trips where the metadata includes fleet "east-coast" and write trip ID, external ID, status, and destination to columns A through D
Pull all trips, flag overdue ones, and add a handoff note column in one pass
List all Radar trips and write external ID, status, destination, mode, and scheduled arrival to columns A through E — add a flag in column F: "Overdue" if the scheduled arrival has passed and the status is still "started", "On Track" otherwise, and leave a blank handoff note field in column G for the dispatch team to fill in
That setup turns a raw trip list into an ops-ready handoff sheet.
Try It
Get the 7-day free trial of SheetXAI and open any Google Sheet — ask it to pull all active Radar trips and write a live snapshot of status and destination data into the sheet. To export user location data instead, see exporting Radar users, or return to the Radar integration overview.