Google Apps Script release notes

Generally available: The getSheetById() method has been added to the Spreadsheet class of the Spreadsheet service. This lets you get a sheet in a spreadsheet using its unique ID.

Generally available: You can now get and set the transparency of a calendar event, meaning whether the event shows as "Busy" or "Available" in Google Calendar. For more information, refer to the following documentation:

• Enum EventTransparency
• Class CalendarEvent
• Class CalendarEventSeries

The Calendar service now has a getEventType() method that lets developers differentiate regular events from other types of events like out-of-office and working location events. For more information, see the following documentation:

• getEventType() for events
• getEventType() for event series
• EventType enum

Generally available: You can now use Looker in Connected Sheets from Apps Script. This update lets you create a new or access existing Looker data source connections, connect a sheet to them, create pivot tables, and more.

The following updates have been made to the Spreadsheet service to support Looker in Connected Sheets from Apps Script.

• The following new data source type has been added:
  • LOOKER
• The following new classes have been added:
  • LookerDataSourceSpec
  • LookerDataSourceSpecBuilder
• The following new methods have been added to existing classes:
  • DataSourceSpec.asLooker()
  • DataSourceSpecBuilder.asLooker()

Generally Available: You can now create and organize tabs in Google Docs documents using Apps Script's Document service. For more information, refer to Work with tabs.

(Generally Available): Multiselect menus are now generally available for Add-ons.

For more information refer to the following:

• SelectionInput for Apps Script
• SelectionInput for HTTP runtimes

(Generally Available): Columns are now generally available for Add-ons.

For more information refer to the following:

• Columns for Apps Script
• Columns for HTTP runtimes

To subscribe to events using Apps Script, you can now use the Advanced Google Workspace Events service. For details, see the Apps Script reference documentation.

The cancelDataRefresh() method has been added to the following classes of the Spreadsheet service:

• DataSourceChart
• DataSourceFormula
• DataSourcePivotTable
• DataSourceSheet
• DataSourceTable

The cancelDataRefresh() method cancels the data refresh associated with the object it's called on if the refresh is currently running.

The cancelAllLinkedDataSourceObjectRefreshes() method has been added to the DataSource class. This method cancels all currently running refreshes of data source objects linked to the data source this method is called on.

(Generally Available): Google Chat apps now support Google Apps Script's Card Service. If you've built your Chat app using Apps Script, you can use Card Service to build user interfaces such as card messages and dialogs. For more information, see the Card Service reference documentation.

(Generally Available): You can now delete multiple unused versions at the same time from the Project History page. Refer to Delete multiple versions.

(Generally Available): The LinkPreview class has been added to the Apps Script Card service. This class lets you control various aspects of link previews, including the smart chip title, the link preview title, and the link preview card.

(Developer Preview): Multiselect menus are now in Developer Preview for Add-ons.

For more information refer to the following:

• SelectionInput for Apps Script
• SelectionInput for other runtimes

(Developer Preview): Columns are now in Developer Preview for Add-ons.

For more information refer to the following:

• Columns for Apps Script
• Columns for other runtimes

(Developer Preview): Google Chat apps now support Google Apps Script's Card Service. If you've built your Chat app using Apps Script, you can use Card Service to build user interfaces such as card messages and dialogs. For more information, see the Card Service reference documentation.

(Generally Available): Google Workspace Add-ons now support third-party resource creation from the @ menu in Google Docs. This feature is gradually rolling out over the next few weeks. To use this feature, see Create third-party resources from the @ menu.

(Generally available): Google Workspace Add-ons now support link previews in Google Sheets and Slides. To learn more, see Preview links with smart chips.

(Generally available): The setPersistValues(persistValues) method has been added to the Action class of the Card service. This means that you can now indicate whether form values are determined by the client's values or the server's values after an action response updates a form's card.

(Generally Available): You can now call version 3 of the Google Drive API from Apps Script with the advanced Drive service. To learn more, see Advanced Drive service.

(Generally available): You can now delete versions in your Apps Script project from the project history page in the Apps Script IDE.

Script projects created after December 10, 2023 can have up to 200 versions. If your script reaches the versions limit, or you want to clean up your script project, delete undeployed versions that you no longer need.

To learn more, see Delete a version.

(Developer Preview): Google Workspace Add-ons now support third-party resource creation from the @ menu in Google Docs. To use this feature, see Create third-party resources from the @ menu.

(Developer Preview): Available as part of the Google Workspace Developer Preview Program, which grants early access to certain features.

Google Workspace Add-ons now support link previews in Google Sheets and Slides. To learn more, see Preview links with smart chips.

(Generally available): You can now call the Chat API from Apps Script with the Advanced Chat Service. To learn how, see Advanced Chat Service in the Apps Script reference documentation.

We've also updated the Apps Script code samples to use the Advanced Chat Service in the following Chat API developer guides:

• Authenticate as an app
• Authenticate as a user
• Try it - Respond to Incidents

You can now view previously deployed script versions and compare them to the current script version in the Apps Script IDE. Anyone who has edit permission on an Apps Script project can access the project history page. To learn more, refer to the following:

• Google Workspace Updates blog: View & compare script versions with Apps Script project history

• Developer documentation: Versions

Third-party smart chips and link previews are now generally available. To build a Google Workspace Add-on that uses this feature, see Preview links with smart chips.

Apps Script added a new method to the Utilities class. parseDate(date, timeZone, format) parses a provided string date according to the specification described in the Java Standard Edition SimpleDateFormat class.

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.

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.

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.

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.

In the HTML Service iframe sandbox, allow-top-navigation, which allows the content to navigate its top-level browsing context, is restricted and not set as an attribute in the sandbox. Instead, the allow-top-navigation-by-user-activation attribute has been added to the sandbox.

