Turn Lever hires into BambooHR records and a Slack welcome

When a candidate is marked hired in Lever, I want their employee record opened in BambooHR and the team told, with nobody retyping anything. Trigger this workflow from a Lever webhook on the candidate hired event, which gives me the opportunity ID of the person who was just hired.

Start by calling Lever Retrieve Opportunity for that opportunity ID, expanding the contact and the owner so I get the candidate profile and the recruiter who owns them in one call. Then call Lever Get Contact for the canonical person record and read their full name, email, and phone number. Hold on to the opportunity's Lever profile URL (the show URL on the opportunity) so I can link back to it later, and hold on to the owner's name as the recruiter.

Next call Lever List Offers on an Opportunity and take the most recent signed or accepted offer. Read the job title, the start date, and the compensation details off it. For department and location, call Lever Retrieve Posting for the posting on the hired application and use its team or department category and its location category.

Before creating anything, call BambooHR Get Employee Directory and check whether an employee with that work email already exists. If one does, skip the create step entirely and say so in the Slack message rather than creating a duplicate record.

Otherwise create the new starter with BambooHR Create Employee, mapping first name, last name, work email, job title, hire date, department, and location from the Lever record. Lever timestamps come back as Unix milliseconds, so convert the offer start date into the YYYY-MM-DD format BambooHR expects for the hire date. BambooHR returns the new employee ID in the Location header rather than in the response body, so read it from there and keep it for the announcement.

Then post a new hire announcement to the people ops channel with Slack Bot Send a Message. Include the new starter's name, job title, start date, the recruiter who owned the opportunity, a link to their Lever profile, and the new BambooHR employee ID.

Finally append a row to the new hire tracker with Google Sheets Append Values, holding candidate name, role, start date, recruiter, and the Lever profile link.

If the offer has no start date recorded yet, still create the BambooHR record and still post and log everything, but leave the hire date empty and call out the missing start date clearly in the Slack message so someone chases it. Write "Start date missing" in the start date column of the tracker row.