Draft a status update from project notes
Pull recent updates from Coda, summarize progress, and draft a status email for stakeholders
Overview
Preparing for stakeholder meetings often means pulling data from multiple places and writing up a summary, which can take longer than the meeting itself. This template gathers your project data, organizes it by status, and drafts an email so you can review and send instead of starting from scratch.
How it works
- Pulls all rows updated this week from your Coda table
- Summarizes what is complete, in progress, and blocked
- Drafts a status update email in Outlook for you to review before sending
Who this is for
Project managers, team leads, and anyone who sends regular status updates and wants to automate the data gathering and drafting process.
Suggested prompt
Pull all rows updated this week from the [1. Table name] table in Coda, summarize what is complete, what is in progress, and what is blocked, then draft a status update email I can review before sending.
Frequently asked questions
Can I use a different project tracking tool?
Yes, you can swap Coda for Airtable, Notion, or another project management tool connected to your MCP server.
Does this send the email automatically?
No, it creates a draft in Outlook for you to review and edit before sending.
Can I customize the status categories?
Yes, modify the prompt to match your project status labels, like not started or needs review.
What if I use Gmail instead of Outlook?
Swap Microsoft Outlook for Gmail in the prompt and connect Gmail to your MCP server.