Now Google’s Gemini AI is able to fill in these empty cells in your spreadsheet

Google is launching a brand new AI perform in Sheets that can assist you generate textual content to fill out components of your spreadsheet. The function, powered by Google Gemini, can reference particular cells to create textual content, summarize data, or categorize your information.

Within the instance shared by Google, you need to use the brand new AI perform to generate and tailor copy for an commercial based mostly on the completely different goal audiences listed in your spreadsheet. To do that, you’ll spotlight the cells the place you need the AI copy to seem after which use this perform (however be sure that to vary the goal vary to match your spreadsheet):

One other instance consists of utilizing the AI perform to summarize the suggestions of consumers listed in a bunch of cells, which you would carry out by typing this:

You can even categorize a buyer inquiry as a praise, trade request, or return request, and even use it to categorise eating places by location. You’ll be able to try a spread of various examples for the AI perform on Google’s help web page.

This builds on the opposite Gemini-powered function in Sheets that may reply questions on your information and even create a visualization. Nonetheless, the AI perform comes with some limitations, because it solely helps text-based responses for now. Google notes that the AI perform can’t entry your complete spreadsheet or Google Drive information, and you may solely generate outputs for the primary 200 chosen cells — you would need to wait till it finishes after which select extra cells.

AI capabilities are rolling out now to Google Workspace customers on the enterprise and enterprise plans, in addition to for Gemini AI Professional and Extremely subscribers. It’s additionally out there to customers with the Gemini Schooling plan or add-on.