January 29, 2025
Generate charts and valuable insights using Gemini in Google Sheets
What’s changing
Building data visualizations and identifying trends in data is a critical business function, however it can be time consuming and oftentimes overwhelming. To improve upon this experience, we’re making it easier for Sheets users, ranging from small business owners to marketing analysts, to visualize and analyze data using Gemini in Sheets.
Starting today, Gemini in Sheets can perform actions or answer questions to address a wide variety of scenarios. Specifically, you can ask Gemini questions about your data and Gemini can provide valuable insights, such as contextual trends, patterns, and correlations between different variables in your data. Gemini will also generate charts based on your data that you can insert as static images over cells in your spreadsheet. For example:
- A marketing manager analyzing campaign performance can ask "Provide some insights on my top 3 performing channels by conversion rate" and can receive a detailed breakdown with supporting visualizations.
- A small business owner managing cash flow can ask "Predict my net income for the next quarter based on historical data" to proactively identify potential shortfalls.
- A financial analyst investigating inventory trends can ask "Identify any anomalies in inventory levels for Product X" to uncover potential supply chain issues or unusual demand patterns.
Ask Gemini in Sheets to share insights and trends from the data.
Ask Gemini in Sheets to visualize data with a chart or bar graph.
Who’s impacted
End users
Why you’d use it
This update reflects Gemini in Sheets’ enhanced intelligence as it now yields valuable outputs by transforming your requests into Python code, executing on them and then analyzing the results to perform multi-layered analysis. As a result, you’re able to do things like identify top-performing products and then instantly dive into their sales trends — all without writing a single line of code.
Additional details
- For the most accurate results, ensure your data is in a consistent format, with clear headers and no missing values.
- When asking Gemini in Sheets to analyze your data, be as specific as possible in your prompts to ensure Gemini understands your request.
- For complex analysis, Gemini in Sheet's performance is most consistent in files below 1 million cells.
- For some simpler questions about your data, Gemini in Sheets may still provide answers using formulas instead of Python code.
- Charts are generated as static images and can be easily inserted into your sheet.
- Charts are not linked to your sheet data, so they won't update automatically if your data changes.
- Once inserted, charts cannot be modified. If you need to make changes, you'll need to generate a new chart.
Getting started
- Admins: To access Gemini in the side panel of Workspace apps, users need to have smart features and personalization turned on. Admins can turn on default personalization setting for their users in the Admin console.
- End users: You can access Gemini for Sheets in the side panel by clicking on “Ask Gemini” (spark button) in the top right corner of Sheets. Visit the Help Center to learn more about collaborating with Gemini in Sheets.
Rollout pace
- Rapid Release and Scheduled Release domains: Extended rollout (potentially longer than 15 days for feature visibility) starting on January 29, 2025, with expected completion by February 20, 2025
Availability
Available for Google Workspace:
- Business Standard and Plus
- Enterprise Standard and Plus
- Customers with the Gemini Education or Gemini Education Premium add-on
- Google One AI Premium
Anyone who previously purchased these add-ons will also receive this feature:
- Gemini Business*
- Gemini Enterprise*
*As of January 15, 2025, we’re no longer offering the Gemini Business and Gemini Enterprise add-ons for sale. Please refer to this announcement for more details.