Append Daily Updates to a Running Project Log

Get the names of all cards from the Trello list named '[Done this Week]' on the '[Project Name]' board. Create a new Google Doc titled 'Weekly Progress Report' and list all the completed card names under a "Completed Tasks" heading.

For all cards in the '[Completed Sprint]' list on your Trello board, retrieve all the comments. Compile these comments into a single Google Doc titled 'Sprint Review Notes' with each card name as a heading.

Review all activity on the Trello board '[Project Name]' from the last 7 days. Create a Google Doc summarizing the key activities, including which cards were moved to the '[In Progress]' and '[Done]' lists.

Find all cards on the Trello board '[Project Name]' that have the label '[Blocked]'. Create a new Google Doc named 'Action Required: Blocked Tasks' and list the names of these cards.

On the Trello board '[Project Name]', find all cards due in the next 24 hours. For each card, add a comment that says, "@[Assignee's Username], a friendly reminder that this is due tomorrow."