Google is rolling out a powerful new AI function for Google Sheets that lets users generate text directly within spreadsheets using natural language prompts. Powered by Google Gemini, the new =AI() function allows you to create ad copy, summarize customer feedback, or categorize data — all based on spreadsheet cell content.
How It Works
Just input a formula like:
or
Gemini AI will then generate text tailored to your selected data. From ads and summaries to classification tasks, the tool makes Sheets more intelligent and context-aware.
Limitations
-
Supports only text-based outputs
-
Limited to 200 selected cells per request
-
Can’t access full spreadsheets or external Drive files
Availability
The feature is rolling out now to:
-
Google Workspace Business & Enterprise users
-
Gemini for Workspace Pro and Ultra plan subscribers
-
Gemini Education users (with the plan or add-on)
For a full list of supported prompts and examples, visit Google’s official support page.
