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 publisherNot yet ratedUpdated 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
Yours to keep. Runs in your Trusapien workspace.
What this needs
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 Create a board meeting briefing from these materials Write an investor update letter for this quarter Summarize this strategic initiative for leadership Prepare a briefing document for the CEO meeting Create an executive summary of this analysis