The Scenario
The quarterly business review is 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 workbook. It is Tuesday afternoon.
The bad version:
- Click into each of the 15 open jobs in Ashby, click to the Applications worksheet, scan the stage for each candidate, write it down.
- Come back to Excel, enter the data for each job's candidates, one row at a time.
- By job 7 you realize the stage names you used for job 1 are inconsistent with what you are writing for job 7 because Ashby uses internal stage IDs and you are translating them in your head.
There are roughly 400 active applications across those 15 jobs. At 30 seconds per application, that is three and a half hours — time you do not have.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It pulls live data from Ashby through a built-in integration. One prompt replaces the afternoon.
Pull all Ashby applications for the job IDs listed in column A of this Excel sheet and write candidate name, current stage, application date, and hiring manager into columns B through E.
SheetXAI calls the Ashby applications endpoint, handles pagination, resolves stage names and hiring manager names from their IDs, and writes the results into the workbook.
What You Get
- One row per application with candidate name, current stage, application date, and hiring manager.
- Stage names resolved from Ashby IDs into readable labels — not raw UUIDs.
- Hiring manager names resolved from user IDs.
- The workbook 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 the Pipeline worksheet.
You want to filter to a specific interview stage
Fetch all Ashby applications currently in the "Technical Interview" stage and write candidate name, job title, recruiter name, and days in stage into the Pipeline worksheet.
The workbook already has a previous export and you want a refresh
Clear the content in the Pipeline worksheet starting from row 2, then fetch all open Ashby applications and write candidate name, job title, current stage, recruiter, and source into the worksheet 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 the Pipeline worksheet. 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.
Try It
Get the 7-day free trial of SheetXAI and open any Excel workbook — 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.