Gemini AI in Google Sheets gets smarter with natural text generation

Google’s new Gemini-powered function in Sheets writes text directly into your spreadsheet, saving time and rethinking workflows.

Google Sheets now includes an AI text function powered by Gemini, writing content directly into selected cells,Users can generate ad copy, summarise feedback, and categorise data using natural language prompts,The feature is available to Gemini Pro and Ultra users, as well as select Workspace and Education plans

What if your spreadsheet could write back? With Google’s latest Gemini AI feature in Sheets, that moment has arrived. This new function doesn’t just analyse your data, it composes tailored text right in your cells, transforming blank grids into dynamic business tools.

Copywriting from cells: a shift in spreadsheet utility

Until now, spreadsheets have been about numbers, charts, and the occasional formula wizardry. But Google’s Gemini integration in Sheets adds a fresh, expressive layer. With the =AI() function, users can write a prompt and point the tool at a range of cells to generate targeted, readable content.

For instance, imagine a campaign planner with different customer personas listed across rows. A single formula like:

`=AI(“Write a formal ad copy for the product. Cater copy to the objective and target audience.”, A2:C2)`

will deliver bespoke advertising lines, directly shaped by each row's data.

This isn’t just smart automation; it signals a shift in how creative professionals and marketers might collaborate with data. For more insights on how AI is changing creative fields, check out our article on how AI Artists are Topping the Charts Weekly.

Summarising, categorising, and simplifying

Beyond advertising, the function lends itself to more analytical tasks. Marketers can summarise customer feedback in a sentence:

`=AI(“For the customer, write a one sentence summary of their feedback.”, A2:D2)`

Or operations teams might use AI to classify inquiries into compliments, return requests, or other support categories. Even food delivery startups can label restaurants by region in seconds. What once required manual input or separate tools is now baked into the same familiar spreadsheet interface. This kind of integration highlights the "invisible impact" of AI, as discussed in our piece, Beyond the Hype AI's quiet revolutions are changing everything.

What it can’t do (yet)

This feature is smart, but not all-seeing. For now, it can only return text responses and only processes up to 200 cells at a time. It also doesn’t scan your full spreadsheet or pull insights from connected Google Drive files. That means you’ll still need to guide it with clear, contextual cell selections.

There’s also a pacing element—you’ll need to wait for one batch to complete before prompting the next. For enterprise teams handling bulk updates, it’s a tool that rewards precision and structure over brute force. You can learn more about similar challenges with AI data processing in Running Out of Data: The Strange Problem Behind AI's Next Bottleneck.

Who gets it, and when

Gemini AI in Sheets is gradually rolling out to users on Workspace’s business and enterprise tiers, as well as subscribers to Gemini AI Pro, Ultra, and Education add-ons. If you fall into one of these groups, you can explore real-world examples on Google’s support site.

It’s another nudge from Google showing how AI is no longer confined to experimental labs. It’s in the daily software you already use—with prompts, not code. For a deeper dive into the broader adoption of AI in business, read about Executives tread carefully on generative AI adoption. A study by McKinsey & Company provides further insights into the business value of AI in various sectors McKinsey & Company: The economic potential of generative AI.

Engagement Close

Could this be the end of tedious manual entries? Or just the start of a more expressive spreadsheet era? Either way, Gemini in Sheets is worth experimenting with, especially for teams who value both structure and creativity.