The Scenario
Your talent acquisition director has been asking for candidate NPS data for two quarters. The surveys exist in Ashby — candidates fill them out at the end of the process. The problem is they live buried in individual application records. To actually analyze them, someone has to pull them into a workbook.
The quarterly review is in two weeks. She wants the data by end of next week. That someone is you.
The bad version:
- Click into application 1 in Ashby. Find the survey tab. Copy the NPS score. Copy the open-text response. Note the application stage it was submitted from. Go to Excel. Enter the row.
- Click into application 2. Repeat.
- By application 40 you notice the survey does not always appear on the application — sometimes it is on the candidate profile instead. Your methodology just broke.
Hundreds of candidate experience surveys submitted in the last quarter. This is a multi-hour project if done manually.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It pulls the survey submissions directly from Ashby through a built-in integration — no clicking through individual records.
Pull all Ashby CandidateExperience survey submissions and write the NPS score, open-text response, and application stage into the Excel 'CandidateNPS' sheet for analysis.
SheetXAI queries the Ashby surveys endpoint, pages through all results, and writes one row per submission into the CandidateNPS worksheet.
What You Get
- One row per survey submission with NPS score, open-text response, and application stage.
- The worksheet is ready for NPS calculation — subtract detractors from promoters.
- If a survey is missing a field, that cell is blank rather than shifting columns.
- Your director gets the data before the deadline.
What If the Data Is Not Quite Ready
You want to filter to a specific date range
Fetch all Ashby CandidateExperience survey submissions created after the date in cell B1. Write candidate ID, application stage, submission date, NPS score, and open-text response into the CandidateNPS worksheet.
You want to break results down by the stage the survey was triggered from
Fetch all Ashby CandidateExperience survey submissions from the last quarter. Write candidate ID, application stage, submission date, NPS score, and open-text response into the CandidateNPS worksheet. Group the rows by application stage.
You also need the job title the candidate applied to
Fetch all Ashby CandidateExperience survey submissions from the last quarter. For each submission, fetch the corresponding application to get the job title. Write candidate ID, job title, application stage, NPS score, and open-text response into the CandidateNPS worksheet.
Pull all survey data, label promoters and detractors, and calculate NPS by stage
Fetch all Ashby CandidateExperience survey submissions from the last quarter. Write candidate ID, application stage, NPS score, and open-text response into the CandidateNPS worksheet. In the next column, label each submission as "Promoter" (9-10), "Passive" (7-8), or "Detractor" (0-6). Below the data, add a summary row calculating overall NPS and NPS by stage.
Try It
Get the 7-day free trial of SheetXAI and open any Excel workbook, then ask it to pull all your Ashby candidate survey submissions into a worksheet for NPS analysis. See also the spoke on exporting pipeline data for reporting, or return to the Ashby overview.