Google Apps Script release notes

Generally Available: Apps Script now supports data regions in Google Workspace, adhering to organizational data location policies configured in the Google Admin console:

• Data at rest: Script project files, code definitions, manifest configurations, trigger metadata, and key-value storage (such as Property Service and Cache Service) are stored within the designated geographic region.
• Data processing: Script executions, container-bound automations, and associated runtime operations are processed within the selected region.

This feature is available for Google Workspace Enterprise Plus and Frontline Plus editions (in-region storage and processing), and Education Standard and Education Plus editions (in-region storage only). Scripts running on the legacy Rhino runtime are not supported under strict data region policies; projects must use the V8 runtime. For details on covered data and managing non-regionalized services, see What data is covered by a data region policy? and Set up advanced settings for data regions.

Gemini Beta: You can now use the Gemini side panel in the Apps Script editor to generate, modify, and debug code, and ask questions. Gemini uses context from your active script project and attached container (if available) to provide relevant Apps Script code and explanation.

To learn more, see Use the Gemini side panel in the Apps Script editor.

Generally Available: Apps Script is generally available as a core service in Google Workspace, giving it the enterprise-grade data protection, robust administrative controls, and standard technical support that safeguard other core services.

Generally Available: The AddOnsResponseService and its associated classes in Apps Script are now generally available. This service allows developers to create and manage interactive responses for Google Workspace Add-ons that extend Google Chat.

Deprecated: The method setAuthentication(clientId, signingKey) has been deprecated and is scheduled for sunset in June 2026. This change is because Maps platform client IDs were deprecated on May 26, 2025, and can't be used after May 31, 2026. Instead, use setAuthenticationByKey(apiKey) or setAuthenticationByKey(apiKey, signingKey). To get an API key, refer to the Client ID Migration Guide.

Generally Available: To authenticate to the Maps service, you can now use an API key with the new methods setAuthenticationByKey(apiKey) and setAuthenticationByKey(apiKey, signingKey). To reset authentication to the default mode, use resetAuthenticationApiKey().

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

For details, see the Vertex AI advanced service reference documentation.

The Apps Script samples gallery now lets you find samples by use case, products, and sample type. The gallery also 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

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 the Google Analytics Data API Advanced Service instead.

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, see Monitor and control Apps Script use in your Google Workspace organization.

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

Learn about the setPublished method to publish forms.

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 to Migrate scripts to the V8 runtime.

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

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

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

ScriptApp class:

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

AuthorizationInfo class:

• getAuthorizedScopes()

For more information, refer to Handle granular OAuth permissions.

The getUrl() method for the CellImage, CellImageBuilder, and OverGridImage classes of the Spreadsheet service has been deprecated. An image's source URL isn't available regardless of how the image is inserted into a spreadsheet.

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

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

• Enum EventTransparency
• Class CalendarEvent
• Class CalendarEventSeries

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

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

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

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

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

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

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

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

Google Workspace administrators can now turn on an allowlist in the admin console to control which external domains users can access through Apps Script's URL 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): Multiselect menus are now generally available for Add-ons.

For more information refer to the following:

• SelectionInput for Apps Script
• SelectionInput for HTTP runtimes

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

For more information refer to the following:

• Columns for Apps Script
• Columns for HTTP runtimes

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

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

• DataSourceChart
• DataSourceFormula
• DataSourcePivotTable
• DataSourceSheet
• DataSourceTable

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

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

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

The default property for the TextButtonStyle enum in the Apps Script Card Service has been renamed from TEXT to OUTLINED to align with the Google Material 3 design system. Existing scripts that use the original default, TEXT, render the same as the new default, OUTLINED.

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

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

The 200 version limit, first announced for new scripts on December 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 to Delete a version.

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

For more information refer to the following:

• SelectionInput for Apps Script
• SelectionInput for other runtimes

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

For more information refer to the following:

• Columns for Apps Script
• Columns for other runtimes

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

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

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

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

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

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

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

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

