Nightly Deel new hire onboarding to Notion and Slack

Every night at 8pm, check Deel for any contracts that were signed or activated in the last 24 hours and kick off a lightweight onboarding for each new hire. Use Deel List Contracts, filtering by status (signed or in-progress) and by signature or start date within the last day, to find the fresh contracts. If you need to inspect one more closely to pull manager, country, role, and start date, retrieve the single contract too.

For each contract, first check the Notion onboarding database using Query a Database to see if a page already exists with that Deel contract ID in the "Processed Contract ID" property. If one exists, skip that hire entirely — no new page, no Slack message. This is the idempotency guard so a re-run (or an overlapping window) never double-posts.

For hires that are new to us, use Notion Create a Page as a child of the onboarding database and fill in: Name, Role or Job Title, Start Date, Country, Manager, and the Deel Contract ID (into a "Processed Contract ID" text property). In the page body, write a short intro paragraph and a tailored first-week checklist — pick tasks that fit the hire (engineering hires get repo access, environment setup, and a first PR; sales hires get CRM login, territory review, and shadow calls; ops or generalist hires get tool logins, a stakeholder intro list, and a 30-day goals doc). Keep it to 5-7 checklist items.

Then use Slack Bot Send a Message to post in the team's welcome channel (ask me for the channel ID on first run). Write a warm, human intro announcing the new joiner — include their name, role, start date, country, who their manager is, and a link to the Notion onboarding page you just created. Tailor the tone and the manager mention per hire; don't just template-fill. Keep it 2-4 sentences.

If nothing new came in from Deel, do nothing (no "quiet day" message). Deel isn't in our poll providers, so run this on a nightly cron rather than a poll trigger.