Release Notes: 2019

This page lists the major changes in each release of Google Apps Script in 2019. It is intended to help developers identify changes in behavior. For more recent changes, see the current year's release notes.

December 2019

December 18, 2019

• The Spreadsheet service has been extended with the following class and new methods to support using color building and theme colors:
  • Color
  • ColorBuilder
  • SpreadsheetTheme
  • ThemeColor
  • ThemeColorType
  • SpreadsheetApp.newColor()
  • Spreadsheet.getPredefinedSpreadsheetThemes()
  • Spreadsheet.getSpreadsheetTheme()
  • Spreadsheet.resetSpreadsheetTheme()
  • Spreadsheet.setSpreadsheetTheme(theme)

December 12, 2019

The documentation for Apps Script manifest file structures has been redesigned and relocated into the Reference section. The new reference pages describe the fields and resources that make up an Apps Script manifest file, including the sections related to Add-ons.

December 11, 2019

The Data Studio service has been extended with the following class and new methods to support different response types and dynamic statuses:

• GetDataResponse
• GetSchemaResponse
• SetCredentialsResponse
• Checkbox.setIsDynamic(isDynamic)
• CommunityConnector.newGetDataResponse()
• CommunityConnector.newGetSchemaResponse()
• CommunityConnector.newSetCredentialsResponse()
• Config.setIsSteppedConfig(isSteppedConfig)
• SelectMultiple.setIsDynamic(isDynamic)
• SelectSingle.setIsDynamic(isDynamic)
• TextArea.setIsDynamic(isDynamic)
• TextInput.setIsDynamic(isDynamic)

December 6, 2019

A new Apps Script Fundamentals codelab playlist has been created. This playlist walks new users through basic Apps Script concepts as they build scripts for Google Sheets.

November 2019

November 6, 2019

• The Spreadsheet service has been extended with the following class and new methods to support using slicers to filter ranges, charts, and pivot tables:
  • Slicer
  • Sheet.getSlicers()
  • Sheet.insertSlicer(range, anchorRowPos, anchorColPos)
  • Sheet.insertSlicer(range, anchorRowPos, anchorColPos, offsetX, offsetY)
• The Script service has been extended with the ScriptApp.getIdentityToken() method, which returns an identity token for the effective user.

October 2019

October 28, 2019

You can no longer publish web apps to the Chrome Web Store. The Chrome Web Store deprecated Chrome apps in 2016 and they are now only available for ChromeOS devices. This change includes published Apps Script web apps. Previously published web apps are no longer discoverable in the Chrome Web Store. Editor Add-ons aren't affected; you can still publish Editor Add-ons to the Chrome Web Store.

October 23, 2019

• The Slides service class RgbColor and the enumeration ColorType have been moved from the Slides service to the Base script service. The functionality of these classes has not changed. Moving these classes to the Base script service enables other services to make use of them in the future. You can now find the documenation for these classes at RgbColor and ColorType.
• Several classes and methods relating to the now shutdown UiApp service have been removed. Most of these methods involved interactions between the Charts service and UiApp that were very seldom used. The following is a full list of the removed classes and methods:
  • Charts service
    • CategoryFilterBuilder
    • Control
    • DashboardPanel
    • DashboardPanelBuilder
    • Chart.getId()
    • Chart.getType()
    • Charts.newCategoryFilter()
    • Charts.newDashboardPanel()
    • Charts.newNumberRangeFilter()
    • Charts.newStringFilter()
    • NumberRangeFilterBuilder.build()
    • NumberRangeFilterBuilder.setDataTable(tableBuilder)
    • NumberRangeFilterBuilder.setDataTable(table)
    • NumberRangeFilterBuilder.setFilterColumnIndex(columnIndex)
    • NumberRangeFilterBuilder.setFilterColumnLabel(columnLabel)
    • NumberRangeFilterBuilder.setLabel(label)
    • NumberRangeFilterBuilder.setLabelSeparator(labelSeparator)
    • NumberRangeFilterBuilder.setLabelStacking(orientation)
    • StringFilterBuilder.build()
    • StringFilterBuilder.setDataTable(tableBuilder)
    • StringFilterBuilder.setDataTable(table)
    • StringFilterBuilder.setFilterColumnIndex(columnIndex)
    • StringFilterBuilder.setFilterColumnLabel(columnLabel)
    • StringFilterBuilder.setLabel(label)
    • StringFilterBuilder.setLabelSeparator(labelSeparator)
    • StringFilterBuilder.setLabelStacking(orientation)
  • Spreadsheet service
    • EmbeddedChart.getId()
    • EmbeddedChart.getType()
    • EmbeddedChart.setId(id)

