AI at work · Guide

AI Can Build You a Custom Dashboard in an Afternoon. Here Is How

By Andrew Ling ·

Short answer

You can have AI build a custom dashboard without writing code. The quickest version is to upload a spreadsheet export to an assistant such as Claude and ask for charts, and the next step up is an interactive dashboard page built in the same chat. With Claude Code, a small team can go further and have a live dashboard that reads a Google Sheet, a CRM or a database every time it opens. Start with read-only data and check the numbers against the source system before anyone makes decisions from them.

Can AI really build a business dashboard for me?

Yes. Most small businesses live with whatever reports each piece of software ships with, and nobody sees all of it on one screen. Now you can describe the page you want and have AI build it. The one-sentence version: "Every morning I open one page that shows new leads, booked appointments and unpaid invoices for the week, pulled straight from the systems we already use, and AI built it."

I build with Claude Code, Supabase and Vercel, so the examples use those, but the same ladder works with other tools. Stop on whichever rung covers what you need.

What are the ways to build one, from easiest to most ambitious?

1. Charts from an export
What you getA set of charts and a short written read of your numbers
How it worksExport a CSV from your CRM or spreadsheet, upload it to the assistant and ask for the charts you want
What it takesTen minutes. A free Claude account can do it
2. An interactive dashboard in the chat
What you getA single page with filters and charts you can click through and share
How it worksAsk the assistant to turn the same export into an interactive dashboard. Claude builds it as an artifact beside the conversation
What it takesUnder an hour. Data is a snapshot, so you upload a fresh export to update it
3. A live dashboard on your own computer
What you getA page that reads your Google Sheet, CRM or database every time it opens
How it worksClaude Code writes a small web app on your machine that uses a read-only key to fetch the numbers
What it takesAn afternoon with Claude Code and a paid Claude plan. No coding experience, but you will copy an API key
4. A shared dashboard the team opens in a browser
What you getThe live page, hosted online, behind a login, with history kept over time
How it worksA scheduled job copies the numbers into a database table each night, and the dashboard reads that table
What it takesA day or two, a database such as Supabase, a host such as Vercel, and someone to review it

How do I make my first dashboard today?

Start on rung one. It costs nothing and tells you which numbers you actually want before you build anything live.

  1. Pick one question you ask every week, such as "Where did this month's leads come from, and how many booked?"
  2. Export the data behind it as a CSV. Most CRMs, booking tools and accounting tools have an export button on their list views
  3. Remove columns you do not need, especially phone numbers, emails and anything private. The dashboard rarely needs them
  4. Upload the file to Claude and write: "Build me charts showing leads by source and by week, and the share of each source that booked. Then tell me the three things you notice."
  5. Pick two or three totals and check them against the original system by hand
  6. When the charts are right, ask: "Turn this into an interactive dashboard I can filter by month."

Claude can read CSV files and spreadsheets, build charts from them and hand back files such as an Excel workbook or a PDF, on every plan including Free, for files up to 30 MB. The interactive version from step six is an artifact: it opens beside the chat, starts private, and can be shared once you are happy with it.

If the export is messy, have the assistant clean it first, as covered in what AI can do for a small business.

How does a live dashboard connect to my systems?

The jump from rung two to rung three is that the data stops being a snapshot. Instead of uploading an export, the dashboard fetches the numbers itself every time you open it.

Claude Code is the tool I use for this. It is Anthropic's agent that reads files, writes and edits them, and runs commands on your computer. It comes with the paid Claude plans: Pro is $20 a month, or $17 a month billed annually. It runs in a terminal, a desktop app, the browser and the mobile apps, and in its default mode it asks before it edits a file or runs a command, so you see each step before it happens.

A rung three session looks like this. You open Claude Code in an empty folder and describe the page: which numbers, which charts, which time ranges. You tell it where the data lives. Then it writes the app, starts it, and you look at it in your browser and ask for changes in plain words.

