Google Sheets Updates & Release Notes

You can now easily identify critical irregularities and outliers in your time-series data when using Connected Sheets to analyze BigQuery data sets from Google Sheets. Anomaly detection in Connected Sheets allows users to distinguish between expected trends and true outliers without requiring manual model training or complex SQL knowledge.

Powered by BigQuery ML and TimesFM, this capability delivers "zero-shot" analysis, meaning you can uncover actionable AI insights immediately—no need to configure or wait for a model to be trained on your data. Anomaly detection also builds upon our recently introduced forecasting feature to provide a more comprehensive suite of predictive tools right where you already work.

Key features include:

• Easy, SQL-free configuration: A user-friendly side panel guides you through configuring your anomaly detection analysis without writing a single line of SQL.
• Clear, built-in formatting: Results are cleanly rendered with new columns for is_anomaly (a boolean indicator) and lower_bound / upper_bound intervals to help you quickly sort, filter, and interpret the findings.
• Customizable thresholds: Take control of your analysis by setting a specific time period, anomaly probability threshold (defaulting to 0.95), and filtering input data
• Automated refresh ability: Just like other Connected Sheets objects, your anomaly detection extracts can be scheduled to refresh automatically, ensuring your insights are always current.

Getting started

• Admins: There is no admin control for this feature.
• End users: Access to anomaly detection in Connected Sheets requires permissions to a BigQuery project with billing enabled.

Rollout pace

• Rapid Release and Scheduled Release domains: Available now

Availability

• Available to all Google Workspace customers and users with personal Google accounts

Resources

• Google Help: Use BigQuery ML in Connected Sheets

We’re excited to introduce new Gemini in Sheets capabilities that enable you to build and edit entire spreadsheets using simple natural language.

Whether you need a quick view of your small business's financial health or a complex project tracker, Gemini in Sheets orchestrates the multi-step construction from start to finish. Workspace Intelligence synthesizes data across your files, emails, chats, and the web to help you visualize your data with stylized tables, formulas, pivot tables, and charts.

Gemini in Sheets can handle complex, multi-step tasks that previously required expert-level knowledge of Sheets. For example, you can ask Gemini to do end-to-end creation to "build a P&L dashboard leveraging my historic service incidents and rate cards," or do side-by-side editing to “add scorecards and bar charts above my sales and inventory data”. Gemini will synthesize relevant information, construct a plan for your approval, and then build out the entire formatted spreadsheet.

Key capabilities include:

• End-to-end creation: Build entire spreadsheets from a single prompt, including data retrieval and formatting.
• Side-by-side editing: Refine and update existing models, budgets, or analysis directly in the side panel.
• Workspace Intelligence: Automatically pull context and data from other Workspace apps to ensure your spreadsheet is accurate and relevant.
• Advanced task fulfillment: Leverages Sheets’ most powerful tools, like pivot tables and complex formulas, without requiring manual configuration.
• Advanced optimization: Handle complex optimization problems that typically require complex manual formulas or third-party tools. Powered by research from Google DeepMind and Google Research OR-Tools.
• State-of-the-art performance: Gemini in Sheets achieved a 70.48% success rate in autonomously manipulating complex, real-world spreadsheets on the full SpreadsheetBench dataset, nearing human expert ability.

Getting started

• Admins: This feature is available by default if Gemini for Workspace in Sheets is enabled. Note that enabling Workspace Intelligence expands the range of supported use cases.
• End users: You must have Workspace smart features enabled to take advantage of these features. Eligible users will see the Gemini icon in the Sheets side panel. Simply describe the spreadsheet or edit you need to begin collaborating. Visit the Help Center to learn more about building and editing spreadsheets with Gemini in Sheets.

Note: Through July 15, 2026, Workspace customers will get promotional access to higher limits for the improved Gemini in Sheets experience, allowing users to experiment with this feature. Users will see a notification when they use this feature, informing them of the promotional access period. Per-user usage limits will apply after July 15; we’ll provide more information in the Help Center in advance of updated usage limits going into effect.

Rollout pace

• Rapid Release domains: Gradual rollout (up to 15 days for feature visibility) starting on April 22, 2026
• Scheduled Release domains: Gradual rollout (up to 15 days for feature visibility) starting on May 6, 2026

