Friday timesheet reminders from Harvest

Chasing timesheets on a Friday afternoon is nobody's favourite job. This checks Harvest for everyone under 35 hours for the week, including people who haven't logged anything, and sends each a friendly reminder with their hours so far.

You then get one email with a table of who was reminded. In a week when everyone is done, nothing is sent.

Run every Friday at 16:00.Run every Friday at 16:00.

Who gets the summarySet summary_recipient to blank.

Find everyone under 35 hours this weekGet a time report. Save it as hours_report.Harvest

People under 35 hours who have an email addressKeep each item in hours_report.results where item.email isn't blank and save it as people_to_remind.

Is there anyone to remind?If people_to_remind isn't empty

Yes

For each person in people_to_remind:For each person in people_to_remind:

Email the person a timesheet reminder Send an email to person.email. Save it as reminder. Subject: Friendly reminder: please finish this week's timesheetHi person.first_name, Just a friendly reminder: your Harvest timesheet shows person.total_hours_display hours logged for this week so far. When you get a moment, could you add any time that's still missing so your week is complete? Thanks so much, and have a great weekend!Gmail

Table of who was remindedMake a table of people_to_remind Save it as reminded_table.

Email the summarySend an email to summary_recipient. Save it as summary. Subject: Timesheet reminders sent this week<p>These people had logged fewer than 35 hours in Harvest this week and were each sent a reminder to finish their timesheet:</p>reminded_table.html<p>hours_report.email_note</p>Gmail

No

No steps