Ai for Sheets.

Published May 23, 2026 — AI for Sheets

How to Use Gemini AI in Google Sheets (Free and Paid Options)

Q: Can I use Gemini in Google Sheets for free?

Yes. You can use the Gemini API with Apps Script and a free API key from AI Studio. The built-in Gemini side panel in Sheets is part of paid plans.

Q: Why don't I see the Gemini icon in Sheets?

The Gemini side panel depends on eligible paid plans, such as Workspace Business Standard or Google One AI Premium, and is generally not available on free Gmail accounts.

Q: Which method is better for large datasets: side panel or API?

For large row-by-row processing, the API approach is better. The side panel is better for one-off prompts and quick interactive help.

Google's Gemini AI works inside Google Sheets in two completely different ways. One is built into the Sheets interface and requires a paid plan. The other uses Gemini's free API and works on any Google account, including personal Gmail.

This guide explains both, who can use each, and which one fits which job.

The Two Ways Gemini Works in Sheets

People often confuse these because both are called "Gemini in Sheets":

The Gemini side panel — a chat-style assistant built into the Sheets interface. Opens from the starburst icon in the top-right corner. Requires a paid plan.
The Gemini API + a custom formula — calls Gemini from inside a cell, the same way you'd write =SUM(). Uses a free API key from Google AI Studio. Works on any Google account.

The side panel is faster to set up if you have access. The API approach is the only free path and is much better for processing large columns of data.

Who Gets the Built-In Gemini Side Panel

The side panel is part of Google Workspace's AI features, not the free Gmail experience.

You have access if you're on:

Google Workspace Business Standard or higher (~$14/user/month, annual billing) — full Gemini across Docs, Sheets, Slides, Gmail, Meet
Google One AI Premium (~$19.99/month, personal) — Gemini in Workspace apps for your personal Google account
Workspace Business Starter — limited Gemini features (such as basic Gemini app and "Help me write" experiences), but no Gemini side panel in Sheets

If you're on free personal Gmail, you won't see the side panel. The starburst icon simply won't be there.

Method 1: Using the Gemini Side Panel (Paid)

If you have a qualifying plan, here's how to use it.

How to open it

Open any Google Sheet
Click the Gemini icon (starburst) in the top-right corner of the toolbar
A side panel opens — type a request in natural language

There's also a "Help me organize" button (small table icon, top-left area) that generates structured tables from prompts, and you can invoke Gemini in any cell by typing = and pressing Ctrl+Alt+G.

What it's good at

"Summarize this sheet in three bullet points"
"Add a column that categorizes column B into Hot, Warm, or Cold leads"
"Write a formula that sums column D only where column C says 'Paid'"
"Build a project tracker template with status, owner, due date, and progress"
"Find rows where the email column looks invalid"

The side panel reads your active sheet and responds with either text or "Insert" buttons that drop generated content directly into your sheet.

Limitations

Works on the active sheet only, not across multiple tabs
Slows down significantly above ~5,000 rows
Designed for one-off questions, not bulk row-by-row processing
Data privacy: Workspace policy states your data isn't used to train Google's public models

Method 2: Using the Gemini API (Free)

For repetitive AI tasks — classifying 500 reviews, translating product names, extracting keywords from descriptions — the side panel is too slow. You want AI inside a formula, running row by row.

This works on any Google account, free or paid, and is the only free way to get AI into Sheets.

Step 1: Get a free Gemini API key

Go to aistudio.google.com
Sign in with your Google account (personal Gmail is fine)
Click "Get API key" in the left sidebar
Click "Create API key" and copy the value

No credit card required. Current free tier limits (mid-2026):

Model	Requests/min	Requests/day
Gemini 2.5 Flash (Preview)	10	500
Gemini 2.5 Pro (Experimental)	5	25
Gemini 2.0 Flash-Lite	30	1,500
Gemini 1.5 Flash	15	1,500

Most of these free-tier models support up to a 1 million token context window. Trade-off: on the free tier, Google may use your prompts to improve their models. For sensitive data, use the paid tier where this is disabled.

Step 2: Add the function to your sheet

Open your sheet, then go to Extensions → Apps Script. Paste a wrapper function that calls the Gemini API, save, and refresh your sheet. After setup, you have a custom formula:

=GEMINI("Translate to French: " & A2)
=GEMINI("Classify sentiment as Positive, Negative, or Neutral: " & B2)
=GEMINI("Extract the company name from this email signature: " & C2)

Drag down. Gemini processes each row automatically.

What this unlocks

Sentiment analysis on customer feedback
Auto-tagging support tickets
Generating product descriptions from feature lists
Extracting structured data from messy text
Translating columns between languages
Summarizing long-form text into one sentence

When to Use Which Method

Task	Best Method
One-off question about your data	Side panel (if you have it)
Building a new sheet or template	Side panel
You don't have a paid plan	API approach
Categorizing or labeling 100+ rows	API approach
Translating a whole column	API approach
Sensitive data	Paid tier of either

Rule of thumb: if you'd do it once, ask the side panel. If you'd do it for every row, use the API.

Real-World Examples

Categorizing leads

200 lead descriptions in column B, each tagged Hot/Warm/Cold based on language used.

=GEMINI("Read this lead description and classify as Hot, Warm, or Cold based on buying intent. Reply with one word only: " & B2)

Cleaning scraped data

Column A: john's PIZZERIA *new*, BLUE BOTTLE coffee (sf), Sam's Diner — closed sundays.

=GEMINI("Return just the clean business name in title case, no extra characters: " & A2)

Generating descriptions

Product spec sheet with name, features, price. One-line description in column D:

=GEMINI("Write a friendly one-sentence product description using these details: " & A2 & ", " & B2 & ", priced at " & C2)

Common Issues and Fixes

"Authorization required" warning on first run. Standard Google security check for any custom script. Click through; the script only talks to Gemini and your sheet.

Formula returns blank or error. Check the API key is saved correctly and you haven't hit the daily limit. Limits reset at midnight Pacific.

Slow performance on large sheets. Gemini formulas re-run every time the sheet recalculates. Once results are stable, copy the column and paste as values (Ctrl+Shift+V → Values only) so they don't regenerate.

Frequently Asked Questions

Can I use Gemini in Google Sheets for free?

Yes, through the Gemini API and Apps Script with a free API key from AI Studio. The built-in Gemini side panel in Sheets requires a paid plan.

Why don't I see the Gemini icon in Sheets?

The side panel is tied to paid Google plans such as Workspace Business Standard or Google One AI Premium. Free Gmail accounts usually do not have that icon.

Which method is better for large datasets: side panel or API?

The API approach is better for row-by-row work at scale because formulas can process many rows consistently. The side panel is best for one-off questions and quick drafting.

Download the GPT Apps Script

Paste it into Apps Script, add your OpenAI API key, then use the OpenAI menu in Google Sheets to run Generate Content on the selected cell.

Download Free GPT Script

Send Feedback