The Scenario
Someone from the operations team pings you on a Tuesday afternoon: "Can you confirm every open role actually has an interview configured in the platform?" It's a fair question. Your company has fifteen active job openings across five departments, and the last time you checked, two of them had interview templates that were either blank or never published.
The bad version:
- Open Async Interview, click into the Jobs section, and start going through the list manually — noting title, status, and whether there are any questions attached.
- Open an Excel workbook and type each one in by hand, because there's no export button that gives you all three fields in a usable format.
- Discover midway through that the platform paginates after ten results, so you've been working off an incomplete list.
This isn't an analysis project. It's a thirty-second data pull that turned into forty-five minutes because the export path doesn't exist. You have a compliance review tomorrow and this check was supposed to take five minutes.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It reads the workbook, understands your layout, and through its built-in Async Interview integration it can pull your full job inventory — every title, status, creation date, and question count — directly into the workbook in one pass.
Here's the prompt that does it:
Fetch all jobs from Async Interview and write job title, status, creation date, and number of questions into columns A through D of the InterviewJobs sheet starting at row 2, sorted by creation date descending.
What You Get
- One row per job in columns A–D: title, status (active/draft/archived), created_at, question count.
- Sorted newest-first so your most recently created roles surface at the top.
- Any job with zero questions gets flagged in column E so you can see immediately which roles have no interview configured.
- The sheet is audit-ready — filter column B for "active" and column E for "MISSING" to get exactly the gap report you need.
What If the Data Is Not Quite Ready
You only want active jobs — not drafts or archived ones
The full list includes everything ever created in the platform, including roles you closed six months ago.
Fetch all jobs from Async Interview where status is "active" and write job title, creation date, and number of questions into columns A through C of the InterviewJobs sheet starting at row 2.
The creation date format doesn't match your workbook's date column
Async Interview returns timestamps in ISO format and your workbook uses MM/DD/YYYY.
Fetch all active jobs from Async Interview and write job title, status, and creation date formatted as MM/DD/YYYY into columns A through C of the InterviewJobs sheet starting at row 2.
You want to join the job list against a second sheet that has your approved headcount
Your HR workbook has an ApprovedRoles sheet with the official list of open requisitions. You need to see which approved roles have a matching Async Interview job configured — and which don't.
Fetch all jobs from Async Interview and write job title and status into columns A and B of the AsyncJobs sheet. Then compare column A of AsyncJobs against column A of the ApprovedRoles sheet and write any approved role title that has no matching Async Interview job into column A of the MissingInterviews sheet.
Clean up job titles, check question counts, and flag the gaps — all at once
Job titles in the platform sometimes have inconsistent casing or trailing spaces. And you need to know which active roles have fewer than two questions, since a single-question interview doesn't meet your screening standard.
Fetch all active jobs from Async Interview. Trim whitespace and apply title case to job title. Flag any job with fewer than 2 questions by writing "NEEDS SETUP" in column E. Write job title, status, creation date, question count, and flag into columns A through E of the InterviewJobs sheet starting at row 2.
Ask for the cleanup and the audit logic in one prompt — there's no reason to pull the data first and apply conditionals in a second pass.
Try It
Get the 7-day free trial of SheetXAI and open the Excel workbook where you track your open headcount, then ask it to pull a full Async Interview job inventory with question-count flags directly into the workbook. You can also explore exporting candidate responses or return to the full Async Interview integration overview.