Google Integrates Gemini AI into Sheets for Advanced Text Generation and Data Analysis

Now Google's Gemini AI is ready to fill in those empty cells in your spreadsheet

Emma Roth is a news writer who covers the streaming wars, consumer tech, crypto, social media, and much more. Previously, she was a writer and editor at MUO. Google is launching a new AI function in Sheets to help you generate text to fill out parts of your spreadsheet. The feature, powered by Google Gemini, can reference specific cells to create text, summarize information, or categorize your data. In the example shared by Google, you can use the new AI function to generate and tailor copy for an advertisement based on the different target audiences listed in your spreadsheet. To do this, you would highlight the cells where you want the AI copy to appear and then use this function (but make sure to change the target range to match your spreadsheet): Another example includes using the AI function to summarize the feedback of customers listed in a group of cells, which you could perform by typing this: You can also categorize a customer inquiry as a compliment, exchange request, or return request, or even use it to classify restaurants by location. You can check out a range of different examples for the AI function on Google's support page. This builds on the other Gemini-powered feature in Sheets that can answer questions about your data and even create a visualization. However, the AI function comes with some limitations, as it only supports text-based responses for now. Google notes that the AI function can't access your entire spreadsheet or Google Drive files, and you can only generate outputs for the first 200 selected cells -- you would have to wait until it finishes and then choose more cells. AI functions are rolling out now to Google Workspace users on the business and enterprise plans, as well as for Gemini AI Pro and Ultra subscribers. It's also available to users with the Gemini Education plan or add-on.

Gemini in Google Sheets now lets you type a prompt to tell it exactly what to do

Also: Google's new free AI agent brings Gemini right to your command line - here's how to try it Sheets already has the capability for Gemini to assist with creating tables and formulas, generating graphs and charts, and handling tasks like conditional formatting, sorting, and filtering. Now you can enter a prompt in a cell to tell Gemini what you want to do. Also: Google Earth just made time travel easier - here's how to visit the old neighborhood From a cell, Google explained, you can input a prompt describing what you want to do (you can even include a data range). With that input, Gemini can do one of several things: Instead of having to manually sort through hundreds of rows of data to handle tasks like categorizing user feedback and writing personalized emails in response, Gemini can now handle the tedious work for you. Google offered a few examples of how this feature might work: If you want to work with cells that aren't contiguous, Google explained that you might use something like: This feature only supports text-based responses for text generation, categorization, and sentiment analysis. The input information is optional, but Google recommends using it for optimal results. Also: The best AI for coding in 2025 (including a new winner - and what not to use) There are a few limitations that might impact how you use this feature. If a cell is updated after Gemini generates a response, the cell will show as "out of sync" and keep the old output for reference. You can select multiple cells with AI functions to generate outputs. However, only the first 200 selected cells with AI functions will be generated. You'll have to wait for the generation to complete to generate output on further cells. Also: Google's Jules AI coding agent built a new feature I could actually ship - while I made coffee Gemini's new capability in Sheets has started rolling out, but the feature might take up to 15 days to reach all users.