Automate Project Status Updates for Your Team
Eliminate manual status reporting by building a system that pulls task data, generates plain-English updates, and delivers them to your team on schedule.
Time Required
2–3 hrs setup
Expected Result
A twice-weekly automated project status update delivered to Slack or email, written in plain English from your project management data.
Connect Your Project Tool
Set up a Make or Zapier scenario that reads your ClickUp, Monday.com, or Notion project board on a schedule. Pull tasks by status: completed, in progress, blocked, and upcoming.
Calculate Progress Metrics
Add a calculation step that computes: % of tasks complete, tasks blocked, days to deadline, and any milestones reached since the last update.
Write the Update with AI
Send the task data and metrics to Claude with a prompt to write a 3-paragraph status update: what was accomplished, what's in progress, and what's at risk or blocked.
Format and Distribute
Format the update as a Slack message with emoji for at-a-glance status, or as a structured email. Deliver every Monday and Thursday at 9 AM.