The Scenario
Your company is taking three days off in December for a company-wide holiday closure. Every employee needs a BambooHR time-off request submitted for those three days — it is a formal holiday entry, not a personal request, and payroll needs it in the system before the pay run.
There are 150 employees. The HR manager has all their employee IDs in an Excel workbook from last month's payroll reconciliation.
She looked in BambooHR for a bulk submission option. There is not one.
The bad version:
- Open BambooHR, click "Request Time Off on Behalf of Employee."
- Select the first employee, set the time-off type, set the start and end date, submit.
- Go back, select the second employee, repeat.
- At employee 50, realize you used the wrong time-off type for the first 30. Go back, find each one, cancel the request, resubmit with the correct type.
- You are now doing 180 operations instead of 150.
This is not HR work. It is a data entry problem with a hard deadline.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It reads each employee ID and submits a BambooHR time-off request per employee in one operation.
Read the Excel table 'HolidayClosure' — column A has BambooHR employee IDs. Create a time-off request for each employee for the dates in cells G1 and G2 with type 'Company Holiday'.
SheetXAI reads every ID in the HolidayClosure table, submits a time-off request per employee using the dates in G1 and G2, and writes the result into the table.
What You Get
- One BambooHR time-off request per employee ID in column A.
- Dates driven by G1 and G2 — easy to update for future closures.
- Status written per row: submitted or error description.
- The workbook is the submission log.
What If the Data Is Not Quite Ready
Only full-time employees get the holiday entry
For each employee ID in column A where column C is 'Full-Time', submit a BambooHR time-off request for the dates in G1 and G2 with type 'Company Holiday'. Write 'submitted' or any error in column D.
US and UK employees use different time-off type IDs
For each row, submit a BambooHR time-off request for the employee ID in column A. If column B is 'US', use time-off type ID 5. If column B is 'UK', use time-off type ID 12. Dates are in G1 and G2. Write result in column C.
Check for existing requests before submitting to avoid duplicates
For each employee ID in column A, check whether a BambooHR time-off request already exists for the dates in G1 and G2. If one exists, write 'exists - skipped' in column B. If not, submit the company holiday request and write 'submitted.'
Full filtered-submit with conflict check and audit log
For rows in column A where column C is 'Full-Time': check for existing BambooHR time-off requests for the dates in G1 and G2. Skip and write 'exists' if found. If not found, submit using the type in column B (US: type 5, UK: type 12). Write status and current timestamp in columns D and E.
The pattern: the guard check, the conditional type selection, and the submission all happen in one instruction.
Try It
Get the 7-day free trial of SheetXAI and open your employee ID workbook, then ask it to submit the company holiday time-off for everyone at once. Pull time-off balances afterward to confirm the closure days applied correctly.