Auto-Rollup Project Status from Team Updates

Executive dashboard updates itself—no more status meetings.

Nora collects weekly status updates from team leads in Notion, rolls them up into an executive project dashboard, and flags at-risk projects.

Every Friday, Nora sends a brief Notion form to each team lead: "What's complete, what's blocked, what's next?" Team leads fill it in (2 minutes). Nora compiles these into an executive dashboard showing: all projects, status (on track/at risk/blocked), % complete, and critical blockers. If any project falls to "at risk" (e.g., 80% of tasks not done by day 4), Nora flags it red and suggests remediation. The CEO can see project health at a glance without requesting status calls. Teams report 50% reduction in status meetings and better visibility into cross-team dependencies.

How it works

  1. Send Notion form to all team leads Friday at 2:00 PM (status, blockers, next steps)
  2. Collect responses over 2 hours
  3. Compile responses into executive dashboard by project
  4. Color-code status: green (on track), yellow (at risk), red (blocked)
  5. Calculate % complete vs. expected for the week
  6. Highlight critical blockers needing escalation

Frequently asked questions

What does "Auto-Rollup Project Status from Team Updates" do?

Nora collects weekly status updates from team leads in Notion, rolls them up into an executive project dashboard, and flags at-risk projects.

How long does setup take?

Under 5 minutes. Connect your tools and Nora handles the rest.

Which tools does this use?

Uses Notion, run by your CEO.

How much time does this save?

Saves approximately 3 hours/week, running weekly on friday at 4:00 pm; collection reminder at 2:00 pm.

Related automations

Start a 1-month free trial · Browse all automations