All workflows
Google Sheets logoGmail logoSlack logo

Welcome next week's new starters

Every Monday, emails anyone starting in the next week and tells the team in Slack who is joining.

Every Monday at 07:003 apps3 steps

Apps it connects

Authenticate each one once and the workflow is ready to run.

What it does

Each integration step this workflow runs, in order, what it is for, and the conditions and loops that decide when it runs.

  1. 1Google SheetsRead rowsReads every row of the new starter roster tab to find everyone whose start date falls within the next seven days.
  2. For each hire

    1. If daysUntil is at least 0 and daysUntil is at most daysAhead

      1. If (hireEmail is not empty or done includes teamKey), hireEmail is not empty and done does not include emailKey

        1. 2GmailSendSends each starter a short welcome email, by first name, giving their role and start date, when the roster has an address for them.
      2. If done does not include teamKey

        1. 3SlackSend messagePosts a note to your team channel naming each starter, their role and their start date, asking people to say hello.

How it works

What happens on each run, in plain English.

Every Monday at 07:00, your new starter roster is read, anyone whose start date falls within the next seven days gets a short welcome email, and your team channel in Slack is told who is joining, in what role and on which day, so nobody arrives to a room that was not expecting them.

The welcome email is written from the roster, not by AI: it greets the person by first name and gives their role and start date, so there is nothing to review and nothing to get confidently wrong. Lodol remembers who it has welcomed, so nobody is emailed or announced twice, even if you run it again by hand, and anyone further out is picked up on a later Monday. A hire with no email address is still announced to the team. If a start date can't be read, a column is missing or a message fails to send, the run is marked as failed and names the people affected, instead of looking like a quiet week.

You need Google Sheets, Gmail and Slack connected, the link to your roster, and the ID of the Slack channel for the announcements. The roster tab needs 'Name', 'Role', 'Email' and 'Start date' columns.

google sheetsgmailslackonboardingnew hireweekly

Start from a workflow that already works.

Add "Welcome next week's new starters" to your workspace, connect its apps, and make it yours.

Free plan, no credit card