To learn more, see Delete a version.

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

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

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

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

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

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

The email address that sends notifications about errors in triggers has been updated from apps-scripts-notifications@google.com to noreply-apps-scripts-notifications@google.com.

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

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

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

• Developer documentation: Versions

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

Apps Script has deprecated the Contacts service. Instead, use the People API advanced service. Refer to Migrate from Contacts service to People API advanced service.

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

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

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.

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.

Apps Script now automatically deletes default 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.

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.

You can now perform the following actions in the new Apps Script integrated development environment (IDE):

• Create test deployments for Editor Add-ons.
• Add, edit, and delete script properties from the project settings page.
• Sort files alphabetically in the editor.
• Debug Rhino functions without migrating to the V8 runtime. If your code isn't V8 compatible, you might receive errors.
• Set the time zone for a script project.

For Google Workspace Add-ons, an Attachment class has been added to the Card Service that lets you add custom attachments to Calendar events. You can also set an event trigger that fires when the user clicks on the add-on attachment provider in the Calendar dropdown menu. For more information, refer to EventAttachmentTrigger.

The get methods for several color objects in the Spreadsheet Service have been deprecated in favor of a new naming convention. The functionality remains the same. For example, the getFontColor() method from the Range class has been replaced with getFontColorObject().

The following classes have updated get methods for color objects:

• Banding:
  • getFirstColumnColor() is now getFirstColumnColorObject().
  • getFirstRowColor() is now getFirstRowColorObject().
  • getFooterColumnColor() is now getFooterColumnColor().
  • getFooterRowColor() is now getFooterRowColorObject().
  • getHeaderColumnColor() is now getHeaderColumnColorObject().
  • getHeaderRowColor() is now getHeaderRowColorObject().
  • getSecondColumnColor() is now getSecondColumnColorObject().
  • getSecondRowColor() is now getSecondRowColorObject().
• BooleanCondition:
  • getBackground() is now getBackgroundObject().
  • getFontColor() is now getFontColorObject().
• GradientCondition:
  • getMaxColor() is now getMaxColorObject.
  • getMidColor() is now getMidColorObject.
  • getMinColor() is now getMinColorObject.
• Range:
  • getFontColor() is now getFontColorObject().
  • getFontColors() is now getFontColorObjects().
• Sheet:
  • getTabColor() is now getTabColorObject.
• Slicer:
  • getBackgroundColor() is now getBackgroundColorObject().

Owners receive email alerts when someone outside the owner's organization edits a script project in the new integrated development environment (IDE).

• For container-bound scripts: If someone outside the container owner's organization creates or edits a container-bound script project, the container owner receives an email notification.

• For standalone scripts: If someone outside the script project owner's organization edits a standalone script project, the script project owner receives an email notification.

The following classes have been added to the Spreadsheet Service to let you add images to cells:

• CellImageBuilder: This builder creates the image value needed to add an image to a cell.
• CellImage: Represents an image to add to a cell.

To add an image to a cell, you must create a new image value for the image using SpreadsheetApp.newCellImage() and CellImageBuilder. Then, use Range.setValue(value) or Range.setValues(values) to add the image value to the cell.

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

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

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

Learn more about HMTL Service restrictions.

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

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

Learn more about the resource key security update for Drive.

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

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

Learn more about smart chips in Google Docs.

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.

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

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

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, see Create and manage deployments.

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, click Use legacy editor.

An advanced service for Google Tables has been added to Apps Script. The Tables service allows scripts to programmatically read and edit rows within Tables.

New classes and methods have been added to support Connected Sheets.

The following new classes have been added to the Spreadsheet service:

• DataSourceChart
• DataSourceColumn
• DataSourceFormula
• DataSourcePivotTable
• DataSourceRefreshSchedule
• DataSourceRefreshScheduleFrequency
• DataSourceSheet
• DataSourceSheetFilter
• DataSourceTableColumn
• DataSourceTableFilter
• DateTimeGroupingRule
• PivotGroupLimit
• SortSpec

