Google is committed to advancing racial equity for Black communities. See how.

Release Notes

This page lists the major changes in each release of Google Apps Script. It is intended to help developers identify recent changes in behavior. For older changes, see the release notes for 2019, 2018, 2017, 2016, 2015, 2014, 2013, 2012, 2011, or 2010.

June 2020

June 12, 2020

New methods have been added to the Spreadsheet service.

April 2020

April 22, 2020

A new simple trigger, onSelectionChange(e), has been added for Google Sheets. The onSelectionChange(e) trigger runs automatically when a user changes the selection in a spreadsheet.

April 2, 2020

The following has been added to the Spreadsheet service

The following has been added to the Drive service

  • There's a new FILE_ORGANIZER value in the Permission enum. If you have FILE_ORGANIZER permission on a shared drive, you can edit, trash, and move content within that drive.

February 2020

February 28, 2020

The following methods have been added to the Spreadsheet service to support the use of theme colors. Many of these methods duplicate the effect of existing color methods, but let you use Color objects instead of strings as parameters and return types:

February 5, 2020

Apps Script now supports the V8 runtime. This enables modern JavaScript features and syntax in Apps Script. You can migrate existing scripts to use V8 and its features.

January 2020

January 21, 2020

To support the launch of G Suite Add-ons, the following manifest changes, service, classes, and methods have been added to Apps Script: