CellWorks
← Back to guides

AI Sales Dashboard Generator: Build From One Prompt

Nov 13, 2026

You need a sales dashboard by Friday. You don't have a BI license, and you don't want to spend a weekend learning pivot tables. An AI sales dashboard generator solves that: you describe the dashboard in plain English, and it hands back a working workbook with the formulas already built.

This walkthrough shows the whole run. You'll see the exact prompt, the four views it produces, and the metrics worth putting on the first screen. You'll also see when a ready-made template is the better choice.

Create a sales dashboard without a BI tool

A BI platform makes sense when you're pulling data from a dozen systems. Most small teams aren't. They have a list of deals, a list of reps, and a quota, and they want to see how the quarter is going.

That is a spreadsheet job. With CellWorks, one prompt produces an automated sales dashboard in Excel or Google Sheets, and you never write a formula or format a cell. The dashboard reads from a tracker tab inside the same workbook, so there's no connector to configure and no separate tool to log into.

This approach won't clean up your data for you. If the deal rows are incomplete or inconsistent, the tiles will faithfully show incomplete, inconsistent numbers.

Gather the sales fields before you prompt

Spend five minutes listing what each deal row needs. Without these six fields, the dashboard has nothing to calculate from:

  • Deal stage: where the deal sits right now, such as Qualified or Closed Won.
  • Amount: the deal value.
  • Close date: expected or actual, so the dashboard can filter by period.
  • Owner: the rep who holds the deal.
  • Region: needed if you split results by territory.
  • Rep quota: the target for each rep, for the same period you're reporting on.

Stage names matter more than they look. The pipeline view counts deals by matching stage text, so "Closed Won" in one row and "closed-won" in another become two different stages.

Pick your stage names now and use them identically in every row and in the prompt. The AI dashboard generator guide covers the rest of the data-prep checks if your list is messy.

Worked example: an AI sales dashboard from one prompt

Here is the run, start to finish. You type one prompt into the prompt box, the preview builds the workbook, and you check the tiles against the rows underneath them. No account is needed for that preview.

The exact prompt, word for word

Copy this, then swap in your own stage names, columns, and rep names:

Build a sales dashboard in Excel. Create a Pipeline tab with these columns:
Deal Name, Deal Stage, Amount, Close Date, Owner, Region. Use these stages
exactly: Lead, Qualified, Proposal, Negotiation, Closed Won, Closed Lost.
Create a Quotas tab with one row per rep: Owner, Quarterly Quota. Fill the
Pipeline tab with sample deals so I can check the tiles. On a Dashboard tab
show four views: pipeline by stage (deal count and total amount), revenue vs
quota for the current quarter, win rate for the current quarter (Closed Won
divided by Closed Won plus Closed Lost), and a rep leaderboard ranked by
closed-won revenue against quota. Make every tile recalculate when I change a
row on the Pipeline tab.

Notice what the prompt does. It names the columns, locks the stage spellings, and defines win rate in words. The less the generator has to guess, the closer the first result is to what you wanted.

What the finished dashboard shows

The run returns three tabs: Pipeline, Quotas, and Dashboard. The Dashboard tab carries the four views you asked for.

  • Pipeline by stage: deal count and total amount for each stage, from Lead through Closed Lost. You see at a glance where deals are stacking up.
  • Revenue vs quota: closed-won revenue for the quarter divided by quota for the same quarter, shown as a percentage of target.
  • Win rate: closed-won deals divided by all closed deals in the quarter.
  • Rep leaderboard: every owner ranked by closed-won revenue, with quota attainment beside each name.

Now verify one tile yourself, because you shouldn't trust a number you haven't checked. Count the Closed Won rows on the Pipeline tab, count the Closed Lost rows, and divide won by the sum. If the result matches the win rate tile, the logic is working.

Change a deal from Negotiation to Closed Won and watch the pipeline count, revenue, win rate, and leaderboard all move together.

Sales KPI dashboard: which metrics to include

A sales KPI dashboard fails when it shows everything. Reps and managers stop reading it after the second scroll. Keep the first view to a few tiles that answer one question: are we going to hit the number?

Lead with pipeline, revenue vs quota, and win rate

Three metrics carry the first view. Each one has a formula you can check by hand:

  • Pipeline by stage: the count and summed amount of open deals in each stage, as of today.
  • Revenue vs quota: closed-won revenue in the period divided by quota for that same period.
  • Win rate: closed-won deals divided by all closed deals, won plus lost, in the period.

State the period on every tile. A win rate with no period attached could be this quarter or all time, and those two numbers can tell opposite stories. The denominator matters just as much: open deals don't count toward win rate, because they haven't been decided yet.

If you're curious how tiles like these get their formulas without anyone typing syntax, the AI formula generator for Excel explains the mechanics.

Rep leaderboard, and which metrics to hold back

Rank reps on closed revenue against quota, not on activity or deal count alone. A rep who closes three large deals should outrank one who closes ten small ones, if the quota says so. Show the quota percentage beside each name so the ranking reads as attainment, not just volume.

