How can I receive all the Due cards from a specific board list via email

Question

How can I receive all the soon-to-expire cards from a specific board list via email, while also expecting to see the detailed content in the email? Scenario: I need to check the cards that are expiring within the next 1-2 days every morning to manage my schedule.

Hannah Humbert - Simpla Workflows · Answer

It looks like it should just be:

every day at 10:30 am, create a report with all cards in list "2. Work In Progress" due in less than 1 days using pattern "- [{cardname}]({cardlink}) ({cardmemberusernames}) {{%Priority}} => DUE on {cardduedate}", group by due date, and send an email notification to "787387751@qq.com" with subject "todo snapshot" and message "here's today's todo-list
{$report}"

Note the report variable {$report} at the end of your email. You need to make sure your message includes this so it pulls the report through.

Also, you might want to adjust your filter to say "due in less than 2 days" so you're not just getting cards due within 24 hours.

wpl12315 · Answer

could someone help me correct the following?every day at 10:30 am, create a report with all cards in list "2. Work In Progress" due in less than 1 days using pattern "- [{cardname}]({cardlink}) ({cardmemberusernames}) {{%Priority}} => DUE on {cardduedate}", create a report with all cards in list "2. Work In Progress" due in less than 1 days using pattern "- [{cardname}]({cardlink}) ({cardmemberusernames}) {{%Priority}} => DUE on {cardduedate}" group by due date, and send an email notification to "787387751@qq.com" with subject "todo snapshot" and message "here's today's todo-list
{listname}"