Email each person their overdue Asana tasks

Overdue tasks sit unnoticed until someone chases them. Each weekday at 8:00 this reads the open tasks in your Asana project that are past their due date and groups them by assignee.

Each person gets a single email with a table of their own tasks. Tasks with no assignee are skipped, and nobody is emailed on a day they have nothing overdue. It reads up to 500 tasks.

Run every weekday at 08:00.Run every weekday at 08:00.

TodayGet today's date and save it as today.

Find overdue tasksFind open tasks in Asana project (not set). Save it as overdue.Asana

Overdue tasks by personGroup the items in overdue.tasks by assignee.email and save it as tasks_by_person.

Email each personFor each person in tasks_by_person:

If person.key isn't blankIf person.key isn't blank

Yes

Table of their tasksMake a table of person.items Save it as table.

Email the assigneeSend an email to person.key. Save it as emailed. Subject: You have overdue taskstable.htmlGmail

No

No steps