The Scenario
The quarterly business review is this Thursday. Three department heads want a single view of every open role their teams are hiring for — candidate name, current stage, job title, recruiter — so they can ask intelligent questions about the pipeline. That data lives entirely in Ashby.
You are the one who has to produce the sheet. It is Tuesday afternoon.
The bad version:
- Click into each of the 15 open jobs in Ashby, click to the Applications tab, scan the stage for each candidate, write it down.
- Come back to the sheet, enter the data for each job's candidates, one row at a time.
- By job 7 you realize the format you used for stage names in job 1 is different from what you're using for job 7 because Ashby uses internal stage IDs and you're translating them in your head.
There are roughly 400 active applications across those 15 jobs. At even 30 seconds per application, that's three and a half hours. You do not have three and a half hours.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It reads the sheet context and pulls live data from Ashby through a built-in integration. One prompt replaces the afternoon.
Fetch all open Ashby applications and write candidate name, email, job title, current interview stage, recruiter name, and application source into this sheet, one row per application.
SheetXAI calls the Ashby applications endpoint, handles pagination across all 15 jobs, resolves stage names and recruiter names from their IDs, and writes the results into the sheet starting at row 2.
What You Get
- One row per application, with candidate name, email, job title, stage, recruiter, and source.
- Stage names resolved from Ashby IDs into readable labels — not raw UUIDs.
- Recruiter names resolved from user IDs.
- The sheet is ready to share with department heads, filter, or pivot.
What If the Data Is Not Quite Ready
You only want applications for specific departments
Fetch all open Ashby applications for jobs in the Engineering and Product departments. Write candidate name, job title, current stage, recruiter, and application date into this sheet, one row per application.
You want to filter to a specific stage
Fetch all Ashby applications currently in the "Technical Interview" stage and write candidate name, job title, recruiter name, and days in stage into this sheet.
The sheet already has data from a previous export and you want a refresh
Clear the content in this sheet starting from row 2, then fetch all open Ashby applications and write candidate name, job title, current stage, recruiter, and source into the sheet one row per application.
Stage, recruiter, and source plus a calculated time-in-stage column
Fetch all open Ashby applications. Write candidate name, job title, current stage, stage entered date, and recruiter into this sheet. Add a formula in column F that calculates how many days each candidate has been in their current stage based on column E and today's date.
The last prompt is the one worth saving. A column showing days-in-stage turns a pipeline export into a tool you can actually act on.
Try It
Get the 7-day free trial of SheetXAI and open any Google Sheet — even a blank one — then ask it to pull your full Ashby pipeline into it. See also the spoke on building a sourcing channel attribution report, or return to the Ashby integration overview.