Each day, emails the manager of anyone who started exactly 90 days ago to book their review.
Uses
Gmail
Google Sheets
Remind managers to hold the 90-day review
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