Weekly Project Status Roll-Up: Asana to Notion Digest

This workflow turns a noisy week of Asana activity into a single, executive-ready status page in Notion — automatically, every Friday afternoon. It scans your chosen Asana project (or portfolio), counts what got completed, what's still open, what slipped past its due date, and what's blocked, then hands the raw activity to OpenAI to draft a tight narrative summary with a Red / Amber / Green health rating and a short list of risks and next steps. The finished digest lands as a new dated page in a Notion database so stakeholders read one clean update instead of digging through task lists.

Use it when you run weekly status rituals and you're tired of hand-assembling the same update. It's ideal for PMs, team leads, and program managers who track work in Asana but report status in Notion (to execs, clients, or cross-functional partners). Reach for it when your project has enough churn that a manual roll-up eats 30-60 minutes every week, or when you want a consistent, dated paper trail of project health that anyone can scroll back through. Point it at a single project for a team digest, or run several copies for a multi-project portfolio.

The schedule trigger fires every Friday at 4pm in your timezone. The workflow queries the Asana API for the target project and filters tasks modified in the last 7 days, bucketing them into completed, in-progress, overdue, and blocked. That structured activity is sent to OpenAI with a status-report prompt that produces a one-paragraph summary, an explicit RAG health rating, top risks, and recommended next steps — all as clean JSON. Finally the workflow creates a new page in your Notion status database, titled with the week-ending date and populated with the summary, the RAG rating as a select property, and the metrics, so the digest is searchable and trend-able over time. Everything runs on Sim, so the Asana, OpenAI, and Notion steps execute live on Agent Hive's engine, not as a mockup.