Tag Archives: Google Sheets

Update to Sheets API v4 migration timeline

Quick launch summary 

Earlier this year, we announced the retirement of the Sheets v3 API. At that time, we stated that you’d need to migrate any applications built on the v3 API to the v4 API by March 3, 2020 to ensure they continue working properly.

We’re extending our timeline to allow developers additional time to migrate their applications: 
  • Starting on April 9, 2020, the spreadsheet and spreadsheets.readonly scopes can no longer be used to list a user’s spreadsheets in the v3 API. 
  • On September 30, 2020, the remainder of the v3 API will be turned down.

For information on transitioning your apps, check out our migration guide.

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

Quick launch summary 

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.


Getting started 

End users: This feature is available by default. Visit the Help Center article to learn more about using this feature.

Rollout pace


Availability 


  • Available to all G Suite customers 

Resources 


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

What’s changing 

You can now import and analyze data from Zendesk in Google Sheets with a new data connector. This add-on is now available in the G Suite Marketplace.

Who’s impacted 

End users

Why you’d use it 

Many organizations rely on Zendesk for capturing and taking action on support, customer service, and customer engagement. With the Data Connector for Zendesk, you can use it to configure and save valuable query configurations and load corresponding data into Google Sheets for analysis.


With the add-on, you can search against tickets in Zendesk (and return data to Sheets from that search), list tickets and metrics, load previous searches, and refresh query results already in your spreadsheet.

When creating a new search, you can select the fields you’d like to import to Sheets and set query conditions.

How to get started 

Additional details 

This add-on will use the Zendesk API to extract data into Sheets. At the moment, any changes to the data will not be reflected in Zendesk.

Helpful links 

Availability 

Rollout details 


G Suite editions 
  • Available to all G Suite editions 

On/off by default? 
  • This add-on can be whitelisted at the domain level. This add-on can be installed from the G Suite Marketplace.

Stay up to date with G Suite launches

Learn how to organize and analyze data with Google Sheets on Coursera

Quick launch summary 

You can learn how to organize information and analyze data using the Getting Started with Google Sheets course now available on Coursera. This course is ideal for users who are new to Sheets, such as new employees being onboarded to G Suite, or students looking to sharpen their analytical skills. 

This course is free for all users, or you can pay an additional fee for access to additional content, projects, quizzes and a course certificate. The Getting Started with Google Sheets course will be available in most countries, see here for more information about availability.

Visit the Coursera website to access the Getting Started with Google Sheets course. To find other learning opportunities, visit the Coursera Google Cloud Learning Site.

Stay up to date with G Suite launches

Instantly create new docs, events, spreadsheets and more from your browser

Quick launch summary

You can quickly create new files directly from your browser with “.new” domains for several Google products. For example, you can type “Cal.new” into your browser to create a new Google Calendar event.



The current “.new” domains are:

Availability

Rollout details



G Suite editions

  • Available to all G Suite editions


On/off by default?
  • This feature will be available by default.


Stay up to date with G Suite launches

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

What’s changing 

We’re adding new features that give users more options to easily customize their charts in Google Sheets. Now you can click directly on data labels, chart titles or legends and drag to reposition them. Or you can easily delete these elements using the delete or backspace keys.

Deleting chart elements in Google Sheets

Repositioning chart elements in Google Sheets.

Who’s impacted 

End users

Why you’d use it 

These features give you more ways to control the look and feel of your charts. For example, you can now easily reposition data labels that overlap to avoid clutter and ensure that key data points stand out. Or you can reposition the legend inside the chart area in order to maximize chart space.

How to get started 



Additional details 

When clicking on a group of items (like a set of data labels), the entire group will be selected first. If you want to drill down further (for example, to select an individual data label), simply click again on the specific element.

Note that most chart elements can be repositioned and deleted, except those that derive their position from data. So, you can reposition elements like chart titles or legends, but data points will remain fixed.

Also included in this launch is the ability to navigate through chart elements using your keyboard.

  • Tab: move between elements 
  • Enter: select an individual element from a group 
  • Escape: go back from an individual element to a group 
  • Arrow keys: reposition the selected elements 


For those who use a screen reader, chart elements will be verbalized as you navigate through them.

Helpful links 



Availability 

Rollout details


G Suite editions 

  • Available to all G Suite editions 

On/off by default? 

  • These features will be available by default. 


Stay up to date with G Suite launches

Goal Seek add-on now available for Google Sheets

What’s changing

The Goal Seek add-on for Google Sheets can now be downloaded and installed from the G Suite Marketplace.


Populating and triggering the solve functionality for the Goal Seek add-on.

The Goal Seek add-on running and successfully finding a solution.


Who’s impacted

Admins and end users

Why you’d use it

You can use the Goal Seek add-on to calculate the required value of a cell to achieve a desired value in another cell. This is particularly useful when conducting break-even analysis or sensitivity calculations, like determining how changing one value affects other correlated values in your sheet.

How to get started

Additional details

This add-on is developed in Apps Script and requires making requests via the Sheets API. That means that the API request quota for your domain will be affected and the number of requests that can be made by other App Script projects could be limited. See the Help Center for more information about monitoring API quotas and adjusting the request quota for your domain.

Helpful links

Availability

Rollout details

G Suite editions
  • Available to all G Suite editions

On/off by default?

Stay up to date with G Suite launches

A new look for the Google Docs, Sheets, and Slides Android apps

Quick launch summary 

Google Docs, Sheets, and Slides now have a new look and feel on Android devices. While there are no functionality changes, users will notice visual improvements, including a restyled document list, highly-legible typefaces, consistent controls, and updated iconography.

This redesign is already reflected in the latest versions of the Google Docs and Slides Android Apps. It will begin rolling out to Sheets on Android today.

Screenshots of Google Docs, Slides, and Sheets with the Material redesign.


This Material redesign is part of a larger effort to bring consistency to the look and feel of our G Suite apps, with ease-of-use in mind. See here for more information on the Google Drive Material redesign on iOS and Android and here for the Docs, Sheets, and Slides redesign on the web. 

Availability 

Rollout details 
G Suite editions 
  • Available to all G Suite editions 

On/off by default? 
  • This feature will be ON by default.

Stay up to date with G Suite launches

Migrate your apps to the latest Sheets API by March 2020

Quick launch summary 

We’re retiring the Sheets v3 API on March 3, 2020. To ensure that projects that were originally built on the v3 API continue to work, migrate your apps to the Sheets v4 API before that date. To learn more about this change, see our post on the Cloud blog. For information on transitioning your apps, check out our migration guide.

  Stay up to date with G Suite launches

New fonts intended to help improve reading speed now available in Google Docs, Sheets, and Slides

Quick launch summary

The Google Fonts team has teamed up with Thomas Jockin to create a series of fonts that are aimed at improving reading speed. To learn more about the research behind this initiative, see here for more details.



These fonts take into account typographical factors, such as size and spacing, that the font developers hope will improve reading speed. This can be particularly helpful for educators who want to leverage new tools that can improve reading among their students, especially those who are sensitive to visual crowding.

We now offer eight different Lexend font families that have varied widths and spacing, so users can choose the font style that’s best for their reading speed.

To access these fonts in Google Docs, Sheets, or Slides:

  • From the Font menu in the toolbar, select “More fonts”.
  • Then, search for Lexend and select the fonts to add them to your saved fonts. These will now appear in the “My fonts” list and in the Font menu in the toolbar. 

Availability

Rollout details

  • These fonts are already available to both Rapid and Scheduled domains.

G Suite editions

  • Available to all G Suite editions

On/off by default?

  • These fonts will be available by default.


Stay up to date with G Suite launches