Friday timesheet chase

On Friday afternoon this reads your Timesheets sheet and emails each person whose Hours this week is still blank, asking them to submit their hours.

Your manager gets one email naming everyone who was reminded. If everyone has submitted, nothing is sent. The sheet needs the columns Name, Email and Hours this week.

Run every Friday at 15:00.Run every Friday at 15:00.

Timesheets sheetSet timesheetSheet to blank.

Manager's emailSet managerEmail to blank.

People who have not submitted hoursRead the rows of timesheetSheet. Save it as missing.Google Sheets

If missing.count is greater than 0If missing.count is greater than 0

Yes

For each person in missing.rows:For each person in missing.rows:

Remind the person to submit their hours Send an email to person.Email. Save it as reminder. Subject: Please submit your hours for this weekHi person.Name, We have not received your hours for this week yet. Please add them to the timesheet when you can.Gmail

Names of the people remindedWrite each item in missing.rows as • @item.Name, one per line and save it as missing_names.

Tell the manager who has not submittedSend an email to managerEmail. Save it as manager_summary. Subject: Timesheets still missing this weekThese people have not submitted their hours this week and have been sent a reminder: missing_namesGmail

No

No steps