Automated Weekly Project Status Updates with Claude Cowork
People: David and Joe
Idea: We built an automation that generates a weekly project status report by pulling activity from multiple data sources - no more chasing people down for updates every Friday.
Details:
- A scheduled Claude Cowork task runs every Friday at noon, starting from our master Excel sheet of active projects
- The Excel sheet tracks each project's name, status sources, Slack channel names, and search terms - so the agent knows where to look for each one
- Cowork uses connectors to search and fetch updates from the last 7 days across Github repos, Granola meeting notes, Slack channels, and Google Drive/Gmail
- It generates a new Word doc with bullet-pointed status summaries for each active project
- If a project looks active but has zero activity in any of its sources for that week, we have a fallback plan
- The planned fallback will use a Slack MCP action to ping the right person and ask for a quick status blurb covering that date range
- This means no project falls through the cracks just because the work happened outside our tracked sources
- We also got it working for multiple people - each person queries the data sources they personally have access to
- A final agent combines all the individual results into one unified status doc for manual review before sharing