Developer Preview: You can now build Google Chat apps as Google Workspace add-ons that useCloud Pub/Sub to receive messages. This architecture is useful if your Chat app is behind a firewall. For details, seeBuild a Chat app that uses Pub/Sub.

Generally Available: TheGmail Postmaster Tools API v2 is now generally available. The API provides access to the full Postmaster Tools dataset—including compliance status data—and includes enhancements like flexible querying withqueryDomainStats and support for batch operations. For details on how to use the v2 API, see the updatedPostmaster Tools API documentation.

Generally Available: You can now convert your interactive event-driven Chat apps to Google Workspace Add-ons that extends Chat.

By converting, your Google Chat app can use the Google Workspace Add-ons framework, opening up new possibilities for integration and features within Google Chat and across Google Workspace. For example, instead of two distributions — one Google Chat app and one Google Workspace add-on — you can distribute a single Google Workspace add-on through Google Workspace Marketplace that extends Chat apps alongside other Google Workspace host applications, like Gmail, Calendar, and Docs.

To learn more, seeConvert an interactive Google Chat app to a Google Workspace add-on.

Generally Available: Use Apps Script's Vertex AI advancedservice to call the Vertex AI API and prompt AI models to generate text, images,and more.

For details, see theVertex AI advanced service reference documentation.

ThelicenseNotification resource and thelicenseNotification.list method are now deprecated. ThelicenseNotification.list method previously retrieved a list of licensing notifications for a given app.

There is no alternative resource or method within the Google Workspace Marketplace API. However, user-initiated install events can be tracked throughGoogle Analytics.

TheGoogle Chat platform samples gallerynow lets you find samples by products, language, and sample type. The galleryalso features the following new samples for building Chat apps:

• Agent2Agent agents
• ADK AI agents
• Dialogflow ES
• Dialogflow CX

TheApps Script samples gallerynow lets you find samples by use case, products, and sample type. The galleryalso features the following new samples:

• Build a Google Chat app with an ADK AI agent
• Build a Chat app with an Agent2Agent agent
• Analyze and label Gmail messages with Gemini and Vertex AI

Developer Preview: You can now build Chat apps that extend Google Workspace add-ons using Apps Script's AddOnsResponseService. For details, seeAddOns Response Service.

TheAdd-ons samples gallerynow lets you find samples by products, languages, sample type, and add-on type.The gallery also features the following new samples:

• Build Chat apps usingAgent2Agentagents,ADK AIagents,DialogflowES,andDialogflowCX
• Plan travels with an AI agent accessible across Google Workspace
• Analyze and label Gmail messages with Gemini and Vertex AI

License Manager API: The SKU name "Gemini Education" has been renamed to "Google AI Pro for Education." For details, see theGoogle Product and SKU IDs documentation andannouncement.

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

• An approval is created, cancelled, reset, or completed on a file.
• An approval reviewer is changed on a file.
• An approval reviewer responded to an approval on a file.

For details, seeSubscribe 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, seeWork with events from Google Drive.

Generally Available: The Google Drive API now supports the reading of content approvals on Drive files through theapprovals resource. To retrieve approvals on a file, you can use either theget orlist method.

For details, seeManage approvals.

Meet API

Developer Preview: Subscriptions are now available for the followingsmartNotes events:

• google.workspace.meet.smartNote.v2.started
• google.workspace.meet.smartNote.v2.ended
• google.workspace.meet.smartNote.v2.fileGenerated

For details, seeSubscribe to Google Meet events in the Google Workspace Events API documentation.

For information on how to receive Google Meet events from Google Cloud Pub/Sub, seeRespond to events from Google Meet.

Meet API

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

You can now retrieve smart notes files in a conference record using theget andlist methods on thesmartNotes resource.

For details, seeWork with artifacts.

Developer Preview: You can now dynamically populate drop-down menus inGoogle Chat apps with data from Google Workspace or external data sources,with an autocomplete functionality. To learn more, seeAdd interactive UI elements to cards.

Developer Preview: You can now call the Chat API to create and managecustom sections and organize conversations in a personalized view:

• Create section (RPC,REST)
• Delete section (RPC,REST)
• List sections (RPC,REST)
• Update section (RPC,REST)
• Position section (RPC,REST)
• List section items (RPC,REST)
• Move section items (RPC,REST)

To learn more, seeSection (RPC,REST) andSectionItem (RPC,REST) in the Chat API documentation.

Limited Preview:Extending Google Workspace Studio with add-ons is in limited preview.

Generally available: The Chat API now supports reading rich links to Gmail threads in Chat messages that appear as chips. To learn more, seeRichLinkType in the Chat API reference documentation.

Developer Preview: You can now buildDialogflow CXandDialogflow ESChat apps as Google Workspace add-ons.

Generally Available: You can now build add-ons that extend Google Workspace Studio (previously known as Google Workspace Flows). For details, seeExtend Google Workspace Studio.

For ideas about what you can build, seeIntroducing Google Workspace Studio: Automate everyday work with AI agents in the Google Workspace blog.

Developer Preview: You can now access data in Gmail Postmaster Tools v2using the v2beta API. The new API provides access to the full Postmaster Toolsdataset, including compliance status data.

The v2beta API also includes enhancements such as thequeryDomainStats method forflexible querying, and adds support for batch operations.

To learn how to use the API, see thePostmaster Tools API documentation.

Meet API

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

You can now identify and join a meeting space using thephoneAccess andgatewaySipAccess fields on thespaces resource.

For details, seeHow Meet identifies a meeting space.

Meet API

Generally Available: Calendar invitees can now receivegoogle.workspace.meet.conference.v2.started andgoogle.workspace.meet.transcript.v2.fileGenerated events.

For details, seeSubscribe to Google Meet events in the Google Workspace Events API documentation.

For information on how to receive Google Meet events from Google Cloud Pub/Sub, seeRespond to events from Google Meet.

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

• A user posts a comment in a Google Docs, Sheets, or Slides file.
• A user replies to a comment.

For details, seeSubscribe 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, seeWork with events from Google Drive.

Developer Preview: Chat apps can find existing group conversations with specific members usingFindGroupChats.

Generally available starting November 10, 2025:

Secondary calendars will now have a single data owner. This applies to both existing and newly created calendars. In the Calendar API, the data owner's email address will be in the read-onlydataOwner field in theCalendars andCalendarList resources.

To prevent unintended actions and undesired states, the following new restrictions apply:

• Only the data owner can delete secondary calendars.
• The data owner's access level cannot be changed from the defaultowner access.
• The data owner cannot remove an owned calendar from their calendar list. They can hide it from their UI.

When a new secondary calendar is created, the authenticated user that makes the request is the data owner. We recommend that you use user authentication to create secondary calendars. Data ownership can be transferred in the Google Calendar UI.

For more details, see the documentation forCalendars andCalendarList closer to November 10.

Gemini Alpha: As part of theGemini Alpha program, you can now build add-ons that extend Google Workspace Flows. For details, seeExtend Google Workspace Flows.

Generally available: We're enhancing membership roles in Chat spaces by introducing a new membership role type. In the Chat UI, existing space managers are now owners and a new manager role is added.

Previously, there were three membership role types in Chat API.MEMBERSHIP_ROLE_UNSPECIFIED, which meant a user wasn't a member but could be invited.ROLE_MEMBER, which meant a user was a member of the space. AndROLE_MANAGER, which meant a user was a space manager.

Now, in the Chat UI,ROLE_MANAGER users are called owners; this is a cosmetic change so permissions and the API enum remain the same. To help space owners administer spaces, we're introducingROLE_ASSISTANT_MANAGER which is called manager in the UI. Possible membership roles include:

• MEMBERSHIP_ROLE_UNSPECIFIED: Default value. For users: they aren't a member of the space, but can be invited. For Google Groups: they're always assigned this role.
• ROLE_MEMBER: A member of the space. In the Chat UI,this role is calledMember. Members have basic permissions, like reading messages in a space. Managers and Owners can grant them additional permissions, like adding or removing members, editing space details, and turning history on and off.
• ROLE_ASSISTANT_MANAGER: A space manager. In theChat UI, this role is calledManager. By default, managers have permission to make other members managers, delete messages, and change space permissions.
• ROLE_MANAGER: A space owner. In the Chat UI, this roleis calledOwner. Owners have the broadest set of permissions, including permission to make other members owners or delete the space.

To learn more, seeUpdate a user's membership in a Google Chat space andMembershipRole in the Chat API reference documentation.

Generally available: When sendingprivate messages, Chat apps can now include interactiveaccessory widgets.

Generally available: You can nowformat text with Markdown, including lists and code blocks, in your Chat apps.

Developer Preview: The following Chat API methods supportapp authentication with administrator approval when called withchat.app.* authorization scopes:

• Get a Chat space event.
• List Chat space events.

Additionally, Chat apps can now call the following methods in the Google Workspace Events API usingapp authentication with administrator approval withchat.app.* authorization scopes:

• Subscribe to Chat space events
• Update or renew a subscription
• Reactivate a subscription

Generally available: Increased per-space quota limits for writing messages and reactions with the Chat API:

• Whenimporting data to Google Chat, the per-space quota limit for writing messages withspaces.messages.create increases from 60 to 600 per minute.
• When writing reactions withspaces.messages.reactions.create, the per-space quota limit increases from 60 to 300 per minute.

To learn more, see the Chat API'sper-space quotas.

Generally available: 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, seeCarousel.

You can now use annotations to create Deal Cards in the Promotions tab.To get started, see theoverview of Deal Cards.

Developer Preview: The following Chat API methods supportapp authentication with administrator approval:

• Get a message as a Chat app with administrator approval usingchat.app.messages.readonly scope.
• List messages with a Chat app with administrator approval usingchat.app.messages.readonly scope.

Generally available: You can now call the Chat API to create messages that quote other messages, or to update messages to remove quotes. To learn more, seeQuote a message.

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

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

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

To learn more, seeTypes of required authentication andAuthenticate as a Chat app.

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

The Drive API has changed how download, print, and copy restrictions are applied.

Users with the role ofowner ororganizer can apply restrictions to other users withwriter roles, in addition toreader roles. Users can directly apply restrictions on files using theitemDownloadRestriction field within theDownloadRestrictionsMetadata object. Determination of whether file restrictions can be changed is controlled by the newcapabilities.canChangeItemDownloadRestriction field.

Similarly, users with the role of shared driveorganizer can directly apply restrictions on shared drives using thedownloadRestriction field within theRestrictions object. Determination of whether shared drive restrictions can be changed is also controlled by thecapabilities.canChangeDownloadRestriction field.

While the previous field (copyRequiresWriterPermission) that controlled download, print, and copy restrictions is still available, the functionality is different for both reading from and writing to the field. We recommend that you use the newDownloadRestriction object to enforce how users can download, print, and copy files.

For more information about how download, print, and copy restrictions are now applied for My Drive and shared drive files, see:

• Protect file content
• Manage shared drives

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

Generally available: You can now build Google Chat apps as Google Workspace add-ons. For details, seeExtend 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, seeSubscribe 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, seeWork 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, seeSubscribe to Google Drive events.

