Google Workspace Changes

Doubled row capacity for Connected Sheets pivot tables backed by BigQuery.

The row capacity for pivot tables backed by BigQuery in Connected Sheets has been doubled from 100,000 to 200,000 rows. This enhancement allows users to analyze substantially larger BigQuery datasets within a single pivot table in Google Sheets.

The AI function in Google Sheets is now enhanced with Google Search results for more up-to-date answers.

The AI function in Google Sheets has been enhanced to automatically ground its responses in Google Search results. This allows the AI function to access up-to-the-minute information from the web to answer user prompts. For example, users can now use the AI function to find daily box office schedules, track market sentiment for new products, or get the latest weather information directly within their spreadsheets.

Increased limit for conditional notifications in Google Sheets to 20.

Google Sheets now allows users to set up to 20 conditional notifications per spreadsheet, significantly increasing the previous limit of 5. This enhancement provides greater flexibility for users to create detailed notification rules that trigger alerts based on specific changes within their spreadsheet data, improving data monitoring and responsiveness.

Google Sheets introduces a new condensed view for version history, displaying only rows with changes for quicker edit identification.

Google Sheets is rolling out a new condensed view for its version history feature. By default, this view will now only display rows containing cells that have undergone changes in the selected version. This enhancement aims to help users identify relevant edits within a spreadsheet more quickly and efficiently. Users can revert to the previous full version history view by selecting the 'Show unmodified rows' checkbox, which will highlight changes across the entire sheet.

Gems, custom AI experts, are now available directly in the side panel of Google Sheets, allowing users to leverage customized AI assistance without switching applications.

Gems, which are custom AI experts designed to help complete specific goals, tasks, and workflows, are now integrated directly into the side panel of Google Sheets. This integration allows users to utilize both custom and pre-made Gems, such as a writing editor or sales pitch ideator, within the Google Sheets application. The feature aims to enhance efficiency by minimizing repetitive prompting and enabling tailored AI assistance for various tasks like creating content, generating sales interactions, or reviewing documents, all without needing to navigate away from the current application.

New AI function in Google Sheets allows users to generate text, summarize, and categorize data directly within cells.

Google Sheets now integrates a new AI function, powered by Gemini, enabling users to perform various data manipulation tasks directly within spreadsheet cells. This includes generating tailored text using spreadsheet information, summarizing data by highlighting key parts, and categorizing data into meaningful groups to detect patterns. This feature aims to help users create hundreds of rows of data quickly, such as categorizing user feedback or writing personalized emails, without needing extensive data or spreadsheet expertise.

Support for file and people smart chips is now available with the Google Sheets API.

The functionality of the Google Sheets API has been extended to include the ability to write and read file and people smart chips. This enhancement allows developers to programmatically interact with these rich data types within Google Sheets, further integrating and automating workflows.

Gemini in Google Sheets now supports more languages.

Gemini in Google Sheets can now provide insights and generate charts based on data in Spanish, Portuguese, Japanese, Korean, Italian, French, and German. This allows users to analyze data and identify trends without writing code.

Direct access to BigQuery saved queries in Connected Sheets.

Users can now quickly and easily create a new Connected Sheet by selecting a previously saved query under any project they have access to.

API support for tables in Google Sheets is now available, allowing users to create and modify tables via the Sheets API.

Following the improvements made to tables in Google Sheets in March and April, we’re excited to introduce API support for tables. Now, users will be able to take basic actions to create and modify tables via the Sheets API.

Google Sheets will display a badge when a file is owned by or shared with someone outside of your domain.

Google Sheets files will now display a badge when the file is owned by or shared with someone outside of your domain. A pop-up will also provide more details and the option to report the externally owned file for abuse. This feature helps users identify potentially risky files and avoid phishing scams.

Out-of-Domain file warnings for Google Sheets files.

Google Sheets will display a badge when a file is owned by or shared with someone outside of your domain. This helps users identify potentially risky files and avoid phishing scams.

Users can now easily add multiple people chips in a Google Sheets cell.

The ability to easily add multiple people chips in a Google Sheets cell has been added.

Connected Sheets users can create custom groupings for numeric chart values.

Connected Sheets users can now create custom groupings for numeric values in a chart. Users can control the minimum and maximum value of the buckets and the interval size of the bucket.

Create custom chart groupings in Connected Sheets

Connected Sheets users can now create custom groupings for numeric values in a chart. Users can control the minimum and maximum value of the buckets and the interval size of the bucket. This improves the experience of using Connected Sheets to visualize a large amount of data.