How to Enable Gemini in Looker Studio

Unlocking the power of AI inside Looker Studio can feel like getting a major promotion, suddenly turning tedious report-building tasks into quick, conversational requests. The integration of Gemini AI transforms how you create visualizations and distill insights from your data. This guide walks you through the exact steps to enable and use Gemini within your Looker Studio reports, so you can stop manually wrangling charts and start asking your data questions in plain English.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

What is Gemini in Looker Studio?

In short, Gemini is Google's powerful AI model, and its integration into Looker Studio (formerly Google Data Studio) fundamentally changes the report creation process. Instead of dragging and dropping fields, configuring chart types, and writing complex CASE statements by hand, you can now use natural language to tell Looker Studio what you want to see. It’s like having a data analyst built directly into the reporting interface.

This integration, often part of the broader "Duet AI for Google Cloud" offering, aims to achieve three key things:

• Accelerate Report Building: Generate entire report pages or individual charts just by describing them. This dramatically cuts down the time spent on the manual, repetitive parts of dashboard creation.
• Democratize Data Analysis: You no longer need to be a data expert to build powerful reports. If you can describe what you need (e.g., "show me sales by region"), Gemini can translate that into the correct charts and tables, making data more accessible to marketers, sales managers, and business owners.
• Automate Complex Calculations: Crafting calculated fields with complex logic used to involve searching for the correct syntax and a lot of trial and error. Now, you can describe the logic in plain English, and Gemini will generate the formula for you.

Essentially, Gemini acts as your intelligent report-building assistant, handling the technical "how" so you can focus on the analytical "what."

Before You Start: Essential Prerequisites

Before diving in, there are a few prerequisites to get out of the way. Because Gemini in Looker Studio is tied into the Google Cloud ecosystem, some settings need to be configured at the project level, not just within the Looker Studio interface. Make sure you have the following in place:

• A Google Cloud Project: Your work needs to be associated with a Google Cloud project. If you don't have one, you'll need to create one.
• Billing Enabled on Your Cloud Project: While Looker Studio itself is free, the advanced AI features powered by Duet AI often require a project with billing enabled. You may not be charged immediately (promotional credits or free tiers often apply), but it's a necessary step for activation.
• Admin Permissions: To enable the necessary APIs, you'll need adequate permissions on the Google Cloud project, such as Owner or Editor. If you work in a larger organization, you may need to ask your cloud administrator for help with these steps.
• An Existing Looker Studio Report: You’ll need a report with a connected data source (like Google Analytics 4, Google Sheets, or BigQuery) to start using the AI features.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

How to Enable Gemini in Looker Studio: A Step-by-Step Guide

Enabling Gemini involves activating the right API in your Google Cloud Project and ensuring you have the correct permissions. Let's walk through it step by step.

Step 1: Navigate to the Google Cloud Console

First, head over to the Google Cloud Console at https://console.cloud.google.com/. If your organization has multiple projects, make sure you select the correct project from the dropdown menu at the top of the page. This should be the project you want to associate with your Looker Studio analytics.

Step 2: Enable the Cloud AI Companion API

The functionality for Gemini and other Duet AI features is controlled by the "Cloud AI Companion API." You need to enable it for your project.

1. In the Cloud Console, use the search bar at the top and type "APIs & Services." Select it from the results.
2. On the APIs & Services Dashboard, click on "+ ENABLE APIS AND SERVICES" near the top of the screen. This will take you to the API Library.
3. In the API Library search bar, type "Cloud AI Companion API" and press Enter.
4. Click on the result and then click the blue "Enable" button. If it's already enabled, you're good to go.

Step 3: Verify Your IAM Permissions

To use the AI features, your Google account needs a specific Identity and Access Management (IAM) role assigned to it within the project. The key permission is the "Cloud AI Companion User" role.

1. In the Cloud Console, use the top search bar to find and navigate to "IAM & Admin."
2. On the IAM page, you’ll see a list of "Principals" (users, groups, and service accounts) and their roles.
3. Find your own email address in the list and check its roles. You'll need either a broad role like Owner or Editor, or the specific "Cloud AI Companion User" role.
4. If you don't have it, click "+ GRANT ACCESS" at the top. In the "New principals" field, enter your email address. In the "Assign roles" dropdown, search for "Cloud AI Companion User" and select it. Click "Save."

