A step-by-step tutorial for project managers who want Claude to pull the week's project activity and draft a status report automatically — ready for you to review and send.


What this actually does

Every Friday afternoon (or whatever day you choose), Claude wakes up on its own, looks at what happened across your connected tools that week, and writes a draft status report. It drops that draft somewhere you'll see it (your Drive, a Slack DM, a local file) so that by the time you sit down to send your update, 80% of the work is already done.

Important: Claude drafts the report. It does not send it. Anything client- or leadership-facing should get a human read-through before it goes out, and this tutorial makes sure to build it that way on purpose.

What you need before you start


Step 1: Connect your tools

Before scheduling anything, make sure Claude can actually see your project data.

  1. Open Claude Desktop and go to Settings → Connectors.
  2. Connect whatever holds your weekly project activity. Common combinations for PMs:
  3. Only connect what the report actually needs. Every connector you add is something Claude could read from during the run; keep the footprint tight and intentional.

Step 2: Do one manual run first

Don't schedule the task blind. Run it once manually so you can see what Claude actually produces and correct it before it's on autopilot.

  1. Open Cowork and click + New task.
  2. Write out the report prompt in full (see the template below).