Availability

• Business: Business Standard and Plus
• Enterprise: Enterprise Standard and Plus
• AI Add-ons: AI Expanded Access*; AI Ultra Access*; Google AI Pro for Education
• Consumer: Google AI Pro and Ultra

*Once promotional limits are no longer in effect, users with AI Expanded Access and AI Ultra Access add-on licenses will have higher limits on usage of Gemini in Sheets.

Resources

• Google Help: Build or edit entire spreadsheets with Gemini in Sheets
• Google Workspace Blog: Introducing Workspace Intelligence
• The Keyword: Gemini in Google Sheets just achieved state-of-the-art performance
• Workspace Updates Blog: Introducing Workspace Intelligence, with admin controls

We're excited to introduce a new AI-powered feature in Google Sheets that allows you to transform unstructured text into organized tables.

Manually formatting and organizing unformatted data in spreadsheets can be a tedious, time-consuming task. Now, when you paste content like bulleted lists, freeform text, or JSON we surface a “Convert to table” button which leverages Gemini to turn your pasted content into a table with just a single click. This helps to streamline data entry so you can move to analysis faster.

Getting started

• Admins: This feature is an additional entry point to existing AI table generation functionality. This feature will be hidden if the Smart features for Google Workspace setting is disabled. Visit the Help Center to learn more about setting smart features controls on or off for users.
• End users: You must have Workspace smart features enabled to use this feature. This feature will be ON by default for eligible users. To use it, simply paste text into a Sheet; if the content is suitable, a "Convert to Table" prompt will appear. Visit the Help Center to learn more about collaborating with Gemini in Google Sheets.

Rollout pace

• Rapid Release domains: Gradual rollout (up to 15 days for feature visibility) starting on April 22, 2026
• Scheduled Release domains: Gradual rollout (up to 15 days for feature visibility) starting on May 6, 2026

Availability

• Business: Business Standard and Plus
• Enterprise: Enterprise Standard and Plus
• Education: Google AI Pro for Education
• Consumer: Google AI Pro and Ultra

Resources

• Google Help: Collaborate with Gemini in Google Sheets

We're introducing Fill with Gemini in Google Sheets, a new AI-powered feature designed to make data preparation and manual entry even easier. Fill with Gemini infers your intent, allowing you to populate data 9x faster than manual entry for 100-cell tasks.*

Whether you need to extract information from the web or categorize existing data, Fill with Gemini handles the heavy lifting, eliminating the need for complex formulas. For example, a marketing team can use it to automatically generate suggested responses based on customer feedback messages, or a small business owner could use it to quickly fill out product details just by describing what they need.

Fill with Gemini offers two ways to enrich your data, saving you time and effort:

• Drag-and-drop: If your column has at least one completed cell, you can use a new drag entry point to fill the column based on the context of the table.
• Prompt-based filling: For empty multi-cell selections, you can use a one-click entry point to "Fill" the range. You can either automatically fill cells when a column has at least one completed cell or write a custom prompt to fit your specific needs.

*Data based on a 95-participant study comparing manual entry against Fill with Gemini on a 100-cell task.

Getting started

• Admins: This feature is an entry point to the existing AI function. It will be hidden if the Smart features for Google Workspace setting is disabled. Visit the Help Center to learn more about managing Google Workspace smart features for your users.
• End users: You must have Workspace smart features enabled to use Fill with Gemini. This feature will be ON by default for eligible users. Users can trigger Fill with Gemini by dragging a selection or selecting empty cells to see the prompt menu. Visit the Help Center to learn more about filling columns with Gemini.

Note: Through July 15, 2026, Workspace customers will get promotional access to higher limits for AI function in Google Sheets, allowing users to experiment with these features. Per-user usage limits will apply after that date; we’ll provide more information in the Help Center in advance of updated usage limits going into effect.

Rollout pace

• Rapid Release domains: Gradual rollout (up to 15 days for feature visibility) starting on April 22, 2026
• Scheduled Release domains: Gradual rollout (up to 15 days for feature visibility) starting on May 6, 2026

Availability

