How to build a live business dashboard in Claude

What is a live dashboard, and how is it different from a regular spreadsheet?#

It looks like this: you open one page and see monthly revenue, new leads, and how many deals are in your pipeline. You don’t export again, copy things into a spreadsheet, or consolidate numbers by hand. You just open it - and the figures are already fresh.

Previously, an artifact in Claude (a built page with a chart or calculator) was a snapshot. The data was baked in at the moment Claude built it. Open it a week later - the figures were still the same. Now such a page can reach into your Google spreadsheet, CRM, payment processor, and show what’s current. Anthropic describes it plainly in its documentation:

The key word is connector. It’s a ready-made connection between Claude and an external service: Google Sheets, Notion, Stripe, email. You grant access once, and after that the page gets data from there on its own. It works on top of the open MCP protocol - if you want to dig deeper, I have an explainer on MCP servers for Claude.

Why does a report you put together by hand go stale by morning?#

It’s a familiar story. Once a week, you open five tabs: your bank, payment processor, CRM, advertising spreadsheet, and something else. You copy numbers into one file, add color, calculate the difference from last week. Two hours later, you have a beautiful report. And a day later, it’s dead - the data has already changed.

The point of a live dashboard is simple: you do the work of “turning data into a picture” once, with a prompt. After that, the picture updates without you.

What happened in 2026: Claude learned to connect to data#

It’s important not to get confused here. Claude now has two similar surfaces, and both provide a “live panel that updates itself.” I discuss their differences and how to choose between them separately. First, here’s what happened.

Before spring 2026, every artifact was static. Claude built a page and permanently embedded the data in it. In April, live panels appeared in the Cowork desktop app. In mid-July, connectors were also enabled for published artifacts - the ones you build in Claude Code or chat and publish to your private address. The July 17 release note puts it this way:

For an entrepreneur, in plain language, that means the metrics panel you put together in an evening no longer goes stale a day later. It looks at your data every time you open the tab.

The business data you’ve gathered in one place becomes a picture in Claude that you can look at every day. CLAUDE.md and the business/ folder structure in a project work on the same principle, but for code - I covered that in my guide to a second brain in Claude Code.

Cowork or a published artifact: where should you build the panel?#

There are two surfaces, and they really are different. Here’s when to use each.

In Cowork, the panel is more seamless - it doesn’t keep asking you for permission at every little step. Anthropic says:

Published artifacts work differently, and it matters for trust: data is shown through the access of whoever opened the page. Your access has nothing to do with it. Two people opening the same panel will see different things - each only what they have access to. That’s right for a team dashboard, but unnecessary complexity for personal use. So my advice is: if the panel is just for you, start with Cowork.

What do you need to build your own panel?#

Let’s break down the barrier to entry as it is. To build a live panel, you need:

1. A paid Claude plan. Connectors to services work on Pro, Max, Team, and Enterprise plans. There are no live connections on the free plan - you’ll get a static snapshot. Published artifacts require Claude Code version 2.1.209 or later.
2. Data in a service you can connect. Google Sheets, Notion, Stripe, HubSpot, email, Slack - somewhere your numbers already live. If revenue exists only in your head and a notebook, first move it at least into a spreadsheet.
3. Half an hour and a clear head. It’s important to understand which three or four numbers you really need to see every day. No technical skills are required.

You don’t need to pay separately for connectors - they’re included in the subscription. The connection directory at claude.ai/directory has grown to several hundred services, and the count grows every week.

How to connect your data: spreadsheets, CRM, payments#

Here’s the process:

1. Open connector settings. In the app or on claude.ai - go to Settings, then Connectors. The claude.ai/directory catalog of available connections is there too.
2. Find your service and click “Connect.” Google Drive and Google Sheets, Notion, Stripe, HubSpot, Gmail, Slack - choose where your data lives.
3. Sign in to the service. The familiar sign-in screen opens (the same OAuth flow as when you sign in to another app with Google). It shows exactly what you’re granting access to. Read it carefully - the permissions you give the connector directly affect the security of your data.
4. Done. The connector is connected. Now Claude can access this service when building and updating the panel.

One caveat about Google Sheets: the standard connector is usually read-only. That means the panel can read your sheet and show figures, but it can’t write back to the spreadsheet. Read access is more than enough for a metrics panel.

How can you build a metrics panel with one prompt?#

Specificity makes all the difference. A vague request like “show me my sales data” will return a generic table that tells you nothing. Name everything explicitly, as you would in a design brief.