New methods to support Connected Sheets have been added to the following classes in the Spreadsheet service:

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

A new class called DecoratedText has been added to the Card Service. DecoratedText adds text with optional decorations and was added to replace the KeyValue class.

The following Folder class methods have been deprecated:

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

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

The DriveApp now has an enforceSingleParent(value) method that enables or disables enforceSingleParent behavior.

• The File class now has the following methods:

  • file.getTargetId(): Gets a shortcut's file ID.
  • file.getTargetMimeType(): Returns the mime type of the item a shortcut points to.
  • file.moveTo(destination): Moves a file to a specified destination folder.

The Folder class now has the following methods:

• folder.createShortcut(targetId): Creates a shortcut to the provided Drive item ID, and returns it.
• folder.moveTo(destination): Moves an item to the provided destination folder.

New methods have been added to the Spreadsheet service:

• The RichTextValue class now has a RichTextValue.getLinkUrl() method that gets the URL of the specified value.
• The RichTextValueBuilder class now has a RichTextValueBuilder.setLinkUrl() method that sets the link URL for the specified value.
• The PivotTable class now has a PivotTable.getSourceDataRange() method that returns the source data range on which the pivot table is constructed.
• The PivotValue class now has a PivotValue.remove() method that removes the value from the pivot table.

A new simple trigger, onSelectionChange(e), has been added for Google Sheets. The onSelectionChange(e) trigger runs automatically when a user changes the selection in a spreadsheet.

The following has been added to the Spreadsheet service:

• A new Drawing class has been added to support drawings.
• You can now get your drawings with the Sheet.getDrawings() method.

The following has been added to the Drive service:

• There's a new FILE_ORGANIZER value in the Permission enum. If you have FILE_ORGANIZER permission on a shared drive, you can edit, trash, and move content within that drive.

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

• The Banding class now has 16 new methods that manipulate color in the banding columns and rows using Color objects.
• The BooleanCondition class now has two new methods that retrieve the color of the condition's background and font as Color objects.
• The ConditionalFormatRuleBuilder class now has seven new methods that set color-based format rules using Color objects.
• The GradientCondition class now has three new methods that retrieve condition colors as Color objects.
• The Range class now has eight new methods that get and set font and background colors using Color objects.
• The Sheet class now has two new methods that get and set tab colors using Color objects.
• The Slicer class now has two new methods that get and set the background color of the slicer using Color objects.
• The TextStyleBuilder class now has a TextStyleBuilder.setForegroundColorObject(color) method that updates the foreground color of the style builder using a Color object.
• The TextStyle class now has a TextStyle.getForegroundColorObject() method that gets the foreground color of the style as a Color object.

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

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

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

• The Card service has been extended with the following classes and methods that provide new widgets and event responses:

  • CalendarEventActionResponse
  • CalendarEventActionResponseBuilder
  • DatePicker
  • DateTimePicker
  • DisplayStyle
  • DriveItemsSelectedActionResponse
  • DriveItemsSelectedActionResponseBuilder
  • FixedFooter
  • SwitchControlType
  • TimePicker
  • CardBuilder.setDisplayStyle(displayStyle)
  • CardBuilder.setFixedFooter(fixedFooter)
  • CardBuilder.setPeekCardHeader(peekCardHeader)
  • CardService.newCalendarEventActionResponseBuilder()
  • CardService.newDatePicker()
  • CardService.newDateTimePicker()
  • CardService.newDriveItemsSelectedActionResponseBuilder()
  • CardService.newFixedFooter()
  • CardService.newTimePicker()
  • Switch.setControlType(controlType)

The Conference Data service has been added to Apps Script. The service helps G Suite Add-ons that extend Google Calendar to stay in sync with third-party conferencing applications. This service is only useful to developers who manage a conferencing application and want to make it available in Google Calendar.

The Spreadsheet service has been extended with the following class and new methods to support using color building and theme colors:

• Color