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 2021, 2020, 2019, 2018, 2017, 2016, 2015, 2014, 2013, 2012, 2011, or 2010.

April 2022

April 13, 2022

You can now perform the following actions in the new Apps Script integrated development environment (IDE):

• Create test deployments for Editor Add-ons.
• Add, edit, and delete script properties from the project settings page.
• Sort files alphabetically in the editor.
• Debug Rhino functions without migrating to the V8 runtime. If your code isn't V8 compatible, you might receive errors.
• Set the time zone for a script project.

March 2022

March 24, 2022

For Google Workspace Add-ons, an Attachment class has been added to the Card Service that lets you add custom attachments to Calendar events. You can also set an event trigger that fires when the user clicks on the add-on attachment provider in the Calendar dropdown menu. For more information, refer to EventAttachmentTrigger.

March 18, 2022

The get methods for several color objects in the Spreadsheet Service have been deprecated in favor of a new naming convention. The functionality remains the same. For example, the getFontColor() method from the Range class has been replaced with getFontColorObject().

The following classes have updated get methods for color objects:

• Banding
  • getFirstColumnColor() is now getFirstColumnColorObject().
  • getFirstRowColor() is now getFirstRowColorObject().
  • getFooterColumnColor() is now getFooterColumnColor().
  • getFooterRowColor() is now getFooterRowColorObject().
  • getHeaderColumnColor() is now getHeaderColumnColorObject().
  • getHeaderRowColor() is now getHeaderRowColorObject().
  • getSecondColumnColor() is now getSecondColumnColorObject()
  • getSecondRowColor() is now getSecondRowColorObject().
• BooleanCondition
  • getBackground() is now getBackgroundObject().
  • getFontColor() is now getFontColorObject().
• GradientCondition
  • getMaxColor() is now getMaxColorObject.
  • getMidColor() is now getMidColorObject.
  • getMinColor() is now getMinColorObject.
• Range
  • getFontColor() is now getFontColorObject().
  • getFontColors() is now getFontColorObjects().
• Sheet
  • getTabColor() is now getTabColorObject.
• Slicer
  • getBackgroundColor() is now getBackgroundColorObject().

February 2022

February 14, 2022

Owners receive email alerts when someone outside the owner's organization edits a script project in the new integrated development environment (IDE).

• For container-bound scripts: If someone outside the container owner’s organization creates or edits a container-bound script project, the container owner receives an email notification.

• For standalone scripts: If someone outside the script project owner's organization edits a standalone script project, the script project owner receives an email notification.

January 19, 2022

The following classes have been added to the Spreadsheet Service to let you add images to cells:

• CellImageBuilder: This builder creates the image value needed to add an image to a cell.
• CellImage: Represents an image to add to a cell.

To add an image to a cell, you must create a new image value for the image using SpreadsheetApp.newCellImage() and CellImageBuilder. Then, use Range.setValue(value) or Range.setValues(values) to add the image value to the cell.