Everything else can wait on a second tab. Sales cycle length, average deal size, and lead source breakdowns are useful for a monthly review, but they don't belong on the screen your team opens every morning.

Skip outside benchmark figures, too. Compare your team with its own quota and its own last quarter instead.

Build the sales pipeline dashboard from your CRM tracker

This is the AI CRM dashboard use case. The dashboard doesn't hold data of its own: it reads the CRM tracker tab in the same workbook, so every tile is a live view of your deal rows.

You can confirm that in the preview. Open the Dashboard tab, click a tile, and check that its formula points at the Pipeline tab. Then edit a deal row and check that the tile recalculates.

Set up the tracker tab the dashboard reads

Give the tracker one row per deal and one column per field. Keep headers in the first row, with no merged cells and no blank rows between deals.

Then protect your stage names. Because the pipeline view counts rows by stage text, a stray "Proposal " with a trailing space shows up as its own stage with its own count. Consider a dropdown list on the Deal Stage column so reps pick a stage rather than type one.

Once the tracker is in daily use, the same data can feed automated Excel reports for weekly or monthly sends. If you're still deciding between a fixed tracker and a generated one, the comparison of a CRM tracker template versus an AI-generated CRM lays out the trade-offs.

Sales dashboard in Excel or Google Sheets

You export the same workbook to either app. Which one you pick depends on how your team works, not on what the dashboard can do.

Choose Excel if your team works desktop-first. It suits people who live in files, email attachments, and offline work, and who may already have Excel on every machine.

Choose Google Sheets if your team edits together in a browser. Reps update their own deal rows while the manager watches the dashboard move, with no file passing back and forth. That makes it the natural home for a sales dashboard template in Google Sheets style, where everyone works in one shared file.

One caution applies to both. Some functions differ by app and version, so a formula that works in current Excel may behave differently in Google Sheets, or in an older Excel release. After you export, check each tile against a quick manual count, the same way you checked the win rate earlier. It takes a few minutes, and it saves you from presenting a wrong number in a pipeline review.

If you haven't generated a file this way before, the guide to create an Excel spreadsheet with AI walks through the prompt-to-file steps.

AI-generated or template: which sales dashboard fits

Both options are legitimate. The question is whether your data already looks like the layout someone else designed.

When a Google Sheets sales dashboard template is enough

A ready-made template works well when your fields already match it. If your CRM export has the same columns, your stages are the standard ones, and you only want the usual pipeline and revenue charts, a template gets you there fast. You paste your data in and you're done.

The catch is the fixed layout. A template expects your columns to match its own. When they don't, you end up renaming headers, rebuilding formulas, or squeezing your process into someone else's structure.

Customize by team or region without starting over

A generated dashboard is built from the field names you list in the prompt, so changing the output means changing a sentence. Say you run two regional teams with different quotas and a custom "Partner Referral" stage. Add the stage to your list, add "Region" to the leaderboard instruction, and rerun the prompt in the preview.

A prompt edit might look like this: "Add a second leaderboard grouped by Region. Add the stage Partner Referral between Lead and Qualified."

The same goes for KPIs a template doesn't include. If you want a metric your template never planned for, you describe it in the prompt instead of hunting for a spare column.

Use a template if your layout is fixed and standard. Use a generated dashboard if you have your own fields, several teams or regions, or metrics a template doesn't cover. For a step-by-step decision, see how to choose a spreadsheet dashboard tool.

Preview your sales dashboard free before you export

You can see the finished dashboard before you commit to anything. The preview is free and needs no account, so you can check the layout, the KPIs, and the tile logic first. You sign up only when you want to export.

Here's your next step. Paste your own pipeline fields into the prompt box, using the prompt above as the starting point, and let the preview build. Check the four views against your rows. When the numbers look right, sign up and export to Excel or Google Sheets.

Frequently asked questions

Can I build a sales dashboard in Excel without knowing formulas?

Yes. You describe the tabs, columns, and views in a plain-English prompt, and the generator builds the formulas for you. You still need to check a tile or two against your own rows, such as counting Closed Won and Closed Lost deals by hand to confirm the win rate.

Which fields does a sales pipeline dashboard need?

At minimum: deal stage, amount, close date, owner, region, and rep quota. Stage, amount, and close date drive the pipeline and win rate tiles, while owner and quota drive the leaderboard. Region is only needed if you want to split results by territory.

Why do my stage counts look wrong?

Almost always because stage names differ between rows. The pipeline view counts by matching text, so "Closed Won" and "closed won" or a trailing space count as separate stages. Fix the spelling in the tracker, or use a dropdown list so reps pick from fixed stage names.

Should I export to Excel or Google Sheets?

Pick Excel if your team works desktop-first, and Google Sheets if several people edit deal rows together in a browser. Either way, check your formulas after export, because some functions differ by app and version.

Do I need an account to try it?

No. The preview is free and needs no account, so you can review the layout and KPIs first. You sign up when you're ready to export.