Automate Your Weekly Progress Report
Stop spending Friday afternoon writing status updates. Build a system that writes your weekly report from your task list and calendar automatically.
Time Required
1 hr setup, then 5 min per week
Expected Result
An automated weekly progress report delivered every Friday with completed tasks, blockers, and the plan for next week.
Connect Your Task Manager
Set up a Zapier or Make trigger that pulls all tasks marked 'Done' in ClickUp, Notion, or Monday.com in the past 7 days every Friday at 4 PM.
Pull Key Metrics
Add a step that pulls your key weekly metrics from wherever they live — Google Sheets, your CRM, or Airtable — and appends them to the report data.
Write the Report with AI
Send the completed tasks and metrics to Claude via API. Use a prompt that formats them into a structured report: wins, blockers, metrics snapshot, and plan for next week.
Deliver the Report
Route the finished report to Slack, email, or Notion — wherever your team expects to see it. Set the automation to run every Friday at 5 PM.