A self-updating business dashboard pulls data from your CRM, ad platforms, payment processor, and analytics tools and assembles it into a single live view — updated automatically every day without anyone touching a spreadsheet. Instead of spending 2–3 hours every Monday morning pulling numbers from five different tools and pasting them into a report, you open one dashboard and the numbers are already there. This guide covers exactly how to build one without code.
What is a self-updating business dashboard?
A self-updating business dashboard is a Google Sheet, Notion database, or dedicated BI tool that automatically refreshes its data on a schedule — daily, hourly, or in real time — by pulling from your operational tools via API. The “self-updating” part means no manual data entry: the automation pulls the numbers, the dashboard displays them.
Most businesses have the data they need scattered across 5–10 tools. Their revenue is in Stripe. Their pipeline is in HubSpot. Their ad spend is in Google Ads and Meta. Their website traffic is in Google Analytics. Their customer count is in their database. A self-updating dashboard aggregates all of these into a single source of truth — updated without anyone having to do anything.
A self-updating dashboard brings all your business metrics into one place — updated automatically every day
Which metrics to include
The best dashboards are opinionated — they show 10–15 metrics that genuinely drive decisions, not everything available. Group your dashboard into three sections:
Revenue and financial metrics
- MRR / ARR (Stripe, Paddle, or payment processor)
- New MRR added this week/month
- Churned MRR
- Outstanding invoices
- Cash in bank (via accounting software)
Pipeline and sales metrics
- New leads this week (CRM)
- Deals in pipeline by stage (HubSpot / Pipedrive)
- Conversion rate (leads → closed)
- Average deal size
- Sales cycle length
Marketing and traffic metrics
- Website sessions (Google Analytics)
- Ad spend and ROAS (Google Ads / Meta)
- Email list size and growth (ConvertKit / Klaviyo)
- Social followers and engagement
Dashboard data flow — each tool's API feeds into the automation layer which writes to the central dashboard
How to build a self-updating dashboard
Step 1: Choose your dashboard destination
For most businesses, Google Sheetsis the best starting point: it's collaborative, familiar, and the automation layer can write to it directly. For more visual dashboards, consider Notion (good for team visibility) or a lightweight BI tool like Looker Studio (free, connects directly to Google Sheets).
Step 2: Map your data sources
List every metric you want and the tool it comes from. For each metric, confirm the tool has an API you can query. Most SaaS tools (Stripe, HubSpot, Google Analytics, Klaviyo) do. If a tool doesn't have a public API, check if it can export to Google Sheets directly (Google Ads and Google Analytics both can via native connectors).
Step 3: Build the automation layer
Build a workflow that runs every morning (or on your desired schedule) that queries each data source via API and writes the results to the corresponding cells in your Google Sheet. The workflow runs in the background without you — the dashboard is current every time you open it.
The dashboard automation workflow — runs every morning, pulls all metrics, updates the sheet automatically
The automation layer that keeps it current
The automation itself is a scheduled workflow with one section per data source. A typical morning dashboard update workflow looks like:
- Query Stripe API for yesterday's revenue, new subscriptions, and churn
- Query HubSpot API for new leads, deal pipeline value, and conversion rate
- Query Google Analytics API for sessions, bounce rate, and top pages
- Query Klaviyo API for subscriber count, open rate, and revenue
- Write all values to the corresponding cells in Google Sheets
- Send a daily summary Slack message to the #metrics channel: “📊 Yesterday: $X revenue, Y new leads, Z new subscribers”
This entire workflow, built in Vendarwon Flow, runs automatically every morning. The inputs are described in plain English; the AI generates the workflow that calls each API, handles errors, and writes to the right cells. For more on automating weekly data summaries, see our guide to automating weekly reports with AI.
The finished dashboard — all metrics populated automatically every morning, no manual data entry
Frequently asked questions
Does a self-updating dashboard replace a BI tool?
For most small and medium businesses, yes — a well-built Google Sheets dashboard with automated data pulls covers 90% of what a BI tool provides, at a fraction of the cost and complexity. BI tools (Tableau, Power BI, Looker) make sense when you need complex joins, large datasets, or highly interactive visualisations. For daily operational reporting, Google Sheets is usually sufficient.
How often should the dashboard update?
Daily is sufficient for most operational metrics. Real-time updates make sense for e-commerce revenue during a launch or ad campaigns you're actively managing. For strategic metrics (MRR, pipeline, customer count), daily is more than enough and prevents the anxiety of watching numbers fluctuate hour by hour.
What if an API call fails?
Build error handling into your dashboard automation: if an API call fails, keep the previous day's value and send yourself a Slack alert. This way the dashboard is never completely empty — it just shows slightly stale data for that metric until the next successful pull.
Can non-technical people build this?
Yes — that's the point of natural language workflow automation. Describe “every morning at 7am, get yesterday's Stripe revenue and write it to cell B3 of my Dashboard sheet” and the workflow is generated for you. No API knowledge or code required. You do need to connect your accounts (Stripe, HubSpot, etc.) which requires finding your API keys, but the workflow generation itself is fully guided.
How is this different from a spreadsheet I update manually?
A manually updated spreadsheet is only as current as the last time someone updated it — which in practice means it's usually a few days or weeks out of date. A self-updating dashboard is always current as of this morning. The difference in decision-making quality is significant: you're always working from accurate, recent data rather than approximations.