The Scenario
Monday morning. Your recruiting manager runs a weekly pipeline review and she needs the ATS data before the 10 AM standup.
Specifically: all active applications across the eight open positions — candidate name, job title, current stage, and application date. She wants it in a Google Sheet that the full recruiting team can see and filter.
Last week someone on the team spent 40 minutes pulling this manually from BambooHR's ATS interface, screenshotting the pipeline view and transcribing it into a sheet. That is not a sustainable workflow for a team reviewing 150 applications across eight roles.
The bad version:
- Open BambooHR ATS, navigate to each of the eight open job postings one at a time.
- Export the candidate list for each job, download eight separate CSVs.
- Open them all in separate tabs, combine them into one tab, add a column indicating which job each row came from.
- By the time you finish, it's 9:55 and the standup starts in five minutes.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It reads the sheet, connects to BambooHR ATS, and pulls all active applications across every open job in one query.
Fetch all BambooHR ATS applications with status 'Active' and write applicant first name, last name, email, job title, current stage, and application date into this sheet.
SheetXAI calls the BambooHR ATS API, retrieves every active application across all open jobs, and writes them into the sheet with one row per candidate — no per-job exports, no combining tabs.
What You Get
- One row per active application across all open positions.
- Columns: first name, last name, email, job title, current pipeline stage, application date.
- All jobs included in one pull — no per-job repetition.
- The sheet updates are repeatable: same prompt next Monday takes about 30 seconds.
What If the Data Is Not Quite Ready
You only want applications for specific job IDs listed in the sheet
The recruiting manager only reviews three of the eight roles in the Monday standup — the others are handled by a separate team.
Fetch BambooHR ATS applications for the job IDs listed in column A of this sheet and write applicant first name, last name, email, current stage, and application date into the 'Pipeline' tab.
You want to flag candidates who have been in the same stage for more than 14 days
Stuck applications need a follow-up flag before the standup.
Fetch all active BambooHR ATS applications and write them into this sheet. Then add a 'Stalled' column: write 'yes' if the application date is more than 14 days ago and the stage is still 'Phone Screen' or 'Application Review', otherwise leave blank.
You need a count of applications per job for the dashboard header row
The sheet has a summary section at the top with one row per job title and a count of active candidates.
Fetch all active BambooHR ATS applications. Write a summary section at the top of this sheet with one row per job title showing the count of active applications. Then write the full application list below starting at row 10.
Full pipeline pull with stage age and summary in one prompt
Fetch all active BambooHR ATS applications. Calculate days in current stage by subtracting application date from today. Write a summary block at row 1 (one row per job, application count). Then write the full list below row 8 with columns: name, email, job title, stage, application date, days in stage. Flag any row over 10 days in stage with 'follow up' in a final column.
The pattern: pulling the data, deriving the age calculation, and building the summary all happen in one instruction.
Try It
Get the 7-day free trial of SheetXAI and open your recruiting pipeline sheet before Monday's standup, then ask it to pull the BambooHR ATS data. You can also pull ATS job summaries for a higher-level view, or bulk-create candidate records from a sourcing list.