How does your team find out a project just tipped into red status? Not by someone finally opening the tracker sheet on Monday morning. Because this workflow decides that for you, every single Friday at 5pm. It reads live data across your Alpha, Beta and Gamma project sheets, merges them into one portfolio view, and calculates RAG status automatically schedule, budget and progress rolled into one flag per project. GPT-4o takes that and writes the executive summary: what happened, what's at risk, what needs attention. The whole thing gets built into a clean HTML dashboard and emailed to stakeholders, no one has to ask for it, and no one has to build it by hand. ✅ Reads Alpha, Beta and Gamma sheets automatically, no manual data pulling ✅ RAG status calculated from schedule, budget and progress ✅ GPT-4o writes the executive summary, not just the numbers ✅ Full HTML dashboard emailed to stakeholders every Friday at 5pm ✅ Slack alert if any node fails, so a broken run never goes unnoticed The dashboard doesn't wait for someone to ask for an update, it's already in their inbox before the weekend starts.