The Scenario
A delivery operations manager starts her morning at 7:45 AM, before the dispatch team arrives. She needs the daily trip status sheet ready for the 8 AM standup — all active Radar trips, their external IDs, statuses, destinations, and travel modes. Last week someone printed a screenshot from the Radar dashboard. It was blurry and didn't show all the columns anyone wanted. There has to be a better way.
The bad version:
- Log into Radar's dashboard, navigate to Trips, screenshot the list — the same approach that produced last week's blurry printout.
- Try to copy the trip data from the dashboard into Excel manually. Radar's trip list doesn't have a click-to-select for bulk copying.
- Ask the on-call engineer to run a quick API pull and send a CSV. The engineer isn't online yet. Standup starts in 12 minutes.
The 8 AM standup happens with incomplete data again. The dispatch team makes decisions without a real trip overview.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Excel workbook. It calls Radar's trips API, retrieves every active trip, and writes the snapshot into the workbook before the standup. Open the workbook, run the prompt, done.
Fetch all Radar trips with status started or approaching and paste trip ID, external ID, status, destination address, and mode into this Excel workbook
What You Get
- One row per active Radar trip
- Trip ID, external ID, status, destination address, and travel mode in separate columns
- The snapshot is current as of when the prompt ran — refresh it any morning by running the same prompt again
What If the Data Is Not Quite Ready
You need scheduled arrival time included in the snapshot
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 Excel workbook
You want to join trip data against a driver roster in Sheet2
List all active Radar trips and write external ID, status, and destination to columns A through C — then match each external ID against the driver table in Sheet2 (external ID in A, driver name in B) and write the driver name to column D
You only want trips assigned to a specific route zone
List all Radar trips where the destination region matches "north-zone" and write trip ID, external ID, status, and destination address to columns A through D of this workbook
Pull all trips, flag any that are overdue, and add a notes column for dispatch in one pass
List all current Radar trips and write external ID, status, destination, mode, and scheduled arrival to columns A through E — add a column F flag: "Overdue" if scheduled arrival has passed and status is still "started" or "approaching", "On Track" otherwise, and add an empty column G labeled "Dispatch Notes" for the team to fill in during standup
The notes column turns the snapshot into a working document for the standup.
Try It
Get the 7-day free trial of SheetXAI and open any Excel workbook — ask it to pull all active Radar trips into a snapshot with status and destination data. For user-level location data, see exporting Radar users, or return to the Radar integration overview.