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 nowgetFirstColumnColorObject()
.getFirstRowColor()
is nowgetFirstRowColorObject()
.getFooterColumnColor()
is nowgetFooterColumnColor()
.getFooterRowColor()
is nowgetFooterRowColorObject()
.getHeaderColumnColor()
is nowgetHeaderColumnColorObject()
.getHeaderRowColor()
is nowgetHeaderRowColorObject()
.getSecondColumnColor()
is nowgetSecondColumnColorObject()
getSecondRowColor()
is nowgetSecondRowColorObject()
.
BooleanCondition
getBackground()
is nowgetBackgroundObject()
.getFontColor()
is nowgetFontColorObject()
.
GradientCondition
getMaxColor()
is nowgetMaxColorObject
.getMidColor()
is nowgetMidColorObject
.getMinColor()
is nowgetMinColorObject
.
Range
getFontColor()
is nowgetFontColorObject()
.getFontColors()
is nowgetFontColorObjects()
.
Sheet
getTabColor()
is nowgetTabColorObject
.
Slicer
getBackgroundColor()
is nowgetBackgroundColorObject()
.
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.