How to create a business metrics dashboard with AI: connect data, visualize KPIs and automate reports without coding

Google Data Studio (also known as Looker Studio until 2026) is Google’s free tool for building dashboards connected to your data.

1. Go to https://datastudio.google.com and sign in with your Google account.
2. On the main screen, click the ”+” button or “Blank report”.
3. Name the report in the top-left corner (for example, “Business Dashboard 2026”).
4. You’ll see a blank canvas. In the next step you’ll connect your data.

If you see the name “Looker Studio” in the interface, it’s the same product. Google unified the name as Data Studio in 2026, but both names may coexist depending on your region.

When you create the report, Data Studio will ask you to choose a data source. The most common ones for small businesses:

Google Sheets (easiest):

1. Select “Google Sheets” as the source.
2. Choose the spreadsheet with your sales, customers or metrics.
3. Select the specific sheet (tab) and click “Add”.

Google Analytics (if you have a website):

1. Select “Google Analytics”.
2. Choose your property (your website) and click “Add”.

For external sources (Facebook Ads, HubSpot, Shopify): Use a third-party connector like Supermetrics or Funnel.io; some have a cost. Confirm prices on the official page of each connector.

Tip: If your data is in Excel, copy it to Google Sheets first and connect from there. It’s the fastest way to get started.

If you have your data in spreadsheets and want to analyze it with AI before connecting, check the tutorial How to use AI in Google Sheets to automate analysis and generate reports.

With data connected, you can build the dashboard. Use the “Insert” menu to add elements:

KPI cards (scorecard):

1. Go to Insert > Scorecard.
2. In the right panel, choose the metric you want to show (total sales, new customers, conversion rate).
3. Drag the card to wherever you want it on the canvas.

Line chart (evolution over time):

1. Go to Insert > Time series chart.
2. Choose the “Date” dimension and the metric you want to see evolve.

Data table (detail):

1. Go to Insert > Table.
2. Add the columns you need (product, revenue, units sold).

Date filter:

1. Go to Insert > Control > Date range.
2. Drag it to the top so it filters the entire dashboard.

Recommended starter KPIs: total sales, new customers, average ticket, conversion rate and the acquisition channel with the best results. Start with fewer than 6 metrics so the dashboard is readable.

This is where AI becomes your personal analyst. You have two ways to use it:

Option A: Export and paste data into Claude or ChatGPT

1. In Data Studio, click the three dots on a chart and choose “Export” (CSV or Google Sheets).
2. Copy the numbers and paste them into Claude or ChatGPT with this prompt:

Here are my business metrics from last month:
[paste your data]

Explain in 3 key points:
1. The main trend you see
2. Which number should concern me and why
3. One concrete action you'd recommend this week

3. The AI responds with a clear-language analysis, no technical jargon.

Option B: Upload a CSV to ChatGPT Plus (Code Interpreter)

1. Export your data as a CSV from Data Studio or Google Sheets.
2. In ChatGPT Plus, open a new conversation and upload the file.
3. Type: “Analyze this file and tell me the 3 most critical KPIs for my business this month.”
4. ChatGPT generates charts and insights directly in the chat.

You can also use Google Gemini inside Google Sheets (if enabled on your account) to summarize entire columns of data. Confirm availability in your Google account.

The last step is having the report arrive on its own, without you having to remember to send it.

Schedule the send from Data Studio:

1. Open your report in Data Studio.
2. Click the email icon in the top bar (or go to File > Schedule email delivery).
3. Enter the recipients’ emails.
4. Choose the frequency (daily, weekly, monthly) and time.
5. Click “Save”. Data Studio will automatically send the PDF report.

For more complex reports with AI included: You can combine Google Sheets, Make.com and Claude so the report includes not just the numbers but also an AI-written summary. Learn how in the tutorial How to automate marketing reports with ChatGPT.

Data Studio’s scheduled delivery sends a snapshot of the dashboard; if you need the report to include AI analysis every week, combining it with Make.com is the most powerful option.

Problem	Fix
Data source won’t connect	Check that the Google Sheet is shared with you and with the account Data Studio uses
Chart shows no data	Verify the “Date” dimension is set correctly and the date filter covers the period with data
Schedule send option doesn’t appear	Make sure the report is saved in your Google Drive account (not in “Recent”)
CSV data doesn’t import correctly	Make sure the first row has headers and dates use the YYYY-MM-DD format
ChatGPT can’t read the file	Confirm you’re using ChatGPT Plus (data analysis is only available on paid plans)