Tag Archives: Google Sheets

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

Additional tools for enhanced reporting in Google Sheets

What’s changing

We’re adding three new tools to help you generate more compelling reports and better display data in Google Sheets:

  • Slicers
  • Scorecard Charts
  • Themes

Earlier this year we announced several new features for objects in Sheets. Together, these new features make for a more impactful reporting experience in Sheets.


Using Slicers, Scorecard Charts, and Themes together to enhance reporting.

Who’s impacted

End users

Why you’d use them

You can use these tools to filter, display key data, and customize the look and feel of your spreadsheets, making it easier and faster to generate more engaging and informative reports.

How to get started


  • Admins: No action required.
  • End users: See below for how to use each new tool in Sheets.

Additional details

Slicers:
Slicers are a new way of filtering for reports or dashboards by condition and by values. To learn more about using Slicers in Sheets, see our Help Center.

Scorecard charts:
Scorecard charts is a new way to call out key metrics, such as KPIs or a key stat, within your sheet. You’ll have the option to show your stat in comparison to another number, for instance illustrating percentage increase or decrease over time. See our Help Center for more information on how to insert a Scorecard chart in Sheets.

Themes:
You can now quickly alter the look and feel of an entire spreadsheet—including charts, pivot tables, and cells—to ensure a consistent look and feel for your spreadsheets. To apply a preset theme, select Format > Theme and choose an option, or to create a custom theme, select Customize in the top right.

Helpful links



Availability

Rollout details

G Suite editions

  • Available to all G Suite editions.

On/off by default?

  • These features will be ON by default.

Stay up to date with G Suite launches

Improving active account awareness when opening files with multiple sign-ins

Quick launch summary 

We’re making it easier for you to identify which Google account is active when opening and contributing to Docs, Sheets, and Slides files.

When you’re logged into multiple accounts, like switching between your work and personal accounts, it can sometimes be confusing to determine which account is active when opening and collaborating on a Doc, Sheet, or Slide. We’re introducing a new dialogue that better indicates which account is active, and gives you the option to quickly change accounts.

This will help eliminate confusion and ensure you’re using the correct account when contributing to content.


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