Google is launching a new AI function in Sheets that will help you generate textual content to fill out elements of your spreadsheet. The characteristic, powered by Google Gemini, can reference particular cells to create textual content, summarize info, or categorize your information.
Within the instance shared by Google, you should utilize the brand new AI perform to generate and tailor copy for an commercial based mostly on the totally different goal audiences listed in your spreadsheet. To do that, you’d spotlight the cells the place you need the AI copy to seem after which use this perform (however ensure to alter the goal vary to match your spreadsheet):
One other instance contains utilizing the AI perform to summarize the suggestions of consumers listed in a gaggle of cells, which you would carry out by typing this:
You can too 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 support page.
This builds on the opposite Gemini-powered characteristic 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 total spreadsheet or Google Drive recordsdata, and you’ll solely generate outputs for the primary 200 chosen cells — you would need to wait till it finishes after which select extra cells.
AI features 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 accessible to customers with the Gemini Training plan or add-on.