- Gemini can use Python to build data newspaper graphics in sheet
- You can also interact with it by asking questions about your data
- However, charts will not auto-update from live dataset
Google has rolled a pretty practical update to its Gemini that allows the AI tool to do more with the data you have in Google Sheets.
With the help of the Gemini addition within the spreadsheet software, users can now build visualizations and analyze data in other ways, such as identifying trends, using artificial intelligence.
In a Google Workspace update blog post, the company noticed, “Gemini in ARK can perform actions or answer questions to tackle a wide variety of scenarios.”
Google Sheets Gemini Upgrade
The update means that Gemini can now provide contextual trends, patterns and relationships between different variables in your data, all of which can be converted into charts.
The company added: “This update reflects Gemini in Sheets’ improved intelligence as it now provides valuable output by converting your requests into python code, performing on them, and then analyzing the results to perform multilayer analysis.”
However, there is a catch-self-indulgence, no coding is required, the charts will be built using a disposable prompt and is therefore not linked to live data. Changes in the data are not reflected in the charts and users will have to generate new visualizations – albeit very easily with AI.
Google also noticed the importance of a solid data fundament to give Gemini the best chance of success and add, “For the most accurate results, make sure your data is in a consistent format, with clear headlines and no lack of values. “
It was also noticed that Gemini’s performance is most “consistent” in spreadsheets with fewer than one million cells, making AI addition a little less appealing for large data sets.
Google Workspace Business Standard/Plus and Enterprise Standard/Plus customers will be among the first to get their hands on the updated AI tool with Google One AI Premium subscribers and anyone with Gemini Education or Gemini Education Premium Add-on.
