Google Workspace developer release notes

Generally Available: The following Chat API methods support app authentication using a new type of authentication scope, https://www.googleapis.com/auth/chat.app.*:

• Create a named space as a Chat app with https://www.googleapis.com/auth/chat.app.spaces or https://www.googleapis.com/auth/chat.app.spaces.create.
• Update a space as a Chat app with https://www.googleapis.com/auth/chat.app.spaces.
• Delete a named space as a Chat app with https://www.googleapis.com/auth/chat.app.delete.
• Get details about a space as a Chat app with https://www.googleapis.com/auth/chat.app.spaces.
• Invite or add a user to a space as a Chat app with https://www.googleapis.com/auth/chat.app.memberships.
• Update a membership as a Chat app with https://www.googleapis.com/auth/chat.app.memberships.
• Remove a member from a space with https://www.googleapis.com/auth/chat.app.memberships.

To learn more, see Types of required authentication and Authenticate as a Chat app.

Generally Available: Chat apps can now create (RPC, REST), update (RPC, REST), and get details about (RPC, REST) Chat space permission settings by calling the corresponding method in Chat API using app authentication with the https://www.googleapis.com/auth/chat.app.spaces or https://www.googleapis.com/auth/chat.app.spaces.create authentication scope, including creating announcement spaces.

You can now read the metadata for Meet, Huddle, and Calendar chips using message annotations. Use the RichLinkMetadata object to read information about the chip.

Generally available: You can now build Google Chat apps as Google Workspace add-ons. For details, see Extend Google Chat.

Generally available: You can now build Google Chat apps as Google Workspace add-ons. For details, see Extend Google Chat.

(Developer Preview): You can now subscribe to events in Google Drive. The following event types are supported:

• A file is added to a folder or shared drive.
• A file is moved to a folder or shared drive.
• A file is edited or a new revision is uploaded.
• A file is trashed or removed from the trash.
• An access proposal is created or resolved on a file.

For details, see Subscribe to Google Drive events in the Google Workspace Events API documentation. For information on how to receive Google Drive events from Google Cloud Pub/Sub, see Work with events from Google Drive.

(Developer Preview): The Google Workspace Events API now supports subscriptions to Google Drive. The API supports the following types of events:

• A file is added to a folder or shared drive.
• A file is moved to a folder or shared drive.
• A file is edited or a new revision is uploaded.
• A file is trashed or removed from the trash.
• An access proposal is created or resolved on a file.

For details, see Subscribe to Google Drive events.

Reports API: You can now retrieve activity events for Gemini in Workspace Apps. These events provide insights into how users in your organization are using Gemini. To retrieve these events, use the activities.list method with applicationName=gemini_in_workspace_apps. For details, see the reference documentation.

Generally available: Create, update, and read Google Drive and People chips in Google Sheets API. To learn more, see Smart chips in the Sheets API documentation.

Developer Preview: Chat apps can now format text with markdown, including lists and code blocks.

The following app-specific fields on the space.message resource are now populated when the created and updated Google Chat events are sent:

• threadKey
• clientAssignedMessageId
• slashCommand
• MatchedUrl

See the space.message resource.

See the list of Google Chat event types.

For Google Workspace organizations that use hardware key encryption, the Gmail API supports using smart cards for client-side encryption (CSE). For details, see the reference documentation for CseIdentity and CseKeyPair resources.

Generally Available: Granular OAuth permissions are now supported for HTTP Google Workspace add-ons. The granular OAuth consent screen lets users specify which individual OAuth scopes they want to authorize.

Keep the following dates in mind when you're building or modifying add-ons:

• HTTP Google Workspace add-ons built after May 27, 2025 must support granular consent.
• Existing add-ons have until December 1, 2025 to add support for granular consent.
• After December 1, 2025, all HTTP Google Workspace add-ons must support granular consent.

For more information about how to add support for granular consent, refer to Build a Google Workspace add-on using HTTP endpoints.

You can now use the Forms Service to publish forms, and to have granular control over who can respond to forms.

Learn about the setPublished method to publish forms.

You can now use the Forms API to publish forms, and use the Drive API to have granular control over who can respond to forms.

• Learn about publishing and adding responders.
• Learn about the setPublishSettings method in the Forms API.
• Learn about the permissions.create method in the Drive API.

Generally Available: You can now call the Chat API to get or update a user's notification settings for a Chat space. For details, see the following guides:

• Get a user's space notification settings
• Update a user's space notification settings

