Every Monday, reminds people with training past due, and tells their manager once it is over two weeks late.
Uses
Gmail
Google Sheets
Chase overdue training and tell managers
Run every Monday at 09:00.Run every Monday at 09:00.
Training tracker sheetSet training_sheet to blank.Training that is overdue and not completedRead the rows of training_sheet. Save it as overdue_training.Google Sheets
For each assignment in overdue_training.rows:For each assignment in overdue_training.rows:Remind the employeeSend an email to assignment.Email. Save it as employee_email.
Subject: Reminder: assignment.Course training is overdueHi assignment.Name,
Your assignment.Course training was due on assignment.date_display. Please complete it as soon as you can.Gmail
If assignment.days_until is less than -14If assignment.days_until is less than -14Yes
Escalate to their managerSend an email to assignment["Manager email"]. Save it as manager_email.
Subject: assignment.Name's assignment.Course training is over two weeks lateassignment.Name has not completed assignment.Course training, due assignment.date_display. Please follow up with them.GmailNo
No steps