Here’s a ready-made prompt you can copy and adapt:

Build a live dashboard artifact with my business metrics. Pull data through my connected connectors whenever the page is opened.

Sections:

Top row - 4 large tiles: monthly revenue, number of new leads, value of deals in progress, average order value. Under each number - percentage change versus last month, a green upward arrow or a red downward arrow.

Revenue chart by week for the last 8 weeks.

Open deals table from CRM: client, amount, stage, number of days open. Sort by amount.

Sources: get revenue and leads from [name your connector - Google Sheets / Stripe / CRM], deals - from [name your CRM].
Add a period filter at the top: this week / 4 weeks / quarter.
If a connector isn't connected, show a clear message in that section saying which service to connect.

Claude will draw the panel in the side of the chat. Then you edit it in words: “put the tiles in one row,” “change the chart to a bar chart,” “add a comparison with the previous quarter.” Each version is saved, and you can roll back to any of them.

What dashboards do entrepreneurs actually need?#

Here’s what people actually build:

Practical advice: start with the question, “What one decision do I make based on this panel?” A typical mistake is cramming in everything you might want to see. The team opens it once, there’s too much, and they never return. One panel - one question.

Live panel, Power BI, or DataLens: which should you choose?#

A comparison on the points that matter to entrepreneurs:

Here’s the answer. DataLens is stronger for heavy analytics and runs locally, but you have to configure data sources and build the panel by hand. Claude wins at something else: build an overview in 15 minutes using ordinary text and pull data directly from Stripe, Notion, or email without setting up a data warehouse. It’s a tool for a quick answer to a question here and now, without trying to replace an enterprise reporting system.

Where live dashboards fall short: honest limitations#

I’ll be direct so you don’t imagine a panel and then hit a wall. Here’s where live dashboards fall short.

I’ll start with public links. A panel that accesses connectors can’t be opened through a public link on any plan. Anthropic states this directly:

The logic is clear: a public link has no signed-in viewer, so there’s no account whose access can be used to get the data, and it can’t safely hand your numbers to an anonymous internet user. The practical takeaway: on Pro and Max, a live panel is a personal tool. If you want to show it to your team, you need a Team or Enterprise plan.

The second limitation is that the panel has no full service behind it. Anthropic calls it what it is:

The rest, more briefly:

• No scheduled updates. Data refreshes when you open the page or click the refresh button. The panel won’t send you a report at 9 a.m. on its own - you need a traditional analytics system for that.
• Storage and calculations are out of scope. The page shows data but doesn’t store information entered into a form. Do heavy calculations before Claude; the page only displays the result.
• One page, up to 16 MB. There are no multiple pages or separate sections within it.

How can you avoid giving Claude too much business data?#

Connecting data to AI is about trust, and there’s something to learn here. Security specialists call indirect prompt injection the main risk of 2026: when an agent has access to your data, contact with untrusted content, and any path outward, a leak becomes almost inevitable. I cover this vector in more detail in my guide to how someone else’s repository can attack Claude Code.

What to do in practice:

1. Connect only what this panel needs. Need revenue? Connect the payment processor. Don’t connect email and calendar “just in case.”
2. Read-only only. Where possible, grant read-only access. A metrics panel shouldn’t write anything to your services.
3. Require manual confirmation for write actions. If a connector can send messages or change records, don’t set it to “always allow.”
4. Check what the panel shows. Connectors break, and the data structure in a service changes. In one case, a data feed stopped working, and the panel quietly displayed incorrect figures for four days. Compare key figures against the source once a week.

As for how the mechanics work, requests to Google, Notion, or Stripe are made by Anthropic infrastructure from its own servers. That means that after you sign in to claude.ai and confirm access to the service, the connections should work normally. This is a conclusion from analyzing the mechanics, not an official vendor guarantee - check it with your own set of services.

A Pro subscription costs about $20 per month.

Where should you start today?#

Specific steps for today:

1. Decide which one metric is most important for you to see every day.
2. Make sure its data is in one service - at least a Google spreadsheet.
3. Connect that service through Claude’s settings (Settings, then Connectors).
4. Copy the ready-made prompt, keep one or two sections for your metric, and build the panel.
5. Open it tomorrow morning and check that the figures are fresh.

After that, add one block at a time as you figure out what you actually look at. Building the first project and getting it to launch is helped by adding working steps in sequence.