Add new BambooHR hires to the right Google Groups on Day 1

Every weekday at 8am ET, run an agent that adds today's new hires to the right Google Groups for their department, title, and office, then posts one recap message in Slack so the IT team can review.

Step 1. Find new hires in BambooHR. Use Get Changed Employees with a since timestamp covering the last ~36 hours so an 8am Monday run still catches Friday-late changes and weekend updates. From the change feed, keep only employees whose start date (hireDate) is today or yesterday in ET. If the change feed entry is missing department, job title, or office/location, call Get Employee for that employee with the specific fields needed (firstName, lastName, workEmail, department, jobTitle, location, hireDate) to fill in the gaps. If workEmail is still missing, skip that person and flag them in the Slack recap as needing review.

Step 2. Load the real Google Groups inventory. Call Google Groups List Groups for the workspace and build a map of group email to a short description (department groups like engineering@, sales@; office groups like nyc-office@, sf-office@, remote@; all-hands groups like all-staff@; function groups like managers@, on-call@). Only pick from groups returned by this call. Never invent a group address.

Step 3. Decide which groups each new hire should join. Use the new hire's department, job title, and office location to pick the matching subset from the real inventory. Examples: a Senior Backend Engineer in NYC joins engineering@, all-staff@, nyc-office@; a Customer Success Manager in remote joins customer-success@, all-staff@, remote@; a director or VP also joins managers@ if that group exists. Be conservative: it is better to add fewer correct groups and flag uncertainty than to add someone to the wrong list. If a hire's department or location does not have an obvious matching group, add them to all-staff@ only and flag the rest as needs-review.

Step 4. Add the hire to each chosen group with Google Groups Create Membership, using their workEmail as the member key. If a membership already exists, treat it as done and continue. If Create Membership fails for any other reason, capture the error message and include it in the recap. Do not retry indefinitely.

Step 5. After processing the full batch, send a single Slack message to the IT-ops channel via Slack Send a Message. The message should list every new hire on its own line or block with: name, work email, department, job title, office, and the exact groups they were added to. Group anyone with errors or needs-review notes at the bottom so they are easy to spot. If there are no new hires for the day, send a one-line message saying so.

Ask me at setup which Slack channel to post to, my rough mapping of departments and offices to groups, and whether contractors or interns should be excluded. Use that to inform the matching logic on each run.