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.

What’s changing

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.

Part of the upload dialog when users choose to import a file to BigQuery via the Google Sheets interface

Users with appropriate permissions will also see a new option to import with Connected Sheets when a file is too large for native upload to Sheets

Getting started

Rollout pace

Availability

Resources

What’s happening

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.

Automatically create a pre-configured extract to drill down into any pivot table aggregated cell

Getting started

Rollout pace

Availability

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

Resources

What’s changing

We’re excited to announce that client-side encrypted (CSE) files including Google Docs, Sheets and Slides now support emoji reactions. Users can use emojis to react to comments and content, bringing an expressive collaboration feature to CSE files. 

This update brings a core Google Workspace feature into our secure CSE framework, allowing users to provide quick feedback, express agreement, or acknowledge updates. Teams can now work together more efficiently and expressively, while still benefiting from the robust security of client-side encryption.

Emoji reactions are fully integrated in CSE documents. Users can add, resolve, delete, and re-open emoji reactions, and these reactions are also surfaced in a file’s version history. Reactions are preserved during export or when editing a Microsoft Office file in Workspace. They are also preserved when additional encryption is added to or removed from a file.

Emoji reactions to content and comments in a CSE Doc

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 emoji reactions.

Rollout pace

• Rapid Release domains: Full rollout (1–3 days for feature visibility) starting on October 21, 2025
• Scheduled Release domains: Gradual rollout (up to 15 days for feature visibility) starting on November 1, 2025

Availability

Available for Google Workspace

• Enterprise Plus
• Education Standard and Plus
• Frontline Plus

Resources

• Google Help: Use comments, action items, & emoji reactions
• Google Help: Collaborate on encrypted files in Docs, Sheets & Slides
• Google Help: Get started with encrypted files in Drive, Docs, Sheets & Slides

 What’s changing

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:

1. 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. 
2. 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.
3. 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. 
4. 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?"

Prompt: “Generate a formula that fills the column next to due date that looks up the assigned teammate based on task id” 

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.
• 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

What’s changing 

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. 

1. 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. 

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 

Availability 

Available for Google Workspace: 

Also available to: 

Anyone who previously purchased these add-ons will also receive this feature: 

Resources 

What’s happening 

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 

Rollout pace 

Availability 

Available for Google Workspace: 

Also available to: 

Anyone who previously purchased these add-ons will also receive this feature: 

Resources 

What’s changing 

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, 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 

Rollout pace 

Availability 

Resources 

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 

Rollout pace 

Availability 

Available to Google Workspace:

Resources 

What’s changing 

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. 

1. 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. 

2. 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. 

3. 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 

Rollout pace 

Availability 

Available for Google Workspace: 

Also available to: 

Anyone who previously purchased these add-ons will also receive this feature: 

Resources 

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 

Rollout pace 

Availability 

Available for Google Workspace: 

Also available to: 

Resources 

What’s changing 

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 

Rollout pace 

Availability 

Available for Google Workspace: 

Anyone who previously purchased these add-ons will also receive this feature: 

*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 

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: 

End users: 

Rollout pace 

Availability 

Resources 

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 

Rollout pace 

Availability 

Resources 

Update

[July 8, 2025]: We have updated the Rollout section with the latest timelines -- please see below for more information.

What’s changing

Currently, when you’re using the Gemini app, you can use Gems, custom AI experts that can help you complete specific goals, tasks, and workflows based on your input. You can also take advantage of pre-made Gems as well, like writing editor, coding partner, sales pitch ideator, and more. 

Today, we’re bringing the power of Gems directly into the side panel of Google Docs, Slides, Sheets, Drive, and Gmail.

Resources

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: 

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 Al function helps you get work done faster. 

Additional details 

Available for Google Workspace: 

Resources