Google explains that Gemini will perform these tasks by running Python code and analyzing its results. For simple queries, it will be able to use standard spreadsheet formulas. Previously, Gemini was limited to basic tasks, such as providing recommendations on how to work with spreadsheets or creating them.
Google warns that these AI-generated data visualizations are static images, so every time you update your data, you'll need to ask Gemini to create new ones.
Manually created charts will always reflect the changes you make. Therefore, if you need a chart for a dynamic project, it may be better to visualize the data in a traditional way.
Google also warns that Gemini's accuracy may be affected by factors such as inconsistent data formatting, missing values, or insufficiently clear queries.