• Business: Business Standard and Plus
• Enterprise: Enterprise Standard and Plus
• AI Add-ons: AI Expanded Access*; AI Ultra Access*; Google AI Pro for Education
• Consumer: Google AI Pro and Ultra

*Once promotional limits are no longer in effect, users with AI Expanded Access and AI Ultra Access add-on licenses will have higher limits on usage of AI function in Google Sheets.

Resources

• Google Help: Use the AI function in Google Sheets
• Google Admin Help: Set smart features & controls on or off for users

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

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

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

What’s changing

Currently, you can utilize Gemini in Google Sheets to generate charts and valuable insights, and today we’re excited to bring AI directly into the cells of your spreadsheet with the power of AI function.

From a cell, you can now input a specific prompt describing what you would like to do and an optional data range, and Gemini can do the following:

• Use relevant information from your spreadsheet to generate text tailored to your specific data.
• Summarize information by analyzing the content of your spreadsheet and highlighting the most important parts, so you can quickly understand your data.
• Categorize your data into meaningful groups, so you can easily detect patterns, such as user sentiment.

Examples of usage

Here are some examples of how you’d use this feature:

• Text generation:

  • =AI("Write a formal ad copy for the product. Cater copy to the objective and target audience", A2:C2)
  • =AI("Create an email to the reviewer addressing specific items in their reviews.", A2:G2)

• Summarization:

  • =AI("For the customer, write a one sentence summary of their feedback.", A2:D2)
  • =AI("You are the owner of a pet sitting business. Write a 2 sentence summary for the customer about their pet’s last stay. Be a little funny.", F2)

• Categorization:

  • =AI("Categorize the customer inquiry as a compliment, exchange request, or return request.", C2)
  • =AI("Perform sentiment analysis on the emails sent by the customers to the barbershop.", C2)

If you want to refer to two ranges that aren’t contiguous, you can use concatenation in the prompt. Here are a few examples:

• =AI("Write a review of the hot sauce " & A2 & " using only the ingredients " & D2 & " and the popularity " & E2 & ".", A2:D2)
• =AI("Find the major themes in the customer feedback of " & B2 & " using the rating " & C2 & " and comments: " & D2 & ".", )

(Note: The second example references a single range; ensure you pass the correct ranges as needed.)

Who’s impacted

• End users

Why you’d use it

Now you can create hundreds of rows of data quickly to do things like categorize user feedback requests or write personalized emails, all without being an expert in data or spreadsheets. Regardless of your data needs, with instant access to Gemini from any cell in your Sheet, the AI function helps you get work done faster.

Additional details

• We currently support text-based responses for text generation, summarization, categorization, and sentiment analysis queries. While the input information is optional, we recommend using it for optimal results.
• After generating, if an explicitly referenced cell or the prompt is updated, the cell shows an out-of-sync state, and keeps the previous output for reference.
• To refresh a cell, you can select one or multiple cells and press “refresh and insert.”
• You can select multiple cells with AI functions and generate outputs; however, only the first 200 selected cells with AI functions will be generated. You can wait for the generation to complete and select more cells to generate outputs.

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 using the AI function in Google Sheets and collaborating with Gemini in Sheets.

Rollout pace

• Rapid Release domains: Extended rollout (potentially longer than 15 days for feature visibility) starting on June 25, 2025
• Scheduled Release domains: Gradual rollout (up to 15 days for feature visibility) starting on July 22, 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 the AI function in Google Sheets

What’s changing

=ISURL() and =ISEMAIL() are two Google Sheets functions that check whether a value is a valid URL or email address, respectively. To ensure more domains and email addresses are properly recognized by these functions, we’re improving the way they are evaluated. Moving forward, properly formatted email addresses and URLs will more accurately return TRUE when passed through =ISEMAIL() or =ISURL().

Additional details

This change, once fully rolled out, will impact both new uses of these functions as well as existing uses of these functions.

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 =ISURL() and =ISEMAIL().

Rollout pace

• Rapid Release and Scheduled Release domains: Extended rollout (potentially more than 15 days for feature visibility) starting on August 25, 2025

Availability

• Available to all Google Workspace customers, Workspace Individual Subscribers, and users with personal Google accounts

Resources

• Google Help: ISEMAIL
• Google Help: ISURL

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

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