How to Create a Simple Dashboard in Google Sheets with AI

Building a dashboard in Google Sheets used to mean wrestling with complex formulas and pivot tables, but built-in AI tools are completely changing the game. This guide will walk you through creating a simple, effective dashboard using the AI features hidden right inside your spreadsheet. We'll start with clean data and end with an interactive report you can easily share with your team.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Why Use Google Sheets for a Simple Dashboard?

Before an expert data analyst tells you that you should be using a "real" business intelligence tool, let's acknowledge why millions of people still build reports in Google Sheets. It has three huge advantages for simple dashboards.

• It's Free and Familiar: Almost everyone has used a spreadsheet. Google Sheets has no licensing cost, and the learning curve is much gentler than dedicated tools like Power BI or Tableau. You can start building immediately without needing a budget or special training.
• Collaboration is Built-In: Being cloud-based, sharing your dashboard is as easy as sending a link. You can work on it with teammates in real time and leave comments, making it incredibly effective for small teams moving fast.
• It Connects to Everything: Google Sheets lives within the Google ecosystem, making it simple to pull data from sources like Google Analytics and Google Ads. With services like Zapier or official third-party add-ons, you can also automate data entry from hundreds of other apps like Facebook Ads, Shopify, or your CRM.

Step 1: Get Your Data Ready for AI

The saying "garbage in, garbage out" has never been more true than when working with AI. An AI tool is only as good as the data you give it. Taking ten minutes to properly structure your data will save you hours of frustration and ensure your dashboard is accurate.

Consolidate Your Data into One "Raw Data" Tab

Your first step is to create a single, clean source of truth. Create a new tab in your Google Sheet and name it something like "Raw Data." This tab is where all your source information will live. Resist the temptation to do any analysis or formatting on this sheet - it should just be a clean log of data.

Your data should be organized in a simple, tabular format. This means each column represents a different metric or dimension, and each row is a unique entry. For a simple marketing dashboard, your columns might look like this:

• Date
• Source / Medium (e.g., google / organic, facebook / cpc)
• Campaign
• Sessions
• Conversions
• Ad Spend
• Revenue

Having a dedicated raw data tab keeps your process organized. Your dashboard will pull from this source, so if you ever need to update or correct data, you only have to do it in one place.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Keep Your Data Tidy

A little bit of spring cleaning goes a long way. Before you let an AI tool analyze your numbers, make sure your data follows these simple rules:

• One Header Row: Your dataset should have a single, frozen header row at the top that clearly labels each column. Avoid multi-row headers.
• No Merged Cells: Merged cells are the enemy of data analysis. They look nice, but they confuse filters, formulas, and AI tools. Get rid of them entirely.
• Consistent Formats: Ensure your data types are consistent. A 'Date' column should only contain dates, and a 'Revenue' column should only contain numbers. An easy way to check this is to highlight a column and check its format under the "Format" > "Number" menu.
• Fill Blank Cells: If a cell has no value, it should be blank or contain a zero. Avoid putting things like "N/A" or "TBD" in numeric columns.

Step 2: Let Google's AI Do the Heavy Lifting with 'Explore'

With your data clean and organized, it's time for the fun part. Google Sheets has a powerful AI-driven feature called Explore that can analyze your data, answer questions in plain English, and generate charts for you automatically.

How to Use the Explore Feature

Getting started with Explore is ridiculously simple. First, click anywhere inside your clean data table. Then, look for the 'Explore' icon in the bottom-right corner of your screen (it looks like a little four-pointed star in a black circle).

When you click it, a new pane will open on the right side of your screen. This is your AI data analyst.

If you don't see the icon, you can also access it by going to Tools > Explore.

Ask Questions in Normal Language

Here's where the magic happens. At the top of the Explore pane, you'll see a text box to "Ask a question about this data." You don't need to know any fancy formulas - just type your question in plain English. Based on our example data, you could ask:

• "total revenue by campaign"
• "bar chart of conversions from google vs facebook"
• "what was the average ad spend per day?"
• "line chart of sessions over time this month"

