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.

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:

• DataSourceChart
• DataSourceColumn
• DataSourceFormula
• DataSourcePivotTable
• DataSourceRefreshSchedule
• DataSourceRefreshScheduleFrequency
• DataSourceSheet
• DataSourceSheetFilter
• DataSourceTableColumn
• DataSourceTableFilter
• DateTimeGroupingRule
• PivotGroupLimit
• SortSpec

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

• BigQueryDataSourceSpecBuilder
• BigQueryDataSourceSpec
• DataExecutionStatus
• DataSourceTable
• DataSource
• EmbeddedChart
• FilterCriteriaBuilder
• PivotFilter
• PivotGroup
• PivotTable
• PivotValue
• Range
• Sheet
• SpreadsheetApp
• Spreadsheet

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:

• file.getTargetId(): Gets a shortcut's file ID.
• file.getTargetMimeType(): Returns the mime type of the item a shortcut points to.
• file.moveTo(destination): Moves a file to a specified destination folder.

The Folder class now has the following methods:

• folder.createShortcut(targetId): Creates a shortcut to the provided Drive item ID, and returns it.
• folder.moveTo(destination): Moves an item to the provided destination folder.

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.

• The RichTextValue class now has a RichTextValue.getLinkUrl() method that gets the URL of the specified value.
• The RichTextValueBuilder class now has a RichTextValueBuilder.setLinkUrl() method that sets the link URL for the specified value.
• The PivotTable class now has a PivotTable.getSourceDataRange() method that returns the source data range on which the pivot table is constructed.
• The PivotValue class now has a PivotValue.remove() method that removes the value from the pivot table.

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

• A new Drawing class has been added to support drawings.
• You can now get your drawings with the Sheet.getDrawings() method.

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:

• The Banding class now has 16 new methods that manipulate color in the banding columns and rows using Color objects.
• The BooleanCondition class now has two new methods that retrieve the color of the condition's background and font as Color objects.
• The ConditionalFormatRuleBuilder class now has seven new methods that set color-based format rules using Color objects.
• The GradientCondition class now has three new methods that retrieve condition colors as Color objects.
• The Range class now has eight new methods that get and set font and background colors using Color objects.
• The Sheet class now has two new methods that get and set tab colors using Color objects.
• The Slicer class now has two new methods that get and set the background color of the slicer using Color objects.
• The TextStyleBuilder class now has a TextStyleBuilder.setForegroundColorObject(color) method that updates the foreground color of the style builder using a Color object.
• The TextStyle class now has a TextStyle.getForegroundColorObject() method that gets the foreground color of the style as a Color object.

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:

• The Apps Script manifest structure has been updated to provide configuration controls for G Suite Add-ons. All add-on manifest settings are specified in the AddOns object in the manifest.

  Manifest fields that previously supported Gmail add-ons still exist, but are now deprecated. See Upgrading your published add-ons for instructions on how to upgrade a Gmail add-on into a G Suite add-on.

• The Card service has been extended with the following classes and methods that provide new widgets and event responses:

  • CalendarEventActionResponse
  • CalendarEventActionResponseBuilder
  • DatePicker
  • DateTimePicker
  • DisplayStyle
  • DriveItemsSelectedActionResponse
  • DriveItemsSelectedActionResponseBuilder
  • FixedFooter
  • SwitchControlType
  • TimePicker
  • CardBuilder.setDisplayStyle(displayStyle)
  • CardBuilder.setFixedFooter(fixedFooter)
  • CardBUilder.setPeekCardHeader(peekCardHeader)
  • CardService.newCalendarEventActionResponseBuilder()
  • CardService.newDatePicker()
  • CardService.newDateTimePicker()
  • CardService.newDriveItemsSelectedActionResponseBuilder()
  • CardService.newFixedFooter()
  • CardService.newTimePicker()
  • Switch.setControlType(controlType)

• The Conference Data service has been added to Apps Script. The service helps G Suite Add-ons that extend Google Calendar to stay in sync with third-party conferencing applications. This service is only useful to developers who manage a conferencing application and want to make it available in Google Calendar.