Turn signed offer letters in Dropbox Sign into BambooHR new hires

Every 30 minutes, check Dropbox Sign for offer letters that have just been fully signed and turn each one into a complete new hire setup in BambooHR, then announce the hire in Slack.

Trigger: cron, every 30 minutes.

Step 1 — find newly signed offer letters in Dropbox Sign. Use Dropbox Sign's List Signature Requests, paging through results until the list_info pages are exhausted or until you reach requests that finished before the last successful run. For each request, only keep ones where is_complete is true AND the title or the template_id indicates an offer letter (the user should be able to configure either a title keyword like "Offer Letter" or a specific template_id). Then filter again to only the ones whose signed_at timestamp is newer than the last run.

Step 2 — for each matching request, call Get Signature Request to pull the signer name, signer email, signed_at timestamp, and any custom merge fields (job title, start date, manager, department). Skip anything whose signature_request_id has already been processed — keep an idempotency record so the same request never creates a duplicate employee.

Step 3 — call Download Signature Request Files (PDF) to grab the signed offer letter PDF.

Step 4 — create the new hire in BambooHR with Create Employee using the parsed identity and job fields (first name, last name, work email, job title, hire date / start date, supervisor, department). Read the new employee's id from the Location header on the 201 response. If a field is missing from the signed offer, leave it blank rather than guessing.

Step 5 — call BambooHR's Upload Employee File on the new employee id to attach the signed offer letter PDF under a configurable category (default "Onboarding"). If the category doesn't exist yet, create it once with Create Employee File Category and reuse it on future runs.

Step 6 — post a Slack message via Slack Bot's Send a Message to a configurable channel (default #people) announcing the new hire. Include their name, role, start date, and a link back to the Dropbox Sign signature request. Use Slack mrkdwn formatting.

Behavior rules: (1) idempotent on signature_request_id — never create the same employee twice; (2) only operate on offer-letter requests so unrelated signed agreements (NDAs, vendor contracts, etc.) are never pulled into HR; (3) handle missing custom fields gracefully by leaving them blank, never inventing values; (4) if BambooHR returns a 409 conflict on duplicate work email, log it and skip rather than crashing the run.

Configurable inputs the user should be able to set: offer letter match rule (template id and/or title keyword), BambooHR file category name, Slack channel name, run cadence.