On the 1st of each month, emails every employee their remaining vacation days.
Uses
Gmail
Google Sheets
Email everyone their vacation days left each month
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