Google Workspace Changes

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.

Group by view aggregation is now available for tables in Google Sheets.

When using tables in Google Sheets, you’ll have access to our new type of view, group by, where you can aggregate your data into groups based on a selected column. This week, we’re excited to introduce the ability to apply column-level aggregations when in a group by view.

Introduce the ability to apply column-level aggregations when in a group by view in Google Sheets.

Introduce the ability to apply column-level aggregations when in a group by view.

Easily add multiple people chips in a Google Sheets cell

Following up on our recent announcement of easily converting data to people chips in Google Sheets, we’re excited to announce that users can now seamlessly convert cells with multiple emails to people chips.

Users can now seamlessly convert cells with multiple emails to people chips in Google Sheets.

Users can now seamlessly convert cells with multiple emails to people chips.

Gemini in the side panel of Google Sheets now supports Greek, Catalan, Indonesian, and Malay.

Gemini in the side panel of Google Sheets can be used in four additional languages: Greek, Catalan, Indonesian, and Malay.

Advanced formatting options for tables in Google Sheets.

Google Sheets has introduced advanced formatting for tables via a new table formatting sub menu. Users can now toggle gridlines, alternating colors, condense view, and include a table footer.