Back to Cookbook

Auto Status Report Builder

Turn raw project updates into a clean weekly status report in minutes

Status reporting is consistently described as time-consuming and culturally entrenched. This recipe automates the collate-sanitize-format-publish loop while preserving the PM's judgment and escalation asks. Works across single projects or full portfolios.

House RecipeWork4 min

INGREDIENTS

📄Google Docs✉️Email

PROMPT

Create a skill called "Auto Status Report Builder". Input: a set of project updates (raw notes, tracker export, or pasted bullets). Output: a consistent weekly status report + portfolio roll-up. Requirements: - Use explicit RAG rules (never "gut feel" unless I request it). - Include a lookahead section (default 14 days). - Highlight decisions needed and escalation asks. - Provide both: (1) executive summary, (2) delivery details. - Output format selectable: email, Google Doc, or slide outline. Guardrails: - Do not hide bad news. If status is red, state the cause and the ask. - If key data is missing, list it as "Missing inputs" and proceed with best effort.

How It Works

Paste your project updates — raw notes, tracker exports, or bullet-point summaries — and

this recipe normalizes them into a consistent weekly report with explicit RAG rules, a

14-day lookahead, and a clear separation between executive summary and delivery details.

What You Get

  • Per-project status report: RAG (rule-based, not gut feel), achievements, upcoming milestones, risks/issues with mitigations, dependencies, blockers, and decision asks
  • Portfolio roll-up: aggregated view across all projects
  • Lookahead section: 7–14 day forward view of milestones and deadlines
  • Output formats: email, Google Doc, or PowerPoint slide outline with speaker notes

Setup Steps

  1. List your projects and their milestone plans
  2. Paste current updates per project (notes, exports, or bullets)
  3. Provide or confirm RAG thresholds (schedule slip days, risk score, etc.)
  4. Choose output format and review the generated report

Tips

  • If key data is missing, the report flags it as "Missing inputs" and proceeds with best effort
  • Bad news is never hidden — red status includes the cause and the ask
  • Report styles: RAG, 3Ps (progress/plans/problems), RAID, or narrative
  • Roll-ups can be grouped by program, portfolio, or sponsor
Tags:#reporting#status#pmo#automation#weekly