Sistava

The AI Formula in Google Sheets: What It Really Does

How-to — — by Mahmoud Zalt

How the =AI() formula in Google Sheets works, the 350 cell cap per run, why the answers are static, and the jobs it is genuinely good at.

People find this function while trying to do something specific: label 600 rows of feedback, pull a company name out of a messy column, or turn short notes into a sentence a customer can read. It is very good at exactly that and misleading if you expect a normal formula.

The mental model that saves you time: it is a text generator that happens to live in a cell, not a calculation. SUM recalculates the moment a number changes. An AI answer sits there until you tell it to run again.

What is the AI formula in Google Sheets?

It is a built in Sheets function that runs Gemini from inside a cell. Google documents the syntax as AI("prompt", [range]), where the prompt is required and describes what you want, and the optional range points at the cells the prompt should use. Google notes that =Gemini() maps to the same function.

Google's documentation lists the supported jobs as text generation, summarising, categorising and finding patterns including sentiment, and says the function can pull real time information from Google Search when the answer needs to be current.

How do you actually use it?

Write the instruction like you would to a new assistant, point it at the cells that hold the raw material, and check the first few results before you fill a column. Google requires an eligible Workspace or Google AI plan, so if the function is not recognised, that is the first thing to check.

Getting a useful column out of the AI function

  1. Confirm the function exists for your account — Google states the AI function requires an eligible Google Workspace or Google AI plan. On a managed domain, admin settings also decide. If typing =AI( gives you nothing, that is the reason, not your syntax.
  2. Write one instruction and test it on one row — Be specific about the output shape. "Label as positive, neutral or negative" gives you three clean values. "Analyse the sentiment" gives you a paragraph you then have to clean up.
  3. Point it at the smallest useful range — Give it the cells that matter, not the whole row. Google notes the function does not have access to your entire spreadsheet or to other files, so the range you pass is genuinely all it sees.
  4. Fill in batches, not all at once — Google documents that only the first 350 selected cells with AI functions will be generated in one operation, and that after a longer term generation limit you wait 24 hours before generating again.
  5. Refresh deliberately — The output is static once inserted. Google's own answer is to use Refresh and Insert to regenerate, so build the habit of refreshing after your source data changes.

That 350 cell figure is the single most useful number to know before you start. A 2,000 row job is not one action, it is six passes with checking in between. Plan the afternoon around that and it goes fine. Discover it halfway through and it feels broken.

What are the real limits?

Google publishes them plainly, which is refreshing. Responses are limited to text. The function cannot see your whole spreadsheet or other files. It cannot be nested inside another function such as IF. And it is unavailable when you open Sheets through a third party cloud storage integration.

LimitWhat Google statesWhat it means for you
Batch sizeOnly the first 350 selected cells with AI functions are generatedLong columns are done in passes, not one click
Longer term capAfter the generation limit, you wait 24 hoursA very large job may span two days
Static outputGenerated content does not recalculate, you use Refresh and InsertAnswers go stale silently when the source row changes
No nestingThe function cannot be nested in other functions such as IFBuild the logic in a helper column instead
Narrow contextIt cannot access your entire spreadsheet or other filesEverything it needs has to be in the range you pass
Text onlyResponses are limited to textIt labels and writes, it does not build charts or run models

One more ceiling comes from Sheets itself rather than the function. A spreadsheet holds up to 10 million cells or 18,278 columns, and users report Sheets refusing any single cell over 50,000 characters. A verbose instruction that produces essays will find that wall.

When is a formula the wrong tool?

The formula is right when the work is one instruction repeated across rows that already exist. It is the wrong tool the moment the job involves getting the rows, deciding what to do with the result, or doing any of this again next week without you.

That is the honest split. Categorising a column is a formula problem. "Every Monday, pull the new responses, label them, flag anything angry and tell me what changed" is a person's job, and it stays a person's job until something else takes it.

Handing over that whole loop, rather than one column of it, is what we built at Sistava. You hire an AI Employee, describe the weekly job in plain English, connect the sheet, and it runs the pass and reports back instead of waiting for you to open the file.

What the AI formula will not do

Worth being blunt about, because a spreadsheet full of confident text can look more finished than it is.

Sample your output before you trust a column. Read twenty rows at random, not the first five, because the first five are usually the tidiest. And if you only need a single piece of text written once rather than a whole column, our free AI tools will do that in a browser tab without touching your spreadsheet at all.

FAQ

Why is =AI() not working in my Google Sheet?

The most common reason is plan or admin settings, since Google states the AI function requires an eligible Google Workspace or Google AI plan. Google also documents that the function is unavailable when you access Sheets through a third party cloud storage integration, which catches people who open files from another storage provider.

How many cells can the AI function fill at once?

Google's documentation says only the first 350 selected cells with AI functions will be generated in one operation. It also describes a longer term generation limit, after which you wait 24 hours before generating again. Large columns are done in batches.

Does the AI formula update when my data changes?

No. Google states that generated content is static once inserted and there is no automatic recalculation if the source data changes. You regenerate manually with Refresh and Insert. This is the biggest difference between the AI function and ordinary Sheets formulas.

Can I put =AI() inside an IF statement?

Google's documentation says the function cannot be nested in other functions, and gives IF as the example. The workaround is a helper column: generate the AI output in its own column, then run your normal logic against that column as if it were any other value.

What is the difference between =AI() and a GPT add-on?

The AI function is built into Sheets by Google and runs Gemini, subject to your Workspace or Google AI plan. Add-ons such as GPT for Sheets are installed from the Google Workspace Marketplace, add their own functions like =GPT(), and bill separately, either through their own account or your own API key.

Is the AI function good enough for customer facing text?

For drafts, yes. For anything a customer reads unedited, sample it properly first. It writes fluently even when it has misread a row, so the failure mode is confident and tidy rather than obviously broken, which is exactly the kind that slips through.

Sources