Once the API is enabled and your permissions are set, the AI features should become available in Looker Studio. Note that it can sometimes take a few minutes for the changes to propagate.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

Step 4: Go to Looker Studio and Find Gemini

Now for the fun part. Open a new or existing report in Looker Studio. Once loaded, you should start seeing the new Gemini features integrated into the user interface. For example, when you create a new blank report, you might see a new option that lets you use a "prompt" to automatically generate a report.

When you have a chart selected, look for a small sparkle or star icon, which usually indicates an AI-powered helper. You can also look for a new "Gemini in Looker Studio" panel on the right side of your screen where you can type requests.

Putting Gemini to Work: Practical Use Cases

Once enabled, you can use Gemini to transform your workflow. Here are a few practical ways to leverage its capabilities.

Generating a Report from Scratch

Imagine you have a new Google Sheet with sales data and need a quick dashboard. Instead of building it manually, you can just ask for it.

Example Prompt: "Using the 'Q2 Sales Data' source, create a report with three charts: a bar chart showing revenue by country, a time series line chart showing weekly sales for the last quarter, and a table of the top 5 performing products by quantity sold."

Gemini will parse this request, identify the dimensions and metrics (Country, Revenue, Date, Product Name, Quantity), choose the appropriate chart types, and arrange them on the canvas for you. From there, you can fine-tune or ask for modifications.

Creating Complex Calculated Fields

This is an incredibly powerful time saver. Forget memorizing syntax for CASE statements or REGEX functions. Just describe the logic you need.

Example Prompt: "Create a new field named 'Audience Segment'. If sessions are from Organic Search, name it 'Organic Visitors'. If they are from Paid Search, name it 'PPC Visitors'. All others should be 'Other Traffic'."

Gemini will instantly generate the corresponding CASE statement formula which you can add as a new dimension to your data source:

CASE
  WHEN
    Default Channel Grouping = "Organic Search" THEN "Organic Visitors"
  WHEN
    Default Channel Grouping = "Paid Search" THEN "PPC Visitors"
  ELSE
    "Other Traffic"
END

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Enhancing and Editing Existing Charts

AI assistance doesn't stop after the initial creation. You can use it to iteratively improve your visualizations.

After creating a chart showing user sessions by device, you could follow up with more specific requests:

• "Change this to a doughnut chart."
• "Add a filter to only show users from the United States."
• "Sort this table by conversion rate in descending order."

Tips for Getting the Best Results

AI is a powerful tool, but the quality of its output often depends on the quality of your input. Here are a few tips to get the most accurate and useful results:

• Be Specific: Vague prompts lead to vague outcomes. Instead of "Show me my traffic," try "Create a line chart of daily website sessions from GA4 over the last 90 days." The more specific you are about metrics, dimensions, chart types, and time frames, the better the result.
• Use Clean Column Names: Gemini works best when your data source has clear and understandable field names. A column named "transaction_revenue" is much easier for the AI to interpret than something cryptic like "col_1_rev_usd."
• Start Simple, Then Iterate: Don't try to build an entire, complex dashboard in a single prompt. Start by asking for a key chart. Once that's done, ask for another to be added, or ask to modify the existing one. This iterative process works just like brainstorming with a human colleague.
• Review and Verify: Always treat the AI's output as a first draft. It’s an incredibly intelligent co-pilot, but not infallible. Double-check the formulas it generates and the chart configurations to ensure they accurately reflect the data and your intent.

Final Thoughts

Enabling Gemini in Looker Studio is more than just turning on a new feature, it’s about embracing a faster, more intuitive way to work with data. By translating natural language into reports and formulas, it empowers everyone on a team to build the dashboards they need without a steep technical learning curve.

We believe this conversational approach is the future of data analytics. At https://www.graphed.com/register, we've built our entire platform around this idea, allowing you to connect all your disparate marketing and sales data sources - from Google Analytics and Shopify to Facebook Ads and HubSpot - and get answers instantly using simple questions. It's about turning hours of manual CSV downloads and spreadsheet wrangling into a 30-second conversation, so you can focus on insights, not setups.