How to Use AI in Google Sheets: Gemini, the AI Function and Practical Prompts
If you want to use AI in Google Sheets, there are now two main ways: chat with Gemini in the side panel to build, analyze and edit spreadsheets, and use the AI function to run prompts across rows of data, for example to categorize feedback or extract details from text. Google has expanded both through 2026, including new languages and usage limits. This guide covers who has access, how each feature works, practical prompts and how to check results. Availability details come from Google Workspace Updates posts from April and July 2026, checked on 15 October 2026.
Who can use AI in Google Sheets
Google's 7 July 2026 Workspace update lists Fill with Gemini, an entry point to the AI function, for:
- Business Standard and Business Plus
- Enterprise Standard and Enterprise Plus
- Google AI Pro and Google AI Ultra for consumers
- Google AI Pro for Education add-ons and AI Expanded Access add-ons
Google also notes that users must have Workspace smart features enabled. For business accounts, admins can manage Gemini features. If you are on a personal Google account, Google AI Pro is the plan to look at; our Google AI Pro vs ChatGPT Plus comparison covers what it includes.
Usage limits
Google said Workspace customers had promotional higher limits until 15 July 2026, after which per-user usage limits apply, with higher limits for AI Expanded Access license holders. Google did not publish specific numbers in those posts.
Way 1: Gemini in the side panel
Gemini in Sheets works like an assistant for the whole spreadsheet. Google's April 2026 update described building and editing complex spreadsheets with Gemini. Try prompts like:
- "Create a monthly budget template with categories, planned, actual and variance."
- "Summarize the trends in this sales data."
- "Create a chart of revenue by month."
- "Add a column calculating margin percentage."
Be specific about columns, calculations and output.
Way 2: The AI function and Fill with Gemini
The AI function runs a prompt on cell contents row by row. That is ideal for text-heavy data:
- Classify feedback: "Classify this comment as positive, neutral or negative."
- Extract details: "Extract the company name from this email signature."
- Summarize: "Summarize this support ticket in under 15 words."
- Tag leads: "Which industry does this company description fit: retail, services, manufacturing or other?"
Fill with Gemini helps apply this down a column. Test on 10 rows, check the results, then extend.
Use AI in Google Sheets safely and accurately
- Check samples. Review a random set of AI outputs before relying on a whole column.
- Keep instructions consistent. Small prompt changes can change results.
- Freeze results you want to keep by copying and pasting values, since AI outputs may change if recalculated.
- Protect sensitive data. Follow your organization's policy before running AI on personal or confidential information.
- Double-check calculations Gemini adds, and compare totals with known figures.
Practical use cases
- Customer feedback analysis: classify and summarize survey responses.
- Lead lists: tag industry, size or fit from descriptions.
- Content planning: generate title ideas or summaries for a content calendar.
- Expense tracking: categorize transactions from descriptions.
- Reporting: summarize weekly data into a short narrative for your team.
For more ways Gemini helps across Google's apps, see our guide to Gemini in Google Workspace.
Example: classifying survey feedback
Say you have 500 rows of open-ended customer feedback in column B.
- Write the instruction: "Classify this feedback as Product, Delivery, Price, Support or Other. Return only the category."
- Test on 10 rows with the AI function and check each result.
- Refine the instruction if categories overlap, for example by adding "Use Support for any mention of contacting us."
- Fill the column using Fill with Gemini.
- Freeze the results by copying and pasting values.
- Summarize: ask Gemini in the side panel for a count by category and the top three themes in each.
A job that might take a person a full day of reading becomes a short review task, with you checking the edge cases.
Writing better prompts in Sheets
- Be explicit about the output format: "Return one word", "Return a number", "Return Yes or No".
- Give the allowed categories rather than letting the AI invent them.
- Include an example in the instruction for tricky cases.
- Keep prompts in a cell you reference, so everyone uses the same instruction.
Privacy and data handling
Before running AI on personal or confidential data, check your organization's policy and Google Workspace settings. Remove columns you do not need, and avoid sending sensitive personal information through AI features unless your plan and policy allow it. Our guide on whether it is safe to upload files to ChatGPT covers the questions to ask about any AI tool.
Troubleshooting
- No Gemini option: check your plan and whether Workspace smart features are turned on; business users may need their admin to enable Gemini.
- Unexpected results: tighten the instruction and list allowed outputs.
- Results changing: paste values once you are happy with them.
- Hitting limits: process data in smaller batches and spread work across days.
Google Sheets vs Excel and ChatGPT
- Google Sheets with Gemini suits teams already working in Google Workspace.
- Excel with Copilot suits Microsoft 365 users; see our comparison of Microsoft Copilot vs ChatGPT for the Microsoft side.
- ChatGPT is handy for one-off analysis of an uploaded file.
Choose the tool that keeps your data where your team already works.
Related reading
For more tools grouped by job, browse our AI tools by profession guide.
FAQ
Which plans include AI in Google Sheets?
Google's July 2026 Workspace update lists Fill with Gemini for Business Standard and Plus, Enterprise Standard and Plus, Google AI Pro and Ultra for consumers, education add-ons and AI Expanded Access add-ons.
What is the AI function in Google Sheets?
It is a function that runs an AI prompt on cell data, for example to classify, summarize or extract information. Google describes Fill with Gemini as an entry point to the AI function.
Are there usage limits?
Yes. Google said per-user usage limits apply after 15 July 2026, with higher limits for AI Expanded Access license holders. Specific numbers were not published in the posts we checked.
What languages does it support?
Google's July 2026 update says the AI function and Fill with Gemini expanded from English, Spanish, Portuguese, Japanese, Korean, French, Italian and German to additional languages including Mandarin, Dutch, Malay and Hebrew.
Do I need to turn anything on?
Google says end users must have Workspace smart features enabled to use Fill with Gemini. Admins may also control Gemini features for business accounts.
Conclusion
To use AI in Google Sheets, check that your plan includes Gemini, use the side panel to build and analyze sheets, and use the AI function with Fill with Gemini for row-by-row text work. Test on small samples, freeze results you rely on, and double-check calculations before sharing.
Sources and methodology
Availability, languages and usage-limit details come from Google Workspace Updates posts "Fill with Gemini in Sheets now available in 11 additional languages" (7 July 2026; https://workspaceupdates.googleblog.com/2026/07/fill-with-gemini-in-sheets-now-available-in-11-additional-languages.html) and "Build and edit complex spreadsheets with Gemini in Google Sheets" (April 2026; https://workspaceupdates.googleblog.com/2026/04/build-and-edit-complex-spreadsheets-with-Gemini-in-Google-Sheets.html), checked 15 October 2026.