The Scenario
You are the IT admin. Your provisioning workflow reads an Excel workbook every night — new rows mean new accounts to create, deleted rows mean accounts to decommission.
HR updates BambooHR when they hire or terminate someone. The workbook is supposed to reflect that. But the workbook gets updated manually, when someone remembers.
Three weeks ago a new hire arrived on day one with no system access because the provisioning script ran at midnight, found no new rows, and did nothing. The BambooHR record existed. The workbook row did not.
The bad version:
- Export the full BambooHR directory, open it alongside last week's export, and diff the two files manually to find new or removed employees.
- Copy the relevant rows into the provisioning workbook.
- Stare at 400 rows across two files trying to spot differences by eye.
- Miss a termination because their record was updated but not removed — the diff logic depends on deletion, not status change.
This process fails silently at the worst possible moment.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It reads the workbook, queries BambooHR's changed-employees endpoint, and writes only the delta — new hires, modifications, terminations — into the workbook.
Pull all BambooHR employee changes since [DATE] and paste employee number, name, status, and change type into the Excel 'ChangeLog' sheet for IT provisioning review.
SheetXAI calls BambooHR's changed-employees endpoint, retrieves every record created, updated, or terminated since the specified date, and writes them into the ChangeLog worksheet with a change type column.
What You Get
- Only the employees who changed since the date you specify — not the full directory.
- Change type column: new hire, update, or termination.
- Columns: employee number, name, employment status, change type.
- The ChangeLog worksheet feeds directly into the provisioning script without any diff logic.
What If the Data Is Not Quite Ready
You want new hires and terminations on separate worksheets
Pull all BambooHR employee changes since the date in cell B1. Write new hires into the 'Provision' sheet with employee number, name, email, and department. Write terminations into the 'Deprovision' sheet with employee number, name, and email.
You need to flag department changes for access-level reviews
Pull all BambooHR employee changes since cell B1. For any update where the department changed, write 'dept-change' in a Notes column — these employees may need access profile updates.
The timestamp in B1 should update automatically after each run
Pull BambooHR changes since the date in cell B1. Write results into the ChangeLog sheet. After writing, update cell B1 to today's date and time.
Full delta pull, split routing, and timestamp update in one prompt
Pull BambooHR employee changes since the date in cell B1. Write new hires into Provision and terminations into Deprovision. Flag department-change updates in Provision with 'dept-change' in Notes. Update cell B1 to the current timestamp after writing.
The pattern: the BambooHR query, the conditional routing, and the state update all happen in one instruction.
Try It
Get the 7-day free trial of SheetXAI and open your IT provisioning workbook, then ask it to pull the BambooHR change log since your last sync. You can also pull the full directory if you need to rebuild the baseline after a schema change.