- Gemini can use Python to create data visualization graphics in the sheets
- You can also interact with it by asking questions about your data
- However, graphics will not automatically be updated live data sets
Google has deployed a rather practical update of its Gemini which allows the AI tool to do more with the data you have in Google Sheets.
Using the Gemini additional module in the calculation sheet software, users can now create visualizations and analyze data in other ways, such as the identification of trends, using artificial intelligence.
In a Google Workspace update blog article, the company noted: “Gemini in the sheets can carry out actions or answer questions to answer a wide variety of scenarios.”
Google Sheets Gemini upgrade
The update means that Gemini can now provide contextual trends, models and correlations between different variables of your data, which can all be transformed into graphics.
The company added: “This update reflects Gemini in the improved intelligence of the sheets because it now provides precious outings by transforming your requests into Python code, by performing them, then analyzing the results to perform a multilayer analysis. “”
However, there is a socket – although no coding is required, the graphs will be built using a punctual prompt and are therefore not linked to live data. The changes to data will not be reflected in the graphics, and users will have to generate new visualizations – but very easily with AI.
Google has also noted the importance of a solid data foundation in order to give Gemini the best chances of success, adding: “For the most specific results, make sure that your data is in a coherent format, with EN EN -make and no missing value. “
It has also been noted that Gemini’s performance is the most “coherent” in the spreadsheets with less than a million cells, which makes the additional module of the AI slightly less attractive for large data sets.
Google Workspace Business Business / Plus and standard Enterprise / Plus customers will be among the first to get their hands on the updated IA tool, as well as Google One IA Premium subscribers and anyone with an add-on Gemini Education or Gemini Education Premium.