All workflows
Google Sheets logoGmail logo

Email everyone their vacation days left each month

On the 1st of each month, emails every employee their remaining vacation days.

Every month on the 1st at 09:002 apps2 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 everyone's balance.
  2. For each employee

    1. 2GmailSendEmails each employee their balance.

How it works

What happens on each run, in plain English.

Nobody wants to find out in December how many vacation days they have left. On the first of each month this reads your Employees sheet and sends each person their balance.

The sheet needs the columns First name, Email and Vacation days left. Keep the balances up to date on the sheet and the emails stay right.

google sheetsgmailvacationmonthly

Start from a workflow that already works.

Add "Email everyone their vacation days left each month" to your workspace, connect its apps, and make it yours.

Free plan, no credit card