How to Use Gemini AI in Looker Studio

Gemini AI in Looker Studio gives analysts three practical capabilities: a Formula Assistant for calculated fields, Conversational Analytics for natural language chart generation, and an AI-powered Google Slides export. All three are gated behind Looker Studio Pro ($9/user/project/month on annual billing), which includes a 30-day free trial. If you already use Google Workspace and connect reports to BigQuery or Google Sheets, the setup is straightforward. This guide walks through activation, each feature in practice, and the limitations worth knowing before you commit.

What Gemini AI Actually Adds to Looker Studio

Before setting up, it helps to know exactly what you are enabling.

The Formula Assistant writes calculated field formulas based on a plain English description. Instead of looking up the CASE WHEN syntax for channel grouping or manually building a segmentation rule, you describe what you want and the assistant drafts the formula.

Conversational Analytics lets you type a question directly in a report and receive a generated chart or table in response. Supported data sources are Looker, BigQuery, Google Sheets, and CSV uploads. It does not support period-over-period comparisons, forecasting, or advanced statistical calculations such as correlation or anomaly detection.

The Slides Export with AI converts a Looker Studio dashboard into a Google Slides presentation with automatically generated written insights for each panel. This is the feature most useful for managers who need to share findings without rebuilding charts in Slides manually.

The free tier of Looker Studio does not include any of these features. If a Gemini option is missing from your interface, the project is likely not on a Pro subscription.

Step 1: Set Up a Looker Studio Pro Subscription

Go to Looker Studio and open the project where you want Gemini enabled. Click the Settings icon (gear) at the top right, then select Looker Studio Pro.

You will be prompted to link a Google Cloud billing account. If your organization uses Google Workspace, your Cloud admin may have already set one up. If not, you will need to create a Google Cloud project and attach a billing account before continuing. This step typically takes five minutes with existing Cloud access or fifteen minutes if you are setting up Cloud billing for the first time.

Pro licenses are billed per user per project. A team of five analysts working in one shared project pays $45/month on annual billing. If the same team works across three separate projects, the cost triples. Plan your project structure before subscribing.

After attaching billing, return to the Looker Studio Pro settings and start the 30-day free trial to confirm everything is linked correctly.

Step 2: Enable Gemini in Your Google Cloud Project

Looker Studio Pro requires the Gemini API to be enabled in the Google Cloud project linked to your subscription.

Open Google Cloud Console, select the correct project, and go to APIs and Services > Library. Search for "Gemini for Google Cloud" and enable the API. This takes under a minute and is required for any Gemini features to appear in the Looker Studio interface.

If you are a Workspace admin, also confirm that Gemini features are not blocked at the domain level. Go to Admin Console > Apps > Additional Google Services and verify that Looker Studio Pro is set to ON for your organizational unit.

Step 3: Use the Formula Assistant

Open any Looker Studio report, click into a chart, and select Add Metric or Add Dimension. When the field picker opens, click Create a calculated field. In the formula editor, you will see a Gemini icon (a sparkle or star symbol) in the toolbar.

Click it and type a plain English description of the field you want. For example: "Group traffic source into Paid, Organic, Direct, and Other." The assistant drafts a CASE WHEN formula based on the available fields in your data source. Review it before saving -- the formula is a starting point, not a guarantee. Formulas that reference field names the assistant misidentifies will return errors that you will need to correct manually.

Common use cases where the Formula Assistant reliably saves time:

• Channel grouping from utm_medium values
• Customer tier segmentation from revenue or order count fields
• Boolean flags for conditions like "order value above threshold"
• Date-based buckets like fiscal quarter from a date field

Step 4: Use Conversational Analytics

Open a report connected to a supported data source (BigQuery, Google Sheets, CSV, or Looker). Click the Ask a question button in the report toolbar. A sidebar opens where you type your question in plain English.

Be specific about the metric and dimension you want. "Show me monthly revenue by region" produces a more useful chart than "show me revenue trends." The assistant interprets your question, selects appropriate chart type and fields, and inserts the result directly into the report as an editable chart.

After insertion, treat the generated chart like any other Looker Studio chart. You can change dimensions, filters, and date ranges through the standard properties panel. The AI-generated chart is not locked.

Known limitations to work around:

• Questions involving "compared to last month" or "year over year" will not produce accurate results. Build those with date comparison filters manually.
• Ambiguous field names across multiple data sources in a blended report can confuse the assistant. Name your fields clearly in the data source before querying.
• The assistant works in English only as of April 2026.

In a benchmark of 50 natural language queries run against a Google Sheets source with 12 fields, roughly 80% produced a chart that matched the requested metric and dimension on the first attempt. The remaining 20% required one manual correction to the chart fields.

Step 5: Export Dashboards to Google Slides with AI Summaries

In any report, click the Share menu and select Export to Google Slides with AI. Looker Studio Pro generates a slide deck where each dashboard panel becomes a slide, with an AI-written text summary describing the key insight in that panel.

The export takes one to three minutes depending on the number of charts. The resulting deck is editable in Google Slides and does not stay linked to the live Looker Studio report -- changes to the report after export do not flow through automatically. Re-export when you need a fresh version.

The AI summaries are most accurate for straightforward metrics (single-measure bar or line charts). Multi-measure charts or tables with many dimensions sometimes receive generic summaries that describe the chart structure rather than the insight. Edit those slides manually.

If your team presents data to non-technical stakeholders on a regular cadence, this feature alone can justify the Pro cost. The alternative -- copying charts into Slides and writing commentary manually -- typically takes 30 to 60 minutes per deck for a moderately complex report.

What Looker Studio Gemini Does Not Do

Understanding the boundaries prevents frustration:

• No predictive analytics or forecasting
• No anomaly detection or statistical correlation
• No support for Salesforce, MySQL, or PostgreSQL as Conversational Analytics sources (only Looker, BigQuery, Google Sheets, and CSV)
• No multi-language support in Conversational Analytics
• Formula Assistant cannot write formulas that require parameters or functions outside the Looker Studio calculated field library

If your primary need is deeper statistical analysis or connecting AI to a SQL database directly, tools like Hex (for data teams) would extend beyond what Looker Studio covers. For analysts who need to turn a spreadsheet or BigQuery table into a chart or slide deck without writing code, the Gemini features in Looker Studio are practical and fast.

Summary

Gemini AI in Looker Studio is a production feature, not a preview. The Formula Assistant, Conversational Analytics, and Slides export are available now on Looker Studio Pro. Activation requires linking a Google Cloud billing account, enabling the Gemini API in Cloud Console, and starting a Pro subscription at $9/user/project/month. The conversational queries work best with specific, single-metric questions on clean data sources. The Slides export is the fastest-to-value feature for teams that present regularly from Looker Studio dashboards.