If you need to redirect your script, add a link or a button for the user to take action on.

Learn more about HMTL Service restrictions.

The Drive Service has added three new methods to the file and folder classes to manage the use of resource keys when sharing files and folders.

• getSecurityUpdateEligible(): Gets whether a file for folder is eligible to apply the security update that requires a resource key for access when it's shared using a link.
• getSecurityUpdateEnabled(): Gets whether a file or folder requires a resource key for access when it's shared using a link.
• setSecurityUpdateEnabled(enabled): Sets whether the file or folder requires a resource key for access when it's shared using a link.

Learn more about the resource key security update for Drive.

The Document Service has added support for smart chips by adding three new classes:

• Date - An element representing a formatted date.
• Person - An element representing a link to a person.
• RichLink - An element representing a link to a Google resource, such as a Drive file or a YouTube video.

Learn more about smart chips in Google Docs.

A new divider widget has been added for Google Workspace Add-ons. To add a divider to an add-on card, use the newDivider() method within the Card service.

A new method has been added to the Sheet class of the Spreadsheet service. setRowHeightsForced(startRow, numRows, height) lets you manually set the height for a row or a set of rows.

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.

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

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.

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.

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.

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.

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.

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.

To support the launch of G Suite Add-ons, the following manifest changes, service, classes, and methods have been added to Add-ons:

• The add-ons 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.

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)

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)

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.

• 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()

• 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)

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)

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

• HYPERLINK
• IMAGE
• IMAGE_LINK

• 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.

• 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)

