The Scenario
A new employee started on Monday. During her first-day paperwork she completed a dependent enrollment form by hand — five dependents, each with a name, relationship, and date of birth.
The HR generalist who handles onboarding is looking at the scanned form. Someone already typed the five rows into a small Google Sheet. Now she needs to get them into BambooHR as dependent records under this employee's profile.
The generalist has done this before. She knows it means clicking into the employee's BambooHR profile, navigating to Dependents, clicking "Add Dependent," filling in each field, saving, and starting again for the next one.
Five times.
She has four other new hires starting this week.
The bad version:
- Open BambooHR, search for the employee, navigate to her Dependents tab.
- Click "Add Dependent," fill in dependent 1's name, relationship, and date of birth, save.
- Repeat four more times, tabbing between the sheet and the BambooHR form.
- Make a typo on dependent 3's date of birth — catch it, go back in, edit.
The form is sitting next to the keyboard. This should take 90 seconds. It takes 15 minutes.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Google Sheet. It reads each row of the dependent form and adds the records to BambooHR through the API — no clicking through profile tabs.
For each row in this sheet, add a dependent to BambooHR employee ID [EMPLOYEE_ID] using column A as the dependent's name, column B as the relationship, and column C as the date of birth.
SheetXAI processes every row, calls the BambooHR API for each dependent addition, and writes a confirmation status into the sheet.
What You Get
- One BambooHR dependent record added per row.
- All three fields populated: name, relationship, date of birth.
- Confirmation written to the sheet after each row — you can see which records landed without checking BambooHR.
- The operation takes seconds regardless of how many rows are in the sheet.
What If the Data Is Not Quite Ready
Dates of birth are in inconsistent formats from the handwritten form
The person who typed the form used different formats: "03/15/1990," "March 15 1990," "1990-03-15."
Before adding the dependents, normalize all dates in column C to YYYY-MM-DD format, then add each row as a dependent to BambooHR employee ID [EMPLOYEE_ID].
Relationship values don't match BambooHR's accepted terms
BambooHR expects "Spouse," "Child," "Domestic Partner" exactly. The sheet has "Wife," "Kid," "Son."
Before adding the dependents, map column B values to BambooHR relationship terms: 'Wife' to 'Spouse', 'Husband' to 'Spouse', 'Kid' or 'Son' or 'Daughter' to 'Child'. Then add each row as a dependent for BambooHR employee ID [EMPLOYEE_ID].
The sheet has rows for multiple employees, not just one
This week's onboarding batch has five new hires. Each one's dependents are in the sheet with their BambooHR employee ID in column D.
For each row in this sheet, add a dependent to the BambooHR employee whose ID is in column D, using column A as name, column B as relationship, and column C as date of birth.
Full normalize and multi-employee add in one shot
Normalize all dates in column C to YYYY-MM-DD. Map relationship values in column B to BambooHR terms (Wife/Husband to Spouse, Kid/Son/Daughter to Child, Partner to Domestic Partner). For each row, add the dependent to the BambooHR employee ID in column D. Write 'added' or any error in column E.
The pattern: the data cleanup and the API writes both happen in one instruction — no intermediate normalization step.
Try It
Get the 7-day free trial of SheetXAI and open your onboarding dependent sheet, then ask it to add the records to BambooHR. You can also pull the full dependent export after adding to confirm all records landed before the benefits administrator does her enrollment review.