Google Sheets Release Notes
Last updated: Apr 9, 2026
- Apr 7, 2026
- Date parsed from source:Apr 7, 2026
- First seen by Releasebot:Apr 9, 2026
Greater control and error visibility for Google Sheets formulas
Google Sheets improves function logic and parameter support for targeted formulas, making errors easier to spot, calculations more predictable, and imported spreadsheets more compatible.
We are introducing updates to the logic and parameter support for a targeted set of Google Sheets functions. These changes are designed to improve error visibility, offer more control over data, and ensure seamless compatibility when importing files.
Specifically, you will notice improvements across several categories of functions, including:
- Better error surfacing: Select informational and statistical functions (such as HYPERLINK, VALUE, and T.TEST) will now more accurately flag underlying errors, like broken URLs or zero-variance denominators, preventing potential data issues from being masked.
- Enhanced parameter support: Several statistical distribution functions (such as HYPGEOM.DIST, NORM.S.DIST, and LOGNORM.DIST) now support additional parameters, allowing for greater control and ensuring they import smoothly from external spreadsheets.
- Refined calculation logic: Select financial and array functions (such as CUMIPMT and FREQUENCY) have been updated to provide more precise and predictable results based on your specific data inputs.
These enhancements reduce friction and provide more trustworthy outcomes for users who rely on precise mathematical behaviors. You can now troubleshoot complex spreadsheets more effectively and import external files with confidence, knowing your formulas will evaluate as expected. For a comprehensive list of Sheets functions and their specific inputs and behavior, please visit our Help Center.
Getting started
- Admins: There is no admin control for this feature.
- End users: There is no end user setting for this feature. Visit the Help Center to learn more about how these functions work in Sheets.
Rollout pace
- Rapid Release and Scheduled Release domains: Available now
Availability
- Google Workspace customers and users with personal Google accounts
Resources
- Google Help: Google Sheets function list
- Feb 23, 2026
- Date parsed from source:Feb 23, 2026
- First seen by Releasebot:Feb 25, 2026
Two new functions in Google Sheets
Google Sheets gains two new dynamic functions, =SHEET and =SHEETS, to reveal a sheet’s index and the total number of sheets. They recalc when tabs change and work for all Workspace and personal accounts, with gradual rollout starting February 23, 2026.
We are adding two new functions to Google Sheets, =SHEET and =SHEETS. These additions help users manage and reference spreadsheets with multiple tabs more effectively.
The new functions operate as follows:- =SHEET(value): Returns the sheet number of a specified sheet name or reference. If the argument is omitted, it returns the number of the sheet containing the function.
- =SHEETS(): Returns the number of all sheets in the spreadsheet.
Please note that the =SHEETS function in Google Sheets does not accept arguments (such as a range of tabs). Formulas containing arguments for this function will result in an error.
These functions allow you to perform calculations based on the structure of your spreadsheet. Both functions are dynamic and will recalculate when a sheet is added, deleted, moved, or renamed within a document. This ensures your data analysis remains accurate even as the organization of your spreadsheet changes.
Getting started
- Admins: There is no admin control for this feature.
- End users: Use =SHEET() or =SHEETS() in any Sheets document to get started with the feature. Visit the Help Center to learn more.
Rollout pace
- Rapid Release and Scheduled Release domains: Gradual rollout (up to 15 days for feature visibility) starting on February 23, 2026
Availability
- Available to all Google Workspace customers and users with personal Google accounts
Resources
- Google Help: Sheets Function
All of your release notes in one feed
Join Releasebot and get updates from Google and hundreds of other software products.
- Feb 17, 2026
- Date parsed from source:Feb 17, 2026
- First seen by Releasebot:Feb 20, 2026
Forecast data in Connected Sheets using BigQuery ML and TimesFM
Connected Sheets now lets you generate forecasts in Google Sheets using BigQuery ML TimesFM. No SQL or Python required, with customizable horizons, confidence intervals, and multi‑series breakdowns. Charts auto-visualize forecasts; rolling out rapidly starting Feb 16, 2026.
Overview
We are introducing a new capability in Connected Sheets for BigQuery that allows users to generate data forecasts directly within Google Sheets using the power of BigQuery ML (BQML) and Google’s state-of-the-art TimesFM model. Users can now predict future sales, demand volume, or other key business metrics without needing to write SQL, use Python, or customize and train their own models.
This feature is designed for simplicity and speed. TimesFM’s powerful foundation model is pre-trained on billions of data points from real-world datasets, enabling business users to generate sophisticated predictions on their data immediately without the complex, time-consuming training pipelines typically associated with machine learning.
Key features
- Simple configuration: Forecasts can be created from any existing BigQuery dataset or custom query using a user-friendly configuration pane in the Sheets UI.
- Customizable parameters: Users can adjust forecast parameters, such as the prediction horizon for how far into the future the user wants to predict and confidence intervals, or use our default options to get started.
- Granular analysis: The feature supports breakouts by any given data dimension, allowing users to run multiple time series forecasts simultaneously (e.g., forecasting sales broken down by region or product category).
- Visual insights: For single time series forecasts, Sheets automatically generates a helpful chart visualizing the forecast alongside historical data.
Getting started
- Admins: There is no admin control for this feature.
- End users: Create a Connected Sheet. On the Preview view, click on “Advanced Analytics” and then “Create a Forecast”.
Rollout pace
- Rapid Release and Scheduled Release domains: Gradual rollout (up to 15 days for feature visibility) started on February 16, 2026
Availability
- Available to all Google Workspace customers and users with personal Google accounts
- Nov 12, 2025
- Date parsed from source:Nov 12, 2025
- First seen by Releasebot:Jan 18, 2026
Analyze large-scale .csv files in Google Sheets with a new direct-to-BigQuery import
Google Sheets now lets you import large CSV datasets directly into BigQuery via Connected Sheets, enabling analysis with Sheets charts, pivots, and formulas in one seamless workflow. This update shortens prep time and speeds insights from raw data to decision-ready visuals.
We're making it easier than ever to analyze massive datasets by more seamlessly connecting Google Sheets and BigQuery. Now, users will see a new option to import .csv files containing datasets of any size directly to BigQuery while opening large .csv files from Drive or via the Data > Data Connectors menu flow in Sheets. From there, users can analyze the entire dataset using familiar Sheets features such as charts, pivot tables, and formulas via Connected Sheets.
Previously, preparing a large dataset for analysis in Connected Sheets was often a multi-step process that could have involved relying on separate data pipelines, processing tools or multiple upload steps, all before the user could return to Sheets to start their analysis. This new connectivity expedites the analysis workflow by allowing users to directly ingest large datasets and begin analysis seamlessly, all within a single interface. This update will help users move from raw data to insights much faster.
Getting started
Admins: This feature will only be available to users who have been granted permissions to write to BigQuery tables. Visit the Help Center to learn more about using Connected Sheets in your organization.
End users: This feature will be available by default for users with permissions to write to BigQuery. Visit the Help Center to learn more about uploading to BigQuery and analyzing via Connected Sheets.
Rollout pace
Rapid Release domains: Gradual rollout (up to 15 days for feature visibility) starting on November 3, 2025
Scheduled Release domains: Gradual rollout (up to 15 days for feature visibility) starting on November 18, 2025
Availability
- Available to all Google Workspace customers, Workspace Individual Subscribers, and users with personal Google accounts
Resources
- Google Workspace Admin Help: Use Connected Sheets in your organization
- Google Help: Get started with BigQuery data in Google Sheets
- BigQuery Help Center: Using Connected Sheets
- Oct 30, 2025
- Date parsed from source:Oct 30, 2025
- First seen by Releasebot:Jan 18, 2026
More powerful pivot tables in Connected Sheets
Connected Sheets now supports 200k row pivots for BigQuery data and adds a drill-down view to instantly reveal underlying records. Double-click or Use Show details to export a focused extract. Available to admins and users with BigQuery permissions.
Connected Sheets pivot tables with BigQuery updates
We are rolling out two significant updates to Connected Sheets pivot tables backed by BigQuery, designed to increase analytical capacity and streamline your workflow.
First, we’re doubling row capacity for pivot tables backed by BigQuery in Connected Sheets, from 100,000 to 200,000 rows. This change will allow users to bring in substantially larger views of BigQuery datasets in a single pivot table, enabling wider, more comprehensive analyses within the familiar Sheets environment.
Second, we’re launching the ability to “drill down” into Connected Sheets pivot tables, allowing you to immediately access the granular data making up any aggregated value. Users can now double-click on a pivot table cell or use the right-click > Show details menu option to instantly create a pre-configured extract, focusing on the specific records that make up that summary metric.
Getting started
- Admins: This feature will only be available to users with appropriate BigQuery permissions. Visit the Help Center to learn more about using Connected Sheets in your organization.
- End users: This feature will be available by default for users with appropriate BigQuery permissions. Visit the Help Center to learn more about analyzing BigQuery data using Connected Sheets.
Rollout pace
- Rapid Release and Scheduled Release domains: Gradual rollout (up to 15 days for feature visibility) starting on October 30, 2025
Availability
Available to all Google Workspace customers, Workspace Individual Subscribers, and users with personal Google accounts
Resources
- Google Workspace Admin Help: Use Connected Sheets in your organization
- Google Help: Get started with BigQuery data in Google Sheets
- BigQuery Help Center: Using Connected Sheets
- Oct 20, 2025
- Date parsed from source:Oct 20, 2025
- First seen by Releasebot:Jan 18, 2026
Gemini in Google Sheets can now analyze data across multiple tables
Gemini in Sheets now analyzes multiple tables in one tab, letting you ask cross‑table questions, generate formulas, create charts, and apply edits across tables. You can target analysis by selecting data for focused insights.
Starting today, Gemini in Sheets can understand and analyze multiple tables within a single tab of a spreadsheet. This new functionality allows you to ask questions and perform analysis that spans multiple data sources, dramatically increasing the power and accuracy of your queries. You can select or deselect tables to focus Gemini’s attention, and you can also directly make a selection within a table to be used as input for your query.
You can use this update while:
- Generating formulas: Generate complex formulas that reference and perform calculations across several tables in one go. For example, you can now have Gemini write XLOOKUP functions to look up values from one table to use in another, or aggregate data from multiple tables into a single summary calculation.
- Analyzing and generating charts: Ask Gemini to analyze data scattered across multiple tables to uncover insights and create data visualizations. You can get a holistic view of your data, whether you’re identifying top performers by combining sales data from different tables, or creating a single chart that compares sales performance data from separate tables.
- Editing your data: Apply changes to multiple tables at once with a single request. For example, you can now use Gemini to apply consistent conditional formatting across all your tables in a spreadsheet or build a single pivot table that summarizes data from multiple tables.
- Targeting analysis with selections: You can now make selections within your tables to focus Gemini’s analysis. Ask for summaries of specific data, find outliers in a selected range, or generate formulas based on the data you’ve highlighted. For example, you can select a column and ask, "What are the trends in the selected column?"
Admins
To access Gemini in Workspace apps, users need to have smart features and personalization turned on. Admins can turn on the personalization setting for their users in the Admin console.
End users
- This feature will be on by default.
- Visit the Help Center to learn more about Gemini in Sheets.
Rollout pace
- Rapid Release and Scheduled Release domains: Gradual rollout (up to 15 days for feature visibility) starting on October 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 AI Pro and Ultra
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.
Resources
- Google Help: Collaborate with Gemini in Google Sheets
- Oct 16, 2025
- Date parsed from source:Oct 16, 2025
- First seen by Releasebot:Jan 18, 2026
Gemini in Google Sheets now tackles multi-step tasks with expanded editing capabilities
Gemini in Sheets now handles multi‑step prompts, executing chained actions in one go. It expands editing tasks from formatting to data cleaning and structure changes, letting you describe complex goals in plain language and have Gemini complete them automatically.
Gemini in Sheets: Multi-action prompts
Earlier this year, we introduced powerful new editing options within Gemini in Sheets like creating pivot tables, applying filters, and adding conditional formatting. Building on that momentum, we’re excited to announce that Gemini can now execute multiple actions at once from a single prompt - no need to simplify your instructions or disrupt your workflow by typing multiple different prompts. Plus, Gemini also newly supports an expanded library of editing tasks.
With Gemini’s understanding of compound requests, you can now describe a complex, multi-step goal in plain language, and Gemini will handle the rest. From structuring and cleaning raw data to performing bulk structural edits, you’ll save valuable time in your workday.
Automate complex formatting and data cleaning tasks: Gemini can now execute on prompts that require chaining multiple actions together.
Multiple, simultaneous formatting requests: For example, you can now ask Gemini to completely reformat a plain project tracker in one go. Ask it to add dropdowns for "Status" and "Priority," insert a new formula column to calculate "Days Until Due Date," add a "Completed" checkbox column, and freeze the header row for easy viewing. Gemini will understand this multi-step request and perform all the actions at once.
Combined analytical and structural changes: For instance, ask Gemini to clean up a sales report by deleting rows for inactive reps, highlighting top performers who are above 120% of their quota in green, and then adding a new "Notes" column for follow-up actions.
Complex structure updates: For instance, you can ask Gemini to delete all "Archived" rows, then insert a new "Team" column with a dropdown list of team names, and finally add a new "Updated Due Date" column to prepare the sheet for the next planning cycle.
Make edits more easily with additional supported actions: We've expanded the library of actions Gemini supports, which now includes:
- Formatting: Add conditional formatting, set a number format, format as a table, or freeze a dimension.
- Data Entry & Manipulation: Add a checkbox, add a dropdown (or convert a cell to a dropdown), fill a range with a formula, or find and replace.
- Structure & Organization: Insert or delete a dimension (row/column), sort data, or add a pivot table.
- Filtering: Create or clear filters.
For example, you can now use natural language for complex data cleaning tasks, like asking Gemini to "Replace 'Software' and 'Web Hosting' with 'IT Services' everywhere on the sheet."
These updates make Gemini a more powerful and intuitive partner in Sheets, taking on complex, time-consuming tasks so you can focus on the insights and decisions that matter.
Getting started
- Admins: To access Gemini in Workspace apps, users need to have smart features and personalization turned on. Admins can turn on the 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: Currently available.
Availability
Available for Google Workspace:
- Business Standard and Plus
- Enterprise Standard and Plus
- Google AI Pro for Education
Also available to:
- Google AI Pro and Ultra
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 legacy Gemini Business and Gemini Enterprise add-ons for sale. Please refer to this announcement for more details.
Resources
- Google Help: Collaborate with Gemini in Google Sheets
- Google Help: Use table references in Google Sheets
- Oct 14, 2025
- Date parsed from source:Oct 14, 2025
- First seen by Releasebot:Jan 18, 2026
The AI function in Google Sheets is now enhanced with Google Search results for more up-to-date answers
Google Sheets adds a grounded AI function that uses Google Search for up-to-date web results, expanding languages and enabling real time data like box office, sentiment, and weather directly from cells.
Earlier this year, we announced AI function in Sheets to help you generate text, summarize information, categorize data, and analyze sentiment at scale, directly from any cell in your spreadsheet. Last month, we expanded feature availability to seven additional languages.
Now, we're making AI function even more powerful by automatically grounding it in results from Google Search, so it can access up-to-the-minute information from the web to answer your prompts.
For example, you can now use the AI function to find the daily box office schedule for newly released movies, track the daily market sentiment for a new product launch, or get the latest weather information as you plan an upcoming vacation.
Getting started
- Admins: This feature will be available by default to users with Gemini in Sheets enabled. Use our Help Center to learn more about managing access to Gemini features in Workspace services.
- End users: This feature will be available by default for users with access to Gemini in Sheets. Use our Help Center to learn more about using the AI function in Google Sheets.
Rollout pace
- Rapid & Scheduled Release domains: Gradual rollout (up to 15 days for feature visibility) starting on October 15, 2025.
Availability
Available for Google Workspace:
- Business Standard and Plus
- Enterprise Standard and Plus
- Google AI Ultra for Education
Also available to:
- Google AI Pro and Ultra
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.
Resources
- Google Help: Use the AI function in Google Sheets
- Workspace Updates Blog: Generate data with Gemini in Google Sheets
- Oct 6, 2025
- Date parsed from source:Oct 6, 2025
- First seen by Releasebot:Jan 18, 2026
Looker Connected Sheets Private IP support
Looker extends Connected Sheets to Private IP Core instances, letting teams analyze Looker data in Sheets despite IP restrictions. Admins enable the feature; users connect via Data Connectors in Sheets. Rapid rollout starts Oct 6, 2025 across Google Workspace and personal accounts.
Organizations who have configured private IP Looker Core instances can now enable Connected Sheets for their teams, bringing easier analysis and sharing capabilities to their users. Now, the users who were previously restricted from using Connected Sheets due to Private IP controls on their Looker instances will be able to leverage powerful and intuitive spreadsheet capabilities to better understand and analyze their Looker data.
Getting started
- Admins: Looker Connected Sheets must be enabled by an admin before it works. Visit the Help Center to learn more about enabling Connected Sheets for Looker.
- End users: This feature will be available by default as configured by your admin. To connect to Looker Private IP instances, just copy your instance ID in Looker and use it to connect in Sheets via Data > Data Connectors > Connect to Looker. Visit the Help Center to learn more about using Connected Sheets for Looker.
Rollout pace
- Rapid and Scheduled Release domains: Gradual rollout (up to 15 days for feature visibility) starting on October 6, 2025.
Availability
- Available to all Google Workspace customers, Workspace Individual Subscribers, and users with personal Google accounts
Resources
- Google Help: Using Connected Sheets for Looker
- Sep 25, 2025
- Date parsed from source:Sep 25, 2025
- First seen by Releasebot:Jan 18, 2026
Configure up to 20 conditional notifications per Google Sheet
Google Sheets conditional notifications now support up to 20 rules per spreadsheet, up from 10. The feature is live for supported Workspace editions and can be enabled via Tools > Conditional Notifications. Admins: on by default; end users: on by default.
Update (Oct 16): We updated the "Availability" section of this post to reflect the accurate edition availability for the feature. Previously, some editions were listed incorrectly.
What’s changing
Last year we introduced conditional notifications in Google Sheets, which allow users to create custom rules in spreadsheets that send email notifications when certain criteria are met. Now we are expanding rule limits for conditional notifications from 10 to 20 rules per spreadsheet. For example, users can choose to be notified when a given task’s status changes or when they are added as an assignee. By expanding the rule limit per spreadsheet, users can take advantage of the feature more frequently and for a wider range of use cases.
Users can customize up to 20 rules that outline the criteria for when an email is sent
When rule conditions are met, recipients will receive emails informing them of the change
Getting started
- Admins: This feature will be on by default. There is no admin control for this feature.
- End users: This feature will be available by default. To use it, go to Google Sheets > Tools > Conditional Notifications and configure up to 20 new rules. Use our Help Center to learn more about using conditional notifications.
Rollout pace
- This feature is available now.
Availability
Available to Google Workspace:
- Business Standard, Plus
- Enterprise Starter, Standard, Plus
- Education Plus
- Enterprise Essentials
Resources
- Google Help: Use conditional notifications
- Sep 24, 2025
- Date parsed from source:Sep 24, 2025
- First seen by Releasebot:Jan 18, 2026
Gemini in Google Sheets now provides smarter, more conversational formula generation
Gemini in Google Sheets now offers detailed natural language explanations for formulas, error explanations with self‑correction, and multiple formula options. This smarter, self‑checking assistant helps users understand and build complex sheets with faster, more reliable results.
Earlier this year, we made it easier to generate charts and insights using Gemini in Google Sheets. Building on that momentum, we’re excited to announce a significant enhancement to formula generation in Gemini for Sheets. Specifically, we've upgraded Gemini to include detailed natural language formula explanations, provide formula error explanation and self-correction, and to output multiple formula options.
With these updates, Gemini can provide a full, reasoned response, making formula generation smarter and more resilient, and helping users to understand the formulas and calculations happening in their sheets.
Detailed natural language formula explanations:
Complex formulas can now be returned with step-by-step explanations of how they work. This improves user understanding and builds trust, making it easier to learn and adapt formulas for future use. If Gemini doesn’t provide an explanation as part of the response, you can always ask in your next query how the generated formula works.Error explanation and self-correction:
Gemini can now explain why a formula failed (e.g., "the date in A1 is formatted as text") and, in a follow-up turn, use the error message to generate a corrected formula that solves the underlying issue.Multiple formula options:
For more complex tasks or when there are several ways to achieve a result, Gemini can now provide multiple formulas.
Getting started
- Admins: To access Gemini in Workspace apps, users need to have smart features and personalization turned on. Admins can turn on the 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
- This update is already available for all Gemini users.
Availability
Available for Google Workspace:
- Business Standard and Plus
- Enterprise Standard and Plus
- Google AI Pro for Education
Also available to:
- Google AI Pro and Ultra
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.
Resources
- Google Help: Collaborate with Gemini in Google Sheets
- Google Help: Use table references in Google Sheets
- Sep 23, 2025
- Date parsed from source:Sep 23, 2025
- First seen by Releasebot:Jan 18, 2026
Generate data with AI function in Sheets now available in seven additional languages
Google Sheets gains Gemini powered AI in seven languages to generate text, summarize, categorize, and analyze sentiment directly in cells. Rolling out to Workspace users with Gemini in Sheets across Rapid and Scheduled releases, with gradual visibility through late 2025.
What’s changing
Earlier this year, we announced AI function in Sheets. You can use the AI function to prompt Gemini to generate text, summarize information, categorize data, or analyze sentiment at scale with generated content appearing directly in the cells you choose. Now, AI function is available to users in Spanish, Portuguese, Japanese, Korean, French, Italian, and German.
Getting started
- Admins: This feature will be available by default to users with Gemini in Sheets enabled. Use our Help Center to learn more about managing access to Gemini features in Workspace services.
- End users: This feature will be available by default for users with access to Gemini in Sheets using Spanish, Portuguese, Japanese, Korean, French, Italian, or German. Use our Help Center to learn more about using the AI function in Google Sheets.
Rollout pace
- Rapid Release domains: Gradual rollout (up to 15 days for feature visibility) starting on September 23, 2025.
- Scheduled Release domains: Gradual rollout (up to 15 days for feature visibility) starting on October 6, 2025
Availability
Available for Google Workspace:
- Business Standard and Plus
- Enterprise Standard and Plus
- Google AI Ultra for Education
Also available to:
- Google AI Pro and Ultra
- 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.
Resources
- Google Help: Use the AI function in Google Sheets
- Workspace Updates Blog: Generate data with Gemini in Google Sheets
- Sep 10, 2025
- Date parsed from source:Sep 10, 2025
- First seen by Releasebot:Jan 18, 2026
Understand changes more quickly with condensed version history in Sheets
Google Sheets adds a condensed version history that shows only changed rows by default for faster edits review. Full history is still available via Show unmodified rows; some embedded objects may not display. Available to all Google accounts and Workspace users as part of the rollout.
We are introducing a new condensed view for version history in Google Sheets. By default, Sheets will now only show rows with cells that had changes in the selected version. The condensed version history will help users identify relevant edits to the sheet more quickly and efficiently.
Version history is a tool which can help users recover information, understand changes, or see who made a specific edit to a spreadsheet. To return to the previous version history experience, where the entire sheet is displayed and the cells with changes are highlighted, simply select the checkbox to “Show unmodified rows”. Note: some embedded objects, like images, may not display when the condensed view is on.
The new condensed view in version history, which only shows rows with cells that had changes in the selected version
Sheets with no changes made in the selected revision will automatically hide all rows, unless the setting is unselected.
The expanded view of version history, which shows all rows. This is still available by selecting the ‘show unmodified rows’ option within version history.
Getting started
- Admins: There is no admin control for this feature.
- End users: The condensed version history will be ON by default. The previous experience will still be available by clicking the ‘Show unmodified rows’ option when looking at the version history. Use our Help Center to learn how to see earlier versions of a file.
Rollout pace
- Rapid Release domains: Gradual rollout (up to 15 days for feature visibility) starting on September 9, 2005.
- Scheduled Release domains: Full rollout (1–3 days for feature visibility) starting on September 23, 2025.
Availability
- Available to all Google Workspace customers, Workspace Individual Subscribers, and users with personal Google accounts
Resources
- Google Help: Find out what's changed in a file
- Aug 27, 2025
- Date parsed from source:Aug 27, 2025
- First seen by Releasebot:Jan 18, 2026
Gemini in Google Sheets helps you create dynamic and easily referenced tables
Gemini powers new Smart Tables in Google Sheets. Converting data to a table auto-formats, names tables, and enables dynamic, readable table references for self-updating formulas. Rolling out across Workspace plans with gradual visibility.
What’s changing
Building on the introduction of intelligent suggestions for table conversion, we’re now using Gemini to make tables in Sheets even more useful. Now, when you accept a “Convert to table” suggestion, Gemini will automatically format your data as a table and create a meaningful table name (e.g., Project_Status).
Tables help organize your data, simplifying common tasks like sorting and filtering. They also enable the use of table references, which use the table's meaningful name in place of cell coordinates. For example, a formula like =SUM(E2:E15) becomes the more descriptive =SUM(Office_Expenses[Amount]). These names are not only easier to read and understand, but they are also easier to write, appearing in formula autocomplete suggestions as you type.
Crucially, table references are dynamic. The formula's range automatically expands and contracts as you add or remove rows from your table, ensuring your calculations are always up to date and accurate, without you ever needing to manually edit cell ranges again.
Getting started
- Admins: To access Gemini in Workspace apps, users need to have smart features and personalization turned on. Admins can turn on the personalization setting for their users in the Admin console.
- End users:
- This feature will be on by default and can be disabled by going to Tools > Suggestion controls > (deselect) Enable table suggestions.
- Visit the Help Center to learn more about using tables in Google Sheets.
Rollout pace
- Rapid Release domains: Gradual rollout (up to 15 days for feature visibility) currently underway
- Scheduled Release domains: Gradual rollout (up to 15 days for feature visibility) starting on September 12, 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 AI Pro and Ultra
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.
Resources
- Google Help: Collaborate with Gemini in Google Sheets
- Google Help: Use tables in Google Sheets
- Google Help: Use table references in Google Sheets
- Google Workspace Updates Blog: New ways to quickly format and organize data with Tables in Google Sheets
- Aug 21, 2025
- Date parsed from source:Aug 21, 2025
- First seen by Releasebot:Jan 18, 2026
Effortlessly work with ServiceNow data across Google Chat and Sheets
ServiceNow unveils Google Chat and Sheets integrations, letting the Virtual Agent chat inside Google Chat and export data directly to Sheets. Admin setup requires Yokohama patch 6 and OAuth configuration; end users can export with a few clicks. Ready now for Google Workspace customers.
What’s changing
ServiceNow, a platform that helps unite people, processes, and systems with AI-powered products for all of their workflows, is now integrated with Google Chat and Sheets.
With the ServiceNow and Google Chat integration, users are now able to interact directly with ServiceNow's Virtual Agent within Google Chat. They can use natural language to resolve issues, get things done, get fast and automated help and support, and seamlessly transition to a live support agent without ever leaving the chat window. See more: Conversational Integration with Google Chat app in the ServiceNow Store and ServiceNow Community.
With the ServiceNow and Google Sheets integration, users can bypass manual file downloads and uploads and export data from ServiceNow directly into Sheets. In addition to streamlining the data export process, this new functionality enhances data accessibility and enables users to leverage Sheets’ powerful data management and visualization features.
Getting started
Admins:
- Google Chat:
- Admins will need to install the integration from the ServiceNow store. See details here. Note: To install the integration, customers must be on ServiceNow's Yokohama patch 6 release or later.
- Google Sheets:
- All the configuration steps must be followed by the ServiceNow admin to set up authentication. Visit the Set up OAuth application on the Google Sheets API and Configure ServiceNow connection and credential aliases for Google Sheets resource for more information.
End users:
- Google Chat:
- In a new chat, enter your domain’s app name and select it.
- If an automated welcome message displays in the chat window, you are all set to use Google Chat with Virtual Agent. Visit the ServiceNow Virtual Agent Documentation for more information.
- Google Sheets: On the ServiceNow platform:
- Navigate to any list from the All menu.
- In the column menu for the list, click Export > Google Sheets. If you don’t see this option in the list column menu, contact your admin.
- Follow the authentication steps to ensure your Google account access.
- Note: You’ll only need to follow the authentication steps the first time you export to Google Sheets and after your authentication session has timed out (as set by your administrator).
- Visit the ServiceNow Documentation on Exporting table records to Google Sheets for more information.
Rollout pace
- Rapid Release and Scheduled Release domains: Available now.
Availability
- Available to all Google Workspace customers, Workspace Individual Subscribers, and users with personal Google accounts
Resources
- Administer the ServiceNow AI Platform
- Exporting table records to Google Sheets
- Set up OAuth application on the Google Sheets API
- Configure ServiceNow connection and credential aliases for Google Sheets
- Create an application registry for Google Sheets on a ServiceNow instance
- ServiceNow Virtual Agent Documentation
- Documentation for the Conversational Integration with Google Chat app in the ServiceNow Store