September 2019

September 9, 2019

The Card service methods CardHeader.setUrl(url) and Image.setUrl(url) have been updated to accept an encoded image data string as an input parameter. As before, you can alternatively use a publicly-available image URL as the input parameter.

August 2019

August 7, 2019

Documentation for the UI service has been removed. This service was deprecated in December 2014 and officially shut down on July 15, 2019. To build interfaces for web apps and Editor Add-ons, use the HTML service.

July 2019

July 26, 2019

• The Group service has been updated with the Groups.getRoles(user) method that can determine the list of roles a specific user in a group has.
• The Slides service has been extended with the following new methods to support concrete color schemes:
  • ColorScheme.setConcreteColor(type, color)
  • ColorScheme.setConcreteColor(type, red, green, blue)
  • ColorScheme.setConcreteColor(type, hexColor)
• The Spreadsheet service has been extended with the following new methods to support trimming whitespace and removing duplicate values:
  • RangeList.trimWhitespace()
  • Range.removeDuplicates()
  • Range.removeDuplicates(columnsToCompare)
  • Range.trimWhitespace()

May 2019

May 20, 2019

• The Gmail service has been updated with the GmailMessage.getHeader(name) method that can retrieve a RFC 2822 header from a message.
• The Optimization service has been updated with the following batch methods:
  • LinearOptimizationEngine.addContraints(lowerBounds, upperBounds, variableNames, coefficients)
  • LinearOptimizationEngine.addVariables(names, lowerBounds, upperBounds, types, objectiveCoeffients)

May 3, 2019

The Document service has been updated to add methods to get and set the language of a document:

• Document.getLanguage()
• Document.getSupportedLanguageCodes()
• Document.setLanguage(languageCode)

April 2019

April 19, 2019

The Data Studio service has been updated to add a few values to FieldType enum:

• HYPERLINK
• IMAGE
• IMAGE_LINK

April 8, 2019

The behavior of the Google Clould (GCP) projects used by scripts has been altered. Now, the default GCP projects that Apps Script creates for new scripts are hidden and script owners can't access them directly. Admins and domain users with the resourcemanager.projects.list permission on the parenting GCP folder can still access default GCP projects.

If you need access to a script's GCP project (because you wish to publish it or take a similar action), it's best to switch your script to use a standard GCP project.

April 5, 2019

• The Spreadsheet service has been extended with the following new classes and methods to support text finding, checkboxes, and other features:
  • TextFinder
  • RecalculationInterval
  • SheetType
  • DataValidationBuilder.requireCheckbox()
  • DataValidationBuilder.requireCheckbox(checkedValue)
  • DataValidationBuilder.requireCheckbox(checkedValue, uncheckedValue)
  • A clearRanges() method has been added to the all the embedded chart type builder classes, such as EmbeddedAreaChartBuilder.clearRanges()
  • EmbeddedChart.getChartId()
  • RangeList.check()
  • RangeList.insertCheckboxes()
  • RangeList.insertCheckboxes(checkedValue)
  • RangeList.insertCheckboxes(checkedValue, uncheckedValue)
  • RangeList.removeCheckboxes()
  • RangeList.uncheck()
  • Range.check()
  • Range.createTextFinder(findText)
  • Range.getDataRegion()
  • Range.getDataRegion(dimension)
  • Range.insertCheckboxes()
  • Range.insertCheckboxes(checkedValue)
  • Range.insertCheckboxes(checkedValue, uncheckedValue)
  • Range.removeCheckboxes()
  • Range.uncheck()
  • Sheet.createTextFinder(findText)
  • Sheet.getType()
  • Spreadsheet.createTextFinder(findText)
  • Spreadsheet.getIterativeCalculationConvergenceThreshold()
  • Spreadsheet.getMaxIterativeCalculationCycles()
  • Spreadsheet.getRecalculationInterval()
  • Spreadsheet.isIterativeCalculationEnabled()
  • Spreadsheet.moveChartToObjectSheet(chart)
  • Spreadsheet.setIterativeCalculationConvergenceThreshold(minThreshold)
  • Spreadsheet.setIterativeCalculationEnabled(isEnabled)
  • Spreadsheet.setMaxIterativeCalculationCycles(maxIterations)
  • Spreadsheet.setRecalculationInterval(recalculationInterval)
