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.

December 2020

December 7, 2020

The Apps Script integrated development environment, or IDE, has been fully redesigned. Along with a completely new interface, the following features have been updated:

  • The editor now has a collapsible left sidebar to navigate to the Apps Script project overview, settings, executions, and triggers.
  • The editor’s resources panel now includes files, advanced services, and libraries.
  • Autoformatting has been added to the editor.
  • Autocomplete in the editor has been enhanced to be faster, more consistent, and extends its support to user-defined functions and JavaScript language features. You can add JSDoc to your functions for better autocomplete suggestions.
  • The editor now supports codeblock and function collapsing.
  • Keyboard shortcuts and a Command Palette has been added to the editor. Press F4 to view the Command Palette and available keyboard shortcuts.
  • The editor now includes a contextual right-click menu with options such as Go To Symbol, Rename Symbols, and Command Palette.
  • Enhancements have been made to the debugger’s performance and speed.
  • Logs now stream in real-time as you run a script.
  • The deployments dialog auto-detects the deployment types from the script project’s manifest. You can change or add more types as needed.
  • Deployments have been merged with versions. Each time you create a new deployment, a new version is automatically created. clasp users are unaffected by this change.
  • A single deployment can be an add-on deployment , web app, library, or API executable. Any deployment can be used as a library.
  • Now only one deployment can be active at a time. This change doesn’t affect existing active deployments. clasp users are unaffected by this change.
  • You can no longer explicitly deactivate published web apps. Instead, delete the deployment that has the web app. To reactivate the web app, deploy it again.
  • The debugger is no longer supported in the Rhino runtime. To use the debugger, migrate your script to the V8 runtime.
  • Testing Editor Add-ons is not yet supported in this release and will be added in 2021. To test Editor Add-ons, switch back to the legacy IDE.

To switch back to the legacy IDE from within the editor, at the top, click Use legacy editor.

October 2020

October 23, 2020

An advanced service for Google Tables has been added to Apps Script. The Tables service allows scripts to programmatically read and edit rows within Tables.

September 2020

September 3, 2020

New classes and methods have been added to support Connected Sheets.

The following new classes have been added to the Spreadsheet service:

New methods to support Connected Sheets have been added to the following classes in the Spreadsheet service:

August 2020

August 27, 2020

A new class called DecoratedText has been added to the Card Service. DecoratedText adds text with optional decorations and was added to replace the KeyValue class.

July 2020

July 27, 2020

To help simplify Google Drive’s folder structure and sharing models, new methods have been added to the Drive service and some existing methods have been deprecated.

The DriveApp now has an enforceSingleParent(value) method that enables or disables enforceSingleParent behavior.

The File class now has the following methods:

The Folder class now has the following methods:

The following Folder class methods have been deprecated:

  • addFile(File)
  • addFolder(Folder)
  • removeFile(File)
  • removeFolder(Folder)

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: