Google Workspace Changes

Set custom table ranges for charts in Google Sheets

Improving the way data is suggested and how data is selected when creating a chart in Google Sheets. Allowing to select which columns to use for the chart axis and series

Sort and filter cells by text or fill color in Google Sheets

Added two additional parameters to filter and sort cells by in Google Sheets: Text color and Fill (background) color.

Retirement of the Sheets v3 API and migration to v4 API.

Google is retiring the Sheets v3 API and requiring developers to migrate their applications to the v4 API. Following several timeline extensions, the final turndown of all components of the v3 API is scheduled for August 2, 2021.

Update to Sheets API v4 migration timeline

Extending the timeline to allow developers additional time to migrate their applications from Sheets v3 API to the v4 API.

Break out a single value within a pie chart in Google Sheets

Google Sheets now allows users to highlight a specific slice of a pie or donut chart by 'pulling it out,' providing more control over chart aesthetics and better visibility for the most important data points.

Break out a single value within a pie chart in Google Sheets

You can now “pull out” and highlight a slice from a pie or donut chart in Google Sheets. This feature gives you more ways to control the look of your charts and better display the most important data in Sheets.

Data Connector for Zendesk is now available as an add-on for Google Sheets.

Google has introduced a new data connector add-on for Google Sheets that enables users to import and analyze data from Zendesk. This tool allows organizations to configure query configurations, search for Zendesk tickets, list metrics, and refresh query results directly within a spreadsheet using the Zendesk API.

Google launches a 'Getting Started with Google Sheets' course on Coursera.

Google has introduced a 'Getting Started with Google Sheets' course on Coursera, designed for new users, onboarded employees, and students to learn how to organize information and analyze data. The course is free for all users, with an optional paid tier for access to additional content, projects, quizzes, and a course certificate.

Directly click on chart elements to move and delete them in Google Sheets

Google Sheets has introduced new features allowing users to easily customize charts by clicking directly on data labels, chart titles, or legends to drag and reposition them, or delete them using the delete or backspace keys. Additionally, the update includes keyboard navigation support (using Tab, Enter, Escape, and Arrow keys) and screen reader verbalization for chart elements to improve accessibility.

Goal Seek add-on now available for Google Sheets

The Goal Seek add-on for Google Sheets is now available for download and installation from the G Suite Marketplace. This tool allows users to calculate the required value of a cell to achieve a desired value in another cell, which is particularly useful for conducting break-even analysis or sensitivity calculations.

Retirement of the Sheets v3 API

Google is retiring the Sheets v3 API and requiring users to migrate their apps to the Sheets v4 API to ensure continued functionality. After several extensions, the final turndown date for all components of the v3 API is August 2, 2021.

Accessibility settings are now easier to access on Sheets

It’s now easier to discover accessibility features like screen reader support, braille support, and screen magnifier support in Sheets. This change will make these settings more readily available by placing the Accessibility settings in the Tools menu.

New integration allows direct import of SAP ERP content into Google Sheets.

In an upcoming SAP release, employees will be able to import ERP content directly into Google Sheets, removing the need to manually export data to CSV files and upload them to Drive, allowing for faster analysis using tools like intelligent pivot tables and macros.

Expanded Braille support for Google Sheets on Windows computers via JAWS and NVDA screen readers.

Google Sheets is expanding its accessibility features by adding Braille support for Windows computers using the latest versions of JAWS and NVDA screen readers. Users with Braille displays can now read and edit cell contents and navigate between cells. This update complements existing Braille support on Chrome OS (via ChromeVox) and Mac (via VoiceOver), ensuring a more inclusive experience across different operating systems and browsers.

Enhanced control over chart data labels, including totals for stacked charts and customizable placement.

Google Sheets is introducing new features to improve how charts represent data. Users can now add total data labels to stacked charts to display the sum of all content in a data set. Additionally, new alignment options for data labels have been added for column, bar, line, point, and area charts, allowing users to position labels in locations such as Center, Inside end, Inside base, Outside end, Left, Right, Above, or Below.