Generally Available: Google Workspace Marketplace has updated the app publishing process. For published apps, certain changes to your draft—such as adding new app integrations or modifying the app name or description—will now trigger a manual review before being published. You can now also cancel an app listing that has been submitted for review, which reverts the app to its draft state. To learn more, seeUpdate your app listing with drafts.

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

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

Google Analytics 4 has replaced Universal Analytics, which means the Apps Script Advanced Service for Google Analytics Management API and Reporting API is deprecated. Use theGoogle Analytics Data API Advanced Service instead.

Developer Preview: Starting on June 16, 2025, the following default Apps Script function names forGoogle Chat app triggers will change:

• ForAdded to space triggers, the default function name will change fromonAddToSpace toonAddedToSpace.
• ForRemoved from space triggers, the default function name will change fromonRemoveFromSpace toonRemovedFromSpace.

If your Chat app responds to being added or removed from Chat spaces, you can address this breaking change and avoid any potential errors by doing one of the following:

• In your Apps Script project, update the name of your functions toonAddedToSpace andonRemovedFromSpace. If required,create another versioned deployment of your Apps Script project and save the new deployment ID in theChat API Configuration page in the Google Cloud console.
• In the Google Cloud console, open theChat API Configuration page and in theTriggers section, update the function name for theAdded to space andRemoved from space triggers so that they use the function name that you're currently using in your Apps Script project.

To learn how to update your Chat app configuration in the Google Cloud console, seeConfigure a Google Chat app.

The following app-specific fields on thespace.message resource are now populated when thecreated andupdated Google Chat events are sent:

• threadKey
• clientAssignedMessageId
• slashCommand
• MatchedUrl

See thespace.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 forCseIdentity andCseKeyPair resources.

For Google Workspace add-ons that extend Google Chat, theinvoked_function field is no longer part of theCommon event object. Use theparameters field to determine and handle user interactions.

If your application doesn't depend on theinvoked_function field, no action is needed.

If your application used theinvoked_function field,see to the documentation for an example that uses theparameters field to create interactive widgets.

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 toBuild a Google Workspace add-on using HTTP endpoints.

Generally available: You can now call the Chat API to create, delete, and view custom emoji in organizations where creating custom emoji is enabled. You can now include or react with custom emoji in messages.

• Learn about including custom emoji in Chat messages
• Learn more about enabling custom emoji

Meet API

Generally Available: You can now programmatically configure the moderation settings and the permissions users receive when they join a meeting space. Additionally, you can also pre-configure auto-recording, auto-transcripts, and "take notes for me" in meeting spaces.

For more information, seeConfigure meeting spaces and members.

You can now create and modify tables, and take basic actions on tables using the Sheets API.

• Learn more about creating tables using the Sheets API
• Learn about theTable object in the Sheets API

For Google Workspace add-ons that extend Google Chat,event_time timestamps are serialized and match the serialization of legacy Google Chat apps. You can now use the same timestamp-handling logic in both legacy Chat apps, and in your Workspace add-ons that extend Google Chat.

Previously, timestamps were serialized in the following format:

"eventTime": { "seconds": 1.742601948E9 "nanos": 7.01868E8}

After this fix, timestamps are serialized in the following format that shows the date and time:

"eventTime": "2025-03-24T16:31:21.165203Z"

See theEvent object in the Google Chat API.

Between approximately September 2024 and March 2025, for Google Sheets modifications made by time-based Apps Script triggers, a bug caused incorrect OAuth App IDs and App Names to be logged in the Google Admin console.

This logging issue did not impact the functionality of Apps Script or Google Sheets. A fix was deployed on March 27, 2025, preventing future incorrect logging. Historical logs will not be corrected.

To learn more about Apps Script and audit logs, seeMonitor and control Apps Script use in your Google Workspace organization.

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

Learn about thesetPublished method to publish forms.

Reports API: User Logs Events now have logs for additional challenge types, such asPasskey,Device Prompt,SAML and more.

Learn more about Login Audit Activity Events. You can get these events using theactivities.list method.

The Google Workspace Events APIv1beta endpoint will be decommissioned for Google Chat and Google Meet events on April 30, 2025. To subscribe to Chat or Meet events, use the generally availablev1 endpoint.

The Google Workspace Events APIv1beta endpoint will be decommissioned for Google Chat and Google Meet events on April 30, 2025. To subscribe to Chat or Meet events, use the generally availablev1 endpoint.

The Google Workspace Events APIv1beta endpoint will be decommissioned for Google Chat and Google Meet events on April 30, 2025. To subscribe to Chat or Meet events, use the generally availablev1 endpoint.

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, seeRespond 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, seeRespond to Google Chat app commands.

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

Meet Media API

Developer Preview: TheGoogle Meet Media API is now available as part of theDeveloper Preview Program. The Meet Media API lets you access real-time media from Google Meet conferences.

As of February 20, 2025, the Rhino runtime is deprecated. Scripts running on Rhino will continue to function until January 31, 2026, after which they will no longer execute. Please migrate your scripts to the V8 runtime before this date. Refer toMigrate scripts to the V8 runtime.

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 booleaninheritedPermissionsDisabled field on thefiles resource totrue. Developers can also opt in to expansive access API behavior in My Drive ahead of any future mandatory enforcement by setting theenforceExpansiveAccess request parameter totrue on thepermissions.delete() andpermissions.update() methods.

To learn more, seeManage folders with limited and expansive access.

Generally available: When a user deletes a message sent by a Chat app, theDeletionType of the Chat APIMessage resource is set toSPACE_MEMBER. Previously, theDeletionType was set toCREATOR.

Reports API: Google Chat now supports thecustomerUsageReports.get() anduserUsageReports.get() methods. Forty eight new metrics have been added tocustomerUsageReports and four new metrics have been added touserUsageReports.

Reports API: A new event typeconversation_read has been added to Google Chat along with four new event parameters toactivities.list, andactivities.watch:

• conversation_ownership
• conversation_type
• message_type
• attachment_status

The full list of events and parameters supported in Chat audit activities can be found on theChat Audit Activity Events page.

Meet API

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

Meet API

Developer Preview: You can now pre-configure auto-recording, auto-transcripts, and "take notes for me" within a meeting space. For details, seeManage auto artifacts.

