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 at 2:00 PM, Nora distributes a Notion form to team leads asking for current status, active blockers, and next steps. Over the next two hours, it collects the responses. At 4:00 PM, Nora compiles these entries into an executive database view. It color-codes each project—green for on track, yellow for at risk, and red for blocked—based on the reported progress against expected weekly milestones. Critical blockers are extracted and highlighted at the top of the dashboard.

The operations lead opens the rollup view to see the health of all projects in one place. They review the escalated blockers and decide where to intervene or reallocate resources. The manual work of chasing team leads and formatting status tables is gone, leaving only the executive decisions.

Runs weekly on friday at 4:00 pm; collection reminder at 2:00 pm using Notion, run by your CEO.

How it works

1. Distribute status forms — On Fridays at 2:00 PM, Nora creates and shares a standardized Notion page with a form block for each designated team lead. It requests the current project phase, active blockers, and upcoming actions for the week.
2. Collect team responses — Nora monitors the specific Notion database where form submissions land. It waits two hours for leads to complete their updates, tracking exactly which assigned projects have received responses and which ones are still pending.
3. Handle missing updates — If a project lacks an update by 3:45 PM, Nora adds a direct comment tagging the responsible team lead inside their specific project page. This serves as a final reminder before the main rollup runs.
4. Compile executive dashboard — At 4:00 PM, Nora queries the submission database and maps all new entries to the master project portfolio database. It updates the current status property for every active project row based on the new data.
5. Flag project risks — Nora evaluates the text in the blockers field and the reported progress. It updates a select property to color-code the project as on track, at risk, or blocked based on the severity of the delays.
6. Surface critical blockers — For any project marked at risk or blocked, Nora reads the specific blocker text. It then appends this text to a summary block at the top of the executive dashboard page for immediate leadership visibility.

What this replaces

Operations leads spend Friday afternoons messaging individual project managers to ask for their weekly updates. They wait for replies, read through unstructured paragraphs, and manually copy the relevant details into a master Notion database. They then read through the whole list to figure out which projects need executive attention and color-code the rows themselves.

• Message team leads to request status updates
• Read unstructured replies across different channels
• Copy and paste updates into a master Notion database
• Determine and apply color-coded statuses manually
• Write a summary of blocked projects for the executive team

Rough estimate rather than a measured figure: about 90 minutes every Friday, assuming 15 active projects and 5 to 7 minutes per project to chase, read, and format the data.

What it needs to run

Accounts and plans

• Notion workspace with databases for active projects and team leads
• Nora assigned to the workspace via Internal Integration Secret

Access it asks for

• Read content: to view project pages, database entries, and team lead responses
• Update content: to modify dashboard properties, add comments, and update status fields
• Insert content: to create the weekly form pages and append summary blocks

What Nora reads

• Team lead form submissions in the updates database
• Current project statuses in the master portfolio database
• Workspace user list to tag team leads

What Nora writes

• Comments on project pages for missing updates
• Status property updates in the master portfolio database
• Text blocks at the top of the executive dashboard page

When it goes wrong

• A team lead submits an update after the deadline Nora processes the late entry when it arrives, updating the master database row for that project. It adds a note to the dashboard summary indicating the update arrived post-deadline.
• The blocker text contradicts the marked status If a lead marks a project on track but lists severe blockers, Nora defaults to marking the project as at risk. It appends a comment tagging the lead for clarification.
• A project in the master database has no assigned lead Nora skips sending a form for that project. It flags the unassigned project in the executive dashboard summary so operations can assign an owner for the following week.
• The Notion API rate limit is reached during compilation Nora pauses its requests. It waits for the limit to reset, then resumes querying and updating the dashboard databases until the rollup is completely finished.

Who this is for

Worth it if

• Operations directors at 30-50 person agencies managing multiple client deliverables concurrently.
• Product teams running weekly sprints across distinct functional groups.
• Remote organizations where asynchronous status updates are required to avoid scheduling large meetings.

Not worth it if

• Small teams with fewer than five active projects where a single weekly sync is sufficient.
• Organizations that track project tasks in Jira or Linear rather than Notion.
• Workflows where executives want to discuss nuance and strategy with leads rather than reading a summary.

A worked example

A mid-sized marketing agency uses Notion to track 12 active client campaigns. Nora is configured to request updates from four account directors every Friday at 2:00 PM and compile the master campaign database at 4:00 PM.

Executive Rollup: Friday, Oct 27

Critical Blockers:
- Apex Rebrand: Waiting on final logo files from client. Strategy phase stalled.
- Horizon Campaign: Ad account verification pending with Meta.

Project Status:
- Apex Rebrand: BLOCKED. Next step: Escalate to client CEO.
- Horizon Campaign: AT RISK. Next step: Resubmit verification documents.
- Zenith Launch: ON TRACK. Next step: Finalize copy deck.
- Meridian Site: ON TRACK. Next step: QA testing begins Monday.

Frequently asked questions

How do I change the time the form goes out?

You tell Nora in plain language through your chat interface. If you want updates collected on Thursday afternoons instead of Fridays, you send a message requesting the change. Nora updates its own internal schedule and starts sending the collection requests at the newly requested time.

What happens if a team lead is on vacation?

If no update is submitted by the deadline, Nora marks the project status as unknown for that week. You can tell Nora to tag a specific secondary contact for a project if the primary lead is away, and it will route the request to them instead.

Does Nora read all my Notion pages to do this?

No. Nora only queries the specific databases you authorize it to access, such as the master project portfolio and the weekly updates database. It does not search or read unrelated workspace pages, personal notes, financial records, or human resources documents stored elsewhere in your Notion account.

Can Nora alter the structure of my executive dashboard?

Nora updates the data inside existing properties and appends text to a specific summary block on the page. It does not delete columns, change property types, or delete the dashboard page itself. It works strictly within the database schema you already have in place.

Connects to

• Notion — all 7 Notion automations

Related automations

• Daily Standup Digest to Slack Channel — Compile team updates into a single daily message so you never miss critical blockers.
• Auto-Respond to FAQ in Slack — Answer common questions instantly in Slack threads so your team stays unblocked.
• Extract Action Items from Slack Threads to Task Board — Turn meeting discussions into tracked tasks automatically.
• Smart DM Follow-Up Reminders — Never lose track of messages awaiting response.
• Auto-Update Team Wiki from Documentation — Keep your team wiki current without manual edits.
• Auto-Generate Meeting Agendas in Notion — Never spend 10 minutes drafting an agenda again.
• Notion Onboarding Checklist with Auto-Reminders — Track new employee onboarding in one place with zero manual follow-ups.
• Auto-Capture Decisions to Notion Decision Log — Never lose track of decisions—automatic capture from meetings & Slack.

Start a 2-week free trial · Browse all automations