The Problem With Getting Sheet Data In and Out of Async Interview
You have an Excel workbook full of candidate data — role names, submission windows, scoring rubrics, hiring pipeline stages. And over in Async Interview, you have a growing queue of video responses, job configurations, and candidate records that your team is reviewing asynchronously.
Async Interview is good at collecting structured video responses at scale without scheduling overhead. But moving that data into a workbook — or keeping your workbook in sync with what's happening in the platform — takes more effort than it should. The usual flow is opening the dashboard, exporting a CSV download, reformatting it to match your internal columns, and repeating that every time the pipeline changes.
Below are the four common ways hiring teams handle this. Only the last one scales.
Method 1: Manual Copy-Paste
The default. Log into Async Interview, find the job, export a CSV, open it, reformat the columns, and paste the data into your workbook. For a small batch of candidates that's inconvenient. For forty responses across three open roles, you're spending an hour on something that will need to be redone next week when a new cohort comes in.
The CSV export from most async interview platforms strips out the video URLs or renders them as plain text that breaks when pasted across sheets. So you end up going back into the dashboard, copying links manually, and re-entering them one by one into the workbook.
By the time everything is in the right columns and the links are working, you've touched every record twice — and whatever scoring happened while you were formatting is already two days old.
Method 2: Power Automate
Power Automate has flow templates for candidate tracking. You can wire up a trigger when a new Async Interview response is submitted, map the fields, and write results into a designated worksheet.
Before you keep reading — do you know what a connector is? A trigger condition? An array expression in a Power Automate action? If those words feel unfamiliar, skip to Method 3 or 4. You'll get more done faster.
If you're still here: the flow is buildable. You authenticate both systems, configure the trigger, map every response field to the right column — name to A, email to B, submitted_at to C, video URL to D — and test it against a live submission.
The problem is that a trigger fires once per new response. Responses that arrived before you built the flow won't flow through it. You're handling the backfill by hand anyway.
You probably just need the full candidate list pulled into your workbook so you can rank and score them this afternoon. You probably have no idea how to build a Power Automate flow from scratch, and that's a reasonable place to be. So you either push it to your IT person — who has their own queue — or you spend two hours learning a tool you'll use once.
And once you need filtering, cross-worksheet joins, or conditional inclusion based on response completeness, you've pushed past what a single Power Automate flow handles natively.
Method 3: The Previous Generation — Connector Add-Ons
Until recently, the best option for repeatable workbook ↔ Async Interview workflows was a category of add-ons that let you manually configure column mappings and saved templates. You picked your range, you tagged your fields, you saved a config, you ran it.
That was a real step up from copy-paste. Output was consistent, configs were reusable, the team didn't have to redo formatting every run.
But you were still responsible for the template design, the field mapping, the schedule, the conditional logic about which responses to include, the renaming of columns to match your internal rubric. The tool got the data through, but the thinking was still on you. And the moment your job configuration changed in Async Interview — a new question added, a field renamed — your config broke until someone went back in and fixed it.
This is the previous generation. It worked, but it asked a lot of the operator.
The Easy Way: Using SheetXAI in Excel
There is a different way entirely. SheetXAI is an AI agent that lives inside your Excel workbook. It reads the workbook, understands what you are looking at, and through its built-in Async Interview integration it can push to or pull from Async Interview for you. No template configuration, no automation glue, no summarizing your data by hand. You just ask.
Example 1: Export all responses for a role into your scoring worksheet
Pull all interview responses from Async Interview for the job in cell B1 and write candidate name, email, submission date, and video URL into the CandidateResponses sheet starting at row 2.
Each response lands in its own row, with the video link in column D formatted as a clickable URL. Incomplete or pending responses are flagged in column E so you know which records to follow up on.
Example 2: Pull a full response roster across all active jobs
Fetch all Async Interview responses submitted in the last 30 days and write candidate name, email, job title, submitted_at, and response URL into the CandidateLog sheet, sorted by submission date descending.
The pattern: instead of exporting each job separately and consolidating them manually, you ask for the full view in one prompt. SheetXAI handles the aggregation and the sort inline.
Try It
Get the 7-day free trial of SheetXAI and open any Excel workbook where you're tracking hiring pipeline data, then ask it to pull your latest Async Interview responses directly into the workbook. The Async Interview integration is included in every SheetXAI plan.
More Async Interview + Excel guides
Export Candidate Responses From Async Interview Into a Google Sheet
Pull every video interview response — name, email, job, submission date, video link — into a spreadsheet so your hiring team can score and rank candidates without leaving their workflow.
Audit Open Interview Jobs From Async Interview Into a Google Sheet
Fetch every active async interview job — title, status, creation date, question count — into a spreadsheet so you can confirm every open role has an interview configured.