Gemini in Google Sheets Gets Updated With Data Analysis and Visualising Tools

The new Gemini features in Google Sheets will be available to Google Workspace users.

Advertisement
Written by Akash Dutta, Edited by Siddharth Suvarna | Updated: 30 January 2025 18:45 IST
Highlights
  • Gemini in Google Sheets can now transform user prompts into Python code
  • It can find contextual trends, patterns, and correlations in the user dat
  • Gemini will also generate charts based on user data
Gemini in Google Sheets Gets Updated With Data Analysis and Visualising Tools

Gemini in Sheet's performance is consistent in files below 1 million cells

Photo Credit: Google

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 Wednesday, the new features are currently being rolled out to the Google Workspace subscribers and those 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 could only convert user requests into formulas, which resulted in single-layer analysis.

Gemini in Google Sheets Gets New Features

In a blog post, the 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 Premium add-on. Additionally, Google One AI Premium subscribers will also get access to these features.

So far, the Gemini side panel in Sheets could 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

Advertisement

 

However, now, Gemini is getting advanced data analysis and visualising capabilities. 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-layered analysis.

Advertisement

Google explained that Gemini will be able 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. Additionally, Gemini will also be able to generate charts to help users visualise the information easily. 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 channels by conversion rate,” and the AI assistant can show a detailed breakdown alongside supporting charts.

Advertisement

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.

 

For the latest tech news and reviews, follow Gadgets 360 on X, Facebook, WhatsApp, Threads and Google News. For the latest videos on gadgets and tech, subscribe to our YouTube channel. If you want to know everything about top influencers, follow our in-house Who'sThat360 on Instagram and YouTube.

Advertisement

Related Stories

Popular Mobile Brands
  1. OnePlus 13s With Snapdragon 8 Elite Chip to Launch in India on This Date
  2. iQOO Neo 10 Pro+ Battery and Charging Details Revealed Ahead of Debut
  3. Samsung Galaxy S25 FE Tipped to Retain Galaxy S24 FE Rear Cameras
  4. Apple AirPods With Built-in Camera Tipped to Launch Next Year
  5. Realme GT 7T Design, Specifications Leaked Ahead of May 27 Launch
  6. Realme P3 5G Series to Get a Limited Period Discount in India
  7. Vivo S30, S30 Pro Mini, Pad 5, TWS Air 3 Launch Date, Key Features Confirmed
  1. Acer AI TransBuds With Ear-Hook Design Unveiled at Computex 2025
  2. Honor 400 Series China Launch Date Revealed; Confirmed to Offer Battery Upgrade Over Predecessors
  3. Acer FreeSense Ring With AI-Powered Health Tracking Features Unveiled in Seven Size Options
  4. Acer Swift Go 14 AI, Swift Go 16 AI Copilot+ PCs Launched at Computex 2025 Alongside Swift Edge 14 AI
  5. Delhi Metro Ticketing Goes Live on Uber App; More Cities, B2B Logistics Up Next
  6. Google Chrome Security Flaws Could Grant Hackers Unauthorised System Access: CERT-In
  7. Realme P3 5G Series to Receive a Limited Period Discount in India: Offers, Availability
  8. Gemini Nano-Enabled API Released to Android Developers Ahead of Google I/O 2025
  9. Vivo S30, S30 Pro Mini Launch Date Set for May 29; Vivo Pad 5, TWS Air 3 to Tag Along
  10. HP OmniBook 5 Series AI PCs With Snapdragon X Series Chipsets Launched: Price, Specifications
Gadgets 360 is available in
Download Our Apps
Available in Hindi
© Copyright Red Pixels Ventures Limited 2025. All rights reserved.