Overview
Leadership needs project visibility without attending every standup or reading every Slack update. A well-structured Notion dashboard with automated data pulls gives executives and managers a real-time view of all project health in one page — what's on track, what's at risk, and what needs attention.
Before you start
- Notion Plus plan or higher
- Active projects tracked in a Notion database
- Zapier account for Slack notifications
- Project owners with Notion accounts
Step-by-step guide (4 steps)
Structure your projects database in Notion
Create a Projects database with fields: Project name, Client, Status (On Track, At Risk, Blocked, Complete), Owner, Start date, Target completion, % Complete, and Last Updated. This is the source of truth your dashboard pulls from.
Create the dashboard page with filtered views
Create a Notion page called 'Project Dashboard.' Add linked database views: (1) Active Projects filtered by Status = On Track or At Risk, (2) Blocked Projects filtered by Status = Blocked (these need immediate attention), (3) Completing This Month filtered by target date.
Add a weekly status update automation
In Zapier, create a Monday morning Zap: query all 'At Risk' or 'Blocked' projects in your Notion Projects database. Post a Slack message to the leadership channel: 'Weekly project health: [X] on track, [Y] at risk, [Z] blocked. [Link to dashboard]'
Add a 'Health Score' formula field in Notion: if % complete is within 10% of where it should be based on elapsed time, Green. If behind 10-25%, Yellow. Over 25% behind, Red. This auto-calculates project health without anyone updating a status manually.
Automate weekly status prompts to project owners
Every Friday at 4pm, send an automated Notion reminder or email to each project owner: 'Please update your project status for the weekly review. [Link to your project page].' This takes 2 minutes per person and ensures the dashboard is current for the Monday review.
What you'll get
Leadership has real-time project visibility without attending every meeting
Blockers are surfaced immediately rather than discovered too late
Project owners develop accountability through weekly status updates
One source of truth for all project health across the organization
Common mistakes to avoid
Building a dashboard before the underlying data structure is correct (fix the Projects database first)
Not automating the weekly status prompt (owners forget to update without a nudge)
Showing too many fields in the dashboard view (keep it to 5-6 columns for scannability)
Frequently asked questions
Do I need coding experience to set up this Notion automation?
No coding is required. This guide walks you through everything using Notion's built-in features and Zapier's visual interface. If you can follow a recipe, you can follow this guide.
How long does this automation take to set up?
Most users complete this setup in 30–60 minutes on their first try. Once set up, it runs completely automatically with zero ongoing effort.
What happens if the automation fails?
Zapier and Make both have error notifications and task history, so you'll know immediately if something goes wrong. We cover troubleshooting steps in the guide above.
Can I customize this automation for my specific business?
Absolutely. The guide includes notes on common customizations. Most automations have multiple variation points — timing, conditions, notification recipients, and more.