The Scenario
The CFO asked for a hiring dashboard before next Tuesday's board meeting. You manage talent acquisition. You have 18 open positions in Recruitee and zero of the pipeline data is in a spreadsheet. Someone on the finance team will want to see total applicants per role, candidates per stage, and days since each role opened — all in one table, not 18 separate Recruitee screens.
The bad version:
- Open each job in Recruitee one at a time, read the pipeline stage counts, and manually type the numbers into the sheet.
- Realize mid-way that you forgot to note the date each role opened, so you go back through half of them.
- Finish the sheet, then find out the CFO wants department names too, so you start over.
This data exists. All of it. It's sitting in Recruitee right now. The board meeting is in five days and the person building this report is supposed to be running talent strategy, not transcribing numbers from a browser into cells.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet and reads from Recruitee through its built-in integration. It can call the Recruitee API, page through all open job offers, collect pipeline stage data for each one, and write the entire snapshot into a structured table — all from one prompt.
List all open Recruitee job offers and for each one fetch the pipeline stages with candidate counts, then write job title, department, total applicants, candidate count per stage, and the date the role opened into my sheet starting at row 1
What You Get
- One row per open job offer, with job title, department, total applicant count, and one column per pipeline stage showing candidate counts.
- A date-opened column so time-to-fill calculations are straightforward.
- The table filled starting at row 1, with headers written automatically.
- A live snapshot as of the moment the prompt runs — re-run it next week for an updated view.
What If the Data Is Not Quite Ready
You only want roles that have been open for more than 30 days
Pull all open Recruitee job offers, calculate the number of days each role has been open based on the date it was created, filter to roles open for more than 30 days, and write job title, department, days open, total applicants, and candidates per stage into my sheet
You need to merge this snapshot with a headcount budget sheet already in the workbook
Fetch all open Recruitee job offers with total applicant counts and pipeline stage breakdowns, then match each job title to the role in column A of Sheet2 using a case-insensitive match and write the applicant count into column D of Sheet2
Department names in Recruitee don't match the department labels in your finance model
Pull all open Recruitee job offers and write job title, Recruitee department, total applicants, and candidates per stage into columns A through H — also add a column I where you map Engineering to Eng, Sales to GTM, and People Ops to HR, leaving any unmapped departments as-is
Full pipeline snapshot plus summary row for the board deck
Pull all open Recruitee job offers with stage-level candidate counts and days open; write one row per job into Sheet1 starting at row 2 with headers in row 1; then in Sheet2 write a summary table with total open roles, total candidates across all roles, average days open, and total candidates per stage summed across all jobs
Ask for the snapshot and the summary in one prompt — there is no reason to pull the data first and then calculate separately.
Try It
Get the 7-day free trial of SheetXAI and open any Google Sheet, then ask it to pull a full hiring pipeline snapshot from Recruitee. For related tasks, see how to export candidates at a specific stage or build a cross-tab pipeline matrix.