Google is launching a new AI function in Sheets that will help you generate textual content to fill out components of your spreadsheet. The characteristic, powered by Google Gemini, can reference particular cells to create textual content, summarize data, or categorize your knowledge.
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 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 make certain to vary 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 can carry out by typing this:
You can even categorize a buyer inquiry as a praise, alternate request, or return request, and even use it to categorise eating places by location. You may try a spread of various examples for the AI perform on Google’s support page.
This builds on the opposite Gemini-powered feature in Sheets that may reply questions on your knowledge and even create a visualization. Nevertheless, 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 whole 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 out there to customers with the Gemini Schooling plan or add-on.