Every Monday morning, emails each person a table of their monday.com items that are past due and not marked Done.
Uses
Gmail
Monday.com
Email each person their past-due monday.com items
Past-due work hides in a busy board. Every Monday morning this reads the board you pick, keeps the items whose due date has passed and that aren't marked Done, and emails each owner a table of just their items, with how many days late each one is and a link to open it.
An item with two owners goes to both. The due date and owner come from the board's first date and people columns.
overdue_items.Monday.comowner in overdue_items.by_owner:For each owner in overdue_items.by_owner:owner.email isn't blankYes
owner.name by a space and save it as name_parts.owner.items Save it as items_table.owner.email. Save it as sent.Send an email to owner.email. Save it as sent.
Subject: Past-due items on the Projects board: owner.count<p>Hi name_parts[0],</p><p>These items on the Projects board are assigned to you, are past their due date and are not marked Done (owner.count in all):</p>items_table.html<p>Please update them in monday.com when you can.</p>No
No steps