Remind managers to hold the 90-day review

Reviews slip when nobody is reminded. Every day at 9:00 this reads your new hires sheet and emails the manager of each person who reached 90 days with the company that day, asking them to book the review.

The sheet needs the columns Name, Start date and Manager email. Nothing is sent on a day when nobody reaches 90 days.

Run every day at 09:00.Run every day at 09:00.

New hires sheetSet sheetUrl to blank.

People who started 90 days agoRead the rows of sheetUrl. Save it as reviews_due.Google Sheets

For each hire in reviews_due.rows:For each hire in reviews_due.rows:

Ask the manager to book the 90-day reviewSend an email to hire["Manager email"]. Save it as reminder. Subject: hire.Name reaches 90 days todayhire.Name started on hire.date_display and reaches 90 days today. Please book their 90-day review and let HR know how it goes.Gmail