• 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 Slides service has been extended with the following new classes and methods that support slide linking and text box insertion:
  • SlideLinkingMode
  • [Layout.insertTextBox(text)}(https://developers.google.com/apps-script/reference/slides/layout#inserttextboxtext)
  • 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()

The Slides service has been extended with the following new classes and methods that support connector lines:

• ConnnectionSite
• Group.getConnectionSites()
• Image.getConnectionSites()
• Line.getConnectionSites()
• Line.getEndConnection()
• Line.getLineCategory()
• Line.getStartConnection()
• Line.isConnector()
• Line.setEndConnection(connectionSite)
• Line.setLineCategory(lineCategory)
• Line.setStartConnection(connectionSite)
• LineCategory.UNSUPPORTED
• PageElement.getConnectionSites()
• Shape.getConnectionSites()
• SheetsChart.getConnectionSites()
• Table.getConnectionSites()
• Video.getConnectionSites()
• WordArt.getConnectionSites()

• The Card service has been extended with the following new classes and methods that let you to customize the background of text button widgets:
  • TextButtonStyle
  • TextButton.setBackgroundColor(backgroundColor)
  • TextButton.setDisabled(disabled)
  • TextButton.setTextButtonStyle(textButtonStyle)
• The Slides service has been extended with the following new methods that let you control the Z-positioning of page elements in Slides. Other new methods let you add alt titles and alt descriptions to page elements. The following methods have been added to the Group, Image, Line, PageElement, Shape, SheetsChart, Table, Video, and WordArt classes:
  • bringForward()
  • bringToFront()
  • sendBackward()
  • sendToBack()
  • setDescription(description)
  • setTitle(title)
• The Spreadsheet service has been extended with the following new classes and methods that let you add and search for metadata strings attached to rows, columns, sheets, or spreadsheets:
  • DeveloperMetadata
  • DeveloperMetadataFinder
  • DeveloperMetadataLocation
  • DeveloperMetadataLocationType
  • DeveloperMetadataVisibility
  • Range.addDeveloperMetadata(key)
  • Range.addDeveloperMetadata(key, visibility)
  • Range.addDeveloperMetadata(key, value)
  • Range.addDeveloperMetadata(key, value, visibility)
  • Range.createDeveloperMetadataFinder()
  • Range.getDeveloperMetadata()
  • Sheet.addDeveloperMetadata(key)
  • Sheet.addDeveloperMetadata(key, visibility)
  • Sheet.addDeveloperMetadata(key, value)
  • Sheet.addDeveloperMetadata(key, value, visibility)
  • Sheet.createDeveloperMetadataFinder()
  • Sheet.getDeveloperMetadata()
  • Spreadsheet.addDeveloperMetadata(key)
  • Spreadsheet.addDeveloperMetadata(key, visibility)
  • Spreadsheet.addDeveloperMetadata(key, value)
  • Spreadsheet.addDeveloperMetadata(key, value, visibility)
  • Spreadsheet.createDeveloperMetadataFinder()
  • Spreadsheet.getDeveloperMetadata()

• The Spreadsheet service has been extended with the following new classes and methods:

  • OverGridImage
  • Sheet.getImages()
  • Sheet.isColumnHiddenByUser(columnPosition)
  • Sheet.isRowHiddenByFilter(rowPosition)
  • Sheet.isRowHiddenByUser(rowPosition)
  • Spreadsheet.getImages()
  • Spreadsheet.isColumnHiddenByUser(columnPosition)
  • Spreadsheet.isRowHiddenByFilter(rowPosition)
  • Spreadsheet.isRowHiddenByUser(rowPosition)

• The following methods have been added to existing services:

  • console service
    • console.error()
    • console.info()
    • console.warn()
  • DataStudio service
    • Field.isHidden()
    • Field.setIsHidden()
  • Gmail service
    • GmailAttachment.getHash()
    • GmailMessage.getAttachments(options)

The Card service has been extended with the following classes and methods to support Gmail add-on compose actions:

• CardService.UpdateDraftActionResponse
• CardService.UpdateDraftActionResponseBuilder
• CardService.UpdateDraftBodyAction
• CardService.ContentType
• CardService.UpdateDraftBodyType
• CardService.newUpdateDraftActionResponseBuilder()
• CardService.newUpdateDraftBodyAction()

The Utilities service has been extended with the following methods and classes:

• Utilities.computeRsaSha1Signature(value, key)
• Utilities.computeRsaSha1Signature(value, key, charset)
• Utilities.computeRsaSignature(algorithm, value, key)
• Utilities.computeRsaSignature(algorithm, value, key, charset)
• RsaAlgorithm

• The Forms service now has the following method:
  • Form.deleteResponse(responseId)`
• The Utilities service now has the following methods:
  • Utilities.computeDigest(algorithm, value), where value is a Byte array
  • Utilities.computeHmacSha256Signature(value, key), where value and key are Byte arrays
  • Utilities.computeHmacSignature(algorithm, value, key), where value and key are Byte arrays

• The Spreadsheet service has been extended with the new Group class and the GroupControlTogglePosition enum. Groups are an association between an interval of contiguous rows or columns that can be expanded or collapsed as a unit.
• The Spreadsheet service has been extended with the following new methods to support Groups:
  • Range.collapseGroups()
  • Range.expandGroups()
  • Range.shiftColumnGroupDepth(delta)
  • Range.shiftRowGroupDepth(delta)
  • Sheet.collapseAllColumnGroups()
  • Sheet.collapseAllRowGroups()
  • Sheet.expandAllColumnGroups()
  • Sheet.expandAllRowGroups()
  • Sheet.expandColumnGroupsUpToDepth(groupDepth)
  • Sheet.expandRowGroupsUpToDepth(groupDepth)
  • Sheet.getColumnGroup(columnIndex, groupDepth)
  • Sheet.getColumnGroupControlPosition()
  • Sheet.getColumnGroupDepth(columnIndex)
  • Sheet.getRowGroup(rowIndex, groupDepth)
  • Sheet.getRowGroupControlPosition()
  • Sheet.getRowGroupDepth(rowIndex)
  • Sheet.setColumnGroupControlPosition(position)
  • Sheet.setRowGroupControlPosition(position)

The Sheets service has been extended with a large number of new classes and methods. The addition of these methods make it possible to reproduce in code nearly any action a Sheets user can take at a keyboard. The new classes and methods include:

• BandingTheme
• Banding
• BooleanCondition
• BooleanCriteria
• ConditionalFormatRuleBuilder
• ConditionalFormatRule
• Dimension
• Direction
• FilterCriteriaBuilder
• FilterCriteria
• Filter
• GradientCondition
• InterpolationType
• PivotFilter
• PivotGroup
• PivotTableSummarizeFunction
• PivotTable
• PivotTableDisplayType
• PivotValue
• RangeList
• RelativeDate
• Selection
• TextDirection
• TextRotation
• TextToColumnsDelimiter
• WrapStrategy
• EmbeddedChartBuilder.setHiddenDimensionStrategy(strategy) (also in each of the type-specific chart builder classes)
• EmbeddedChartBuilder.setNumHeaders(headers) (also in each of the type-specific chart builder classes)
• EmbeddedChartBuilder.setMergeStrategy(mergeStrategy) (also in each of the type-specific chart builder classes)
• EmbeddedChartBuilder.setTransposeRowsAndColumns(transpose) (also in each of the type-specific chart builder classes)
• Range.activateAsCurrentCell()
• Range.applyColumnBanding()
• Range.applyColumnBanding(bandingTheme)
• Range.applyColumnBanding(bandingTheme, showHeader, showFooter)
• Range.applyRowBanding()
• Range.applyRowBanding(bandingTheme)
• Range.applyRowBanding(bandingTheme, showHeader, showFooter)
• Range.createFilter()
• Range.createPivotTable(sourceData)
• Range.deleteCells(shiftDimension)
• Range.getBandings()
• Range.getNextDataCell(direction)
• Range.getTextDirection()
• Range.getTextDirections()
• Range.getTextRotation()
• Range.getTextRotations()
• Range.getWrapStrategies()
• Range.getWrapStrategy()
• Range.insertCells(shiftDimension)
• Range.setShowHyperlink(showHyperlink)
• Range.setTextDirection(direction)
• Range.setTextDirections(directions)
• Range.setTextRotation(degrees)
• Range.setTextRotation(rotation)
• Range.setTextRotations(rotations)
• Range.setVerticalText(isVertical)
• Range.setWrapStrategies(strategies)
• Range.setWrapStrategy(strategy)
• Range.setTextToColumns()
• Range.setTextToColumns(delimiter)
• Range.setTextToColumns(delimiter)
• Sheet.autoResizeColumns(startColumns, numColumns)
• Sheet.autoResizeRows(startRows, numRows)
• Sheet.clearConditionalFormatRules()
• Sheet.getActiveRangeList()
• Sheet.getBandings()
• Sheet.getConditionalFormatRules()
• Sheet.getCurrentCell()
• Sheet.getFilter()
• Sheet.getPivotTables()
• Sheet.getRangeList(a1Notations)
• Sheet.getSelection()
• Sheet.hasHiddenGridlines()
• Sheet.isRightToLeft()
• Sheet.setActiveRangeList(rangeList)
• Sheet.setColumnWidths(startColumn numColumns, width)
• Sheet.setConditionalFormatRules(rules)
• Sheet.setCurrentCell(cell)
• Sheet.setHiddenGridlines(hideGridlines)
• Sheet.setRightToLeft(rightToLeft)
• Sheet.setRowHeights(startRow, numRows, height)
• Spreadsheet.getActiveRangeList()
• Spreadsheet.getBandings()
• Spreadsheet.getCurrentCell()
• Spreadsheet.getRangeList(a1Notations)
• Spreadsheet.getSelection()
• Spreadsheet.setActiveRangeList(rangeList)
• Spreadsheet.setCurrentCell(cell)

The Charts service has been extended to support EmbeddedCharts in Google Sheets with the enums ChartHiddenDimensionStrategy and ChartMergeStrategy. In addition, the following ChartTypes have been added:

• TIMELINE
• BUBBLE
• CANDLESTICK
• GAUGE
• GEO
• RADAR
• ORG
• SPARKLINE
• STEPPED_AREA
• TREEMAP
• WATERFALL

The Spreadsheet service has been extended with the following new methods:

• SpreadsheetApp.setActiveSheet(sheet, restoreSelection)
• Spreadsheet.setActiveSheet(sheet, restoreSelection)

Calendar event triggers are now available. You can use these triggers in conjunction with the Calendar advanced service to discover recently changed calendar events via regular sync operations.

• The Slides service has been extended with the following new methods:
  • Layout.insertGroup(group)
  • Layout.insertImage(image)
  • Layout.insertLine(line)
  • Layout.insertPageElement(pageElement)
  • Layout.insertShape(shape)
  • Layout.insertSheetsChart(sheetsChart)
  • Layout.insertTable(table)
  • Layout.insertVideo(video)
  • Layout.insertWordArt(wordArt)
  • Master.insertGroup(group)
  • Master.insertImage(image)
  • Master.insertLine(line)
  • Master.insertPageElement(pageElement)
  • Master.insertShape(shape)
  • Master.insertSheetsChart(sheetsChart)
  • Master.insertTable(table)
  • Master.insertVideo(video)
  • Master.insertWordArt(wordArt)
  • Page.insertGroup(group)
  • Page.insertImage(image)
  • Page.insertLine(line)
  • Page.insertPageElement(pageElement)
  • Page.insertShape(shape)
  • Page.insertSheetsChart(sheetsChart)
  • Page.insertTable(table)
  • Page.insertVideo(video)
  • Page.insertWordArt(wordArt)
  • Presentation.appendSlide(slide)
  • Presentation.insertSlide(insertionIndex, slide)
  • Slide.insertGroup(group)
  • Slide.insertImage(image)
  • Slide.insertLine(line)
  • Slide.insertPageElement(pageElement)
  • Slide.insertShape(shape)
  • Slide.insertSheetsChart(sheetsChart)
  • Slide.insertTable(table)
  • Slide.insertVideo(video)
  • Slide.insertWordArt(wordArt)
  • TextRange.appendRange(textRange)
  • TextRange.appendRange(textRange, matchSourceFormatting)
  • TextRange.insertRange(startOffset, textRange)
  • TextRange.insertRange(startOffset, textRange, matchSourceFormatting)
• The Spreadsheet service has been extended with the following new enum class and method:
  • CopyPasteType, an enum class describing paste types.
  • Range.copyTo(destination, copyPasteType, transposed)

• The UrlFetch service now has a fetchAll method that makes multiple fetch requests.
• The Utilities service now has methods to compress and decompress Blob objects using gzip.

• The Gmail add-ons framework is now available to all developers.
• A new Card service supports Gmail add-ons by defining several UI widget elements that you can use to create a Gmail add-on interface without HTML or CSS. These widgets function on both desktop and mobile. You can only use the Card service in a Gmail add-on project.
• You can now view and explicitly edit Apps Script project manifests. These files give you more direct control of project properties.
• You can now directly control the OAuth scopes that your project requests during authorization. Use this control to prevent your script project from asking for more access than it needs.
• You can now deploy a script project directly from the project manifest.
• We've updated the Publish script editor menu item to more accurately represent the various kinds of deployments a project can have, such as add-on, web app, or API executable deployments.

• The Calendar service has been extended with the following new methods:
  • CalendarApp.createAllDayEvent(title, startDate, endDate)
  • CalendarApp.createAllDayEvent(title, startDate, endDate, options)
  • CalendarApp.getEventById(iCalId)
  • Calendar.createAllDayEvent(title, startDate, endDate)
  • Calendar.createAllDayEvent(title, startDate, endDate, options)
  • Calendar.getEventById(iCalId)
  • CalendarEvent.setAllDayDates(startDate, endDate)
• The Groups service has been extended with the following new methods:
  • Group.getGroups()
  • Group.hasGroup(group)
  • Group.hasGroup(email)
• The Spreadsheet service has been extended with the following new methods and classes:
  • AutoFillSeries enumeration
  • Range.autoFill(destination, series)
  • Range.autoFillToNeighbor(series)
  • Sheet.moveColumns(columnSpec, destinationIndex)
  • Sheet.moveRows(rowSpec, destinationIndex)

Added Apps Script support for the Google Slides service. You can now use Apps Script to create and edit presentations and their contents; you can also build add-ons for Google Slides.

• Added GmailDraft to the Gmail service. You can now create, edit, delete, and send new draft messages or draft replies to existing messages and threads. Drafts can reply to the original sender or "reply all".
• You can now determine if a message or thread is in your priority inbox using GmailMessage.isInPriorityInbox() or GmailThread.isInPriorityInbox().

• Added a Spreadsheet.getFormUrl() method that returns the URLs of Forms send responses to this Sheet or Spreadsheet.
• Adds a Checkbox Grid item to the Forms service.
• Enabled the collection of exception and error reports using Stackdriver Error Reporting.

Added the method Range.randomize() that randomizes the order of rows in a spreadsheet Range.

• Quizzes in Google Forms is now accessible from the Apps Script Forms service.
• Added support for Combo and Histogram charts. Like other charts, these can be embedded in a Google Sheet.
• Added ability to getColor() and setColor() for Calendar Events. Events have their own color set: EventColor.

• Introduced project collaboration using Shared drives. Files and scripts in a shared drive are owned by the group instead of individuals, allowing collaborators to develop and maintain scripts more readily.
• Script editors (in addition to script owners) can now publish add-ons and deploy scripts as web apps or executables for the Execution API.
• For all container-bound scripts, the container owner takes ownership of a new script project regardless of who created it.

Added forms validation classes for check boxes, generic data, grid items, paragraph text items, and text items.

Added X-Frame-Option header support to HtmlService, allowing iframes to render Apps Script HTML and web apps.

Added support for Android add-ons. Now you can make Google Docs and Sheets add-ons that work on Android.

Support for PATCH requests has been added to UrlFetchApp.

• The Spreadsheet API adds new methods for getTabColor() and setTabColor(color).

• The Spreadsheet API adds a new NamedRange type and the following related methods:

  • NamedRange.getName() gets the name of the named range
  • NamedRange.setName(name) sets the name of the named range
  • NamedRange.getRange() gets the underlying range associated with the named range
  • NamedRange.setRange(range) sets the underlying range associated with the named range
  • NamedRange.remove() deletes the named range
  • Spreadsheet.getNamedRanges() gets an array of all the named ranges in the spreadsheet
  • Sheet.getNamedRanges() gets an array of all the named ranges in the sheet
  • Protection.setNamedRange(range) associates an existing protected range with an existing named range

• The Utilities API includes a new getUuid() method that generates a unique identifier.

Added the following methods to the Spreadsheet service to let scripts control "warning-based" protection for spreadsheet ranges (which means that every user can edit data in the area, except editing prompts the user to confirm the edit):

• Protection.isWarningOnly()
• Protection.setWarningOnly(warningOnly)

Added two variations of the method computeRsaSha256Signature to the Utilities global object to let scripts sign a string using the RSA SHA-256 algorithm.

• Added the following enum and methods to the Script service to allow scripts to identify their installation source and project keys:
  • InstallationSource
  • ScriptApp.getInstallationSource()
  • ScriptApp.getProjectKey()
• Added several new web-safe base-64 encoding and decoding methods:
  • Utilities.base64DecodeWebSafe(String)
  • Utilities.base64DecodeWebSafe(String, Charset)
  • Utilities.base64EncodeWebSafe(Byte)
  • Utilities.base64EncodeWebSafe(String)
  • Utilities.base64EncodeWebSafe(String, Charset)

• Added the ability to publish add-ons for domain-wide installation. This lets an admin of a Google Apps domain install and authorize a Docs, Sheets, or Forms add-on for all users in the domain if the add-on is published to the Google Apps Marketplace. If the developer has already published a Google Apps Marketplace app that is closely related to their add-on, they can also choose to bundle the add-on with the Marketplace app so that admins install both the app and the add-on together.
• Added the ability to change the Google Developers Console project that a script uses for authorization. This feature is most commonly used to bundle an add-on with a Google Apps Marketplace app, as above.

Added the following class, enum, and methods to the Spreadsheet service, to give precise control over protected sheets and ranges:

• Protection
• ProtectionType
• Range.canEdit()
• Range.isEndColumnBounded()
• Range.isEndRowBounded()
• Range.isStartColumnBounded()
• Range.isStartRowBounded()
• Range.protect()
• Sheet.getProtections(type)
• Sheet.protect()
• Spreadsheet.getProtections(type)

Added a new IFRAME sandbox mode for HTML service that imposes many fewer restrictions than the other sandbox modes and runs much faster. However, IFRAME mode does not work at all in certain older browsers, including Internet Explorer 9.

• Added five new FormApp methods:
  • Form.getShuffleQuestions(): Determines whether the order of the questions on each page of the form is randomized.
  • Form.hasLimitOneResponsePerUser(): Determines whether the form allows only one response per respondent. If the value is true, the script cannot submit form responses at all.
  • Form.setLimitOneResponsePerUser(enabled): Sets whether the form allows only one response per respondent. The default for new forms is false. If the value is set to true, the script cannot submit form responses at all.
  • Form.setShuffleQuestions(shuffle): Sets whether the order of the questions on each page of the form is randomized.
  • Form.shortenFormUrl(url): Converts a long URL for a form to a short URL.
• Added two new SpreadsheetApp methods:
  • Sheet.insertImage(blob, column, row): Inserts a Blob as an image in the sheet at a given row and column.
  • Sheet.insertImage(blob, column, row, offsetX, offsetY): Inserts a Blob as an image in the sheet at a given row and column, with a pixel offset.

Add-ons for Google Sheets and Docs can now use time-driven installable triggers.

• Added the LinearOptimizationService, which allows scripts to model and solve linear and mixed-integer linear programs.
• Add-ons for Google Sheets and Docs can now use most installable triggers, although they still cannot use time-driven triggers (sometimes called clock triggers).
• Added an installable open trigger for Google Docs. Like the installable open triggers for Sheets and Forms, this trigger is similar to the simple onOpen() trigger, but allows the triggered function to call services that require authorization, if the user has authorized the script ahead of time.
• Added several new ScriptApp methods, classes, and enums to support installable triggers in add-ons:
  • AuthorizationInfo: An object used to determine whether the user needs to authorize this script to use one or more services, and to provide the URL for an authorization dialog. Returned by ScriptApp.getAuthorizationInfo().
  • AuthorizationStatus: An enumeration denoting the authorization status of a script. Returned by AuthorizationInfo.getAuthorizationStatus().
  • DocumentTriggerBuilder: A builder for document triggers. Returned by TriggerBuilder.forDocument(...).
  • ScriptApp.getUserTriggers(...): Gets all installable triggers owned by this user in the given document, spreadsheet, or form.

• Added the UiService method DocsListDialog.setOAuthToken(oAuthToken), which sets an OAuth 2.0 token to use when fetching data for the dialog, on behalf of the user whose content should be shown. This method will become mandatory before calling DocsListDialog.showDocsPicker() on September 30, 2014.
• Added the CacheService method getDocumentCache() and the LockService method getDocumentLock(), which get a cache and a lock that all users can access within the current document, if the script is published as an add-on. These methods are conceptually similar to the PropertiesService method getDocumentProperties(), which was introduced for use in add-ons earlier this year.

Added the value ON_CHANGE to the ScriptApp.EventType enum so that Google Sheets change events can be detected correctly.

Added a source property to the event parameter for form triggers. This makes it possible to retrieve the form that triggered the event.

The Range method getDataSourceUrl() is now supported in the new version of Google Sheets. For information on other incomplete Apps Script features in the new version of Sheets, see the list of known issues.

• Released a CSS package to apply Google styling to fonts, buttons, and form elements in HTML service dialogs and sidebars, primarily for use in add-ons.
• Added the UI method createAddonMenu(), which allows scripts to insert a sub-menu into the Add-ons menu in Google Sheets or Docs. For more information, see the guide to menus.
• Added the ScriptApp enum AuthMode, which identifies categories of authorized services that Apps Script can execute through a triggered function. For more information, see the guide to the add-on authorization lifecycle.
• Added support for the custom JsDoc annotation @OnlyCurrentDoc, which forces the authorization dialog to ask only for access to files in which an add-on or script is used, rather than all of a user's spreadsheets, documents, or forms. An opposing annotation, @NotOnlyCurrentDoc, is also available.

• Added the following DocumentApp classes and methods, which allow scripts to create bookmarks and named ranges, plus set the user's cursor position or selection.
  • Bookmark
  • `NamedRange
  • `RangeBuilder
  • `Document.addBookmark(position)
  • `Document.addNamedRange(name, range)
  • `Document.getBookmark(id)
  • `Document.getBookmarks()
  • `Document.getNamedRangeById(id)
  • `Document.getNamedRanges()
  • `Document.getNamedRanges(name)
  • `Document.newPosition(element, offset)
  • `Document.newRange()
  • `Document.setCursor(position)
  • `Document.setSelection(range)
  • `Position.insertBookmark()
• Added the following ScriptApp class and methods, which allow scripts to create state tokens that can be used in callback APIs (like OAuth flows), as well as to retrieve the script's own OAuth 2.0 access token.
  • `StateTokenBuilder
  • `ScriptApp.getOAuthToken()
  • `ScriptApp.newStateToken()
• Added the method showModalDialog(userInterface, title) to the Ui class, and replaced the method showDialog(userInterface) with showModelessDialog(userInterface, title). This allows scripts to specify whether a dialog in Google Docs, Forms, or the new version of Sheets should prevent the user from interacting with anything other than the dialog.
• Added the client-side HTML-service method google.script.host.editor.focus(), which allows scripts to switch browser focus from the dialog or sidebar to the Google Docs, Sheets, or Forms editor.

Added the following Session methods, which allow scripts to determine the user's locale and time zone:

• getActiveUserLocale()
• getActiveUserTimeZone()

The new SpreadsheetApp method Spreadsheet.getUi() allows scripts to access the spreadsheet's user-interface environment in order to add features like menus, dialogs, and sidebars. This method is consistent with the getUi() methods in DocumentApp and FormApp, but only works in the new version of Google Sheets. The older version of Google Sheets continues to use the existing methods documented in the guides to dialogs and sidebars and menus.

Added the SpreadsheetApp method DataValidationBuilder.requireFormulaSatisfied(String), as well as an accompanying CUSTOM_FORMULA value in DataValidationCriteria. This feature can only be used in the new version of Google Sheets.

Added the advanced parameter escaping to UrlFetchApp.fetch(). If false, reserved characters in the URL will not be automatically escaped.

The Maps.DirectionFinder.Mode enum now includes the TRANSIT value allowing for the retrieval of public transit routes in the Maps service.

Added seven new advanced services: + Admin SDK Directory service + Admin SDK Reports service + Fusion Tables service + Google+ Domains service + Mirror service + YouTube service + YouTube Analytics service

Added TITLE and SUBTITLE values to the DocumentApp.ParagraphHeading enum.

Added the following FormApp methods, which allow scripts to work with progress bars, custom closed-form messages, and YouTube videos. + Form.hasProgressBar() + Form.setProgressBar(enabled) + Form.getCustomClosedFormMessage() + Form.setCustomClosedFormMessage(message) + Form.addVideoItem()

Added the following DriveApp methods, which allow scripts to get the owner of a File or Folder.

• File.getOwner()
• Folder.getOwner()

• HTML Service now supports most CSS3 features. A notable exception is the :nth-child() pseudo-selector, which remains unsupported, along with a small number of obscure or non-standardized CSS3 features. To check whether the Caja security sandbox in HTML Service supports a specific feature, see the CSS whitelist definitions in Caja's public repository.
• Added the following DriveApp methods, which allow scripts to save the state of a file or folder iterator and resume at a later time. These method are useful if processing an iterator in one execution would exceed the maximum execution time.
  • FileIterator.getContinuationToken()
  • FolderIterator.getContinuationToken()
  • DriveApp.continueFileIterator(continuationToken)
  • DriveApp.continueFolderIterator(continuationToken)

Added the DocumentApp methods InlineImage.getLinkUrl() and InlineImage.setLinkUrl(url).

• Added the DriveApp methods DriveApp.getFoldersByName(name) and DriveApp.searchFolders(params), which return a FolderIterator with the requested results.
• Added the DriveApp methods File.getViewers(), File.getEditors(), Folder.getViewers(), and Folder.getEditors(), which return an array of Users with view or edit access.

Added the DriveApp methods File.makeCopy(destination) and File.makeCopy(name, destination), which allow scripts to specify a folder to which a file should be copied.

Added the method Spreadsheet.deleteSheet(sheet), which allows deletions of sheets that are not the active sheet.

• Added the method GmailMessage.getPlainBody(), which returns the content of the message without HTML formatting.
• Launched a new feature to allow programmatic control over data-validation rules in Google Sheets.

On ChromeOS devices, it is now possible to activate autocomplete (sometimes called "content assist") with the keyboard shortcut Ctrl + Space.

Added DriveApp and FormApp to the services tracked on the Apps Script Dashboard.

Added XmlService to replace the old Xml service.

• Issue 1034: The new Drive Service methods addCommenter() and removeCommenter() allow scripts to add and remove commenters on files.
• Issue 674: Mail sent with GmailApp now appears in the Sent Mail folder in Gmail.

• The script editor is now available within Google Docs and the Google Forms editor, and both Docs and Forms can now be containers for scripts.
• Added Forms Service, which allows scripts to create and modify Google Forms.
• Added Drive Service, which allows scripts to create and modify files and folders in Google Drive. This is a newer version of the existing DocsList Service.
• Added a getUi method to DocumentApp and FormApp, which returns a Ui object that allows the script to add features like menus, dialogs, and sidebars to the Docs or Forms editor.
• Added the FormTriggerBuilder class to allow scripts to respond to Forms events.
• Added a setSandboxMode method to enable a faster version of the HtmlService sandbox.
• Added a MimeType enum, which provides access to MIME-type declarations without typing the strings explicitly.
• Added an option to upgrade to a new authorization flow that requires fewer clicks and automatically creates a Google Developers Console project for every script.

Issue 2158: The request object passed in to doPost() methods now contains the POST body. It can be accessed using e.postData.getDataAsString().

Issue 1363: Added support for spreadsheet change events. The onChange() event now fires when certain modifications, such as row insertions, are done to a spreadsheet.

• Issue 1771: Added a clear() method to the Tree and TreeItem classes. These methods remove all children from the object.
• Issue 1743: Added an autoResizeColumn() method to the Sheet class. This method resizes a column to fit its contents.
• Issue 1314: Added support for lazy loading in the Tree class, which reduces wait times in rendering the UI.

Issue 995: The new methods Sheet.hideSheet(), Sheet.isSheetHidden(), and Sheet.showSheet() allow scripts to control the visibility of individual sheets within a spreadsheet.

• Added the method Utilities.formatString(), which allows printf-like substitution of placeholders within a format string.
• Added the property DocsList.FileType.FORM to let DocsList access new Google Forms.

Added the method DocumentApp.openByUrl(), which allows documents to be opened by their URL directly.

Added the ability to directly attach StaticMap objects in emails.

Added the method SpreadsheetApp.openByUrl(), which allows spreadsheets to be opened by their URL directly.

• Issue 1642: When connecting to an external database with Jdbc.getConnection, you can now include the advanced argument use JDBCCompliantTimezoneShift.
• Issue 619: UiInstance's createAnchor method now allows links using the mailto scheme.
• Issue 286: UrlFetchApp's fetch method now accepts followRedirects as an advanced argument.

Added the method after(durationMilliseconds) to class ClockTriggerBuilder to simplify the creation of one-off triggers.

Added extra validation to the datasource URLs used in charts. Custom datasource URLs that rely on non-Google authentication will no longer work.

Added the ability to disable SSL certificate validation in the SoapService, in response to a feature request.

Added options to EmbeddedChartBuilder to make it easier to configure embedded charts. EmbeddedChartBuilder now contains the methods asAreaChart(), asBarChart(), asColumnChart(), asLineChart(), asPieChart(), asScatterChart() and asTableChart() as replacements for calls to setChartType().

• Added the ability to list alternate sender addresses using GmailApp.getAliases() and use them in GmailApp.sendEmail() with the advanced option "from".
• Created the class GmailAttachment, which is the same as a Blob but provides a getSize() method that isn't subject to quota restrictions.
• Added the ability to set a custom app icon for web apps published to the Chrome Web Store. This is the icon that shows up on Chrome's New Tab Page. More information on the Publishing to the Chrome Web Store page.
• Added the ability to close containing dialogs from HtmlService pages. More information on the Html Service page.

Added a setLabelSeparator() method to CategoryFilterBuilder, to allow for label separator strings to be used.

• Fixed an issue where arrays retrieved from ScriptDb didn't behave properly.
• Fixed an issue where the execution transcript would stop recording after Browser.msgBox() was called.
• Fixed an issue where scriptlet tags in HtmlTemplates behaved strangely when in attribute values.
• Fixed a problem that prevented scripts from sending POST requests to other scripts that used the ContentService.

Added an isDeleted() method to SitesApp's Page class.

• Added methods to delete ScriptProperties and UserProperties. Additional methods were also added to set multiple properties, get all properties, etc.
• Added a setOption method to the various chart builders to make it possible to set advanced options for Charts.

• UiApp widgets now have a setStyleAttributes method which allow you to set multiple attributes at once.
• Added a new log method to the Logger service which accepts a format string and a variable number of values to insert.

Added a getThumbnail() method to the DocsList service's File class.

• Added support for chatting with script collaborators in the Script Editor. When two or more people are collaborating on a script, a chat panel will be visible on the right-hand side of the Script Editor.
• Added the ability to support autocomplete for included libraries when they are included in development mode.
• Added UiInstance.remove methods to remove widgets from UiInstance.
• Added support for Google Analytics via the Analytics Service.

• Launched script.google.com and the ability to create standalone scripts that are not bound to a container like Google Sheets or Google Sites.
• Launched the Html Service, which you can use to create web apps using HTML, CSS, and JavaScript. The reference documentation is here.
• Launched the Content Service, which you can use to serve text in various forms, such as text, XML, RSS, or JSON.
• Launched ScriptDb, a JavaScript object database for Apps Script. The reference documentation is here.
• Added the ability to publish web apps with versioning and with the option to have them execute as the user accessing the app.
• Added support for registering Apps Script web apps in the Chrome Web Store, making it quick and simple to publish and distribute your web apps.

• Added the ability to create, modify, and remove Embedded Charts in Google Sheets. Embedded Charts are charts that live solely within Spreadsheets and use multiple ranges of data for their datasource.
• Added support to the Domain Service for NicknameManager and GroupsManager.

• Launched Script Libraries and Versions in response to this feature request.
• Added getDescription() and setDescription() methods to File and Folder.

Added a DocumentApp.HorizontalAlignment.JUSTIFY value to the DocumentApp.HorizontalAlignment enumeration.

• Added the method everyMinutes() to Script Service.

• Added method to DocsList service to getRootFolder().
• Added method to File and Folder classes to check whether the item isTrashed().

Launched the Script service in response to this feature request, which allows developers to programmatically set triggers and manage the publishing of scripts as a service.

Added the ability to set the subject line via the subject field in the advanced arguments for GmailMessage.forward().

• Added the ability to set the target for an Anchor in UI app, in response to this issue.
• Added the ability to include a limited set of HTML tags when working with UiApp widgets, in response to this issue. Here is the list of HTML tags that are permitted: B, BLOCKQUOTE, BODY, BR, CENTER, CAPTION, CITE, CODE, DIV, EM, H1, H2, H3, H4, H5, H6, HR, I, LABEL, LEGEND, LI, OL, P, SPAN, STRONG, SUB, SUP, TABLE, TBODY, TD, THEAD, TITLE, TR, TT, UL
• Added support for sheet protection, in reference to this issue. Introduced two new methods: Sheet.getSheetProtection and Sheet.setSheetProtection, as well as a new PageProtection class.

• Added methods to the Document class to addHeader() and addFooter().
• Added a merge() method to the Range class.

• Added a feature to cancel running scripts, when the script is run from the script editor.
• Added getEventSeriesById() to Calendar.

• Added the setNestingLevel() method to ListItem.
• Added the setGlyphType() method to ListItem to support glyph types other than numeric glyphs.
• Added getWidth() and setWidth() methods to TableCell.

• Enabled Spreadsheet.show() in autocomplete.
• Added the ability to copy and paste from the Revision History.
• Added support for the Groups Services.
• Added support for the Domain Services.
• Added support for the AdSense Services.

• Added the Lock and Cache services.
• Added support for client handlers and validators.

• Added support for inlineImages when sending emails with MailApp.sendEmail().
• Added the Charts Services, which allow users to dynamically create charts and embed them in emails, UiApp, or export them as images.
• Added the Prediction Services, which allow users to access a cloud hosted machine learning service that makes it easy to build smart apps. Added the Tasks Services, which allow users to manage tasks and task lists. Added the UrlShortener Services, which let you create, inspect, and manage goo.gl short URLs.

Added support for ScrollPanel to the GUI Builder.

Added supports for projects in Apps Script.

Fixed an issue where Xml.element failed if the child elements were XmlElements.

• Added the Gmail service.
• Added the Document service.
• Introduced the GUI Builder.

Added an appendRow() method to Spreadsheet.

• Binary files can be uploaded using FileUpload.
• Enhanced ListBox to function as a multi-select ListBox.

Added a method in Utilities class that parses CSV text.

Added integration with Google Sites, so that Apps Script can now be run from within Google Sites. Read more here.

• Added ability for users to create new recurring calendar events through CalendarApp.newRecurrence() and Calendar.createEventSeries().
• Added ability to access existing event series through CalendarEvent.getEventSeries().
• Added ability for users to modify or delete an entire event series through CalendarEventSeries.

• Added new methods to CalendarEvent to get the creation date and the date the event was last updated: getDateCreated() and getLastUpdated().
• Added a new method to Contact to get the date a contact was last updated: getLastUpdated().

• Added Spreadsheet.show() to the script editor autocomplete and the documentation.
• Clarified the use of Session.getUser() and added two new methods: Session.getActiveUser() and Session.getEffectiveUser().
• Added support for persistent storage in scripts via UserProperties and ScriptProperties. Script Properties and User Properties are also available from File > Properties in the script editor.
• Added several new methods to the Contact class: Contact.getGivenName(), Contact.setGivenName(), Contact.getMiddleName(), Contact.setMiddleName(), Contact.getFamilyName(), Contact.setFamilyName(), Contact.getMaidenName(), Contact.setMaidenName(), Contact.getNickname(), Contact.setNickname().
• Major improvements to the Sites service, fixing many issues and adding new functionality.
• Added support for find and replace in the script editor.
• UiApp is now available to all users. Previously, it was only available to Google Apps Premier domains.
• The timezone for a script can now be set from File > Properties in the script editor.
• The user interface for time-based triggers has been updated to make it more clear that the events are triggered between N and N+1 hours.
• The script timezone is now visible in the script triggers dialog.
• Revision history for scripts is now available from File > See revision history in the script editor.
• Added two new methods to the Utilities class provide JSON support: Utilities.jsonParse() and Utilities.jsonStringify().
• Added support for outbound OAuth requests. See UrlFetchApp.addOAuthService().
• Added a new method to class Spreadsheet to get the form URL: Spreadsheet.getFormUrl().
• Added a new Blob class to simplify moving data between different Google Apps Script services.

• Added two new methods to the Sheet class for getting frozen rows and columns: Sheet.getFrozenRows() and Sheet.getFrozenColumns().
• Added sorting methods: Sheet.sort() and Range.sort().
• Added methods to get row height and column width in a Sheet: Sheet.getRowHeight() and Sheet.getColumnWidth().