Weekly Status Report Roll-up
workflowFreeCreates a consolidated weekly status view across all departments by gathering updates, normalizing formats, identifying cross-cutting themes and dependencies, and synthesizing into an executive-ready summary with R/Y/G status indicators.
· Official publisher★ 3.4 (6 reviews)Updated Jun 2, 2026Executive & Cross-FunctionalHow it runs — 4 agents, chained
one run per triggerGathers weekly status updates from all specified departments, extracting accomplishments, blockers, metrics, and status indicators for the reporting period.
Normalizes the collected department updates into consistent format, identifies cross-cutting themes that span multiple departments, and maps inter-department dependencies.
Creates R/Y/G status summary for each department and initiative based on the normalized data, applying configured thresholds and highlighting changes from prior period.
Synthesizes all inputs into a polished executive weekly summary with executive summary bullets, status tables, wins, attention items, and cross-functional dependencies.
About
Creates a consolidated weekly status view across all departments by gathering updates, normalizing formats, identifying cross-cutting themes and dependencies, and synthesizing into an executive-ready summary with R/Y/G status indicators.
Pipeline
- Department Update Collector — Gathers weekly status updates from all specified departments, extracting accomplishments, blockers, metrics, and status indicators for the reporting period.
- Cross-Functional Status Tracker — Normalizes the collected department updates into consistent format, identifies cross-cutting themes that span multiple departments, and maps inter-department dependencies.
- Status Report Generator — Creates R/Y/G status summary for each department and initiative based on the normalized data, applying configured thresholds and highlighting changes from prior period.
- Report Writer — Synthesizes all inputs into a polished executive weekly summary with executive summary bullets, status tables, wins, attention items, and cross-functional dependencies.
- ✓Multi-department update aggregation
- ✓Format normalization across different reporting styles
- ✓Cross-functional theme identification
- ✓R/Y/G status calculation with configurable thresholds
- ✓Executive summary synthesis
- ▪Requires updates from at least 2 departments to proceed
- ▪85% reduction in roll-up creation time from 2-3 hours to 20 minutes
- ▪Status changes from prior week must be highlighted
- ▪Missing department data must be explicitly flagged
Connectors required
Runs entirely on what you paste in — no accounts to link, no data access to grant.
Use cases Summarize this meeting transcript Extract all action items and owners from these notes Document the key decisions made in this meeting Create a follow-up email from this meeting What were the main discussion points and conclusions?
Use cases Analyze risks in this project plan Identify timeline dependencies that could cause delays Assess resource constraint risks What scope creep risks should we watch for? Review this project for delivery risks