Generally Available: You can now use a new non-sensitive scope (https://www.googleapis.com/auth/meetings.space.settings) to set up auto-artifacts for meetings created by other apps including Google Calendar. For details, seeOAuth scopes for settings.

Meet Add-ons SDK

Early Access Preview: Meet add-ons on Android now contains a new meeting status,MEETING_WITH_START_COACTIVITY_PERMISSION_DISABLED, which lets you set a status when the user doesn't have permission to start a co-activity session during a meeting.

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 theScriptApp andAuthorizationInfo 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 toHandle granular OAuth permissions.

When building Google Workspace Add-on user interfaces, the following functionality is now available:

• TextInput Format Validation.
• Required inputs submission validation forTextInput,DateTimePicker, dropdown selector, and multiselect widgets. To learn more, seeaddRequiredWifget andsetAllWidgetsAreRequired.

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, seeRespond to quick commands as a Google Chat app.

Developer Preview: To respond to slash commands, Chat apps must now use theAppCommandPayload instead of aMessagePayload. To learn more, seeRespond to slash commands.

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, seeRespond 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, seeCarousel.

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

To learn more about Chat app authentication, seeTypes of required authentication andAuthenticate as a Chat app.

Developer Preview: You can now use the following widgets when building user interfaces for Add-ons:

• Chip
• Overflow menu
• Material buttons
• Collapsible text paragraph
• Customizable control button of a collapsible section

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:

• EnumEventTransparency
• ClassCalendarEvent
• ClassCalendarEventSeries

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

ThegetUrl() method for theCellImage,CellImageBuilder, andOverGridImage classes of theSpreadsheet service has been deprecated. An image's source URL isn't available regardless of how the image is inserted into a spreadsheet.

Developer Preview: You can now build Google Chat apps as Google Workspace Add-ons. For details, seeExtend Google Chat.

Developer Preview: You can now build Google Chat apps as Google Workspace Add-ons. For details, seeExtend Google Chat.

Developer Preview: You can now build Google Chat apps as Google Workspace Add-ons. For details, seeExtend Google Chat.

Chat apps now have 90 days to complete the import of data. Previously, Chat apps had 30 days. To learn more, seeImport data to Google Chat.

The Calendar service now has agetEventType() 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 havebirthdayProperties 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 thecontact as a resource name in thePeople API to fetch contact details.

To learn more, see thedeveloper 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 inimport mode using thespaces.create method.

Developer Preview: You can now use a read-only scope (https://www.googleapis.com/auth/chat.customemojis.readonly) toget orlist 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 thespaceNotificationSetting 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, seeDesign an interactive card or dialog.

Developer Preview: Whencreating 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, seeCustomEmoji (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, seePreview links with smart chips.

Meet Add-ons SDK

Generally Available: You can now retrieve themeetingCode property of an ongoing meeting. This is applicable in version 1.1.0.

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

• PredefinedPermmissionSettings field for theSpaces resource
• PermissionSettings field for theSpaces resource

Apps Script has rescheduled the shutdown date of the Contacts service to January 31, 2025. Refer to theApps Script sunset schedule.

The Apps Script Contacts service was deprecated in December 2022. Instead, use the People API advanced service. Refer toMigrate from Contacts service to People API advanced service.

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 withhttps://www.googleapis.com/auth/chat.app.spaces orhttps://www.googleapis.com/auth/chat.app.spaces.create.
• Update a space as a Chat app withhttps://www.googleapis.com/auth/chat.app.spaces.
• Delete a named space as a Chat app withhttps://www.googleapis.com/auth/chat.app.delete.
• Get details about a space as a Chat app withhttps://www.googleapis.com/auth/chat.app.spaces.
• Invite or add a user to a space as a Chat app withhttps://www.googleapis.com/auth/chat.app.memberships.
• Update a membership as a Chat app withhttps://www.googleapis.com/auth/chat.app.memberships.
• Remove a member from a space withhttps://www.googleapis.com/auth/chat.app.memberships.

To learn more, seeTypes of required authentication andAuthenticate as a Chat app.

(Generally available) - For event subscriptions, you can now use theeventTypes field in theupdateMask parameter of thesubscriptions.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 thefiles.download method to download blob file content or export Google Workspace document content either through the Drive API or its client libraries.

Thefiles.download method returns anOperation resource to the client. You can use theOperation interface to asynchronously retrieve the status of the API method by polling the operation through theGetOperationRequest method.

Thefiles.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, seeManage long-running operations.

Generally Available: Google Workspace Marketplace supports draft app listings. With a draft listing, you can make changes to your app listing and then preview and test the changes before publishing them. While your draft changes are in testing, the original app listing remains available on the Google Workspace Marketplace. To learn more, seeUpdate your app listing with drafts.

Generally Available: ThechatSpaceLinkData object has been added to theRichLinkMetaData field of thespaces.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 andremove members from a space
• Get details about amember and aspace
• Update ordelete a space
• Update a user's membership

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

For more information about searching spaces, read the documentation atSearch 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 inimport mode using thespaces.create method.

Meet Add-ons SDK

Generally Available: TheGoogle Meet Add-ons SDK is now generally available.

The Meet Add-ons SDK lets you embed your app into Google Meet as a Google Workspace Add-on where users can discover, share, and collaborate, plus sync content state across devices, without leaving Meet.

For more information, see theguides andreference documentation.

Generally available: You can now use Looker inConnected 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 theSpreadsheet 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 call Chat API using Cloud Client Libraries in addition to the already available Google API Client Libraries.

Benefits of Cloud Client Libraries include:

• Idiomatic code that follows your preferred language's natural conventions and styles.
• Consistent style across client libraries.
• Handling the low-level details of server communication, including authentication, pagination, long-running operations, streams, and retries.
• Installable using package management tools likenpm andpip.
• Improved performance in some cases, thanks to gRPC.

Additionally, our Chat API reference documentation now features aRPC reference arranged by services and their methods in addition to our existingREST reference arranged by resource hierarchies and their methods.

To learn more, seeInstall client libraries.

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

Meet Add-ons SDK

Developer Preview: Add-ons can now programmatically end a collaboration by calling theendCollaboration method for theMeetMainStageClient or theMeetSidePanelClient. This is applicable in version0.9.0 or later.

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, seeDesign an interactive card or dialog.

Google Workspace administrators can now turn on an allowlist in the admin console to control which external domains users can access through Apps Script'sURL Fetch service.

• If you're using a script or add-on that accesses external domains, work with your administrator to add those URLs to the admin allowlist.
• If you've published an add-on on the Google Workspace Marketplace, it might be helpful to list the URLs that admins should add to their allowlist on your Marketplace listing.

For more information, refer to the Google Workspace Admin Help article:Allow only certain external connections for Apps Script and Sheets.

Google Workspace administrators can now turn on an allowlist in the admin console to control which external domains users can access through Apps Script'sURL Fetch service.

• If you're using a script or add-on that accesses external domains, work with your administrator to add those URLs to the admin allowlist.
• If you've published an add-on on the Google Workspace Marketplace, it might be helpful to list the URLs that admins should add to their allowlist on your Marketplace listing.

For more information, refer to the Google Workspace Admin Help article:Allow only certain external connections for Apps Script and Sheets.

Generally available starting September 17, 2024: Create and manage birthdays directly within Google Calendar. Birthdays are exposed in the Calendar API as a neweventType 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 theevents.list() andevents.watch() methods. If no type filters are specified, all event types including birthdays are returned.

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

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

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

For details, seeChoose 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 theexternalUserAllowed option.

Generally Available: When building Chat apps using Google Cloud Functions, Cloud Run, or any system that supports authentication via ID tokens, you can nowAuthenticate requests using Cloud Functions or Cloud Run orAuthenticate 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 toMake a Google Chat space discoverable to specific users in a Google Workspace organization using theaccessSettings field on theSpace resource. You can read the URI of the space using thespaceUri 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 thePredefinedPermissionSettings andPermissionSettings fields.

Developer Preview: Google Workspace Marketplace now supports draft app listings. With a draft listing, you can make changes to your app listing and then preview and test the changes before publishing them. While your draft changes are in testing, the original app listing remains available on the Google Workspace Marketplace. To learn more, seeUpdate your app listing with drafts.

(Generally Available): You can now add a Google Group to a Chat space using thespaces.members.create method or thespaces.setup method. You can remove a Google Group from a space using thespaces.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'stargetResource field to//chat.googleapis.com/spaces/-. To learn more, seeSubscribe 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'stargetResource field to//chat.googleapis.com/spaces/-. To learn more, seeSubscribe to Google Chat events.

(Developer Preview): If you're a domain administrator or a delegated administrator, you can now include theuseAdminAccess 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, seeAuthenticate and authorize using administrator privileges.

Meet Add-ons SDK

Early Access Preview: For Meet add-ons on Android, you can now view and reference specific error codes from add-on exception errors.

Meet API

Developer Preview: The Meet API now lets you pre-configure a meeting space and manage the members who join a meeting.

For more information, seeConfigure meeting spaces and members.

Meet Add-ons SDK

Developer Preview: Google Meet Add-ons SDK supports two usability improvements that aren't backwards compatible and require developer action.

1. The introduction of an add-on loading screen. Make sure to callcreateAddonSession on both the main stage and side panel once your add-on has finished loading. This signals Meet to dismiss the loading screen.

2. The removal of thestartActivity button in the Meet side panel. Instead, the add-on now starts the activity through a call tostartCollaboration. Make sure to callstartCollaboration in your add-on once the user has completed content selection and is ready to start the collaboration.

Meet Add-ons SDK

• Added the connection exceptionaddonexception.ADDON_NOT_INSTALLED. To fix this error, display a message to the user that they must install the add-on and provide a link to the Google Workspace Marketplace page containing the add-on.

(Developer Preview): If you're a domain administrator or a delegated administrator, you can now include theuseAdminAccess 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, seeAuthenticate and authorize using administrator privileges.

The following changes toevents from Gmail take effect onMay 30, 2024:

• Events from Gmail usefromGmail insteaddefault as the value for theeventType field. You can filter by this new event type using theevents.list() andevents.watch() methods.
• Events from Gmail use the email address of the email recipient as the event organizer instead ofunknownorganizer@calendar.google.com.
• You can only update the eventproperties, such as reminders, color ID, visibility, status, and extended properties ofEvent resources with the event typefromGmail.

For details, see the Calendar APIEvents reference documentation.

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

The following change takes effect onJune 3, 2024:

Forbatch operations onEvent resources, a batched item returns an HTTP409 Conflict status code if the batch operation can't successfully execute this item due to conflicts with other requested batched items.

Suggested action: Exclude all successfully finished and failed batched items and retry remaining items in a different batch operation or by using single event operations.

For more information, seeHandle API errors.

Live Sharing SDK

• Added thewithCoWatching andwithCoDoing methods to allow both first party and third party apps to include the initial state of the add-on session.

• Added a newAddonException ofOPERATION_UNSUPPORTED. The exception occurs when requesting an unsupported operation on Meet.

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

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

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

• DataSourceChart
• DataSourceFormula
• DataSourcePivotTable
• DataSourceSheet
• DataSourceTable

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

ThecancelAllLinkedDataSourceObjectRefreshes() method has been added to theDataSource 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.

Theusers.spaces resource represents a user's read state in a space. Theusers.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, seeBuild 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, seeSend 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 theCard 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 theCard 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 thespaces.members.patch method. To learn more, seeUpdate 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 theexternalUserAllowed option.

(Generally available): Google Chat apps can get, list, and subscribe to events. To receive events, you can do the following:

• Use theget() andlist() methods on thespaces.spaceEvents resource of the Google Chat API.
• Create subscriptions to events about users and spaces using Google Workspace Events API.

To learn more, seeWork with events from Google Chat.

Events about deleted messages are now supported (Event type:google.workspace.chat.message.v1.deleted).

(Generally available): Subscriptions to Google Chat spaces and users are now generally available. To learn more, seeSubscribe to Google Chat events.

Events about deleted messages are now supported (Event type:google.workspace.chat.message.v1.deleted).

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

The default property for theTextButtonStyle enum in the Apps ScriptCard Service has been renamed fromTEXT toOUTLINED to align with theGoogle Material 3 design system. Existing scripts that use the original default,TEXT, render the same as the new default,OUTLINED.

The default property for theTextButtonStyle enum in the Apps ScriptCard Service has been renamed fromTEXT toOUTLINED to align with theGoogle Material 3 design system. Existing scripts that use the original default,TEXT, render the same as the new default,OUTLINED.

(Developer Preview): You can nowget orlist 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 toDelete 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, seeBuild a Dialogflow CX Google Chat app.

(Generally Available): TheLinkPreview 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): TheLinkPreview 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): TheformattedText field on theMessage resource includes the markup syntax for bulleted list text formatting. For more information, seeFormat a text message.

The 200 version limit, first announced for new scripts onDecember 6, 2023, has been extended to all script projects. If your existing script project already has more than 200 versions, after June 1, 2024 you won't be able to add a new version. To delete unused versions, refer toDelete a version.

(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): 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): 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 theCard 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 theCard Service reference documentation.

Meet API

Generally available: v2 of theGoogle Meet API is now generally available. For more information, see thev2 reference documentation.

Generally available: Google Meet events are now generally available using the Google Workspace Events API. To learn more, seeSubscribe to Google Meet events.

(Generally available): The Google Workspace Events API is now generally available and supports subscriptions to Google Meet events. To learn more, seeSubscribe to Google Meet events and thev1 reference documentation.

Meet Add-ons SDK

Developer Preview: ThegetCurrentMeetingRecordingStatus() method has been deprecated. There isn't a replacement method to get this data.

The following changes will take effect onMarch 11, 2024:

• The use ofevent type filters will be considered when reviewing quota increase requests. Before you request a quota increase, make sure you specify the event types you need as a parameter for your application.
• Bothevents.list andevents.watch will use the same default event type filter.
• To help with error handling, improved error messages will be returned when unsupported operations are attempted on special event types, such as working location, out-of-office, and focus time events.

For more information, refer to the following:

• Manage focus time, out of office, and working location events
• Manage quotas

Generally available: Theevents.watch() method now supports theeventTypes field as a query parameter so that you can subscribe to changes about specific Calendar events, such as working location, out-of-office, or focus time events. For details, see thereference documentation.

Meet API

• Developer Preview: A change announced by email on December 21, 2023 to members of the developer preview program, specifyingspaces/{spaceId} changed from the previous version, has now gone into effect. Requests using meeting space resource names with the old meeting space IDs are now rejected. Note that a meeting code can also be used as an alias when callingspaces.get, such asspaces/abc-mnop-xyz. When provided with a meeting code,spaces.get returns the canonical resource identifier for the meeting space.

Reports API: The event returned in theactivities.watch method payload is now filtered to the event name set in the filter. Before this change, multiple events were returned in the payload even if the customer filtered to a specific event.

You can now get a list of the user's installed apps in v3, with information about each app's supported MIME types, file extensions, and other details.

Theapps resource represents a user's list of installed apps and it supports the following methods:

• Get a specific installed app.

• List all the installed apps.

