The Scenario
The monthly leadership meeting is tomorrow morning. Your talent acquisition manager needs to present hiring velocity — how many roles are open, applicant counts per role, and whether any positions are past the 60-day time-to-fill target.
She needs it in Excel, formatted for the slide deck template.
Last time this data was gathered by hand: someone opened each of the eight job listings in BambooHR ATS individually, noted the applicant count and posting date, then typed everything into a worksheet. It took over an hour.
The bad version:
- Open BambooHR ATS, click into job 1, record the applicant count and date.
- Back to the list, click into job 2, repeat.
- After eight jobs, realize you forgot to capture the department for the first four.
- Go back through those four, add the department column.
- Open Excel, type it all in, add a DAYS formula.
- It is 11:30 PM and the meeting is at 9 AM.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It pulls BambooHR ATS job summaries in one API call — every job, applicant count included.
Pull all open BambooHR ATS jobs and write job ID, title, department, applicant count, and date opened into the Excel 'RecruitingDashboard' sheet.
SheetXAI queries the BambooHR ATS jobs endpoint, retrieves every open role with its metadata and applicant count, and writes them into the RecruitingDashboard worksheet.
What You Get
- One row per open BambooHR ATS job.
- Columns: job ID, title, department, applicant count, date opened.
- Applicant counts from the API — no manual counting in the ATS UI.
- Data lands ready for a DaysOpen formula using the date opened column.
What If the Data Is Not Quite Ready
You need a DaysOpen column calculated from the posting date
Pull all open BambooHR ATS jobs with job ID, title, department, applicant count, and date opened. Add a DaysOpen column calculated as today minus date opened. Write into the RecruitingDashboard sheet.
You want to flag roles past the time-to-fill target
Pull all open BambooHR ATS jobs. Add DaysOpen. Add a Status column: 'at risk' if DaysOpen is over 60, 'on track' otherwise. Write into RecruitingDashboard.
You need a summary row at the top for the slide deck
Pull all open BambooHR ATS jobs. Write a summary row at row 1 showing total open roles and total applicants. Write the full job list below row 3 in the RecruitingDashboard sheet.
Full dashboard in one prompt
Pull all open BambooHR ATS jobs. Add DaysOpen. Add Status ('at risk' if over 60 days, 'on track' otherwise). Write a summary row at row 1 (total open roles, total applicants). Write the full list below row 3, sorted by DaysOpen descending. Into the RecruitingDashboard sheet.
The pattern: the pull, derived columns, and the summary header all happen in one instruction.
Try It
Get the 7-day free trial of SheetXAI and open your recruiting workbook before the next leadership meeting, then ask it to pull the BambooHR ATS job summaries. You can also pull the full application pipeline for each role if leadership wants candidate-level detail.