The Scenario
The debrief is tomorrow at 10 AM. Fifteen candidates made it to the final round, and you need all the interviewer feedback in one place before the meeting starts — interviewer name, overall rating, and the key feedback text — so the hiring committee can review it without scrambling through Ashby during the call.
The feedback is in Ashby. Getting it into a shareable sheet is the blocker.
The bad version:
- Click into candidate 1's application in Ashby, navigate to the Feedback tab, find the first submission, copy the interviewer name, copy the rating, copy the feedback text, go to the sheet, paste.
- Go back to Ashby. Find candidate 2.
- Somewhere around candidate 6, you notice one interviewer submitted two separate forms — one short one from the phone screen that snuck into the final-round view. You have to figure out which submission is the right one to include.
Fifteen candidates with three or four interviewers each is potentially 60 individual feedback submissions. This is not a 30-minute task.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It reads the application IDs and pulls the feedback submissions from Ashby through a built-in integration — all 15 candidates in one operation.
For each application ID in column A of this sheet, fetch all Ashby feedback submissions and write interviewer name, submitted date, overall score, and feedback text into columns B through E.
SheetXAI calls the Ashby feedback endpoint for each application, handles multiple submissions per candidate, and writes one row per submission. The debrief sheet is ready in under two minutes.
What You Get
- One row per feedback submission, with interviewer name, submitted date, overall score, and feedback text.
- Multiple submissions per candidate each get their own row — no collapsing.
- The sheet is ready to share with the hiring committee before the meeting.
- If a submission is missing a field, that cell is blank rather than breaking the export.
What If the Data Is Not Quite Ready
You only want submissions from the final-round interview stage
For each application ID in column A, fetch only Ashby feedback submissions where the associated interview type is "Final Round". Write interviewer name, submitted date, overall score, and feedback text into columns B through E.
The hiring manager wants a summary column alongside the raw feedback
For each application ID in column A, fetch all Ashby feedback submissions. Write interviewer name, overall score, and feedback text into columns B through D. In column E, write a one-sentence summary of the feedback text for each submission.
You want one row per candidate with feedback from all interviewers combined
For each application ID in column A, fetch all Ashby feedback submissions and combine the interviewer names into column B (comma-separated) and the feedback texts into column C (line-separated). Write the average overall score into column D.
Pull feedback, flag missing submissions, and sort by overall score in one shot
For each application ID in column A, fetch all Ashby feedback submissions. Write each submission as a separate row with interviewer name, score, and feedback text in columns B through D. In column E, flag any application where fewer than three feedback submissions exist as "Incomplete." Sort all rows by score descending when done.
The last prompt surfaces the preparation gaps — you know before the meeting which candidates have missing feedback, not during it.
Try It
Get the 7-day free trial of SheetXAI and open any Google Sheet with Ashby application IDs for your finalists, then ask it to pull all the interview feedback before your debrief. See also the spoke on bulk advancing application stages, or return to the Ashby overview.