Gemini in Google Sheets Gets Updated With Data Analysis and Visualization Tools
Google has announced a significant upgrade to its Gemini AI tool in Google Sheets, bringing advanced data analysis and visualization capabilities to users. This update, rolled out on Wednesday, is available to Google Workspace subscribers and those on the Google One AI Premium plan.
New Features and Capabilities
The new features allow Gemini in Google Sheets to transform user prompts into Python code, enabling multi-step analysis. Previously, Gemini in Google Sheets could only convert user requests into formulas, resulting in single-layer analysis. With the ability to generate Python code, Gemini in Google Sheets can now perform more complex and layered data analysis.
In a blog post, Google detailed the new capabilities being added to the Gemini assistant for Google Sheets. These features are available to Google Workspace Business Standard and Plus subscribers, Enterprise Standard and Plus subscribers, and users with Gemini Education or Gemini Education Premium add-on. Additionally, Google One AI Premium subscribers will also get access to these features.
Data Analysis and Visualisation
The AI assistant for Google Sheets can now transform user requests into Python code and execute them, allowing for multi-layered analysis. This means that Gemini in Google Sheets can answer queries about the data and provide deeper insights into the spreadsheet. Users can ask the AI about contextual trends, patterns, and correlations between different variables in the data.
Additionally, Gemini in Google Sheets can generate charts to help users visualise the information easily. These charts can be inserted as static images over cells in the spreadsheet. For example, a user aiming to analyse a marketing campaign’s performance can ask Gemini in Google Sheets to “Provide insights on the top three performing channels by conversion rate,” and the AI assistant can show a detailed breakdown alongside supporting charts.
Availability and Rollout
These capabilities have been rolled out by Google, but it is expected to take around 15 days before the feature is visible to all eligible users. The update is part of Google’s ongoing efforts to enhance the functionality of its AI tools and provide users with more powerful data analysis and visualisation capabilities.
Pricing
The new Gemini AI features in Google Sheets are available to users subscribed to Google Workspace and Google One AI Premium plans. Google Workspace Business Standard and Plus, Enterprise Standard and Plus, as well as Gemini Education and Gemini Education Premium add-ons, include access to these capabilities. The Google One AI Premium plan, which includes Gemini, is priced at $19.99 per month.
Huawei’s DeepSeek-R1 AI Model: Controversy and Industry Reactions
User Experience and Feedback
Users have expressed excitement about the new features, noting that the ability to generate Python code and perform multi-layered analysis will significantly enhance their productivity. The ability to visualise data through charts is also seen as a valuable addition, making it easier for users to interpret and present their data.
Future Developments
Google has hinted at further enhancements to the Gemini AI tool in Google Sheets, with plans to introduce more advanced features in the coming months. These updates are expected to build on the current capabilities and provide users with even more powerful tools for data analysis and visualisation.
Key Takeaways
The new features in Gemini for Google Sheets represent a significant step forward in AI-powered data analysis and visualization. By enabling multi-layered analysis and providing deeper insights into user data, Gemini is set to become an indispensable tool for Google Workspace and Google One AI Premium subscribers.
for more info visit on this link : https://support.google.com/docs/answer/14218565?hl=en
Huawei’s DeepSeek-R1 AI Model: Controversy and Industry Reactions