Generally available: Chat apps can respond to quick commands. To use quick commands, users select the command from the message reply area in a Chat space. To learn more, see Respond to Google Chat app commands.

Generally available: Chat apps can respond to quick commands. To use quick commands, users select the command from the message reply area in a Chat space. To learn more, see Respond to Google Chat app commands.

Google Chat API now supports mentioning users who haven't joined a Chat space or are members of a space that is in import mode when sending a message with user authentication. To learn how, see Mention users in a text message.

Generally Available: The Google Drive API now supports folders with limited access which allow you to restrict folders to specific users. Folders with limited access broadens the expansive access model from shared drives to My Drive.

To limit access to a folder, developers can set the boolean inheritedPermissionsDisabled field on the files resource to true. Developers can also opt in to expansive access API behavior in My Drive ahead of any future mandatory enforcement by setting the enforceExpansiveAccess request parameter to true on the permissions.delete() and permissions.update() methods.

To learn more, see Manage folders with limited and expansive access.

Meet API:

Generally Available: All meeting participants can now query for certain conference data including the conference records, the conference artifacts, and the participant records.

Generally Available: Granular OAuth permissions are now supported for users executing scripts in the Apps Script IDE. The granular OAuth consent screen lets users specify which individual OAuth scopes they would like to authorize. The granular consent screen will gradually launch to the remaining Apps Script surfaces, such as add-ons and trigger executions, in the future.

For more information, refer to the Workspace Updates blog post: Granular OAuth consent in Google Apps Script IDE executions.

Generally Available: To complement the release of the granular consent flow in Apps Script IDE executions, the following methods have been added to the ScriptApp and AuthorizationInfo classes to let Apps Script developers programmatically interact with the scopes granted for a script.

ScriptApp class:

• requireScopes(authMode, oAuthScopes)
• requireAllScopes(authMode)
• getAuthorizationInfo(authMode, oAuthScopes)

AuthorizationInfo class:

• getAuthorizedScopes()

For more information, refer to Handle granular OAuth permissions.

Developer Preview: Quick commands are a new way for users to invoke and interact with a Chat app directly without typing a slash command. For details, see Respond to quick commands as a Google Chat app.

Developer Preview: Quick commands are a new way for users to invoke and interact with a Chat app directly without typing a slash command. For details, see Respond to quick commands in Google Chat.

Developer Preview: You can now design your Chat app to include a carousel, which is a layout that rotates and displays a list of cards in a slideshow format, with buttons navigating to the previous or next carousel card. For details, see Carousel.

Developer Preview: Chat apps can now create (RPC, REST), update (RPC, REST), and get details about (RPC, REST) Chat space permission settings by calling the corresponding method in Chat API using app authentication with the https://www.googleapis.com/auth/chat.app.spaces or https://www.googleapis.com/auth/chat.app.spaces.create authentication scope, including creating announcement spaces.

To learn more about Chat app authentication, see Types of required authentication and Authenticate as a Chat app.

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

You can now access birthday and other special events that are automatically created from Google Contacts using the Calendar API.

Birthday events now have birthdayProperties that show birthday-specific event data, such as the type of the special event, whether it's a birthday, an anniversary, or another significant date, and the contact that the event is linked to. You can use the contact as a resource name in the People API to fetch contact details.

To learn more, see the developer guide for the birthday event type.

Generally Available: If you're migrating to Google Chat from other messaging platforms, you can now create a group chat in import mode using the spaces.create method.

