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

Read more