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 sheet.
That someone is you. The quarterly review is in two weeks and she wants the data by end of next week.
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 the sheet. Enter the row.
- Click into application 2. Repeat.
- By application 40 you realize the survey doesn't always show on the application — sometimes it's on the candidate profile instead. Your methodology just broke.
There are 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 Google Sheet. It pulls the survey submissions directly from Ashby through a built-in integration — no clicking through individual records.
Fetch all Ashby survey submissions of type 'CandidateExperience' created after the date in cell B1 and write candidate ID, application ID, submission date, and each survey answer into this sheet.
SheetXAI queries the Ashby surveys endpoint with the date filter from B1, pages through all results, and writes one row per submission with each answer in a separate column.
What You Get
- One row per survey submission, with candidate ID, application ID, submission date, and individual survey answers.
- Answers in separate columns so your director can pivot by question.
- The sheet is ready for NPS calculation — subtract detractors from promoters and you have your score.
- If a survey has fewer answers than others, those cells are blank rather than shifting columns.
What If the Data Is Not Quite Ready
You want NPS score and open-text response specifically, not all fields
Fetch all Ashby CandidateExperience survey submissions created after the date in cell B1. Write candidate ID, application ID, submission date, NPS score, and the open-text response into this sheet, one row per submission.
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 this sheet. 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 this sheet.
Pull all survey data, calculate NPS by stage, and flag detractors in one pass
Fetch all Ashby CandidateExperience survey submissions from the last quarter. Write candidate ID, application stage, NPS score, and open-text response into this sheet. In column E, 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 Google Sheet, enter a start date in cell B1, and ask it to pull all your Ashby candidate survey submissions for analysis. See also the spoke on exporting pipeline data for department reporting, or return to the Ashby overview.