The Scenario
It is the day before the monthly leadership meeting. Your talent acquisition manager has been asked to present hiring velocity — how many roles are open, how many applicants are in each pipeline, and whether the team is hitting the 60-day time-to-fill target.
She needs a Google Sheet with all open BambooHR ATS jobs: job title, department, location, number of applicants, and date the position was opened.
The last time this came up someone pulled it by hand. It took an hour and involved opening each job listing individually to count applicants because BambooHR's default ATS export doesn't include applicant counts.
The bad version:
- Open BambooHR ATS, navigate to the Jobs section.
- Click into the first open job, note the applicant count, copy the posting date.
- Go back, click into the second job, repeat.
- After eight jobs, realize you forgot to note the department for the first three.
- Go back, recheck those three, finish the rest, paste everything into a sheet by hand.
The meeting is in 14 hours. The sheet still needs formulas for days-open calculations.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It reads the sheet and pulls BambooHR ATS job summary data in one call — every open job, applicant count included.
Fetch all job summaries from BambooHR ATS and write job title, department, location, number of applicants, and posting status into this sheet.
SheetXAI queries the BambooHR ATS jobs endpoint, pulls every job with its metadata and applicant count, and writes them into the sheet. No clicking through individual job listings.
What You Get
- One row per BambooHR ATS job listing.
- Columns: job title, department, location, applicant count, posting status.
- Applicant counts pulled directly from the API — no manual counting in the UI.
- Data lands ready for a days-open calculation using the date opened column.
What If the Data Is Not Quite Ready
You want only open jobs, not filled or cancelled positions
The leadership dashboard should only show active openings.
Fetch all BambooHR ATS jobs with status 'Open' and write job ID, title, department, location, number of applicants, and date opened into this sheet.
You need a days-open column calculated from the posting date
The 60-day time-to-fill target requires a column showing how many days each role has been open.
Fetch all open BambooHR ATS jobs and write job title, department, location, applicant count, and date opened. Add a 'DaysOpen' column calculated as today's date minus the date opened.
You want to flag roles that have exceeded the time-to-fill target
Any role open more than 60 days needs a visual flag for the leadership slide.
Fetch all open BambooHR ATS jobs. Add a DaysOpen column. Add a 'Status' column: write 'at risk' if DaysOpen is over 60, 'on track' otherwise. Write into the 'RecruitingDashboard' tab.
Full dashboard build in one prompt
Fetch all open BambooHR ATS jobs. Add DaysOpen calculated from date opened to today. Add a Status column ('at risk' if over 60 days, 'on track' otherwise). Write a summary row at row 1 showing total open roles and total applicants. Write the full list below row 3. Sort by DaysOpen descending.
The pattern: pulling the data, deriving calculated columns, and building the summary header all happen in one instruction.
Try It
Get the 7-day free trial of SheetXAI and open your recruiting dashboard sheet 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 alongside the job summary.