Email everyone their vacation days left each month

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.

Run every month on day 1 at 09:00.Run every month on day 1 at 09:00.

Employees sheetSet employees_sheet_url to blank.

Everyone's vacation balanceRead the rows of employees_sheet_url. Save it as employees.Google Sheets

For each employee in employees.rows:For each employee in employees.rows:

Email the employeeSend an email to employee.Email. Save it as balance_email. Subject: Your vacation daysHi employee["First name"], Vacation days left: employee["Vacation days left"] Please plan your time off with your manager.Gmail