What’s changing
Google is making it easier for Google Sheets users to visualize and analyze data using Gemini in Sheets.
Gemini in Sheets can perform actions or answer questions to address a wide variety of scenarios.
For example, 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.
Here are some examples of how Gemini in Sheets can be used:
- 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.
Why you’d use it
Gemini in Sheets is now able to perform multi-layered analysis by transforming your requests into Python code, executing on them and then analyzing the results. This means that you can now do things like identify top-performing products and then instantly dive into their sales trends — all without writing a single line of code.