(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, seeCreate third-party resources from the @ menu.

Each user can have up to500 million items that were created by that account, no matter where those items reside. Previously, users could create an unlimited number of items in Drive.

(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, seeCreate third-party resources from the @ menu.

(Developer Preview): The Google Workspace Events API supports theget() method on theOperations resource.

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

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

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

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

(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, seeSubscribe to Google Chat events in the Google Workspace Events API documentation.

(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, seeSubscribe to Google Chat events.

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

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

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

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

Meet Add-ons SDK

• Google Chrome and other browsers have begun phasing out third-party cookies to better protect user privacy. Chrome has restricted third-party cookies for 1% of users from January 4th, 2024. For more details on how to prepare, provide feedback, and report potential site issues, refer to the following:
  • Prepare for third-party cookie restrictions
  • The next step toward phasing out third-party cookies in Chrome

Directory API

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

Directory API: Theaction method of thechromeosdevices resource is deprecated. Instead, use thebatchChangeStatus method in thecustomer.devices.chromeos resource.

Meet API

• Developer Preview: Added thestartTime andendTime fields to theconferenceRecords.recordings resource andconferenceRecords.transcripts resource.

We've published a comprehensive tutorial and code sample showing how to build a Chat app using generative AI and a database,Manage projects with Google Chat, Vertex AI, and Firestore.

(Generally available): TheCard Builder Tool is now available to help youdesign and preview card messages in Google Chat apps.

(Generally available): ThesetPersistValues(persistValues) method has been added to theAction class of theCard 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, seeAdvanced Drive service.

The Google Chat APIspaces.list() method now supports app authentication for query filters.

To fix a bug that prevented events ofeventType != 'default' from importing, we updated the code sample inPopulate a team vacation calendar, the popular Apps Script + Calendar API solution. Review the code change inGitHub.

To fix a bug that prevented events ofeventType != 'default' from importing, we updated the code sample inPopulate a team vacation calendar, the popular Apps Script + Calendar API solution. Review the code change inGitHub.

Meet Add-ons SDK

• Developer Preview: TheGoogle Meet Add-ons SDK is now available as part of theDeveloper 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.

Theusers.spaces resource represents a user's read state in a space. Theusers.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, seeDelete a version.

(Generally available): You can now retrieve Google Groups that are members of a Google Chat space usingListMemberships (with theshowGroups option) andGetMembership. If you try toadd a member to a Chat space while this member is already part of a Google Group in the same space, it triggers analready exists error (HTTP status code409).

(Developer Preview): Your Chat app can now send anapp 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.

A user's My Drive can't contain more than100 levels of nested folders. Previously, folders in My Drive could be at an unlimited depth.

(Generally available):Google Material Design 3 styles, includingicons, are available for cards in Chat apps.

(Developer Preview): Google Workspace Add-ons now support third-party resource creation from the @ menu in Google Docs. To use this feature, seeCreate 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, seeCreate third-party resources from the @ menu.

(Developer Preview): Available as part of theGoogle 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, seePreview links with smart chips.

(Developer Preview): Available as part of theGoogle 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, seePreview links with smart chips.

(Generally available): You can now call the Chat API from Apps Script with the Advanced Chat Service. To learn how, seeAdvanced 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, seeAdvanced 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

Users can now install Google Chat apps from app listing pages on the Google Workspace Marketplace. For details, seePublish Google Chat apps.

Users can now install Google Chat apps from app listing pages on the Google Workspace Marketplace. For details, seePublish Google Chat apps.

Meet API

• Developer Preview:Google Meet API is now available as part of theDeveloper 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): The Google Workspace Events API now supports subscriptions to Google Meet meeting spaces and users. The API supports the following types of events:

• A conference starts or ends.
• A participant joins or leaves a conference.
• A recording is generated.
• A transcript is generated.

To learn more, seeSubscribe to Google Meet events.

(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, seeSubscribe 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, seeSubscribe to Google Chat events.

(Developer Preview): You can now migrate historical memberships when youimport 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, seeSelection input.

Live Sharing SDK

• Added aRecordingInfo field to theAddonMeetingInfo resource that indicates if the current Google Meet call is being recorded.

• Added theverifyRecordingInfo method to theAddonSession.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.

(Developer Preview): Google Chat apps can now monitor and receive events about Google Chat spaces. The following event types are supported:

• New messages
• Updated messages
• New members
• Updated members
• Removed members
• Updated space
• Deleted space

To receive events, Chat apps create subscriptions using the Google Workspace Events API. To learn more, see theGoogle Workspace Events API overview.

(Developer Preview): The Google Workspace Events API is now available to members of the Developer Preview Program. The API supports subscribing to Google Chat spaces for the following types of events:

• New messages
• Updated messages
• New members
• Updated members
• Removed members
• Updated space
• Deleted space

To learn more, see theGoogle Workspace Events API overview.

You can now use theformattedText field toview the text formatting sent in a message.

The email address that sends notifications abouterrors in triggers has been updated fromapps-scripts-notifications@google.com tonoreply-apps-scripts-notifications@google.com.

The classic Google Sites service has been deprecated due to thetransition from classic Sites to new Sites. There isn't a way to connect to new Sites with Apps Script.

Developer Preview: You can now update a human user's membership in a Chat space. For example, you can use thespaces.members.patch method to update membership roles frommember tomanager and frommanager tomember.

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, seeManage working locations for Google Calendar users.

The user interface (UI) of Google Workspace Add-ons has been upgraded to better reflectMaterial 3 guidelines (GM3). The updated interface is generally available on web for Gmail, Calendar, Drive, Docs, Sheets, and Slides. New and existing Google Workspace Add-ons automatically reflect the new interface.

Embed SDK Web

• You no longer have to add a domain to an allowlist. Any domain can embed Meet.
• You no longer have to provide anaccessToken when building theMeetApp. Previously, theaccessToken indicated user consent of having Google Meet in an embedded website. Meet now shows its own consent dialog to the user before they can join a meeting. Consent is cached for 24 hours.
• Anonymous users can now join a meeting and are only required to enter a name to represent them during the meeting. Previously, users had to be signed in to a Google Account.
• Documentation changes:
  • The "Configure OAuth consent" and "Set up authentication & authorization" pages were removed.
  • TheSet up your Google Cloud project section was added.

Google Chat users outside of Google Workspace organizations can now install and use public Google Chat apps. To learn about how users discover and use Chat apps, seePublish Google Chat apps.

The Google Workspace Marketplace now offers independent security verification badges that appear in search results and on app listing pages. To receive the badge, your app must undergo an independent security assessment. To learn about the requirements for the badge, see thedocumentation.

Google Chat apps thatauthenticate 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, seeMention users in a message.

Thecapabilities.canModifyContentRestriction parameter was deprecated.

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, seeProtect file content.

You can now specifyno divider between card sections.

You can now specifyno divider between card sections.

Multiselect menus are now available inDeveloper Preview. Multiselect menus help users input static and dynamic data for Google Chat apps. To learn more, see theSelection 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, seePreview 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, seePreview links with smart chips.

Developer Preview: Available as part of theGoogle 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

• Renamed SDK artifact and namespace:
  • Maven artifact changed tocom.google.android.meet:meet-addons.
  • Java namespace changed tocom.google.android.meet.addons.
• Removed deprecatedqueryMeeting() method. UseregisterMeetingStatusListener() instead.
• RemovedliveSharingApplicationName parameter from the session builder.
• ThecloudProjectNumber parameter onAddonClientFactory#getClient is now required. This value is acquired byregistering a Meet add-on.
• Artifact released:com.google.android.meet:meet-addons:2.0.0-alpha03.

You canauthenticate and authorize users' credentials to access the Chat API by using OAuth 2.0. Authenticating and authorizing with user credentials lets Chat apps access user data and perform operations on the authenticated user's behalf. When an app performs an action with user authentication (such as creating a space), Google Chat might display an attribution message that tells users the name of the app that performed the action for the user who authorized it.

Oauth 2.0 scopes are available for you to request and your users to consent to.

Quotas and limits are applied to the Chat API.

The following methods are available:

• Create a message
• Delete a message
• Get a message
• Update a message
• List messages
• Create a reaction
• Delete a reaction
• List reactions
• Create a membership
• Delete a membership
• Get a membership
• List memberships
• Create a space
• Delete a space
• Get a space
• Find a direct message
• List spaces
• Update a space
• Set up a space (create and populate)
• Download media
• Upload media

Live Sharing SDK

Renamed the following symbols:

+`LiveSharing*`→`Addon*`+`*Delegate`→`*Handler`+`CoWatchingSession`→`CoWatchingClient`+`CoDoingSession`→`CoDoingClient`

Live Sharing SDK

AddedonParticipantPrivilegeChanged callback toAddonSessionHandler. Artifact released:com.google.android.livesharing:livesharing:2.0.0-alpha02.

The Google Workspace Marketplace launches a new category calledIntelligent Apps, where users can discover AI-powered productivity apps that let organizations work faster by automating their Google Workspace workflows. To learn more about Marketplace categories, see thedocumentation.

Live Sharing SDK

Alpha version of a new SDK major release. While the internals of this SDK are production-ready, the API surface of this alpha is subject to additional breaking changes—such as new features—before a final 2.0.0 release is published. The following changes are part of this release:

• Co-Doing:
  • CoDoingSession: RenamedbroadcastStateUpdate() tosetGlobalState().
  • CoDoingSessionDelegate:
    • Eliminated onCoDoingStateQuery(). If initial state must be set upon connecting to live sharing, callCoDoingSession#setGlobalState() explicitly instead.
    • RenamedonCoDoingStateChanged() toonGlobalStateChanged().
• Co-Watching:
  • CoWatchingSession: Removed previously-deprecatednotifyPlayoutRate() overload.
  • CoWatchingSessionDelegate:
    • RenamedonCoWatchingStateQuery() toonStateQuery().
    • onStateQuery() now returns aQueriedCoWatchingState, which is a subset ofCoWatchingState. Update the return type and either:
      • Continue building and returning aCoWatchingState...
      • Or, simplify the implementation by constructing a simplerQueriedCoWatchingState instance.
• LiveSharingClient:
  • Replaced the following methods with a builder pattern:
    • connectMeeting() /disconnectMeeting()
    • beginCoDoing() /endCoDoing()
    • beginCoWatching() /endCoWatching()
• Instead of callingconnectMeeting() followed bybeginCoDoing()(or co-watching), callnewSessionBuilder().withCoDoing().begin().
• begin() returns a newLiveSharingSession instance:
  • To end the session, callendSession().
  • To set participant metadata after the session has started, callsetParticipantMetadata().
  • To access the co-doing/co-watching session, callgetCoDoing()/getCoWatching().
  • To access information about the current meeting, callgetMeetingInfo().
• To set up participant metadata and register a delegate, callwithParticipantMetadata() as part of the session builder chain.
• AddedregisterMeetingStatusListener()/unregisterMeetingStatusListener()and deprecated `queryMeeting().
• Artifacts released:com.google.android.livesharing:livesharing:2.0.0-alpha01.

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

Live Sharing SDK

MarkedMeetingDisconnectHandler as deprecated; developers should migrate toLiveSharingSessionDelegate instead.

Live Sharing SDK

AddedLiveSharingSessionDelegate 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, seeProcess information inputted by users.

Buttons can now include text and an icon. Previously, only an icon or only text was allowed in buttons.

Live Sharing SDK

Maximum size ofco-doing state increased from 1650 bytes to 16 KB.

Live Sharing SDK

Fixed some issues.

Live Sharing SDK

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

Apps Script has deprecated theContacts service. Instead, use thePeople API advanced service. Refer toMigrate from Contacts service to People API advanced service.

The Contacts service shutdown has been rescheduled from April 2023 to January 2025. Refer to theApps Script sunset schedule.

Developer Preview: Available as part of theGoogle 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, seePreview links with smart chips.

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

Apps Script has sunset the following methods:

• getChatThreads()
• getChatThreads(start, max)

There isn't a replacement method to get this data with Apps Script.

Learn about the switch from Classic Hangouts to Chat.

Live Sharing SDK: Fixed potential issues in bundled Proguard configuration in previous release.

Live Sharing SDK:

• Updated external dependencies.
• Artifact releasedcom.google.android.livesharing:livesharing:1.0.5.

Live Sharing SDK:

• Improved bundled Proguard configuration.
• UpdatedMAX_CODOING_BLOB_BYTES to correctly represent the current maximum.
• Artifact released:com.google.android.livesharing:livesharing:1.0.4.

Live Sharing SDK: Fixed some issues.

Live Sharing SDK:

• The SDK size was significantly reduced.
• Artifact released:com.google.android.livesharing:livesharing:1.0.3

Apps Script has turned down the legacy integrated development environment (IDE) in favor of the redesigned IDE that launched in December 2020.

Learn more about the IDE updates from the following blog posts:

• Updated Apps Script integrated development environment will replace the legacy experience by Q4 2022.
• Additional functionality for the Apps Script Integrated Development Environment (IDE) Script Editor.
• Use the new Apps Script Integrated Development Environment (IDE) Script Editor.

Live Sharing SDK:

• Fixed some issues.
• Javadoc improvements.
• Artifact released:com.google.android.livesharing:livesharing:1.0.2.

Reseller API: The maximum queries per day (QPD) of 10,000 no longer applies.

Live Sharing SDK: Fixed some issues. Artifact released:com.google.android.livesharing:livesharing:1.0.1.

Live Sharing SDK: Fixed some issues. Artifact released:com.google.android.livesharing:livesharing:1.0.0.

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

Live Sharing SDK: Fixed some issues. Artifact releasedcom.google.android.livesharing:livesharing:1.0.0-eap08.

Live Sharing SDK: Thecom.google.android.apps.meetings.permission.MEET_LIVE_SHARING permission is obsolete and removed from the manifest.

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

Live Sharing SDK:

• Executors passed toLiveSharingClientFactory#getClient are now respected by the SDK.
• UpdatedLiveSharingException:
  • MEET_VERSION_UNSUPPORTED: Consumers can now queryLiveSharingExceptionMetadata#packageName()to redirect the user to install an appropriate app.
  • SDK_VERSION_UNSUPPORTED: New error code for phasing out old SDK versions if necessary in the future.
  • PARTICIPANT_INELIGIBLE: New error code indicating that the current user is not eligible to participate.
• The SDK no longer requires the fullcom.google.guava:guava target as a dependency; onlycom.google.guava:listenablefuture.

Apps Script now automatically deletesdefault Google Cloud projects (Google Cloud projects that Apps Script creates in the background) when their associated scripts haven't run in 180 days or more. If the script runs after Apps Script deletes the default Google Cloud project, Apps Script creates one for the script.

This update doesn't affect standard Google Cloud projects (Google Cloud projects created by people).

Apps Script has deprecated the following methods:

• getChatThreads()
• getChatThreads(start, max)

These methods will become unavailable later this year once Google switches all users from Classic Hangouts to Google Chat. There isn't a replacement method to get this data with Apps Script.

Learn about the switch from Classic Hangouts to Chat.

Cards v1 is deprecated. Instead, useCards v2.

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

You can now call functions in separate files before they're parsed. Previously, the V8 runtime required a script file to be parsed before any other file could call the functions it defines.

Now, the order of files in the Apps Script editor doesn't matter. This means that you can call a function in a different file to assign a value to a global variable—the function is always defined before it's called. This behavior reflects that of the legacy Rhino runtime.

Live Sharing SDK: In-call banner does not have the correct string.

Live Sharing SDK: Removed internal handler creation for ongoing call detector. If LSA does not provide a handler, the registered receiver will run on the UI thread.

Live Sharing SDK:

• SurfacedLiveSharingMeetingInfo.Builder to API consumers for ease-of-testing.
• Added new overload ofLiveSharingClientFactory#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 toLiveSharingException, allowing common errors to be tagged with a canonical code. Currently supports one error code:MEET_VERSION_UNSUPPORTED.
• Enabled#queryMeeting() feature.
• Artifact releasedcom.google.android.livesharing:livesharing:1.0.0-eap05.

Live Sharing SDK: Addressed some race conditions.

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

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

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

Live Sharing SDK: Renames the following symbols on the API surface:

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

Live Sharing SDK:

• FixesExceptionInInitializerError bug introduced in1.0.0-eap02.
• Fixes "playout rate set as zero" known issue.
• Fixes "wait for connection to resolve" known issue.

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

Live Sharing SDK: Enables logging forERROR-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: Addresses issue withio.grpc.util.SecretRoundRobinLoadBalancerProvider instantiation for some apps.

Live Sharing SDK: Initial release. Artifact released:com.google.android.livesharing:livesharing:1.0.0-eap01

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, anAttachment class has been added to theCard 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 toEventAttachmentTrigger.

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

Theget methods for several color objects in theSpreadsheet Service have been deprecated in favor of a new naming convention. The functionality remains the same. For example, thegetFontColor() method from the Range class has been replaced withgetFontColorObject().

The following classes have updatedget methods for color objects:

• Banding:
  • getFirstColumnColor() is nowgetFirstColumnColorObject().
  • getFirstRowColor() is nowgetFirstRowColorObject().
  • getFooterColumnColor() is nowgetFooterColumnColor().
  • getFooterRowColor() is nowgetFooterRowColorObject().
  • getHeaderColumnColor() is nowgetHeaderColumnColorObject().
  • getHeaderRowColor() is nowgetHeaderRowColorObject().
  • getSecondColumnColor() is nowgetSecondColumnColorObject().
  • getSecondRowColor() is nowgetSecondRowColorObject().
• BooleanCondition:
  • getBackground() is nowgetBackgroundObject().
  • getFontColor() is nowgetFontColorObject().
• GradientCondition:
  • getMaxColor() is nowgetMaxColorObject.
  • getMidColor() is nowgetMidColorObject.
  • getMinColor() is nowgetMinColorObject.
• Range:
  • getFontColor() is nowgetFontColorObject().
  • getFontColors() is nowgetFontColorObjects().
• Sheet:
  • getTabColor() is nowgetTabColorObject.
• Slicer:
  • getBackgroundColor() is nowgetBackgroundColorObject().

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 theSpreadsheet 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 usingSpreadsheetApp.newCellImage() andCellImageBuilder. Then, useRange.setValue(value) orRange.setValues(values) to add the image value to the cell.

Versions 1.0 and 1.1 of the TLS security protocol are disabled. To establishJDBC connections, use TLS 1.2 or higher.

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

AnnouncementThe Google Keep API is now available for enterprise administrators.

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, theallow-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 aboutHMTL Service restrictions.

TheDrive Service has added three new methods to thefile andfolder 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 theresource key security update for Drive.

TheDocument 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 aboutsmart chips in Google Docs.

The Microsoft SQL Server JDBC driver was updated to version 7.2.1. If you encounter issues,report them on the issue tracker. If you're an administrator and need live support,contact Google Workspace support.

Google Sheets API v3 is turned down. For more information, seeMigrate from Sheets API v3.

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

A new method has been added to theSheet class of theSpreadsheet 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 generalCalendar usage limits:

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

SeeManage quotas for more information.

The following updates have been made to deployments in the new editor:

• You can now have more than one active deployment.
• You can now change the version associated with an active deployment.

To learn more, seeCreate and manage deployments.

TheKeyValue class is deprecated. Instead, use theDecoratedText class.

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

Starting today, all existing and new out of office events will be updated to set the organizer tounknownorganizer@calendar.google.com instead of the Calendar owner. It may take 2-3 weeks for this change to fully roll out.

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

From now, we requireconferenceData to be consistent withconferenceData.conferenceSolution.key.type; meaning only Google Meet calls can haveconferenceData.conferenceSolution.key.type set tohangoutsMeet. All 3P video conference providers are expected to setconferenceData.conferenceSolution.key.type toaddOn.

The Apps Script integrated development environment, or IDE, has been fully redesigned. Along with a completely new interface, the following features have been updated:

• The editor now has a collapsible left sidebar to navigate to the Apps Script project overview, settings, executions, and triggers.
• The editor's resources panel now includes files, advanced services, and libraries.
• Autoformatting has been added to the editor.
• Autocomplete in the editor has been enhanced to be faster, more consistent, and extends its support to user-defined functions and JavaScript language features. You can add JSDoc to your functions for better autocomplete suggestions.
• The editor now supports codeblock and function collapsing.
• Keyboard shortcuts and a Command Palette has been added to the editor. Press F1 to view the Command Palette and available keyboard shortcuts.
• The editor now includes a contextual right-click menu with options such as Go To Symbol, Rename Symbols, and Command Palette.
• Enhancements have been made to the debugger's performance and speed.
• Logs now stream in real-time as you run a script.
• The deployments dialog auto-detects the deployment types from the script project's manifest. You can change or add more types as needed.
• Deployments have been merged with versions. Each time you create a new deployment, a new version is automatically created. clasp users are unaffected by this change.
• A single deployment can be an add-on deployment , web app, library, or API executable. Any deployment can be used as a library.
• Now only one deployment can be active at a time. This change doesn't affect existing active deployments. clasp users are unaffected by this change.
• You can no longer explicitly deactivate published web apps. Instead, delete the deployment that has the web app. To reactivate the web app, deploy it again.
• The debugger is no longer supported in the Rhino runtime. To use the debugger,migrate your script to the V8 runtime.
• Testing Editor Add-ons is not yet supported in this release and will be added in 2021. To test Editor Add-ons, switch back to the legacy IDE.

To switch back to the legacy IDE from within the editor, at the top, clickUse legacy editor.

An advanced service forGoogle Tables has been added to Apps Script. TheTables service allows scripts to programmatically read and edit rows withinTables.

Meet video conferences should be added explicitly using the following existing parameters:

1. SetconferenceDataVersion query parameter to1.
2. SetconferenceData.createRequest event property as follows:
   • conferenceData.createRequest.conferenceSolutionKey.type tohangoutsMeet.
   • conferenceData.createRequest.requestId to unique request id.

We stopped auto-populating Meet for API calls (such asEvents.insert) to prevent Meet conferences being added unintentionally via 3rd parties.

New classes and methods have been added to supportConnected Sheets.

The following new classes have been added to theSpreadsheet 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 theSpreadsheet service:

• BigQueryDataSourceSpecBuilder
• BigQueryDataSourceSpec
• DataExecutionStatus
• DataSourceTable
• DataSource
• EmbeddedChart
• FilterCriteriaBuilder
• `PivotFilter
• PivotGroup
• PivotTable
• PivotValue
• Range
• Sheet
• SpreadsheetApp
• Spreadsheet

A new class calledDecoratedText has been added to theCard Service.DecoratedText adds text with optional decorations and was added to replace theKeyValue class.

TheDriveApp now has anenforceSingleParent(value) method that enables or disablesenforceSingleParent behavior.

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

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

To helpsimplify Google Drive's folder structure and sharing models, new methods have been added to theDrive service and some existing methods have been deprecated.

The followingFolder class methods have beendeprecated:

• addFile(File)
• addFolder(Folder)
• removeFile(File)
• removeFolder(Folder)

New methods have been added to theSpreadsheet service:

• TheRichTextValue class now has aRichTextValue.getLinkUrl() method that gets the URL of the specified value.
• TheRichTextValueBuilder class now has aRichTextValueBuilder.setLinkUrl() method that sets the link URL for the specified value.
• ThePivotTable class now has aPivotTable.getSourceDataRange() method that returns the source data range on which the pivot table is constructed.
• ThePivotValue class now has aPivotValue.remove() method that removes the value from the pivot table.

All Team Drive-related fields are removed from the Vault API. Although these fields are marked as deprecated and will continue to be available until then, we strongly recommend that you update your apps and your API configuration to reference the new fields as soon as possible. If you do not migrate your apps by June 1, 2020, they might stop functioning.

If you have additional questions or need assistance, please visit oursupport page.

Reports API: A new parametermember_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. TheonSelectionChange(e) trigger runs automatically when a user changes the selection in a spreadsheet.

The following has been added to theSpreadsheet service:

• A newDrawing class has been added to support drawings.
• You can now get your drawings with theSheet.getDrawings() method.

The following has been added to theDrive service:

• There's a newFILE_ORGANIZER value in thePermission enum. If you haveFILE_ORGANIZER permission on a shared drive, you can edit, trash, and move content within that drive.

Service accounts created on or after March 2, 2020 are only able to invite guests usingdomain-wide delegation of authority.

The following methods have been added to theSpreadsheet service to support the use of theme colors. Many of these methods duplicate the effect of existing color methods, but let you useColor objects instead of strings as parameters and return types:

• TheBanding class now has 16 new methods that manipulate color in the banding columns and rows usingColor objects.
• TheBooleanCondition class now has two new methods that retrieve the color of the condition's background and font asColor objects.
• TheConditionalFormatRuleBuilder class now has seven new methods that set color-based format rules usingColor objects.
• TheGradientCondition class now has three new methods that retrieve condition colors asColor objects.
• TheRange class now has eight new methods that get and set font and background colors usingColor objects.
• TheSheet class now has two new methods that get and set tab colors usingColor objects.
• TheSlicer class now has two new methods that get and set the background color of the slicer usingColor objects.
• TheTextStyleBuilder class now has aTextStyleBuilder.setForegroundColorObject(color) method that updates the foreground color of the style builder using aColor object.
• TheTextStyle class now has aTextStyle.getForegroundColorObject() method that gets the foreground color of the style as aColor object.

Apps Script now supports theV8 runtime. This enables modern JavaScript features and syntax in Apps Script. You canmigrate existing scripts to use V8 and its features.

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

• The add-onsmanifest structure has been updated to provide configuration controls for G Suite Add-ons. All add-on manifest settings are specified in theAddOns object in the manifest.Manifest fields that previously supported Gmail add-ons still exist, but are now deprecated. SeeUpgrading your published add-ons for instructions on how to upgrade a Gmail add-on into a G Suite add-on.

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

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

Google Workspace Add-ons have been launched. Google Workspace add-ons are the latest generation of add-ons, and build on the original Gmail add-ons infrastructure. Google Workspace add-ons provide a variety of new features, including:

• The ability to extendGmail,Calendar, andDrive—all from a single add-on!
• Homepage interfaces that provide an initial start point for the add-on and non-contextual interfaces.
• Contextual interactions that allow Google Workspace add-ons to automatically react when useropens a Gmail message,composes a new draft message,edits a Calendar event, orselects files and folders in Google Drive.
• The ability to create client-independent interfaces using Apps Script'sCard service, including new widgets likeDate and Time pickers.
• The ability to publish Google Workspace add-ons to theGoogle Workspace Marketplace.

With the launch of Google Workspace add-ons, Gmail add-ons have been deprecated. You can still use existing Gmail add-ons, but they are effectively just Google Workspace add-ons that only extend Gmail. If you have Gmail add-ons you've developed, you canupgrade them into Google Workspace add-ons to take advantage of the new features.

Note: Editor add-ons can't be upgraded into Google Workspace add-ons at this time. All editor add-ons remain functional.

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

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

Themessages.import method uses a more performant backend implementation. The new version is API-compatible with the previous implementation and all clients automatically started using the new behavior as of a few weeks ago. The new backend supports parallelmessage.import calls efficiently and clients can now import messages in parallel for a user to achieve higher migration throughput. The quota cost of themessage.import method has been decreased to reflect the new performance.

The Gmail add-onhttps://www.googleapis.com/auth/gmail.addons.executescope is no longer required for Gmail add-ons. Apps Script and Gmail now ignore this scope if it is present in an add-on's manifest.

All add-ons are now in the G Suite Marketplace.

To streamline the add-on discovery experience for users in the G Suite Marketplace, publication of both public and private add-ons to the Chrome Web Store is deprecated. Chrome extensions continue to be presented in the Chrome Web Store and aren't affected by this change.

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

TheScript service has been extended with theScriptApp.getIdentityToken() method, which returns an identity token for the effective user.

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

TheSlides service classRgbColor and the enumerationColorType have been moved from the Slides service to the [Base script service](https://developers.google.com/apps-script/reference/base). The functionality of these classes has not changed. Moving these classes to the Base script service enables other services to make use of them in the future. You can now find the documentation for these classes at [RgbColor](https://developers.google.com/apps-script/reference/base/rgb-color) and [ColorType`](https://developers.google.com/apps-script/reference/base/color-type).

Several classes and methods relating to the now shutdownUiApp service have been removed. Most of these methods involved interactions between theCharts service andUiApp that were very seldom used. The following is a full list of the removed classes and methods:

• Charts service
  • CategoryFilterBuilder
  • Control
  • DashboardPanel
  • DashboardPanelBuilder
  • Chart.getId()
  • Chart.getType()
  • Charts.newCategoryFilter()
  • Charts.newDashboardPanel()
  • Charts.newNumberRangeFilter()
  • Charts.newStringFilter()
  • NumberRangeFilterBuilder.build()
  • NumberRangeFilterBuilder.setDataTable(tableBuilder)
  • NumberRangeFilterBuilder.setDataTable(table)
  • NumberRangeFilterBuilder.setFilterColumnIndex(columnIndex)
  • NumberRangeFilterBuilder.setFilterColumnLabel(columnLabel)
  • NumberRangeFilterBuilder.setLabel(label)
  • NumberRangeFilterBuilder.setLabelSeparator(labelSeparator)
  • NumberRangeFilterBuilder.setLabelStacking(orientation)
  • StringFilterBuilder.build()
  • StringFilterBuilder.setDataTable(tableBuilder)
  • StringFilterBuilder.setDataTable(table)
  • StringFilterBuilder.setFilterColumnIndex(columnIndex)
  • StringFilterBuilder.setFilterColumnLabel(columnLabel)
  • StringFilterBuilder.setLabel(label)
  • StringFilterBuilder.setLabelSeparator(labelSeparator)
  • StringFilterBuilder.setLabelStacking(orientation)
• Spreadsheet service
  • EmbeddedChart.getId()
  • EmbeddedChart.getType()
  • EmbeddedChart.setId(id)

The Calendar API allows attaching a conference data of typeaddOn to a new or existing event usingEvents.insert orEvents.update methods.

TheCard service methodsCardHeader.setUrl(url) andImage.setUrl(url) have been updated to accept an encoded image data string as an input parameter. As before, you can alternatively use a publicly-available image URL as the input parameter.

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

Reports API: The customer usage reports for App Maker and Apps Script are deprecated and will eventually be removed from the API.

• TheGroup service has been updated with theGroups.getRoles(user) method that can determine the list of roles a specific user in a group has.
• TheSlides 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)
• TheSpreadsheet 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 "Team Drive" feature of Google Drive has been renamed to "shared drive". Consequently, the Vault API is changing as follows:

• Shared drive-related request and response fields have replaced Team Drive in:

  • DriveOptions
  • HeldDriveQuery
  • SearchMethod

• SharedDriveInfo has replacedTeamDriveInfo.

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

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

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

TheData Studio service has been updated to add a few values toFieldType enum:

• HYPERLINK
• IMAGE
• IMAGE_LINK

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

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

• TheSpreadsheet 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)
  • AclearRanges() method has been added to the all the embedded chart type builder classes, such asEmbeddedAreaChartBuilder.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)
• TheData Studio service has been extended with the following new classes and methods that support configuring BigQuery connectors:
  • BigQueryConfig
  • BigQueryParameterType
  • CommunityConnector.newBigQueryConfig()
• TheNotification objects in theCard service no longer have a type that you must set. Calls to the now removedNotification.setType(type) method result in a no-op.

Hangouts Chat and Google Meet together are the next generation of Hangouts. Later this year they will replace the original version (classic Hangouts) in Google Workspace.

Vault admins must take action to prepare for this migration.Learn More.

• TheSpreadsheet service has been extended with the following new classes and methods to supportBigQuery 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)

• TheData Studio service has been extended with the following new methods involving reaggregation settings:

  • Field.getIsReaggregatable()
  • Field.setIsReaggregatable(isReaggregatable)

• TheSpreadsheet 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()
• TheData 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 deprecatedUiApp service will be officially shutdown on July 15th, 2019. After this date, the service will no longer function for any script project.

• TheSlides 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()
• TheData Studio service has been extended with the following new classes and methods that error displays:
  • DebugError
  • UserError
  • CommunityConnector.newDebugError()
  • CommunityConnector.newUserError()

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

TheFusion Tables advanced service has been deprecated and will shutdown fully on December 3rd, 2019.

Starting on January 7, 2019, notifications and reminders using thesms method type will be ignored. The API calls setting such notifications and reminders will still succeed and modify all the other fields.

Since Calendar offers in-app notifications, you can still get notified, regardless of your device or connection. For more information seeGoogle Calendar SMS notifications to be removed.

• TheCard 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)
• TheSlides 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 theGroup,Image,Line,PageElement,Shape,SheetsChart,Table,Video, andWordArt classes:
  • bringForward()
  • bringToFront()
  • sendBackward()
  • sendToBack()
  • setDescription(description)
  • setTitle(title)
