Gemini has some new abilities that could make it more helpful in Sheets, Google announced in a post on the Workspace blog. Now, Gemini can respond to questions about your data with details about trends or by creating static charts that you can insert into your spreadsheet as images. The new capability is rolling out now to most Workspace plans and to users on the $19.99-per-month Google One AI Premium plan.
Google says Gemini does all of this by creating and running Python code, then producing an analysis of the code’s results.