As you type, the AI will try to auto-complete your question and will generate a corresponding chart or a numerical answer right inside the Explore pane. This is the fastest way to get quick insights without building a single pivot table yourself.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Use AI-Generated Charts and Insights

Even if you don't ask any questions, the Explore pane automatically analyzes your entire dataset and provides suggested visualizations and insights under the "Answers" section. It might create a bar chart showing Sessions by Source, or a pivot table breaking down Revenue by Campaign.

If you see a chart you like, you can add it directly to your spreadsheet with a single click. Simply hover over the chart and click the "Insert chart" icon that appears. You just created your first dashboard component in seconds.

Step 3: Assemble Your Dashboard

Now that you have your charts, let's put them together in a clean, professional-looking dashboard tab.

Create a New "Dashboard" Tab

Just like you made a dedicated tab for your raw data, create another one called "Dashboard." This is where you'll arrange all your final charts and high-level numbers. Keeping it separate from the raw numbers makes your report clean, easy to read, and prevents others from accidentally messing with the source data.

Arrange Your Charts and KPIs

Drag the charts you generated with the Explore tool from their default location onto your new "Dashboard" tab. Think about how a person will read your report. A good practice is to place your most important, high-level Key Performance Indicators (KPIs) at the top. This includes metrics like:

• Total Revenue
• Total Ad Spend
• Total Conversions
• Return on Ad Spend (ROAS)

Below those top-level KPIs, you can place your charts and graphs that provide more context and detail. Arrange them in a logical grid format. For example, you might place a "Revenue by Campaign" chart next to a "Spend by Campaign" chart to easily compare the two.

Add Interactivity with Slicers

A static dashboard is good, but an interactive one is even better. A Slicer is a user-friendly filter that allows you or your teammates to easily segment the data on your dashboard without ever having to edit formulas.

Let's say you want to filter your entire dashboard by campaign. Here's how to add a slicer:

1. Click on one of your charts or pivot tables.
2. Go to the menu and select Data > Add a Slicer.
3. A slicer filter box will appear on your sheet. In the settings pane that opens on the right, under the "Data" tab, choose the column you want to filter by - in this case, 'Campaign'.
4. Now, you'll have a slicer with a dropdown list of all your campaigns. Anyone viewing the dashboard can check or uncheck campaigns to instantly filter all the connected charts and data. You can add multiple slicers for things like Date Range or Source.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Step 4: Keep Your Dashboard Fresh Automatically

An amazing AI-powered dashboard is only useful if the data is recent. Manually copying and pasting new data every week is tedious and prone to errors. To complete your setup, you'll want to automate the flow of data into your "Raw Data" tab.

While this goes beyond Sheets’ own AI capabilities, it's a critical step. A simple way to do this is with official add-ons. If you're building a Google Analytics dashboard, for instance, you can use the free Google Analytics Spreadsheet Add-on. You can configure it to automatically fetch data every night or every week, so your dashboard is always up-to-date when you open it.

For non-Google platforms, tools like Zapier or Make.com can act as a bridge. You can set up workflows (or "Zaps") that automatically add a new row to your Google Sheet whenever something happens in another app, like a new sale in Shopify or a new ad spend entry in Facebook Ads.

Final Thoughts

By pairing clean, organized data with Google Sheets' built-in Explore feature, you can build a useful dashboard in under an hour. You start with a solid data foundation, use natural language to ask questions and generate visuals with AI, arrange those visuals on a dedicated dashboard tab, and then automate the incoming data flow to keep it relevant.

While Google Sheets is an incredible tool for getting started, you'll eventually find that managing data across multiple platforms (like Google Ads, Shopify, and your CRM) in one sheet becomes complicated and time-consuming. That's why we built Graphed. We connect directly to all your marketing and sales sources in one click, letting you create dashboards and get insights simply by asking questions in plain English. It eliminates the spreadsheet management altogether, giving you a real-time, unified view of business performance without the manual updating.