• TheSpreadsheet 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. SeeAuthorizing Google Calendar API Requests for more details.

The following methods in theSpreadsheet service now return anOverGridImage object instead of void:

• Sheet.insertImage(blobSource, column, row)
• Sheet.insertImage(blobSource, column, row, offsetX, offsetY)
• Sheet.insertImage(url, column, row)
• Sheet.insertImage(url, column, row, offsetX, offsetY)

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

Reports API: Thecommunity_name parameter for theGoogle+ communities report is now available only for communities inside your organization.

TheCard service has been extended with the following classes and methods to supportGmail add-on compose actions:

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

Alert Center API: V1beta1 is now available.

A more flexible approach to sending event change notifications is now available through thesendUpdates 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.

TheData Studio service is now available. You can use this service when building aData Studio Community Connector.

TheUtilities 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

Reports API: The availability of past data for theEntities Usage Report has been changed to 30 days.

The Google Tasks API is now generally available.

Thequota limits forUrlFetchGET response size andPOST size have been increased to 50MB / call.

• TheForms service now has the following method:
  • Form.deleteResponse(responseId)`
• TheUtilities service now has the following methods:
  • Utilities.computeDigest(algorithm, value), where value is aByte array
  • Utilities.computeHmacSha256Signature(value, key), where value and key areByte arrays
  • Utilities.computeHmacSignature(algorithm, value, key), where value and key areByte arrays

The quota on total data received byUrlFetch per day per user has been removed.

Reports API: Fixed an issue where someEntities Usage Parameters were under-reported for someGoogle+ communities. This has been corrected as of May 25, 2018.

• TheSpreadsheet service has been extended with the newGroup class and theGroupControlTogglePosition enum. Groups are an association between an interval of contiguous rows or columns that can be expanded or collapsed as a unit.
• TheSpreadsheet 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)

Macros for Google Sheets are now becoming available for users, and will finish rolling out over then next few weeks. This feature lets you record macros in the Google Sheets UI and use Apps Script to create or edit them.

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

TheCharts service has been extended to supportEmbeddedCharts in Google Sheets with the enumsChartHiddenDimensionStrategy andChartMergeStrategy. In addition, the followingChartTypes have been added:

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

• The deprecatedenable(restriction) method of theScriptApp.Service class has been sunset.
• The deprecatedService.Restriction enum used with theScriptApp.Service class has been sunset.

TheSpreadsheet service has been extended with the following new methods:

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

Support for theJSON-RPC protocol andGlobal HTTP batch endpoints has been deprecated, and will be fully discontinued on March 25, 2019. This change is being made to the Google API infrastructure and as such affects multiple Google APIs, including Calendar v3.

For more information and migration instructions, see theDiscontinuing support for JSON-RPC and Global HTTP Batch Endpoints blog post.

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

• TheSlides 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)
• TheSpreadsheet service has been extended with the following new enum class and method:
  • CopyPasteType, an enum class describing paste types.
  • Range.copyTo(destination, copyPasteType, transposed)

• TheUrlFetch service now has afetchAll method that makes multiple fetch requests.
• TheUtilities service now has methods tocompress anddecompress Blob objects usinggzip.

• TheApps Script dashboard is now available. You can use it to see, search, and monitor all your script projects.TheApps Script API is now available. This API includes and extends the original Apps Script API. You can use the Apps Script API in an application to do any of the following:
  • Create, read, and update Apps Script projects.
  • Create and manage project versions.
  • Create and manage project deployments.
  • Monitor script use and metrics.
  • Run script functions remotely.
• The open-sourceclasp tool is now available. It lets you manage and develop Apps Script projects locally from the command line instead of the Apps Script editor.

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

• TheGmail add-ons framework is now available to all developers.
• A newCard service supports Gmail add-ons by defining severalUI 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 projectmanifests. These files give you more direct control of project properties.
• You can now directly control theOAuth 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 nowdeploy a script project directly from the project manifest.
• We've updated thePublish 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.

• TheCalendar 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)
• TheGroups service has been extended with the following new methods:
  • Group.getGroups()
  • Group.hasGroup(group)
  • Group.hasGroup(email)
• TheSpreadsheet 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)

Add-ons now requireOAuth Client Verification prior to beginning the publication process. Verification no longer is conducted during the add-on review.

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

• AddedGmailDraft to the Gmail service. You can now create, edit, delete, and sendnew draft messages ordraft 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 usingGmailMessage.isInPriorityInbox() orGmailThread.isInPriorityInbox().

• Added aSpreadsheet.getFormUrl() method that returns the URLs of Forms send responses to this Sheet or Spreadsheet.
• Adds aCheckbox Grid item to the Forms service.
• Enabled the collection ofexception and error reports usingStackdriver Error Reporting.

To protect users from abuse,Google OAuth clients that request certain sensitive OAuth scopes are subject to review by Google. Such apps may present users with a warning screen saying the app is unverified by Google. You can remove this screen from your app's authorization flow bysubmitting a review request.

Hangouts and Google Meet conferences are now supported in Calendar events via theconferenceData 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, seeCreate Events.

Reports API: Nine new parameters have been added to theGoogle+ 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, theGoogle+ 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

Stackdriver Logging has been moved out ofEarly Access. All scripts now have access to Stackdriver logging.

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

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

DeprecatedReview Action, which sunsets on July 15th, 2017.

• Quizzes in Google Forms is now accessible from theApps Script Forms service.
• Added support forCombo and Histogram charts. Like other charts, these can be embedded in a Google Sheet.
• Added ability togetColor() andsetColor() for Calendar Events. Events have their own color set:EventColor.

Reports API: Google Docs customer and usage reports are being replaced by Google Drive customer and usage metrics. See details inUpdate your Drive and Docs Metrics.

Reports API: Six new parameters have been added to theGoogle+ 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 usingShared 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 nowpublish add-ons anddeploy scripts as web apps or executables for theExecution API.
• For allcontainer-bound scripts, the container owner takes ownership of a new script project regardless of who created it.

• Enabled theSlides Advanced Service.
• Enabled theSheets Advanced Service.

Thehistory.list method supports filtering history records by type.

Introduced theEarly Access program for new G Suite Business features. These features includeApp Maker andStackdriver Logging.

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

Added forms validation classes forcheck boxes,generic data,grid items,paragraph text items, andtext items.

The Gmail API supports agmail.metadata scope. This scope gives developers access to a user's mailbox including history records, labels, and email headers, but not email body's or attachments.

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

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

The use of project keys to identify scripts is now deprecated. The preferred unique identifier for a script is theScript ID. There are no plans to turn off or disable the use of project keys; code that uses project keys will continue to work for the foreseeable future.

NATIVEsandbox mode is now shut down. All scripts default toIFRAME mode, regardless of which mode, if any, is specified. Scripts that relied onNATIVE mode featuresmay need to be migrated.

New endpoints for managing mail settings:

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

Theq request parameter for thedrafts.list method restricts results to the messages matching the specified query.

Google Sheets API v4 is now available. For more information, seeIntroducing the Google Sheets API v4.

The Google Cloud Search API is now available for enterprise administrators.

The Google Slides API is now generally available.

Support forPATCH requests has been added toUrlFetchApp.

Deprecated theadd(widget) method in theDashboardPanel class because it takes aUiApp.Widget argument, and UiApp was deprecated in 2014.

• The Spreadsheet API adds new methods forgetTabColor() andsetTabColor(color).

• The Spreadsheet API adds a newNamedRange 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 newgetUuid() method that generates a unique identifier.

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

Thedrafts.list method has anincludeSpamTrash option, which determines if the response should include drafts with theSPAM orTRASHlabel applied. The default is currently set totrue for this option.

In theHTML service,EMULATEDsandbox mode wassunset. Any scripts that explicitly requestEMULATED mode now default toIFRAME mode.

In theHTML service, all new scripts default toIFRAME sandbox mode unlessNATIVE mode is explicitly specified.

Deprecated the methodService.enable() in the ScriptApp global object. This method is no longer useful because Apps Script's authorization model has changed since the time the method was introduced.

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 themethodcomputeRsaSha256Signature to theUtilities 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, thehistory.list method returns all currentMessage.labelIds as part of the response inmessagesAdded,messagesDeleted,labelsAdded, andlabelsRemoved.

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

You can now sendpush notifications on mailbox updates, providing real-time server notification without the need for constant polling. WithCloud 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 themethodgetUserAgent() to theHtmlService global object to let scripts get the user-agent string for the current browser.

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

Deprecated the following OAuth class and methods in favor ofOAuth libraries:+OAuthConfig+UrlFetchApp.addOAuthService(serviceName)+UrlFetchApp.removeOAuthService(serviceName)

TheDocsList service, which wasdeprecated in 2014, has been sunset and no longer functions. Users relying onDocsList should switch toDriveApp.

• Add-ons are now out of developer preview. This means anyone can nowpublish an add-on. New add-ons will still be reviewed prior to publishing, but the publishing process has been streamlined.
• Add-ons can now be developed and published from standalone scripts (as opposed to scripts bound to a Sheet, Doc, or Form). The add-on must still operate on a Sheet, Doc, or Form, but the script does not need to be bound to a single master file. Developing from a standalone script is preferred in that it makes collaboration and testing easier.
• Add-on scripts in development can betested to ensure they behave as intended.

New scopes for labels and inserting messages to better protect users and accommodate apps that don't need full mailbox data access:

• https://www.googleapis.com/auth/gmail.insert: Allows themessages.insert andmessages.import methods only.
• https://www.googleapis.com/auth/gmail.labels: Allows alllabel operations.

• Added the ability topublish add-ons for domain-wide installation. This lets an admin of a Google Apps domain install and authorize a Docs, Sheets, or Formsadd-on for all users in the domain if the add-on is published to theGoogle 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 tochange 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.

Themessages.insert method now supports thedeleted request parameter and lets you setSENT andDRAFT labels.

Deprecated the URL Fetch service's classOAuthConfig, which provided the ability to connect to OAuth 1.0 APIs. This has been replaced by the open source libraryOAuth1 for Apps Script. See themigration guide for more information.

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

Themessages.import method now supports the following parameters to better supportEmail Migration use cases:

• neverMarkSpam
• processForCalendar
• deleted

Changed severalSpreadsheet methods that previously returned void so that they now return aSpreadsheet object that can be used to chain method calls.

Issue 4617: HTML service pages that use the newIFRAME sandbox mode now render correctly in Firefox.

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)

• Deprecated the following class and methods, which have been replaced by the more powerful Protection class above. Although this class and these methods are deprecated, they will remain available for compatibility with the older version of Sheets.

  • PageProtection
  • Spreadsheet.getSheetProtection()
  • Spreadsheet.setSheetProtection(permissions)
  • Sheet.getSheetProtection()
  • Sheet.setSheetProtection(permissions)

• Replaced the methodSpreadsheetApp.open(file), which takes aFile object from the deprecatedDocsList service as a parameter, with a version that takes aFile object from theDrive service instead. The new method has the same name.

• Changed the Document service methodsText.getFontFamily() andText.setFontFamily(fontFamilyName) to use string names for font families instead of theFontFamily enum, and consequently deprecatedFontFamily.

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

The default behavior no longer automatically addsINBOX andUNREAD labels tomessages.import emails. Whenmessage.labelIds isn't specified, imported mail is only visible in All Mail. If you wantINBOX orUNREAD labels applied, specify them in themessage.labelIds field.

You can now specifymessage.labelIds onmessages.import requests to automatically apply the given labels to the message.

Increased the defaultper-user quotas from 25 units/user/second to 250 units/user/second and adjusted some method costs slightly.

Added a newIFRAME 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.

• Deprecated both theUI service and theDocsList service. As announced in theblog post, theDocsList service will be turned off on April 20, 2015, and the UI service will be turned off on June 30, 2015. To create user interfaces, use theHTML service instead. To replace theDocsList service, use theDrive service instead.
• Removed theDomain service, asannounced earlier in the year.

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

• Added five newFormApp 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 newSpreadsheetApp methods:
  • Sheet.insertImage(blob, column, row): Inserts aBlob as an image in the sheet at a given row and column.
  • Sheet.insertImage(blob, column, row, offsetX, offsetY): Inserts aBlob as an image in the sheet at a given row and column, with a pixel offset.

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

Reports API: We have added theOAuth Token Audit reporting application to theactivities.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.

Reseller API: NewtransferToDirectdeletionType.

Reseller API: NewbillingMethod field.

Reports API: Added the following parameters to theGmail 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 theChromeOS Devices customer usage report to thecustomerUsageReports.get method. This new report allows you to view information about ChromeOS device usage in your domains.

Issue 3928: TheDocument methodsetSelection, theSheet methodactivate, and theSpreadsheet methodssetActiveRange andsetActiveSelection now work correctly if they are called from anonOpen oronEdit trigger.

Removed theFinance service, asannounced earlier in the year.

Add-ons are nowavailable in Google Forms. As with add-ons for Docs and Sheets, Forms add-ons are in developer preview, so you mustapply to publish them.

You can now specify the return format for thethreads.get method. The available formats arefull,metadata, andminimal, similar to themessages.get method. The raw format isn't allowed for thethreads.get to avoid unexpectedly large amounts of data being returned.

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

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

Added a newIMPORTANT label to match functionality with the Gmail UI.

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

• messagesTotal
• messagesUnread
• threadsTotal
• threadsUnread

TheUiService widgetDocsListDialog now requires that you callDocsListDialog.setOAuthToken(oAuthToken) before callingDocsListDialog.showDocsPicker().

• Added theLinearOptimizationService, which allows scripts to model and solve linear and mixed-integer linear programs.
• Add-ons for Google Sheets and Docs can now use mostinstallable triggers, although they still cannot use time-driven triggers (sometimes called clock triggers).
• Added aninstallable open trigger for Google Docs. Like the installable open triggers for Sheets and Forms, this trigger is similar to the simpleonOpen() trigger, but allows the triggered function to call services that require authorization, if the user has authorized the script ahead of time.
• Added several newScriptApp 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 byScriptApp.getAuthorizationInfo().
  • AuthorizationStatus: An enumeration denoting the authorization status of a script. Returned byAuthorizationInfo.getAuthorizationStatus().
  • DocumentTriggerBuilder: A builder for document triggers. Returned byTriggerBuilder.forDocument(...).
  • ScriptApp.getUserTriggers(...): Gets all installable triggers owned by this user in the given document, spreadsheet, or form.

Themessages.insert method defaults to usingreceivedTime and themessages.import method defaults to usingdateHeader.

When you use themessages.get method, you can request the metadata return format to return only the email headers and metadata such as identifiers and labels.

• Added theUiService methodDocsListDialog.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 callingDocsListDialog.showDocsPicker() on September 30, 2014.
• Added theCacheService methodgetDocumentCache() and theLockService methodgetDocumentLock(), 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 thePropertiesService methodgetDocumentProperties(), which was introduced for use in add-ons earlier this year.

Replaced theCacheService methodsgetPrivateCache() andgetPublicCache() and theLockService methodsgetPrivateLock() andgetPublicLock() withgetUserCache(),getScriptCache(),getUserLock(), andgetScriptLock(), respectively. The old method names have been deprecated, but will continue to function. The new names follow the same conventions asPropertiesService.

You can specify theinternalDateSource for both themessages.insert andmessages.import methods.

Reports API: The maximum time limit for usage reports has been increased from 180 days to 450 days. Because this change will take time to populate in our data, the full 450 day history will be available on May 30, 2015 with an earliest available record date of March 6, 2014.

Reports API: A newview event has been added to theDrive activity report.

Directory API: TheChromeosdevices resource has the following fields:

• recentUsers
• Device'sethernetMacAddress

Directory API: The following fields have been added to theMobiledevices resource:

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

Reseller API: Deprecatedreadonly scope.

Reseller API: newlicensedNumberOfSeats field in theSubscriptions resource.

Added the valueON_CHANGE to theScriptApp.EventType enum so that Google Sheetschange events can be detected correctly.

Quota costs for all methods in the API have been reduced by a factor of 10. For example, if a method previously cost 150 quota units, it now costs 15. For a complete list of API method costs, see theper-method quota usage chart.

The Gmail API is publicly available!

Reports API: TheDrive 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.

Deprecated the script gallery in the old version of Google Sheets. As explained in theblog post, the add-on store in the new version of Sheets gives developers wider distribution, automatic updates, and several other features not available in the script gallery.

Reports API: Bothcustomer anduser Gmail reports now include default values. For example, if a user sends no email, thenum_emails_sent parameter is returned as 0. Previously, if there was no data for a field, that field was omitted from the report.

Added theDocument service methodsgetTextAlignment andsetTextAlignment as well as the enumTextAlignment, to supportNORMAL,SUPERSCRIPT, andSUBSCRIPT text alignment in Google Docs.

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

• Issue 3956: In the new version of Google Sheets, it is now possible to call methods that refer to the "active" sheet or spreadsheet even if the sheet or spreadsheet has just been created.
• Issue 3579: TheBlob methodgetAs can now create PDFs from spreadsheets created with the new version of Sheets.
• Issue 3378: The documentation page for a library version now uses the same CSS styles as the Apps Script reference documentation.

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

Deprecated bothScriptDB and theDomain service. As announced in the blog post, the services will remain available for the next six months but will be turned off on November 20, 2014. To replaceScriptDB, see themigration guide and the improved guide toconnecting to external databases through JDBC. To replace theDomain service, see theAdmin SDK Directory andAdmin SDK Reports advanced services.

The "Report an issue" dialog foradd-ons now asks users whether they would like to share their name and email address with the developer.

• Issue 3963: TheApps Script dashboard is available again.
• Issue 3533: TheTrigger methodsgetEventType() andgetTriggerSource() no longer throw an exception if the trigger belongs to a spreadsheet created by thenew version of Google Sheets.

• Issue 3891: In the new version of Sheets, custom functions now recalculate correctly if more than 100 cells are passed as an argument.
• Issue 3859: In the new version of Sheets, setting data-validation criteria for a cell that already contains a value no longer corrupts the spreadsheet.
• Issue 3773: In the new version of Sheets, the Browser methodsinputBox andmsgBox now treat newline characters (\n) the same way that the older version of Sheets did. Specifically,\n produces a space, but\\n (double-escaped) produces a line break.
• Issue 2335: The fact that the ID of aGmailThread varies based on the messages it contains isnow documented.
• Issue 2288: The fact that a Google Site or page of a site cannot have more than 500 child pages isnow documented.
• Issue 1427: The fact that the methodgetAs replaces the part of a filename that follows the last period with the new file type's extension isnow documented.

In thenew version of Google Sheets, the Undo command can now revert changes made by a script. This was already true in Docs, Forms, and the older version of Sheets.

Reports API: A change has been made to how parameters with no data are returned by the API. Previously, if there was no data for a parameter, it would be absent from the report. For example, the Gmail user usage report would not include thenum_emails_sent field in the response if a user didn't send any emails on the report date. The API now returns these parameters with a default of 0 for integers and false for boolean values.

• Issue 3669: In thenew version of Sheets, theRange methodsgetValue() andgetValues() no longer throw an exception if a cell uses the built-in Sheets methods=IMAGE(url) or=SPARKLINE(data).
• Issue 2684: If a script relies on a deleted version of a library, it is now possible to switch to a different version.

TheDocument methodsetSelection, theSheet methodactivate, and theSpreadsheet methodssetActiveRange andsetActiveSelection no longer have any effect if they are called from anonOpen oronEdit trigger.

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

The deprecated SOAP service and old XML service have now been removed from autocomplete and documentation, as announced on July 9, 2013 and documented in theApps Script sunset schedule. Existing scripts that use these services should still function. The UI service widgetsDeckPanel,DecoratedPopupPanel,DockLayoutPanel,DockPanel,StackLayoutPanel, andTabLayoutPanel have been completely disabled, as announced on April 15, 2013.

• Issue 3788: In the new version of Sheets, custom functions now calculate if they are passed an error value as an argument. This matches the behavior in the older version of Sheets.
• Issue 3539: In the new version of Sheets, theRange methodssetValue andsetValues now automatically detect when a value should be set as a formula. This matches the behavior in the older version of Sheets.

• Issue 3866: TheDocsList methodsFile.getEditors() andFile.getViewers()no longer throw a server error on every call.
• Issue 3865: TheDocsList methodFile.getOwner() no longer throws a server error on every call.
• Issue 3845: The advanced Google services forDrive andCalendar are now documented.
• Issue 3624: In the new version of Sheets, theSheet methodhideSheet() can now hide sheets that have just been inserted.
• Issue 3554: In the new version of Sheets, theRange methodsort() now succeeds for ranges that do not include column A.
• Issue 3522: In the new version of Sheets, theSpreadsheetApp methodgetActiveSheet() now returns the correct sheet in a single custom function call. However,getActiveSheet() still returns an incorrect value if the custom function is used in more than one cell with the same function arguments, or if called from an installable edit trigger in the new version of Sheets.
• Issue 3496: In the new version of Sheets, theSpreadsheetApp methodgetActiveRange() now returns the correct range in a single custom function call. However,getActiveRange() still returns an incorrect value if the custom function is used in more than one cell with the same function arguments, or if called from an installable edit trigger in the new version of Sheets.

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

When anadd-on is installed from the store, theonInstall()simple trigger is now passed anevent parameter,e, which includes anauthMode property. This makes it easier for an add-on tocallonOpen(e) fromonInstall(e).

• Issue 3691: In the new version of Google Sheets, scripts can now run for 6 minutes instead of 5 minutes.
• Issue 3236: Google Picker, a "file-open" dialog for information stored in Google servers, including files in Google Drive, is nowsupported in HTML service.

Reports API: Added two newlogin_failure_type values to theLogin Audit events:login_failure_account_disabled andlogin_failure_unknown.

Reports API: Fixed an issue that caused filters to use case-sensitive comparisons. All filters are now case-insensitive.

• Issue 3800: In the new version of Sheets, custom functions now accept numbers larger than 10,000,000 or smaller than 0.0001 as arguments.
• Issue 3770: In the new version of Sheets,Sheet.insertImage() now inserts the image at the correct size.
• Issue 3724: In the new version of Sheets,Range.setValue() now correctly sets numeric values in non-English spreadsheets.

In thenew version of Google Sheets,Range.setValues() now automatically extends the spreadsheet if the range is larger than the present size.

Issue 3757: The link to the Google Developers Console in the Advanced Google Services dialog now opens the correct project.

Changed thequota for Gmail from 10,000 reads and 10,000 writes per day (excluding sent messages) to 20,000 reads and writes combined per day.

• Released aCSS 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 methodcreateAddonMenu(), which allows scripts to insert a sub-menu into the Add-ons menu in Google Sheets or Docs. For more information, see theguide to menus.
• Added theScriptApp enumAuthMode, which identifies categories of authorized services that Apps Script can execute through a triggered function. For more information, see theguide 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.