Automated Weekly Status Report

1. Create a new workflow and add a Schedule trigger node. Set it to run every Monday at 9:00 AM in your timezone. 2. Add a Notion node — use the "Query Database" action. Select your Projects database and filter by Status equals "Active" or "In Progress." 3. Add a Function/Code node to format the query results into a readable report. Loop through each project and build a summary with project name, owner, status, and any blockers listed in a Blockers property. 4. Add a Gmail node — use the "Send Email" action. Set the recipient to your stakeholders distribution list, subject to "Weekly Status Report - [Date]", and paste the formatted report as the HTML body. 5. Add a Slack node — use the "Send Message" action. Post the report summary to your #status-updates channel using mrkdwn formatting. 6. Test the workflow manually by clicking "Execute Workflow" and confirming the email and Slack message arrive with correct project data. 7. Check that the Notion filter is pulling only active projects and not completed or archived ones. 8. Activate the workflow so it runs automatically on the schedule.