Google Sheets can now AI-generate charts and insights for you

Google recently updated Gemini for Workspace, improving what the AI assistant can analyze, understand, and do in Google Sheets. This comes about a year after Google first introduced Gemini for Workspace and brought AI tools to Gmail, Docs, Sheets, and more to users who pay for a Google One AI Premium plan ($19.99 per month).

In the update announcement post, Google explains that Gemini in Sheets is now better at identifying trends and relationships between variables, generating charts to be inserted into spreadsheets, and using Python code to conduct even more advanced analyses.

However, there are some limitations:

• AI-generated charts can’t be edited after they’ve been inserted.
• They’re not dynamic, which means they won’t automatically update if you change the data in the spreadsheet.
• For best results, Google recommends that the data is well-structured, with clear headings and no missing values.

The new Gemini Dashboard in Sheets is available to Google One AI Premium users, enterprise customers with Business or Enterprise Workspace (Standard or Plus), and users with Gemini Education, Gemini Education Premium, Gemini Business, or Gemini Enterprise plans.

Google has already started rolling out the feature but won’t be complete until February 20, so if you don’t see it yet, you may have to wait.