Send a Weekly Project Status Digest Automatically
By the end of this recipe, your team will get a clear, plain-language project status update in their channel every week — written from what actually happened on the board, without anyone spending Friday afternoon assembling it. Because your tasks and your team chat live in the same workspace, the AI can read the week's real activity and narrate it, instead of you copy-pasting a list of "done" items into a message.
Readiness: Available now. Build the single-board version as an automation, or ask Copera AI to narrate one or several boards on demand. A standing teammate that owns the weekly digest across every board is rolling out in early access.
What it does
Status updates are a chore because the information is all there — it's just scattered across dozens of rows that changed during the week. Somebody has to read them, decide what matters, and write it up. This recipe hands that to the AI.
There are two clean ways to get the digest, and most teams use both:
- On a schedule (hands-off): an automation reads what changed on one project board this week and posts a written status update to your channel every Friday, automatically.
- On demand (broadest): you ask Copera AI to read a board — or several — and write the digest right now, which is the better path when you want one narrative that spans multiple projects.
Either way, the output is a readable update — what shipped, what's in progress, what's blocked, what's due next — not a raw dump of row changes.
Build it yourself
A scheduled automation watches one board and narrates its week. This is honest and reliable: an automation is scoped to the board it's attached to, so it does a great job on a single project. (For a digest that rolls up several boards into one message, use the "Or just ask Copera AI" path below — that's what it's best at.)
In Automations, start a flow with a Schedule trigger set to when you want the update — for example, every Friday at 4:00 PM.
Add a Find rows action on your project board that returns the rows updated in the last 7 days. Narrow it with a row filter if you only want certain statuses (say, everything except "Backlog").
Add an AI → Summarize step over those rows. Prompt it for the shape you want: "Write a project status update with four short sections — Shipped this week, In progress, Blocked or at risk, and Due next week — in plain language a stakeholder can skim."
Add a Post channel message action that sends the summary to your project channel. Prefer to check it first? Send it to yourself with a Send direct message action, or add a human approval request so you can edit before it goes wide.
Or just ask Copera AI
For a digest that spans several projects, this is the better path — Ask Copera AI can read multiple boards and roll them into one narrative. Open Ask Copera AI and say:
"Read our Marketing, Product, and Sales boards and write one weekly status update for the leadership channel — what shipped this week, what's in progress, what's blocked, and what's due next week. Then post it to the #leadership channel."
Ask Copera AI searches the boards you name, writes the digest, and — with Ask before acting on — shows you the message on a review card before it posts, with a Sources list so you can see exactly which rows it drew from. Want it purely as a written answer you'll paste yourself? Ask it to draft the digest without posting.
Make it a standing teammate
Standing AI teammates are rolling out gradually. When one is available in your workspace, you can put a named teammate in charge of the weekly digest: it reads every board you give it, writes the roll-up, and posts it on its own schedule under its own identity — no automation to maintain per board. Until then, the scheduled automation (per board) and the on-demand ask (across boards) above cover it. Everything here can be built today as an Automation.
Tips
Tell the AI the audience. "For the engineering channel" and "for the client-facing leadership channel" produce very different digests from the same rows — one keeps the detail, the other zooms out to outcomes. Name the reader in your prompt.
Draft to yourself first, then flip it on. Point the automation at your own DMs for the first couple of weeks. Once the digest reads the way you'd write it, change the destination to the team channel and let it run unattended.
Keep your statuses clean. The digest is only as good as the board underneath it. Consistent status values and up-to-date due dates give the AI the signal it needs to tell "shipped" from "slipping."
Frequently Asked Questions
Can Copera write a weekly project status update for me?
Yes. A scheduled automation finds the rows that changed on your project board this week, an AI step turns them into a plain-language status update, and it posts to your team channel. You can also ask Copera AI to read one or several boards and write the digest on demand.
Does it cover more than one board?
A scheduled automation is scoped to the board it watches, so it produces a clean digest for a single project. For one digest spanning several boards, ask Copera AI — it reads multiple boards and rolls them into one narrative.
What does the digest actually say?
Whatever you prompt it to. A typical status digest covers what shipped this week, what's in progress, what's blocked or at risk, and what's due next — written in plain language, not a raw list of row changes.
Can I review the digest before it posts?
Yes. Send the draft to yourself as a DM or email first, or route it through a human approval step, so you can adjust the wording before it reaches the channel.
Do I need to write code?
No. Build it on the visual Automations canvas by connecting blocks, or describe it to Ask Copera AI and let it assemble the flow. You review everything before it runs.
Related
- Automations — schedule triggers, find-rows, and AI summarize steps
- Ask Copera AI — read boards and write the digest on demand
- Board Dashboards — the visual counterpart to a written digest
- Copera for Project Management — the wider project workflow
- End-of-Day Team Check-In — the daily sibling of this recipe
- What You Can Build with Copera AI — the full playbook