What they were stuck on, and what we built
The problem
A team spent hours each week assembling performance updates and answering the same reporting questions: pulling data from several sources, working out what changed, and writing it up, again, every Monday.
What we did
We built a scheduled AI reporting workflow: data aggregated from the approved sources, filtered for relevance and recency, summarized by an AI step with strictly structured output, and delivered to the team's channel on schedule, with live questions answered through MCP against the same governed data. Failures degrade gracefully: a source outage or a malformed response produces an alert, never a silently wrong report.