Gemini in Google Sheets (2026): What It Does, Which Plan Gets It, and the Limits Google Doesn't Agree On

The short answer

Gemini in Google Sheets does two jobs. The side panel builds tables, formulas, charts and analysis when you ask it to. The =AI() function fills a column for you: it categorizes, summarizes, scores sentiment or looks things up on Google Search, row by row. As of November 7, 2026 it isn't on Business Starter. It starts at Business Standard. And Google's own pages disagree on how many cells it fills at once: 350 or 3,000.

Every AI pitch for spreadsheets shows the same demo: a messy column becomes a clean one in two seconds. What the demo leaves out is which plan you need, how many rows it handles before it stops, and what it does when your data changes next week. Those three things decide whether this saves your team an afternoon or creates a column of stale guesses nobody remembers to refresh.

What Gemini actually does in Sheets

From Google's Help Center, there are two ways in.

• The side panel (the "Ask Gemini" spark button, top right). It creates tables, writes formulas, fixes a formula that's showing an error, builds charts, and answers questions about your data. It can work across several tabs in one prompt. One catch: if you don't insert what it generates, you lose the conversation history.
• The AI function, typed in a cell as =AI("prompt", A2) or =Gemini(). This is the one that saves real time. Point it at a row and it writes a summary, sorts a support ticket into a category, labels a review positive or negative, or pulls a fact from Google Search. Since the October 28 update, when it uses the web it shows the source for each cell.

There's also "Fill with Gemini": fill one cell in a column by hand, drag, and it completes the rest from the pattern. If you've ever had someone spend a Friday tagging 800 leads by industry, this is that job.

Which plan gets it

This is the line most small teams miss. Google's pricing page marks Gemini in Sheets as not included on Business Starter. Starter gets Gemini in Gmail and the Gemini app, and that's it. Sheets, Docs, Slides, Drive and Meet start at Business Standard.

Google's October 28 update lists the AI function on:

• Business Standard and Business Plus
• Enterprise Standard and Enterprise Plus
• Google AI Pro and Ultra (personal plans), and Google AI Pro for Education
• The AI Expanded Access add-on

The upgrade math for a 5-person team on an annual plan: Starter is $7 a user and Standard is $14. That's $35 a month more, or $420 a year, to put Gemini in Sheets, Docs and Meet for everyone. Full plan prices are on Google Workspace pricing. Whether the $420 is worth it depends on whether anyone on the team actually spends hours in spreadsheets. If two people do, compare it with what those two would pay for a separate AI seat. Is Gemini worth it walks through that comparison.

The cell limit Google doesn't agree with itself on

Here's the number nobody else prints side by side. Read on November 7, 2026:

The likely explanation is that the Help Center page hasn't caught up with the update, or that the two numbers apply to different entry points (typing =AI() in each cell vs. one Fill request). Google doesn't say. Here's what the difference means on a real job: categorizing 2,000 customer reviews.

• At 350 a run: 6 runs (five of 350, one of 250). That's six rounds of select, generate, wait.
• At 3,000 a request: one request, with room to spare.

Either way, it beats a person tagging them by hand. But if you're planning a 10,000-row cleanup, the difference is 29 runs or 4, so test it on your own account first. Select 500 cells with the function in them, click Generate, and count how many fill.

Four things that break real spreadsheets

These are all on Google's own limitations list, and each one has caught somebody's month-end report:

1. The output doesn't update itself. Generate and Insert writes the result into the cell, and version history credits the edit to you. If the source row changes next week, the AI's answer doesn't. If you build the prompt by joining cells together ("..."&B2&"..."), Google says you won't even get a refresh prompt. Add a "last generated" date column so stale answers are easy to spot.
2. You can't nest it. =IF(AI(...)) doesn't work. Put the AI result in its own column, then run your IF on that column.
3. It only sees what you point it at. The function can't read the rest of the sheet or anything else in Drive. No range, worse answers.
4. There's a daily ceiling. Google says the function has short-term and long-term generation limits, and when you hit the long-term one, you wait 24 hours. It publishes no number. Don't plan a deadline-day cleanup around it.

And one more: if your company opens Sheets files through Box, Dropbox or Egnyte, the AI function doesn't run there at all.

Gemini in Sheets vs ChatGPT and Claude

All three now work in spreadsheets. ChatGPT for Excel also installs in Google Sheets and runs on ChatGPT credits. Claude connects to your Google files through Claude for Google Workspace. The honest tiebreaker is which subscription your team already pays for. If you're on Workspace Business Standard, Gemini is already in your sheets, at no extra cost. Start there before you buy anything.

The part that actually takes a decision is the data. Customer lists, payroll and client numbers go through whichever AI your team picks, so pick on purpose: which account, which plan, which sheets are off limits. Setting that up is a small piece of an AI implementation, and it's the piece that keeps a quick win from turning into a cleanup.

Today's micro-action

Open the sheet your team updates by hand every week. Add a column, type =AI("Categorize this row as one of: lead, customer, vendor, other", A2:D2), fill it down 20 rows, and click Generate and Insert. If 18 of the 20 are right, you just found your first hour back. If you get "AI function not available," you're probably on Starter.

Sources

Google Docs Editors Help, "Use the AI function in Google Sheets," support.google.com/docs/answer/15877199 (read November 7, 2026); Google Workspace Updates, "Fill with Gemini now provides cell-level citations for web sources and supports larger requests," October 28, 2026 (read November 7, 2026); Google Docs Editors Help, "Collaborate with Gemini in Google Sheets," support.google.com/docs/answer/14356410 (read November 7, 2026); Google Workspace pricing, workspace.google.com/pricing (read November 7, 2026). The 2,000-row and 10,000-row run counts and the 5-person upgrade figure are our arithmetic.