Gemini in Google sheets is getting a Major upgrade that will allow the artificial intelligence (AI) tool to analyse and visualise user data. Announced on Wednsday, the new features are currently being rolled out to the google workpace subscribers and there subscribed to the google one ai premium plan. Interestingly, the update also lets Gemini Convert Complex Prompts Into Python Code to perform multi-step analysis. Earlier, it would only convert user requests into formulas, which resulted in single-layer analysis.
Gemini in Google Sheets Gets New Features
In a blog postThe mountain view-based tech giant announced that new capabilities were being added to the gemini assistant for google sheets. These features will be available to Google Workspace Business Standard and Plus Subscribers, Enterprise Standard and Plus Subscribers, and Users with Gemini Education or GEMINI EDUCATION PREMICATION PremiCation Premium Adduction Premium. Additional, Google One Ai Premium subscribers will also also get access to these features.
So far, the Gemini Side Panel in Sheets Cold Summarise Spreadsheets and Create Tables. These were done by turning prompts into formulas and by executing them on the sheet. However, Since Formulas are limited in scope, users can only add one layer to analyse the spreadsheet data.
Data Analysis Feature in Google Sheets
Photo Credit: Google
However, now, gemini is getting advanced data analysis and visualising capabilites. The AI Assistant for the Platform Can Now Transform User Requests Into Python Code and Execute Them. This way, the chatbot can analyse the results to perform a multi-layred analysis.
Google explained that gemini will be removed to answer queries about the data and provide deeper insights about the spreadsheet. Users can ask the ai about contextual trends, patterns, and correlations between different variables in the data. Additional, Gemini will also be able to generate charts to help users visualize the information easy. These charts can also be inserted as static images over cells in the spreadsheet.
Highlighting an example, the post stated that a User Aiming to Analyse a Marketing Campaign Performance Can Ask Gemini To “Provide Insights on the Top Three Performing Channells by CONTENELS Ow a detailed Breakdown ALONGSIDE Supporting Charts.
These capabilities have been rolled out by google, however, it is expected to take Around 15 days before the feature is visible to all eligible users.
6
