Google’s =AI() function (also written =GEMINI()) lets you generate, summarize, categorize, or fact-check text directly inside a Google Sheets cell — but as of August 2026 it only works on Business Standard, Business Plus, Enterprise Standard, or Enterprise Plus Workspace plans, not Business Starter. Before you build a workflow around it, here’s what it’s actually good for, where it breaks down, and what to use instead when it does.
What the =AI() Function Actually Does
The syntax is AI("prompt", [optional range]). You type it into a cell, select the cell, and click Generate and insert — it doesn’t calculate automatically like a normal formula. Per Google’s own documentation (verified August 3, 2026), it can:
- Generate text tailored to data in your sheet (slogans, emails, keyword lists)
- Summarize a cell or range into key points
- Categorize rows into groups you define, including sentiment analysis
- Pull real-time information from Google Search into a cell
Straight from Google’s examples:
=AI("Generate slogan for event in 10 words or less", A2)
=AI("Classify the customer enquiry as a compliment, exchange request or return request.", C2)
=AI("Perform sentiment analysis on the emails sent by the customers to the barbershop.", C2)
=AI("What is the current capital of Kazakhstan?", A2)These four are Google’s own documented examples, not ones we invented — copy them as templates and swap in your own prompt and range.
Do You Actually Have Access? (Plan Requirements)
This is the part most guides skip, and it’s the first thing to check before you spend time on this function. Google’s official Gemini-in-Workspace plan comparison table lists the AI function in Sheets under exactly these tiers — no others:
| Plan | =AI() function available? |
|---|---|
| Business Starter | No |
| Business Standard | Yes |
| Business Plus | Yes |
| Enterprise Starter | No |
| Enterprise Standard | Yes |
| Enterprise Plus | Yes |
As of August 2026, Business Standard runs about $14/user/month on an annual commitment (~$16.80 month-to-month) and Business Plus about $22/user/month annual (~$26.40 month-to-month) — Business Starter, at roughly $7/user/month, does not include it at all, regardless of what Gemini features it does include elsewhere. If you’re on a personal Google Account without Workspace, Google’s documentation ties the closest equivalent — the “Fill columns with Gemini” feature — to individual Google AI Pro ($19.99/month) and Google AI Ultra (restructured at I/O 2026 into roughly $99.99 and $199.99 monthly tiers) plans. Pricing changes; verify current numbers on Google’s own pricing pages before budgeting.
If your admin enabled Gemini for your organization but you still don’t see the function, check whether your plan is Starter — that’s the single most common reason this fails silently.
When =AI() Is the Right Tool
Use it when the job is small, contained to data already in the sheet, and doesn’t need to repeat automatically:
- One-off text generation tied to a row’s data — writing a slogan, a short reply, or a keyword list from that row’s inputs.
- Categorizing or scoring existing rows — spam/not spam, compliment/complaint/return request, positive/negative/neutral sentiment.
- A quick fact lookup you’ll manually verify — population, a date, a capital city — where speed matters more than airtight sourcing.
- You don’t want to touch Apps Script or an API key — it’s a formula, not code; anyone who can type a formula can use it.
When to Skip It (and What to Use Instead)
=AI() breaks down the moment you need automation, nesting, or scale. Here’s the comparison:
| Situation | =AI() / =GEMINI() | Better option |
|---|---|---|
| Needs to run automatically (on edit, on a schedule) | No — manual “Generate” click only | Apps Script triggers |
| Needs to nest inside IF, VLOOKUP, or ARRAYFORMULA | No — Google’s docs explicitly list embedded AI functions as unsupported | Generate the AI output in a helper cell first, then reference that cell |
| Needs to see your whole workbook, not just one range | No — only reads the range you pass in | Gemini’s “Analyze data” side panel |
| Needs a static formula, not a live AI call | Possible but re-runs and can change on refresh | Draft the formula with ChatGPT, paste the plain formula |
| You’re on Business Starter or a free personal account | Not available at all | Upgrade, or handle it outside Sheets with a chat AI tool |
| Need custom logic + AI combined into one automated pipeline | No — it’s a manual cell formula, not a script | Apps Script + an AI API (same trigger-based approach as above, with custom logic added) |
The Limits That Catch People Off Guard
Even on an eligible plan, five documented limits explain most of the “why isn’t this working” reports in Google’s own support community:
| Limit | What happens | Workaround |
|---|---|---|
| 350-cell batch cap | Select more AI-formula cells than that and only the first 350 generate | Generate in batches; select the remaining cells once the first batch finishes |
| Short- and long-term generation limits | “Generate” temporarily stops working; hitting the long-term cap locks you out for about 24 hours | Spread heavy use across the day; wait out a lockout rather than retrying repeatedly |
| No undo/redo | Ctrl+Z doesn’t revert an AI-generated value | Use “Regenerate” instead, or note the prior value before generating |
| No embedded functions | =IF(AI("..."),"x","y") fails outright |
Put the AI call in its own cell, reference that cell from your logic formula |
| No third-party cloud storage | Function won’t generate if you’re accessing Sheets through Box, Dropbox, or Egnyte | Open the file natively in Google Drive |
Fixing “AI Function Not Available” and Other Errors
This exact error is one of the most repeated threads in the Google Docs Editors Community. According to Google’s documentation, it means one of the following:
- Wrong plan. You’re on Business/Enterprise Starter, or a personal account without an eligible Google AI plan — see the table above.
- Admin has it turned off. Even on an eligible plan, a Workspace admin can restrict Gemini features org-wide.
- Language setting. The function’s availability depends on your account’s language setting; switching to a supported language (the feature is documented as English-first) can resolve it.
- Third-party storage. As above — Box/Dropbox/Egnyte-mounted Sheets don’t support it.
- You tried to embed it. Nesting inside another formula returns an error, not a result — this isn’t a bug, it’s a documented limitation.
FAQ
Is the Google Sheets AI function free?
No. As of August 2026 it requires Business Standard, Business Plus, Enterprise Standard, or Enterprise Plus — Business Starter and free personal Google accounts don’t include it.
What’s the difference between =AI() and =GEMINI()?
None functionally — Google documents them as two names for the identical function. Use whichever you remember.
Can I use =AI() inside ARRAYFORMULA or IF?
No. Google’s documentation explicitly lists embedded AI functions as unsupported; generate the AI output in its own cell first, then reference that cell.
What We Verified, and What We Didn’t
Verified today (August 3, 2026) directly against Google’s own Docs Editors Help pages: the function syntax, the four example prompts reproduced above, the full limitations list, and the plan-eligibility table (Business Starter excluded; Standard/Plus and Enterprise Standard/Plus included). Pricing figures came from current third-party pricing trackers cross-checked against Google’s Google One AI Ultra support page for tier structure — Google doesn’t publish per-user Workspace pricing on the same page as the feature docs, so treat exact dollar figures as approximate and confirm on Google’s pricing page before budgeting. We don’t have a Workspace account with Gemini enabled, so we could not run these formulas ourselves or screenshot live output — every prompt example here is reproduced from Google’s own documentation, not independently executed.