Developer Preview: You can now use a read-only scope (https://www.googleapis.com/auth/chat.customemojis.readonly) to get or list custom emoji.

Developer Preview: You can now call the Chat API to get or update a user's space notification settings. To learn more, see the spaceNotificationSetting reference documentation.

Generally Available: The following widgets are now available for building card-based user interfaces:

• Chip
• Overflow Menu
• Material Buttons
• Collapsible Text paragraph
• Customizable control button of collapsible Section

Chat apps can use these widgets in card messages, homepages, and dialogs. For examples, see Design an interactive card or dialog.

Developer Preview: When creating custom emoji is turned on for a Workspace organization, you can now call Chat API to manage custom emoji:

• Create custom emoji (RPC, REST)
• Delete custom emoji (RPC, REST)
• Get custom emoji (RPC, REST)
• List custom emoji (RPC, REST)

To learn more, see CustomEmoji (RPC, REST) in the Chat API documentation.

Generally Available: Google Sheets now supports smart chips for link previews to third-party resources. To learn more, see Preview links with smart chips.

Generally available: You can now call the Chat API to create announcement spaces, and read and update the permission settings of a space. For more information, see the following reference documentation:

• PredefinedPermmissionSettings field for the Spaces resource
• PermissionSettings field for the Spaces resource

Developer Preview: The following Chat API methods support app authentication using a new type of authentication scope, https://www.googleapis.com/auth/chat.app.*:

• Create a named space as a Chat app with https://www.googleapis.com/auth/chat.app.spaces or https://www.googleapis.com/auth/chat.app.spaces.create.
• Update a space as a Chat app with https://www.googleapis.com/auth/chat.app.spaces.
• Delete a named space as a Chat app with https://www.googleapis.com/auth/chat.app.delete.
• Get details about a space as a Chat app with https://www.googleapis.com/auth/chat.app.spaces.
• Invite or add a user to a space as a Chat app with https://www.googleapis.com/auth/chat.app.memberships.
• Update a membership as a Chat app with https://www.googleapis.com/auth/chat.app.memberships.
• Remove a member from a space with https://www.googleapis.com/auth/chat.app.memberships.

To learn more, see Types of required authentication and Authenticate as a Chat app.

(Generally available) - For event subscriptions, you can now use the eventTypes field in the updateMask parameter of the subscriptions.patch method to change the event types to receive for the target resource.

The Google Drive API returns a long-running operation (LRO) every time you call the files.download method to download blob file content or export Google Workspace document content either through the Drive API or its client libraries.

The files.download method returns an Operation resource to the client. You can use the Operation interface to asynchronously retrieve the status of the API method by polling the operation through the GetOperationRequest method.

The files.download method is the only way to download Google Vids files in MP4 format and is typically best suited to downloading most video files.

To learn more, see Manage long-running operations.

Generally Available: The chatSpaceLinkData object has been added to the RichLinkMetaData field of the spaces.messages resource. This lets you add a smart chip to your message that points to a Chat space in any field that supports formatted text.

Generally Available: Google Workspace administrators can now call the Google Chat API to manage and search Google Chat spaces across their organization. This functionality lets them manage spaces at scale and automate common or repeatable tasks, such as the following:

• Search spaces based on specified criteria
• List members of a space
• Add members to and remove members from a space
• Get details about a member and a space
• Update or delete a space
• Update a user's membership

For more information about managing spaces, read the documentation at Manage Google Chat spaces as a Google Workspace administrator.

For more information about searching spaces, read the documentation at Search for and manage Google Chat spaces for your Google Workspace organization.

Developer Preview: If you're migrating to Google Chat from other messaging platforms, you can now create a group chat in import mode using the spaces.create method.

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.

Developer Preview: The following widgets are now available for building card-based user interfaces:

• Chip
• Overflow Menu
• Material Buttons
• Collapsible Text paragraph
• Customizable control button of collapsible Section

Chat apps can use these widgets in card messages, homepages, and dialogs. For examples, see Design an interactive card or dialog.

Generally available starting September 17, 2024: Create and manage birthdays directly within Google Calendar. Birthdays are exposed in the Calendar API as a new eventType called "birthday" which distinguishes special all-day events with an annual recurrence. Birthday events support a limited set of event properties.

You can filter by the birthday event type using the events.list() and events.watch() methods. If no type filters are specified, all event types including birthdays are returned.

To learn more, see our developer guide about working with the birthday event type.

(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

(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

Generally Available: You can now get, edit, and delete tasks assigned from Google Docs documents or Chat spaces using the Tasks API. For more information, refer to the tasks reference documentation.

The Google Drive API now supports the drive.meet.readonly scope. This restricted scope lets you view Drive files created or edited by Google Meet.

For details, see Choose Google Drive API scopes.

Generally Available: You can now import a space from other messaging platforms, and allow external users to join that Chat space. For more information, see the externalUserAllowed option.

Generally Available: When building Chat apps using Google Cloud Functions, Cloud Run, or any system that supports authentication via ID tokens, you can now Authenticate requests using Cloud Functions or Cloud Run or Authenticate requests with an App URL ID Token to verify that the requests to your app came from Google Chat.

Generally Available: You can now call the Chat API to Make a Google Chat space discoverable to specific users in a Google Workspace organization using the accessSettings field on the Space resource. You can read the URI of the space using the spaceUri field.

(Generally Available): Dialogflow CX Chat apps can open dialogs and receive data inputted by users in card messages and dialogs.

(Developer Preview): You can now use the Chat API to create announcement spaces, plus read and update the permission settings of a space. For more information, see the PredefinedPermissionSettings and PermissionSettings fields.

(Generally Available): You can now add a Google Group to a Chat space using the spaces.members.create method or the spaces.setup method. You can remove a Google Group from a space using the spaces.members.delete method.

Google Chat apps can now create a subscription to receive events for all Chat spaces where the user is a member. To target all spaces for a user, set the subscription's targetResource field to //chat.googleapis.com/spaces/-. To learn more, see Subscribe to Google Chat events.

Google Chat apps can now create a subscription to receive events for all Chat spaces where the user is a member. To target all spaces for a user, set the subscription's targetResource field to //chat.googleapis.com/spaces/-. To learn more, see Subscribe to Google Chat events.

(Developer Preview): If you're a domain administrator or a delegated administrator, you can now include the useAdminAccess parameter when you call the Chat API with your administrator privileges with the following methods to manage Chat spaces and memberships in your Workspace organization:

• Get a space
• Update a space
• Get a member
• Update a member

To learn more, see Authenticate and authorize using administrator privileges.

(Developer Preview): If you're a domain administrator or a delegated administrator, you can now include the useAdminAccess parameter when you call the Chat API with your administrator privileges to manage Chat spaces and memberships in your organization. The following API methods are supported:

• Search spaces
• Delete spaces
• List memberships
• Create memberships
• Delete memberships

To learn more, see Authenticate and authorize using administrator privileges.

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): You can now get and update a user's read state in a space, and get a user's read state in a message thread. User read states are singleton resources that represent details about a specified user's last read message.

The users.spaces resource represents a user's read state in a space. The users.spaces.threads resource represents a user's read state in a message thread.

User read states support the following methods:

• Get space read state to return details about a user's read state within a space.

• Update space read state to update a user's read state within a space.

• Get thread read state to return details about a user's read state within a thread.

(Generally Available): Build a Chat app that understands and responds with natural language using a direct integration between Dialogflow CX and Google Chat API. To learn how, see Build a Dialogflow CX Google Chat app.

(Generally available): Your Chat app can now send an app home card message to a user. This message is a customizable card message that a Chat app sends to a user when they open a direct message with the Chat app.

For details, see Send an app home card message for a Google Chat app.

(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): 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 update a human user's membership in a Chat space to change their role between regular member and space manager using the spaces.members.patch method. To learn more, see Update a user's membership in a Google Chat space.

(Developer Preview): You can now import a space from other messaging platforms, and allow external users to join that space. For more information, see the externalUserAllowed option.

(Generally available): Google Chat apps can now use accessory widgets, which are interactive widgets that appear at the bottom of a message. For details, see Send a message.

(Developer Preview): You can now get or list events about a Google Chat space. For example, you can track periodic resource changes, such as monthly reports of new or changed members in a space, or fetch events that are missing from subscriptions using the Google Workspace Events API.

The following types of space events are supported:

• A message is created or updated.
• A member is added, updated, or removed.
• The space is updated.

For more information, see the following:

• Work with events from Google Chat.
• Get details about an event in a space.
• List events from a space.

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

(Developer Preview): Build a Chat app that understands and responds with natural language using a direct integration between Dialogflow CX and Google Chat API. To learn how, see Build a Dialogflow CX Google Chat app.

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

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

(Generally available): The formattedText field on the Message resource includes the markup syntax for bulleted list text formatting. For more information, see Format a text message.

(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): 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.

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

(Developer Preview): The Google Workspace Events API supports the get() method on the Operations resource.

(Developer Preview): The Google Workspace Events API now sends lifecycle events when subscriptions expire. For details, see Subscription expired events.

(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): Google Workspace Add-ons now support link previews in Google Sheets and Slides. To learn more, see Preview links with smart chips.

(Developer Preview): Chat apps can now subscribe to events about users. The following event types are supported:

• New memberships
• Updated memberships
• Deleted memberships
• Multiple memberships have changed

For details, see Subscribe to Google Chat events in the Google Workspace Events API documentation.

(Developer Preview): You can make a Chat space discoverable to a target audience instead of inviting users individually.

(Developer Preview): The Google Workspace Events API now supports subscriptions to Google Chat users. Subscriptions to Chat users support the following event types:

• New memberships
• Updated memberships
• Deleted memberships
• Multiple memberships have changed

For details, see Subscribe to Google Chat events.

(Generally available): Import data from your other messaging platforms into Google Chat. You can import existing messages, attachments, reactions, memberships, and space entities from your other messaging platforms to corresponding Chat API resources. You can import this data by creating Chat spaces in import mode and importing data into those spaces.

(Generally available): You can now migrate historical memberships when you import data into Google Chat.

(Developer Preview): Chat apps can now add interactive buttons to the bottom of messages. For details, see the reference documentation.

Chat apps can now send messages privately in spaces with multiple people. For details, see Send private messages to Google Chat users.

Directory API

(Generally available): You can now change the device status of ChromeOS devices in batch. For more information, refer to Deprovisioning or disabling Chrome devices.

(Generally available): The Card Builder Tool is now available to help you design and preview card messages in Google Chat apps.

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

Meet Add-ons SDK:

• (Developer Preview): The Google Meet Add-ons SDK is now available as part of the Developer Preview Program. The Meet Add-ons SDK lets you embed your app into Google Meet as an add-on where users can discover, share, and collaborate in the app without leaving Meet.

Developer Preview: You can now get and update a user's read state in a space, and get a user's read state in a message thread. User read states are singleton resources that represent details about a specified user's last read message.

The users.spaces resource represents a user's read state in a space. The users.spaces.threads resource represents a user's read state in a message thread.

User read states support the following methods:

• Get space read state to return details about a user's read state within a space.

• Update space read state to update a user's read state within a space.

• Get thread read state to return details about a user's read state within a thread.

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

(Generally available): You can now retrieve Google Groups that are members of a Google Chat space using ListMemberships (with the showGroups option) and GetMembership. If you try to add a member to a Chat space while this member is already part of a Google Group in the same space, it triggers an already exists error (HTTP status code 409).

(Developer Preview): Your Chat app can now send an app home card message to a user. This message is a customizable card message that a Chat app sends to a user when they open a direct message with the Chat app.

(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): 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.

(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

(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

Meet API:

• (Developer Preview): Google Meet API is now available as part of the Developer Preview Program. Meet API lets you create and manage meetings for Google Meet and offers entry points to your users directly from your app.

(Developer Preview): Google Chat apps can now subscribe to the following types of events about message reactions:

• New reactions
• Removed reactions
• Multiple reactions have changed.

For details, see Subscribe to Google Chat events.

(Developer Preview): Subscriptions to Google Chat spaces now support the following event types:

• New reactions
• Removed reactions
• Multiple reactions have changed.

For details, see Subscribe to Google Chat events.

(Developer Preview): You can now migrate historical memberships when you import data into Google Chat.

(Generally available): Multiselect menus for cards and dialogs are now generally available. Multiselect menus let users select Google Workspace users and spaces, or select items from external data sources. For details, see Selection input.

Live Sharing SDK:

• Added a RecordingInfo field to the AddonMeetingInfo resource that indicates if the current Google Meet call is being recorded.

• Added the verifyRecordingInfo method to the AddonSession.Builder resource to specify if the Meet Add-ons SDK should make sure that the add-on application has the correct recording status. If this method is called and there's a discrepancy between the add-on and Meet in regards to the recording status, then Meet severs the add-on connection and the session is terminated.

   addonClient.newSessionBuilder(appContext, new MyAddonSessionDelegate())
         .withParticipantMetadata(new MyMetadataDelegate(), initialMetadata)
         .withCoWatching(new MyCoWatchingHandler())
         .withCoDoing(new MyCoDoingHandler())
         .verifyRecordingInfo() // Newly added method
         .begin();
  

• Artifact released: com.google.android.meet:meet-addons:2.0.0-alpha04.

You can now use the formattedText field to view the text formatting sent in a message.

Developer Preview: You can now update a human user's membership in a Chat space. For example, you can use the spaces.members.patch method to update membership roles from member to manager and from manager to member.

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

Generally available: Reading and updating working locations using the Google Calendar API is now generally available. For details, see Manage working locations for Google Calendar users.

Google Chat apps that authenticate as a user can now reference users with their email address. The following Chat API methods support using email addresses to reference users:

• Set up a space
• Find a direct message
• Create a membership
• Get a membership
• Delete a membership

Chat apps can also use email addresses to @mention users. To learn more, see Mention users in a message.

A new content restriction parameter that only the file owner can modify (ownerRestricted) was added.

In addition, three capabilities were added:

• capabilities.canModifyEditorContentRestriction
• capabilities.canModifyOwnerContentRestriction
• capabilities.canRemoveContentRestriction

For details, see Protect file content.

You can now specify no divider between card sections.

You can now specify no divider between card sections.

Multiselect menus are now available in Developer Preview. Multiselect menus help users input static and dynamic data for Google Chat apps. To learn more, see the Selection input widget documentation.

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.

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.

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

Import data from your other messaging platforms into Google Chat. You can import existing messages, attachments, reactions, memberships, and space entities from your other messaging platforms to corresponding Chat API resources. You can import this data by creating Chat spaces in import mode and importing data into those spaces.

Live Sharing SDK: Added onParticipantPrivilegeChanged callback to AddonSessionHandler. Artifact released: com.google.android.livesharing:livesharing:2.0.0-alpha02.

You can now design your Chat app to include checkboxes, radio buttons, switches, or a dropdown menu in your Chat app. For more information, see SelectionInput widget.

Live Sharing SDK: Added LiveSharingSessionDelegate to the API. Artifact released: com.google.android.livesharing:livesharing:1.2.0.

Chat apps can now receive and respond to user-submitted information in cards and dialogs. For more information, see Process information inputted by users.

Live Sharing SDK:

• Added notifyLiveSharingFailureEvent method to API for failure reporting.
• Artifact released: com.google.android.livesharing:livesharing:1.1.0.

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

You can now build third-party smart chips for Google Workspace Add-ons. To use 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.

Developer Preview: The Google Calendar API now supports reading and updating working locations. For details, see Manage working locations for Google Calendar users.

Live Sharing SDK:

• Added API for setting participant metadata. Note: This functionality is not yet present. This will occur in a future release.
• Artifact released: com.google.android.livesharing:livesharing:1.0.0-eap07

On the web, Google Chat cards now match Google Material Design. The Material Design cards feature aesthetic enhancements that improve usability and render faster.

Live Sharing SDK:

• Surfaced LiveSharingMeetingInfo.Builder to API consumers for ease-of-testing.
• Added new overload of LiveSharingClientFactory#getClient, permitting API consumers to provide their own executor services. Consumers can begin using this API, but the SDK does not yet respect the provided executors. This will occur in a future release.
• Added error code mechanism to LiveSharingException, allowing common errors to be tagged with a canonical code. Currently supports one error code: MEET_VERSION_UNSUPPORTED.
• Enabled #queryMeeting() feature.
• Artifact released com.google.android.livesharing:livesharing:1.0.0-eap05.

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

On mobile devices, Google Chat cards now match Google Material Design. The Material Design cards feature aesthetic enhancements that improve usability and render faster.

Live Sharing SDK: Artifact released com.google.android.livesharing:livesharing:1.0.0-eap04

Live Sharing SDK: Artifact released com.google.android.livesharing:livesharing:1.0.0-eap03

Live Sharing SDK: Enables logging for ERROR-level logs for better debugging with partners. This will be reverted at the end of the EAP program; any details revealed in these logs are covered by NDA.

Live Sharing SDK: Artifacts released com.google.android.livesharing:livesharing:1.0.0-eap02

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.

The Calendar API now supports custom attachments. See Calendar add-ons for more information.

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.

The Calendar API now exposes a new eventType. The new type is called focusTime and allows users of the API to distinguish the special focus time events. For more information, see the API reference.

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.

Two new quotas now exist for the Calendar API in addition to the general Calendar usage limits:

• Per minute per project.
• Per minute per project per user.

See Manage quotas for more information.

You can use the calendarId from the API endpoint https://www.googleapis.com/calendar/v3/calendars/calendarId to identify the owner of the out of office event.

The Calendar API now exposes a new field for events. The new field is called eventType and allows users of the API to distinguish special event types, such as outOfOffice. For more information, see the API reference.

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.

Reports API: A new parameter member_type has been added to the Enterprise Groups activity report. Valid member types include user, group, service account, and other.

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 Calendar API allows attaching a conference data of type addOn to a new or existing event using Events.insert or Events.update methods.

• 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 Calendar API now supports four new OAuth scopes. The scopes allow your application to limit access to only the data you really need. See Authorizing Google Calendar API Requests for more details.

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

A more flexible approach to sending event change notifications is now available through the sendUpdates parameter. The new parameter lets you set event change notifications to do one of the following:

• Notify all the event guests.
• Notify only the guests who are not using Google Calendar.
• Completely suppress the notifications, for example, during a migration.

Now it is possible to always keep in sync guests who use other calendaring systems, without sending too many non-mandatory emails to Google Calendar users.

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.

Reports API: We have created the Entities Usage Report to generate reports on entities used by your account's users. The API currently supports reporting for Google+ communities.

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

Hangouts and Google Meet conferences are now supported in Calendar events via the conferenceData field. You can:

• Read conference data associated with events.
• Copy conference data from one event to another.
• Request new conference generation for an event.
• Clear conference data associated with events.

To learn more, see Create Events.

Reports API: Nine new parameters have been added to the Google+ customer usage report. The new parameters are:

• num_communities
• num_communities_public
• num_communities_private
• num_communuties_organization_wide
• num_communities_organization_private
• num_collections
• num_collections_public
• num_collections_organization_wide
• num_collections_organization_private

In addition, the Google+ user usage report was created with seven metrics:

• num_shares
• num_plusones
• num_plusones_received
• num_replies
• num_replies_received
• num_reshares
• num_reshares_received

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

Reports API: We have added the App Maker and Apps Script customer usage reports to the customerUsageReports.get method. These new reports allow you to view information about App Maker and Apps Script usage in your domains.

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

Reports API: Six new parameters have been added to the Google+ customer usage report. The new parameters are:

• num_new_users
• num_shares
• num_reshares
• num_plusones
• num_replies
• num_stream_items_read

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

The history.list method supports filtering history records by type.

The messages.batchModify method lets you modify labels on multiple messages by message IDs, in a single batch operation.

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.

New endpoints for managing mail settings:

• Send-as aliases and Signatures
• Forwarding
• Filters
• Vacation Responder
• POP and IMAP

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.

The messages.batchDelete method lets you delete multiple messages, by message IDs, in a single batch operation.

The drafts.list method has an includeSpamTrash option, which determines if the response should include drafts with the SPAM or TRASHlabel applied. The default is currently set to true for this option.

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.

To determine the full state of an email before and after a change, the history.list method returns all current Message.labelIds as part of the response in messagesAdded, messagesDeleted, labelsAdded, and labelsRemoved.

Added a Message.internalDate field that exposes the message's creation timestamp in the mailbox.

You can now send push notifications on mailbox updates, providing real-time server notification without the need for constant polling. With Cloud Pub/Sub, you can now use webhooks—for example, to receive callbacks when updates happen. Additionally, you can filter these notifications to specific Gmail labels.

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

The messages.insert method now supports the deleted request parameter and lets you set SENT and DRAFT labels.

The history.list method now provides details of the change type in each history record. For example, using the messagesAdded, messagesDeleted, labelsAdded, or labelsDeleted enums, it's possible to easily tell how a message was changed and typically avoids the need for additional calls to synchronize your client.

The messages.import method now supports the following parameters to better support Email Migration use cases:

• neverMarkSpam
• processForCalendar
• deleted

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)

Reports API: We have added the Mobile Device customer usage report to the customerUsageReports.get method. This new report allows you to view information about mobile device usage in your domains.

You can now specify message.labelIds on messages.import requests to automatically apply the given labels to the message.

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.

Reports API: We have added the Google Calendar audit report to the activities.list method. This new report allows you to view information about changes to calendars and calendar events for users in your domain.

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

Reports API: We have added the Google Sites customer usage report to the customerUsageReports.get method. This new report allows you to view information about Google Sites usage in your domains.

Reports API: We have added the OAuth Token Audit reporting application to the activities.list method. This new report allows you to view information about third party websites and applications that users in your domains have granted access to.

Reports API: Added the following parameters to the Gmail customer usage report:

• num_inbound_delivered_emails
• num_inbound_rerouted_emails
• num_inbound_rejected_emails
• num_inbound_spam_emails
• num_inbound_non_spam_emails
• num_inbound_encrypted_emails
• num_inbound_unencrypted_emails
• num_outbound_delivered_emails
• num_outbound_rerouted_emails
• num_outbound_rejected_emails
• num_outbound_encrypted_emails
• num_outbound_unencrypted_emails

Reports API: We have added the ChromeOS Devices customer usage report to the customerUsageReports.get method. This new report allows you to view information about ChromeOS device usage in your domains.

You can now specify the return format for the threads.get method. The available formats are full, metadata, and minimal, similar to the messages.get method. The raw format isn't allowed for the threads.get to avoid unexpectedly large amounts of data being returned.

The getProfile method provides mailbox-wide information like current history ID and total message and thread counts.

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

Added a new IMPORTANT label to match functionality with the Gmail UI.

Added new fields to the Labels resource to simplify counting how many messages have a given label applied:

• messagesTotal
• messagesUnread
• threadsTotal
• threadsUnread

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

You can specify the internalDateSource for both the messages.insert and messages.import methods.

Reports API: A new view event has been added to the Drive activity report.

Directory API: The following fields have been added to the Mobiledevices resource:

• serialNumber
• imei
• meid
• wifiMacAddress
• networkOperator
• defaultLanguage
• managedAccountIsOnOwnerProfile
• deviceCompromisedStatus
• buildNumber
• kernelVersion
• basebandVersion

Directory API: The Chromeosdevices resource has the following fields:

• recentUsers
• Device's ethernetMacAddress

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

Reports API: The Drive activity report is now available. This new report provides insight about Drive activity and how your account's users manage, modify, and share their Google Drive documents. This report is available only for G Suite Business customers and replaces the Google Docs activity report. The Google Docs activity report is now deprecated and will cease functioning on January 31, 2015.

Reports API: Includes usage statistics from suspended users in Customers Usage reports.

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

Reports API: A new num_users_2sv_not_enrolled_but_enforced parameter has been added to the customer accounts usage report. This new parameter indicates the number of domain users that have 2-step verification enforced but have not enrolled.

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.

Reports API: Added two new login_failure_type values to the Login Audit events: login_failure_account_disabled and login_failure_unknown.

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

Reports API: Added the following fields to the Customer Account Usage and Users Account Usage reports:

• Customer Accounts
  • num_authorized_apps
  • authorized_apps
  • drive_used_quota_in_mb
  • gmail_used_quota_in_mb
  • gplus_photos_used_quota_in_mb
  • total_quota_in_mb
  • used_quota_in_mb
  • apps_total_licenses
  • apps_used_licenses
  • vault_total_licenses
  • coordinate_total_licenses
• User Accounts
  • num_authorized_apps
  • drive_used_quota_in_mb
  • gmail_used_quota_in_mb
  • gplus_photos_used_quota_in_mb
  • total_quota_in_mb
  • used_quota_in_mb
  • used_quota_in_percentage

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

Reports API: Suspended users are now included in the statistics for Google Docs reports. Some domains might notice an increase in the number of reported documents. The following parameters have been added to the User's usage report:

• Accounts: used_quota_in_percentage
• Docs
  • num_docs_externally_visible
  • num_docs_internally_visible
• Gmail: num_emails_exchanged

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

• getActiveUserLocale()
• getActiveUserTimeZone()

Directory API: Supports push notifications for changes to users and aliases. You no longer need to poll resources to detect changes. You can create a notification channel using the users.watch and users.aliases.watch methods. You can stop receiving notifications with the channels.stop method.

Directory API: Structured search queries for users are available by using the users.list method.

Reports API: Added push notifications for changes to the Activities resource. This is exposed in the API as two new methods, activities.watch and channels.stop, to start and stop receiving notifications.

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

Reports API: Added support for resellers to retrieve usage reports and audit information for a specific customer. This is exposed in the API as a new customerId parameter for the activities.list, customerUsageReports.get, and userUsageReport.get methods.

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

The Review Action is out of preview, and now available to all users.

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

The Schema Validator tool in Testing Your Schemas has been replaced with the new Email Markup Tester.

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.

Reseller API: To retrieve all of a customer's subscriptions, use the customer's customerId parameter. For more information, see Retrieve & update a subscription.

Reseller API: To retrieve all transferable subscriptions for a customer, use the customer's customerId and the customerAuthToken. For more information, see Retrieve all transferable subscriptions for a customer.

Reseller API: When retrieving all transferable subscriptions for a customer, the response contains a subscription's transferInfo property with the tranferabilityExpirationTime and minimumTransferSeats attributes.`

Reseller API: The customer resource's resourceUiUrl URL to customer's Admin console dashboard. The read-only URL is generated by the API service. This is used if your client application requires the customer to complete a task in the Admin console.

Reseller API: The API can retrieve the full account settings of one of your resold customers or the customerId and customerName of a standalone Google customer or a customer managed by another reseller.

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.

It is now possible to use schemas to define Orders, Parcel Deliveries, and the TrackAction to let users track packages being delivered.

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

The RSVP Action is now enabled for all emails sent by Google Calendar.

Added XmlService to replace the old Xml service.

Reseller API: A subscription's optional status property can be ACTIVE, CANCELLED, PENDING, or SUSPENDED. For more information, see the subscriptions resource.

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