• The Data Studio service has been extended with the following new classes and methods that support configuring BigQuery connectors:
  • BigQueryConfig
  • BigQueryParameterType
  • CommunityConnector.newBigQueryConfig()
• The Notification objects in the Card service no longer have a type that you must set. Calls to the now removed Notification.setType(type) method result in a no-op.

February 2019

February 26, 2019

• The Spreadsheet service has been extended with the following new classes and methods to support BigQuery data connectors in Sheets:
  • BigQueryDataSourceSpec
  • BigQueryDataSourceSpecBuilder
  • DataExecutionErrorCode
  • DataExecutionState
  • DataExecutionStatus
  • DataSourceParameterType
  • DataSourceParameter
  • DataSourceSpecBuilder
  • DataSourceSpec
  • DataSourceTable
  • DataSourceType
  • DataSource
  • Range.getDataSourceTables()
  • Sheet.getDataSourceTables()
  • SpreadsheetApp.enableAllDataSourcesExecution()
  • SpreadsheetApp.enableBigQueryExecution()
  • SpreadsheetApp.newDataSourceSpec()
  • Spreadsheet.getDataSourceTables()
  • Spreadsheet.insertSheetWithDataSourceTable(spec)
• The Data Studio service has been extended with the following new methods involving reaggregation settings:
  • Field.getIsReaggregatable()
  • Field.setIsReaggregatable(isReaggregatable)

January 2019

January 22, 2019

• The Spreadsheet service has been extended with the following new classes and methods to support text styles and Rich Text cell formatting:
  • RichTextValue
  • RichTextValueBuilder
  • TextStyle
  • TextStyleBuilder
  • Range.getRichTextValue()
  • Range.getRichTextValues()
  • Range.getTextStyle()
  • Range.getTextStyles()
  • Range.setRichTextValue(value)
  • Range.setRichTextValues(values)
  • Range.setTextStyle(style)
  • Range.setTextStyles(styles)
  • SpreadsheetApp.newRichTextValue()
  • SpreadsheetApp.newTextStyle()
• The Data Studio service has been extended with the following new classes and methods that define and support authentication types for community connectors:
  • GetAuthTypeResponse
  • AuthType
  • CommunityConnector,newAuthTypeResponse()
• The deprecated UiApp service will be offically shutdown on July 15th, 2019. After this date, the service will no longer function for any script project.

January 4, 2019

• The Slides service has been extended with the following new classes and methods that support slide linking and text box insertion:
  • SlideLinkingMode
  • Layout.insertTextBox(text)
  • Layout.insertTextBox(text, left, top, width, height)
  • Master.insertTextBox(text)
  • Master.insertTextBox(text, left, top, width, height)
  • Page.insertTextBox(text)
  • Page.insertTextBox(text, left, top, width, height)
  • Presentation.appendSlide(slide, linkingMode)
  • Presentation.insertSlide(insertionIndex, slide, linkingMode)
  • Slide.getSlideLinkingMode()
  • Slide.getSourcePresentationId()
  • Slide.getSourceSlideObjectId()
  • Slide.insertTextBox(text)
  • Slide.insertTextBox(text, left, top, width, height)
  • Slide.refreshSlide()
  • Slide.unlink()
• The Data Studio service has been extended with the following new classes and methods that error displays:
  • DebugError
  • UserError
  • CommunityConnector.newDebugError()
  • CommunityConnector.newUserError()