drafty
HubSpot logo

Build a HubSpot pipeline dashboard with Claude

Connect the HubSpot MCP server to Claude, ask for a deal-pipeline dashboard from your live CRM, and publish it to a link your team comments on directly — no BI tool, no screenshots pasted into Slack.

What you'll build
A self-contained pipeline dashboard — open pipeline value, deals by stage, win rate, average deal size, expected revenue, and the deals closing this month — generated by Claude from your real HubSpot data, then published to a drafty.im/canvas/… link. Your team clicks the exact stage or number they want changed and leaves a note. Claude reads the comments and ships a revised version to the same URL.

This is an end-to-end example: connect a data source over MCP, generate a dashboard from live numbers, and close the review loop on one link. Total time, start to shared link, is under fifteen minutes. The same shape works for any of the other examples — only the connection step changes.

Here's the finished dashboard, published to a canvas — click any tile or number to leave a comment, exactly as your team would:

Live canvas — comment on any elementOpen ↗

The three moving parts

  1. The HubSpot MCP server gives Claude read access to your HubSpot CRM — deals, pipelines, contacts, companies, owners, activities — through a controlled set of tools. You approve what it can touch.
  2. Claude pulls the numbers and writes a single self-contained HTML dashboard. You iterate on it in the artifact panel until it's right.
  3. Drafty turns that HTML into a stable link your team reviews. Comments pin to the exact element; Claude ships the fix to the same URL.

The generation step is fast now. The part this example is really about is the third one — getting the dashboard in front of people without losing their feedback to a screenshot circled in Preview.

Step 1 — Connect the HubSpot MCP server

HubSpot runs an official remote MCP server at https://mcp.hubspot.com. You connect once; it authenticates over OAuth (PKCE), so no key is pasted into a config file.

In Claude Code:

claude
claude mcp add --transport http hubspot https://mcp.hubspot.com/

Then run /mcp inside Claude Code and follow the OAuth prompt to authorize the account. When you authorize, grant read scopes only — this dashboard never needs to write to HubSpot.

In Claude (web, desktop, or mobile): open Settings → Connectors → Browse connectors, select HubSpot, click Connect, log into your HubSpot account, and approve read permissions on the authorization screen.

Safety first
Connect with OAuth and grant read-only permissions on the CRM objects you actually need — deals, pipelines, contacts, companies. The connector respects your HubSpot user permissions, so it can never see more than your own account can. Never paste a private app access token into a config file or commit it. The dashboard only reads; it has no reason to hold write permissions.

Step 2 — Pull the numbers

Ask Claude in plain language. It uses the HubSpot MCP server's read tools to fetch real CRM data:

claude
Using the HubSpot MCP server, pull everything we need for a sales pipeline dashboard: total open pipeline value, count and value of deals in each pipeline stage, win rate over the last 90 days, average deal size, weighted/expected revenue for open deals, and the deals with a close date this month. Summarize the figures before you build anything.

Claude calls HubSpot, returns the figures, and you sanity-check them against the HubSpot deals view before going further. This is the moment to catch a wrong assumption — the wrong pipeline, deals stuck in a forgotten stage, a currency mix — while it's cheap.

Step 3 — Build the dashboard

Once the numbers look right, ask for the artifact:

claude
Build a single self-contained HTML dashboard from those figures. Open pipeline value as the hero number, then a deals-by-stage funnel, tiles for win rate, average deal size, and expected revenue, and a table of deals closing this month. Clean, no external dependencies — inline the CSS and any chart code.

Claude renders it live in the artifact panel. Iterate in place — you're not regenerating from scratch:

Step 4 — Publish to Drafty for review

A Claude artifact link is a preview, not a stable URL — iterate the artifact and the link you already sent now shows the old version. Ask Claude to publish it to a Drafty canvas instead, so the link you share always stays current:

claude
Publish this dashboard to Drafty as a canvas and give me the shareable link.

Claude pushes the dashboard and hands back a drafty.im/canvas/… link that renders on any device. Send it — your team opens it in a browser, no login and no Claude account needed.

Step 5 — The review loop

This is the part that's not obvious until you've done it once.

A reviewer clicks the specific stage, tile, or number they want changed and leaves a pinned comment — "this win rate looks high, are we counting deals that were never really qualified?" The comment is anchored to that element, not floating in a Slack thread. Claude reads the comments through the CLI, reruns the relevant HubSpot query if needed, and pushes a revised dashboard to the same URL. The reviewer refreshes and sees the change; the thread stays attached to the element.

The mechanic matters because of what it removes. A Slack message about a chart produces "the number on the left looks wrong." A pinned comment on the actual tile produces "this — exclude deals in the Closed Lost stage from the win-rate denominator." One of those produces a correct revision; the other produces a guess.

Keeping it fresh

An MCP-generated dashboard is a snapshot — it holds the numbers Claude pulled when it built it; it doesn't re-query HubSpot when someone opens the link. For a weekly pipeline review or a board-ready snapshot, that's fine.

To make it a live canvas that always shows today's figures, copy this prompt — Claude sets up the refresh for you and schedules it to run on its own:

claude
Turn this HubSpot dashboard into a live canvas: every morning, re-pull the latest pipeline numbers from HubSpot via the MCP server, rebuild the dashboard, and push a new version to the same canvas URL so the link always shows today's figures. Schedule it to run daily on its own.

The link stays stable while the content updates underneath it — see keeping a canvas updated automatically.

What to watch for

HubSpot dashboard with Claude — FAQ

Do I need to paste my HubSpot access token anywhere?
No. The remote HubSpot MCP server at mcp.hubspot.com authenticates over OAuth (PKCE), so you authorize the account through a consent screen instead of pasting a token. The connector respects your existing HubSpot user permissions — it can never read more than your own account can — so never paste a private app token into a config file or commit one.
Is the dashboard live or a snapshot?
A snapshot. It contains the numbers Claude pulled when it built the file; it does not re-query HubSpot when someone opens the link. To refresh it, ask Claude to repull and re-push to the same URL — or put that on a daily schedule so the stable link always shows current pipeline numbers.
Can my team comment without a HubSpot or Claude account?
Yes. The dashboard is published to a Drafty canvas link that renders in any browser. Reviewers click the exact element they want changed and leave a pinned comment with no login required. Only the person connecting HubSpot needs access to the CRM.
Is it safe to give Claude access to my HubSpot CRM?
Connect with read-only OAuth scopes, and a pipeline dashboard never needs more than that. The MCP server honors your HubSpot user permissions, every tool call is mediated by the server, and in Claude you approve actions. Don't grant write scopes for a read-only reporting task.
How is this different from a HubSpot report or dashboard?
HubSpot's native reports and dashboards query live data inside a model you maintain — the right choice for standing, governed reporting. This approach is for a fast, shareable snapshot you can spin up in minutes and iterate by talking to Claude, then collect feedback on inline. Different jobs: one is a standing system, the other is a quick reviewable deliverable.