The Scenario
You're three weeks into hiring for a customer success role. Forty candidates have completed their async video interviews — they answered four pre-recorded questions, submitted their responses, and now those videos are sitting in Async Interview waiting to be reviewed. Your hiring manager asked for a ranked shortlist by end of day Friday.
The bad version:
- Log into Async Interview, open the job, and start copying candidate names and emails one by one into an Excel workbook — because there's no clean bulk export that lands the way you need it.
- Go back into each candidate's profile to copy the video link, paste it into column D, and check that it actually resolves (two of them don't).
- Repeat this forty times across an afternoon that was supposed to be for actual screening.
Nobody hired you to be a copy-paste operator. You're supposed to be running the evaluation process, not building the workbook it lives in. Friday is closer than it looks.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It reads the workbook, understands your column layout, and through its built-in Async Interview integration it can pull all forty candidate records directly into your workbook — no manual copying, no link verification loop.
Here's the prompt that does it:
Pull all interview responses from Async Interview for the job in cell B1 and write candidate name, email, job title, submission date, and response URL into columns A through E of the CandidateResponses sheet starting at row 2, sorted by submission date ascending.
What You Get
- One row per candidate in columns A–E: name, email, job title, submitted_at, video URL.
- Records sorted oldest-to-newest so you can review in submission order.
- Any response where the video URL is missing or malformed gets flagged with a note in column F.
- The sheet is ready to score — add a column G for your rubric ratings and you're in evaluation mode.
What If the Data Is Not Quite Ready
The job title in B1 doesn't exactly match the Async Interview job name
Sometimes the value in B1 is "Customer Success Manager — Q2 2026" and the platform has it as "CS Manager Q2." Exact-match pulls return nothing.
Fetch all Async Interview jobs whose title contains the text in cell B1 and write the matching job ID into cell C1, then pull all responses for that job ID into columns A through E of the CandidateResponses sheet starting at row 2.
Some candidates submitted twice — duplicate responses in the export
You had a candidate resubmit after a technical issue. Now they appear twice and it'll mess up your scoring totals.
Fetch all interview responses from Async Interview for the job in cell B1, deduplicate by email keeping the most recent submission date, and write candidate name, email, submission date, and response URL into columns A through D of the CandidateResponses sheet.
You need responses across multiple jobs — not just one
You're hiring for three roles simultaneously and want one consolidated sheet to surface cross-role comparisons.
Fetch all Async Interview responses for the jobs listed in column A (rows 2 through 4) of the JobList sheet and write candidate name, email, job title, submission date, and response URL into the AllCandidates sheet, sorted by job title then submission date.
Clean the email column, flag late submissions, and pull it all in one shot
The emails coming out of the platform sometimes have trailing spaces or mixed case. And you need to know which candidates submitted after the deadline in cell D1.
Fetch all interview responses from Async Interview for the job in cell B1. Trim and lowercase all email values. Flag any submission where submitted_at is later than the date in cell D1 by writing "LATE" into column F. Write all results — name, email, job title, submission date, video URL, flag — into columns A through F of the CandidateResponses sheet starting at row 2.
The pattern: ask for the data normalization and the conditional logic in the same prompt — you don't need to clean first, then pull, then flag.
Try It
Get the 7-day free trial of SheetXAI and open the Excel workbook where your hiring team tracks candidate pipeline, then ask it to pull all Async Interview responses for your current open role into a scored, ready-to-review list. You can also look at auditing your open interview jobs or browse the full Async Interview integration overview.