How to Use the =AI() Function in Google Sheets

What the =AI() Function Does

Google shipped the =AI() function in Google Sheets as part of its March 2026 Gemini workspace rollout. The function places a large language model inside a spreadsheet cell. You write a prompt in plain English, point it at your data, and the cell returns AI-generated output. No Apps Script. No add-ons. No Python.

On the SpreadsheetBench benchmark, Gemini in Sheets scored 70.48% for autonomous spreadsheet manipulation, a result Google says "nears human expert ability." For practical purposes, this means the function handles categorization, summarization, extraction, and sentiment analysis reliably enough to use on real business data.

Who Gets Access

The =AI() function is available in beta to users on these Google Workspace plans: Business Standard, Business Plus, Enterprise Standard, Enterprise Plus, and the consumer AI Ultra plan. If you are on a free Google account or Workspace Starter, you will not see the function. Your Workspace admin must also enable Gemini features under Admin Console > Apps > Google Workspace > Settings for Sheets.

To confirm access, open any Google Sheet, click a cell, and type =AI(. If the function autocompletes, you have access.

Basic Syntax

The function signature is:

=AI(prompt, [reference])

The first argument is a text string containing your instruction. The second argument is optional and accepts a cell or range that provides context. Both arguments can also reference other cells containing text.

A simple example that classifies a support ticket:

=AI("Classify this support ticket as Bug, Feature Request, or Question", A2)

If cell A2 contains "The export button does not work on Safari," the function returns "Bug."

Five Practical Formulas

Here are five formulas that cover the most common use cases for operations teams and analysts.

1. Categorize free-text responses

=AI("Categorize this customer feedback into one of: Positive, Negative, Neutral", B2)

Drag this down a column of survey responses to tag sentiment across hundreds of rows in seconds. In internal testing by Google, the Fill with Gemini feature completed table population tasks up to 9x faster than manual entry.

2. Extract structured data from messy text

=AI("Extract the company name, dollar amount, and date from this text. Return as: Company | Amount | Date", C2)

This works on invoice descriptions, email snippets, and CRM notes. The output lands in a single cell. To split it across columns, combine with SPLIT():

=SPLIT(AI("Extract company, amount, date separated by |", C2), "|")

3. Summarize long text into one sentence

=AI("Summarize this in one sentence under 20 words", D2)

Useful for condensing meeting notes, product reviews, or incident reports into a scannable column.

4. Generate formula suggestions

=AI("Write a Google Sheets formula that calculates the percentage change between E2 and E3")

The function returns a formula string. You then paste it into a new cell. This replaces the loop of switching to ChatGPT, copying a formula, and pasting it back.

5. Translate content

=AI("Translate this to Spanish", F2)

Unlike GOOGLETRANSLATE(), the AI version handles idiomatic expressions and context-dependent phrasing. It also works with longer text blocks that GOOGLETRANSLATE() truncates.

Using Fill with Gemini for Bulk Operations

For column-wide operations, Fill with Gemini is faster than dragging formulas. Select the column header of an empty column next to your data. Click the Gemini sparkle icon in the toolbar. Describe what you want: "Classify each row in column B as Positive, Negative, or Neutral." Gemini fills the entire column in one pass.

This is especially useful when you have more than 500 rows. Dragging =AI() formulas row by row triggers individual API calls per cell, which slows the sheet. Fill with Gemini batches the operation.

Conversational Analysis with the Gemini Sidebar

Click the Gemini icon in the right sidebar (or use Help > Gemini). You can ask questions about your data in natural language: "What is the average order value by region?" or "Show me a chart of monthly revenue trends."

The sidebar generates charts, pivot summaries, and insights without formulas. It also suggests follow-up analyses. For quick exploratory work on a new dataset, this replaces 10 minutes of VLOOKUP and pivot table setup with a single question.

Limits and Gotchas

Rate limits. Each =AI() call consumes Gemini API quota. Google has not published exact per-user limits, but heavy users report throttling after roughly 200 to 300 calls in a short burst. Batch with Fill with Gemini when possible.

Non-deterministic output. The same prompt on the same data can return slightly different wording across recalculations. If you need stable output, copy-paste values after the initial run (Ctrl+Shift+V) to freeze results.

No image or file input. The function processes text only. You cannot point it at an image in Google Drive or a PDF attachment.

Cell length limits. Output is capped at approximately 8,000 characters per cell. Summarization prompts work well within this limit, but generating long-form content in a single cell will get truncated.

Recalculation cost. Every sheet recalculation (adding rows, editing cells, reopening the file) re-triggers =AI() calls. This burns through quota and slows large sheets. Convert AI columns to static values once you are satisfied with the output.

When =AI() Falls Short

The function works well for classification, extraction, and short-form generation. It struggles with multi-step analysis that requires reasoning across many rows simultaneously. If you need to correlate trends across 10,000 rows, run regression models, or build interactive dashboards from raw uploads, a dedicated data analysis platform will handle the job better. VSLZ, for example, processes entire datasets from a single prompt and returns statistical analysis with charts, skipping the cell-by-cell approach entirely.

Quick Reference

Open a Google Sheet. Type =AI("your prompt", A2) in any cell. If autocomplete does not appear, confirm your Workspace plan supports Gemini and that your admin has enabled it. Start with classification or extraction tasks on a small range. Use Fill with Gemini for bulk operations. Convert AI output to static values before sharing the sheet. Keep prompts specific and concise for the most reliable results.