A Google Sheet
How the dashboard reads themReads the sheet through Google's API, or the sheet is published as a CSV the page loads
What you hand Claude CodeThe sheet link and access set up for reading only
Your CRM
How the dashboard reads themCalls the CRM's API for contacts, opportunities or appointments
What you hand Claude CodeAn API key or private integration token with only the permissions the dashboard needs
A database such as Supabase
How the dashboard reads themQueries the table directly
What you hand Claude CodeA key that can read, never one that can write or delete
Several of the above
How the dashboard reads themEach source is read separately and combined on the page
What you hand Claude CodeOne read-only key per system

Most CRMs that offer an API let you choose what a key can do. GoHighLevel's private integration tokens, for example, are created in the account settings with the scopes you select. Give the dashboard the smallest set that works.

Claude can also reach outside systems through MCP, an open standard for connecting AI assistants to other software, which is handy for asking your data questions in chat. For a page the team opens every morning, a small app that reads the data directly is simpler.

What does the top rung look like?

Rung four is a dashboard your whole team can open in a browser, with history. The usual shape has three parts.

  • A nightly job copies today's numbers from each system into one database table. The job can be a Google Apps Script on a time-driven trigger, an n8n workflow, or a small script Claude Code writes
  • The table lives in a database. Supabase's free plan allows two active projects with 500 MB of database each, but free projects pause after a week with no activity, so a dashboard the team relies on belongs on the Pro plan, which starts at $25 a month
  • The dashboard page is hosted online. Vercel's Hobby plan is free but only for personal or non-commercial use, so a business dashboard needs the Pro plan at $20 a month per developer seat

Because the numbers are stored each night, the dashboard can show trends you never had: this week against the same week last year, or how long leads sat before anyone replied. And once the history is in one table, you can ask AI to read it each Monday and write three sentences on what changed.

Where does an AI-built dashboard go wrong?

The two big failures are wrong numbers that look right and keys left where anyone can read them.

  • Check totals against the source system before anyone acts on them. AI can misread a column, double count a contact who appears twice, or treat a cancelled booking as booked. Pick three numbers and confirm them by hand the first week, and again after every change
  • Write down what each number means. "Leads" can mean new contacts, form fills or opportunities. Tell the assistant which, and put the definition on the page
  • Never put an API key inside a page that runs in someone's browser. Anyone who opens the page can read it. Ask Claude Code to keep keys on the server side, and say so in your first instruction
  • Use read-only access. A dashboard has no reason to change or delete anything
  • Put anything with customer details behind a login. On Vercel, Hobby projects cannot use password protection. Pro offers it as an add-on at $20 a month per project, or you can build a sign-in into the app
  • In Supabase, turn on row level security for every table the dashboard reads. With it on and no policies written, the public key reads nothing, which is the safe starting point

When do you not need a custom dashboard?

If one system holds everything you care about and its built-in reports already answer your weekly question, use those. A custom page is one more thing to keep working.

If nobody looks at the numbers now, a dashboard will not change that. Decide who opens it, how often and what they do when a number moves. If you cannot answer that, rung one, a monthly export and a chat, is enough.

And if the data is sensitive enough that you would not hand it to a contractor, keep it off a hosted dashboard until someone who understands security has reviewed the build.

Frequently asked questions

Do I need to know how to code to build a dashboard with AI?

No for the first two rungs: you upload an export and describe what you want in plain words. A live dashboard with Claude Code also needs no coding, but you will copy API keys, read short instructions and test each change, so set aside an afternoon.

Can the free version of Claude make charts from my spreadsheet?

Yes. Claude can analyze uploaded CSV and spreadsheet files and build charts on every plan, including Free, for files up to 30 MB. Claude Code, which builds a live dashboard, needs a paid plan.

Is it safe to give AI access to my CRM data for a dashboard?

It can be, with three limits: give it a read-only key with only the permissions the dashboard needs, keep that key out of the page itself, and leave out personal details the dashboard does not need. Check how your AI plan handles your data before you connect customer records.

How is this different from Looker Studio or Power BI?

Those are reporting tools you configure yourself, and they work well if your data sources are on their connector lists. Building with AI means describing the page in words and getting exactly that page, including logic a reporting tool does not offer, but you own the upkeep.

Keep reading

More in AI at work.

Free newsletter

Get the weekly AI update for small teams

One short email a week: what changed in AI and in the tools small teams run on, what it means for you, and what to do about it. No spam, unsubscribe any time.