Google Workspace Updates: Google Apps Script

Granular OAuth consent in Google Apps Script IDE executions

Wednesday, January 8, 2025

What’s changingGoogle offers a wide variety of APIs that Google Apps Script developers can use to build features for Google users. The data access that these APIs can reference is governed by the OAuth scopes of each Workspace application, which users are required to authorize before a script can run. Historically, the OAuth consent screen has asked the user to authorize all of the necessary OAuth scopes to run a given script.

This screenshot shows the current OAuth consent screen, which requires the user to authenticate all or none of the requested OAuth scopes.

This screenshot shows the old OAuth consent screen, which requires the user to authenticate all or none of the requested OAuth scopes.

Starting today, the OAuth consent screen will now let users specify which individual OAuth scopes they would like to authorize. For example, if a script requests access to a user’s Sheets and Forms files, and the users only intends to use the script with Sheets files, they can decide to only allow access to their spreadsheets and not their forms. This affords users the benefit of more granular control over what data their 3P applications are allowed to access.

This screenshot shows the new OAuth consent screen, which lets the user provide consent for a subset of the requested OAuth scopes.

Additional detailsTo complement the release of this new consent flow, we’re also adding methods to the ScriptApp and AuthorizationInfo classes that let Apps Script developers programmatically interact with the scopes granted for a script. Refer to the developer documentation for more information.
After a user grants permission to a script, Apps Script might request OAuth consent again in the following cases:

The user, who has granted consent to a subset of the requested OAuth scopes, tries to run a part of the script that was not previously authorized.
The script is updated in such a way that it requires permission for additional scopes.
The user revoked access to the script from their Google Account settings.

All past execution failures will be logged in the execution history. Each OAuth failure will contain a hyperlink that users can use to provide the permissions that were missing.

Getting Started

Admins: There is no admin control for this feature.
Developers and end users:

Granular OAuth consent is only available for scripts that have finished migrating to the V8 runtime. If you would like to utilize granular consent on one of the few remaining Rhino scripts, you can manually migrate to V8 by following these instructions.
This new consent screen will only be used for new OAuth scope grants. Pre-existing scope grants will not be affected, so no action is required by users on scripts they’ve already authorized.
The new consent screen will be launched first to the Apps Script IDE (i.e. executing a script directly from Apps Script). The consent screen will launch to the remaining surfaces in the future:

Google Ads Script
Macro executions
Trigger executions
Web app executions
API Executions
Chat apps
Add-ons

Rollout pace

Rapid Release and Scheduled Release domains: Extended rollout (potentially longer than 15 days for feature visibility) starting on January 8, 2025, with expected completion by January 24, 2025

Availability

Available to all Google Workspace customers and Workspace Individual Subscribers

Resources

Developer Documentation: Migrating scripts to the V8 runtime

Developer Documentation: Class ScriptApp

Google Workspace Updates Weekly Recap - August 2, 2024

Friday, August 2, 2024

3 New updatesUnless otherwise indicated, the features below are available to all Google Workspace customers, and are fully launched or in the process of rolling out. Rollouts should take no more than 15 business days to complete if launching to both Rapid and Scheduled Release at the same time. If not, each stage of rollout should take no more than 15 business days to complete.
More granular control for Google Apps Script

We’re introducing a new toggle in the Admin console that adds controls for who can access and execute Google Apps Script scripts.

Users who have Apps Script turned on can use it to create, edit, and execute Apps Script scripts.
When disabled, end users can’t create or edit scripts and script and trigger executions are blocked.

By default, Apps Script is turned on for all users in an organization. To change this setting, navigate to the Admin console > Apps > Google Workspace > Drive and Docs > Google Apps Script. This setting will not take effect if the entire Drive and Docs Service is turned OFF. | Rolling out now to Rapid Release and Scheduled Release domains. | Available to Google Workspace customers. | Learn more about turning Apps Script on or off for users.

Improving tables in Google SheetsFollowing our announcement of tables in Google Sheets, we’re excited to introduce improvements to the experience. More specifically, you can now:
1. Add table rows (anywhere in a table) and columns (to the right of a table) from an easy button at the edge of a table.

Add table rows and columns from an easy button at the edge of a table.

2. Automatically set column types when converting a range to a table.

3. Drag values down or across to auto-fill cells, which expands the table automatically.

4. Use spaces in table names, meaning you can name something “Project tracker” instead of “Project_tracker”.

Rollout to Rapid Release domains for #2 is complete; launch to Scheduled Release domains planned for August 5, 2024. | Rolling out to Rapid Release domains now for #1, #3 and #4; launch to Scheduled Release domains planned for August 14, 2024. | Available to all Google Workspace customers, Workspace Individual Subscribers, and users with personal Google accounts. | Visit the Help Center to learn more about using tables in Google Sheets.

Google Meet annotation updates for mobile devices

Earlier this year, we announced annotations for Google Meet, which made it possible for presenters and their appointed co-annotators to highlight content or make other notations over presented content. Beginning today, Android users can appoint co-annotators. Previously on Android devices, it was only possible for presenters to use annotations. | Rolling out now to Rapid Release and Scheduled Release domains. | Available to Google Workspace Business Starter, Standard, and Plus; Enterprise Starter, Standard, and Plus; Frontline Starter and Standard; Essentials, Enterprise Essentials, and Enterprise Essentials Plus; Education Standard, Plus, the Teaching & Learning Upgrade; Workspace Individual subscribers. | Visit the Help Center to learn more about using annotations in Google Meet.

Previous announcements

The announcements below were published on the Workspace Updates blog earlier this week. Please refer to the original blog posts for complete details.

Catch up on followed threads from the home shortcut in Google Chat

We’re introducing the ability to follow and review threads within the home shortcut in Chat. | Learn more about threads in home.

Gemini in the side panel of Google Drive introduces a new PDF viewing experience

You can now interact with the Gemini side panel while viewing PDFs. | Learn more about PDF viewing with Gemini.

Allowlist and Audit Logs for URLs accessed from Google Apps Script and Google Sheets

Admins can now monitor which URLs are being accessed by referencing new logs that we’re adding to the audit and investigation page. Admins can then create an allowlist that controls which of those URLs they’d like to enable/disable. | Learn more about accessed URLs.

Prevent downloading, printing, or copying files by combining Data Loss Prevention rules with Context-Aware Access conditions

Today, we’re expanding protections by enabling admins to combine DLP rules with Context-Aware Access conditions. | Learn more about combining rules and conditions.

Admins can now centrally set default grading settings for teachers in their district

Classroom admins can now centrally set default grading settings for teachers in their district using the Admin console. | Learn more about default grading settings.

Educators can now create new classes in Google Classroom using SIS data and import grading periods from the SIS

Teachers can now create new classes by importing information such as student rosters, co-teachers, grading categories, and grading periods from their SIS. Also, teachers can now import their grading periods from their student information systems (SIS) into Classroom. | Learn more about new SIS capabilities.

Completed rollouts

The features below completed their rollouts to Rapid Release domains, Scheduled Release domains, or both. Please refer to the original blog posts for additional details.

Rapid Release Domains:

Adding Data Loss Prevention (DLP) to form content in Google Forms

Scheduled Release Domains:

Enhancing the Google Calendar appointment scheduling experience with additional features

Rapid and Scheduled Release Domains:

Paused rollouts

We have paused the rollout for this feature while we evaluate performance and quality. We will provide an update with new rollout information as soon as possible.

Enhancing your productivity on Android devices with new features in Gmail and Google Chat apps

For a recap of announcements in the past six months, check out What’s new in Google Workspace (recent releases).

Allowlist and Audit Logs for URLs accessed from Google Apps Script and Google Sheets

Wednesday, July 31, 2024

What’s changingWe’re introducing a feature that will allow admins to restrict which URLs Apps Scripts and Sheets can source external content from. More specifically, admins can now monitor which URLs are being accessed by referencing new logs that we’re adding to the audit and investigation page. Admins can then create an allowlist that controls which of those URLs they’d like to enable/disable.

When such an allowlist is specified, users in the organization will only be able to use those allowlisted URLs for both their Apps Scripts and their Sheets IMPORT functions. This allows organizations to more granularly control access in a way that better aligns with a Zero Trust security posture.

Who’s impacted Admins and end users

Why it’s important Data exfiltration is an important security concern for admins, especially when it comes to Apps Scripts and Sheets because certain functions are capable of accessing external data. With this update, admins have more granular control over URLs accessed by users in their organization.

Getting started

Admins:

Logs can be found under Reporting > Audit and investigation > Drive Log Events OR Security > Security Center > Investigation Tool.
The URL allowlists can be found in the Admin console under Apps > Google Workspace > Drive and Docs > Features and Applications > Importing and fetching from URLs.

If an allowlist is not established, no URLs will be restricted.

Visit the Help Center to learn more about Drive log events.

End users: There is no end user setting for this feature.

Rollout pace

Rapid Release and Scheduled Release domains: Gradual rollout (up to 15 days for feature visibility) starting on July 31, 2024

Availability

Available for Google Workspace:

Business Plus
Enterprise Standard, Plus
Enterprise Essentials Plus
Education Standard, Plus

Resources

Google Workspace Admin Help: Drive log events

Google Workspace Updates Weekly Recap - March 15, 2024

Friday, March 15, 2024

4 New updatesUnless otherwise indicated, the features below are available to all Google Workspace customers, and are fully launched or in the process of rolling out. Rollouts should take no more than 15 business days to complete if launching to both Rapid and Scheduled Release at the same time. If not, each stage of rollout should take no more than 15 business days to complete.
Banner alerts for Google Drive item capacity limits in shared drives
To give users more visibility when shared drives in their domain are approaching the item capacity limit (400,000 items), we’re introducing banner alerts that identify current shared drive capacity. These banners will be visible when less than 20% capacity is left and will appear only for users who have edit access to add content to the specific shared drive. | Rolling out to Rapid Release domains now; launch to Scheduled Release domains planned for April 3, 2024. | Available to Google Workspace Business Standard, Business Plus, Essentials Starter, Enterprise Essentials, Enterprise Essentials Plus, Enterprise Standard, Enterprise Plus, Education Fundamentals, Education Standard, Education Plus, the Teaching and Learning Upgrade, and Nonprofits. | Learn more about item capacity limits in shared drives.
Input numbers into slider controls across Google Docs, Slides and Drawings Rapid Release domainsScheduled Release domainscropping and adjusting images.

Updated version history limits for Apps Script projectsEarlier this year, we announced that you can create and save up to 200 versions for newly created scripts. We’ve expanded this limit to all scripts. If needed, you can permanently delete multiple script versions at the same time from the project history page using the new “Bulk delete” feature. | This is available now to all Google Workspace customers, Google Workspace Individual subscribers, and users with personal Google accounts. | Learn more using our developer documentation on working with Apps Script versions.

Google Meet-certified Logitech Rally Bar Huddle room kits are now available
Logitech Rally Bar Huddle room kits for Google Meet are now available for purchase. These kits are optimized for small spaces that can accommodate 3 to 5 people. The device can be used as a meeting room appliance, in USB mode connected to a meeting room PC, or connected via laptop. | This is available now to all Google Workspace customers with Google Meet hardware devices. | Visit Logitech’s website for more information on purchasing a room kit.

Google Meet-certified Logitech Rally Bar Huddle room kits are now available

Previous announcements

The announcements below were published on the Workspace Updates blog earlier this week. Please refer to the original blog posts for complete details.

Application load failures are now captured for the Google Meet hardware devices

Admins can now see when the Google Meet app fails to load for a device. | Learn more about application load failures.

Create fully customized email campaigns using new layout editor tool

Starting this week, even more users across Google Workspace editions can now create customized email layouts using a new email layout editor that is accessible from the compose screen in Gmail or Google Drive. In the layout editor, you can create a new email layout from scratch or select from a predefined set of email templates, which include images, text elements and buttons. | Available to Workspace Business Standard, Business Plus, Enterprise Standard, Enterprise Plus, Education Standard, Education Plus and Workspace Individual subscribers only. | Learn more about customizable email campaigns.

Select App Access Controls can now be applied at the organizational unit

Google Workspace Admins can now configure a number of App Access Control (AAC) policies at the Organizational Unit (OU) level. | Learn more about App Access Controls.

Import data from other messaging platforms using the Google Chat API is now generally available

Google Workspace developers registered in our Workspace Developer Preview program have been able to import user data from other messaging platforms into Google Chat using the Google Chat APIs. This functionality is now generally available to all Workspace developers and admins. | Learn more about importing data using the Chat API.

Subtly enhance your appearance with portrait touch-up when using Google Meet on the web

In October 2023, we introduced portrait touch-up for Google Meet on mobile devices. We’re extending this functionality to Google Meet on the web. Portrait touch-up can be used to lightly touch up your appearance before or during a meeting, helping you feel more comfortable and confident in your appearance during video calls. | Available to Business Standard, Business Plus, Enterprise Essentials, Enterprise Starter, Enterprise Standard, Enterprise Plus, Education Plus, Teaching & Learning Upgrade, Google One and Google Workspace Individual subscribers only. | Learn more about subtly enhancing your appearance with portrait touch-up.

Completed rollouts

The features below completed their rollouts to Rapid Release domains, Scheduled Release domains, or both. Please refer to the original blog posts for additional details.

Rapid Release Domains:

New formatting sidebar in Google Docs, Slides and Sheets apps on Android Tablets (Docs and Slides only)

Scheduled Release Domains:

Rapid and Scheduled Release Domains:

For a recap of announcements in the past six months, check out What’s new in Google Workspace (recent releases).

Google Workspace Updates Weekly Recap - January 12, 2024

Friday, January 12, 2024

4 New updatesUnless otherwise indicated, the features below are available to all Google Workspace customers, and are fully launched or in the process of rolling out. Rollouts should take no more than 15 business days to complete if launching to both Rapid and Scheduled Release at the same time. If not, each stage of rollout should take no more than 15 business days to complete.
Version history limits for Apps Script projects For all new scripts, you’ll be able to create and save up to 200 versions of your script. If needed, you can permanently delete a script version from the project history page. | This is available now to all Google Workspace customers. | Learn more using our developer documentation on working with Apps Script versions.

Share a link to a specific time in a Google Drive video We’re adding new functionality to the Drive sharing button that lets you share timestamped links to specific parts of a video. On web, simply navigate to drive.google.com > find and open a video file > play the video (you can pause the playback before performing the following steps) > select the dropdown on the “Share” button in the top-right corner > select “Copy link to this time” > send the link. | Rolling out now to Rapid Release and Scheduled Release domains. | Available to all Google Workspace customers and users with personal Google Accounts. | Learn more about copying a specific time in the video.

Share a link to a specific time in a Google Drive video

Introducing dropdown options on the sharing button in Google Docs, Sheets, Slides and DrawingsWe’re adding a new feature that ensures a seamless sharing experience across Workspace. In Google Docs, Sheets, Slides and Drawings, you will now see a dropdown on the Share button that surfaces quick actions, such as pending access requests and the “Copy link” option. | Rolling out now to Rapid Release and Scheduled Release domains. | Available to all Google Workspace customers and users with personal Google Accounts.

Using functions in Connected Sheets for BigQuery Today, Connected Sheets for BigQuery supports 23 Sheets functions, such as AVERAGE and XLOOKUP. However, all of these functions behave somewhat differently than their native counterparts. Thus, to help Connected Sheets users write better functions, we now display context-aware Help Center content in Sheets. The ‘formula help’ shows descriptions for Connected Sheets functions when writing a formula that would query BigQuery, and otherwise shows descriptions of native Sheets functions. | This is available now to all Google Workspace customers and users with personal Google Accounts. | Learn more about the XLOOKUP function.

Previous announcementsThe announcements below were published on the Workspace Updates blog earlier this week. Please refer to the original blog posts for complete details.

Updates to metrics in Google Drive Apps Reports and Reports API We’re making some updates to the Google Drive metrics in the Admin Console Apps reports and the Reports API. As a result of these improvements, admins who analyze metrics will have more reporting clarity and can better understand activity trends within their domain. | Learn more about metrics in Drive Apps Reports and Reports API.

Easily share Google Drive files to Google Calendar meeting attendees

We’re introducing the option to share any file with all meeting participants on a Google Calendar invite via the sharing dialog within a file. | Learn more about sharing Drive files to Calendar.

Google Meet is now available on Logitech Android appliances

Google Meet is now supported on Logitech’s Rally Bar and Rally Bar Mini Android-based appliances for collaboration rooms and spaces of just about any size. After initial setup, admins can easily enroll, manage, and monitor these devices using the Google admin console. Google Meet on Logitech Android-based devices is supported on CollabOS v1.11 as a video conferencing provider | Learn more about Meet on Logitech Android appliances.

Google Meet hardware devices from Poly now support interoperability with Cisco Webex and Zoom

We’re expanding the existing interoperability between Google Meet, Cisco Webex, and Zoom to include Android-based Meet hardware devices from Poly. Specifically, these devices include: Poly Studio X30, X50, X52, and X70. | Learn more about support interoperability with Cisco Webex and Zoom.

Extending Trusted Types to Gmail

We’re excited to announce the expansion of Trusted Types to Gmail. This will provide a defense against DOM XSS and further enhances our advanced data protection controls to keep users and data safe across more of the apps they use everyday. | Learn more about Trusted Types.

Completed rollouts

The features below completed their rollouts to Rapid Release domains, Scheduled Release domains, or both. Please refer to the original blog posts for additional details.

Rapid Release Domains:

Scheduled Release Domains:

Rapid and Scheduled Release Domains:

For a recap of announcements in the past six months, check out What’s new in Google Workspace (recent releases).

View & compare script versions with Apps Script project history

Wednesday, August 23, 2023

What’s changing As we continue to improve the experience for Apps Script developers, today we're announcing project history, a new interface for developers to view previously deployed script versions and compare versions to the current script version.

Developers can use project history to view the code of previously deployed script versions. The highlight changes can be used to quickly compare differences between their selected version and the current, or head, version, taking the guesswork out of determining what's changed. Anyone who has edit permission on an Apps Script project can access project history. To navigate to the project history page, open an Apps Script project and click Project History.

The project history page displays up to 200 previously deployed versions and the head version of the script.

To compare a version to the head version, turn on Highlight changes.

Additional improvements for script versions will be made in the coming weeks.

Who’s impacted

Developers

Why it’s important

Apps Script is a low-code development platform that makes it quick and easy to build business solutions that integrate, automate, and extend Google Workspace. With Apps Script, Google Workspace users can customize workflows, create automations, and build integrations that connect the applications they use every day.

Getting Started

Developers: Use our developer documentation to learn more about working with Apps Script and watch the video below to see project history in action:

Anyone who has edit permission on an Apps Script project can access project history. To navigate to the project history page, open an Apps Script project and click Project History.

Rollout

Rapid Release and Scheduled Release domains: Gradual rollout (up to 15 days for feature visibility) starting on August 23, 2023

Availability

Available to all Google Workspace customers and users with personal Google accounts

Resources

Google Workspace Updates Weekly Recap - September 23, 2022

Friday, September 23, 2022

New updates
There are no new updates to share this week. Please see below for a recap of published announcements.

Previous announcements

The announcements below were published on the Workspace Updates blog earlier this week. Please refer to the original blog posts for complete details.

Introducing new spacing feature on Google SitesIn addition to adjusting the spacing between content in Sites using a new density theme setting, you're now able to use spacers to add empty space to your Sites in specific places. | Learn more.

Updated Apps Script integrated development environment will replace the legacy experience by Q4 2022 By the end of Q3 2022, we will begin turning down the legacy experience. Beginning Q4 2022, the new IDE will become the default experience with no option to revert. | Learn more.

For a recap of announcements in the past six months, check out What’s new in Google Workspace (recent releases).

Updated Apps Script integrated development environment will replace the legacy experience by Q4 2022

Wednesday, September 21, 2022

What’s changing In December 2020, we announced an updated and improved experience for the Apps Script integrated development environment (IDE). Since then, it has been possible to access the legacy IDE. By the end of Q3 2022, we will begin turning down the legacy experience. Beginning Q4 2022, the new IDE will become the default experience with no option to revert.

Who’s impacted Admins and developers

Why it’s important Apps Script is a rapid application development platform that makes it fast and easy to create custom business solutions that integrate with Google Workspace and that increase the power of apps including Calendar, Docs, Drive, Gmail, Sheets, and Slides. With this launch, we’ve revamped the cloud-based IDE that helps you create, edit, and manage projects. The new IDE simplifies the experience of developing for Google Workspace — for more information, see our original announcement, as well as additional features we announced in April 2022 to reach parity with the legacy experience.

Getting started

Admins and Developers: Use our developer documentation to learn more about working with Apps Script.

Rollout pace

Rapid Release and Scheduled Release domains: Beginning Q4 2022, the new IDE will become the default experience with no option to revert back.

Availability

Available to Google Workspace customers, as well as legacy G Suite Basic and Business customers

Resources

Build custom, integrated solutions across Google Workspace with the new AppSheet Apps Script connector

Wednesday, April 13, 2022

What’s changing We’re introducing a new AppSheet and Apps Script connector which allows you to extend custom, no-code apps to integrate and automate workflows across Google Workspace.

The Apps Script Connector will be available for users in the AppSheet Core plan and above, which is available to users of the Google Workspace Enterprise edition. Users in the AppSheet Starter plan can test the feature. Learn more from AppSheet documentation.

Who’s impacted Admins, end users, and developers

Why it matters AppSheet is Google’s platform for building no-code custom apps and workflows to automate business processes. AppSheet works well with mixed data sources, even if customer data is stored across Sheets, CloudSQL, or on-premise databases.

Apps Script is Google’s hosted JavaScript platform that makes it easy to build solutions that integrate, automate, and extend Google Workspace. Apps Script is integrated with Google Workspace APIs and includes native integrations to Google services such as YouTube, Google Analytics, and BigQuery.

You can use the AppSheet Apps Script connector to extend custom no-code apps to integrate and automate workflows across Google Workspace. This is useful in a variety of scenarios, such as use cases in the retail, manufacturing or public sector. For example, you could use the connector with your AppSheet app to:

Receive employee travel requests via the web, and when a request is made, it can look up the requestor’s manager and send a chat or email notification for approval.
Allow workers to capture photos from their mobile device for on-site inspections, and upload images and media to Google Drive and adjust Drive sharing settings to ensure auditors have access.
Manage shift schedules and appointments through a simple web interface, and when a time slot is booked, create an event on Google Calendar with the requestor invited.

Getting started

Rollout pace

Rapid and Scheduled Release domains: Full rollout (1–3 days for feature visibility) starting on April 13, 2022

Availability

The Apps Script Connector will be available for users in the AppSheet Core plan and above (available to Google Workspace Enterprise, see AppSheet pricing). Users in the Starter plan can test the feature.

Resources

Additional functionality for the Apps Script Integrated Development Environment (IDE) Script Editor

Wednesday, April 13, 2022

What’s changing In December 2020, we announced a redesign of the Integrated Development Environment (IDE) for Google Apps Script. The modern and simplified development experience makes it quicker and easier to build solutions that make Google Workspace apps more useful for your organization.

We’re now adding several new features to the IDE to help achieve functional parity with the legacy IDE experience. These features are:

Script Properties
Add-on Testing
Time Zone Setting
Rhino Debugging

See below for more information.

Who’s impacted Admins and developers

Why it’s important Apps Script is a rapid application development platform that makes it fast and easy to create custom business solutions that integrate with Google Workspace and that increase the power of apps including Calendar, Docs, Drive, Gmail, Sheets, and Slides. For more information, see the original announcement on the Workspace Updates Blog.

This launch ensures Apps Script users can utilize the legacy features in the new environment:

Script Properties: Allows you to store simple data in key-value pairs scoped to one script. Script properties are typically used to store developer configuration data. The new IDE has now integrated the interface to edit, delete and create up to 50 new script properties.
Add-on Testing: Allows add-on developers to test their add-ons before publishing them broadly.
Time Zone Setting: Allows you to update the time zone of the script and its executions.
Rhino Debugging: Adds the ability to debug Rhino subroutines on V8 debugger, without migrating to V8. If the code is not V8 compatible, users will get a warning message.

We hope these additional features empower you to create solutions and integrations for Google Workspace applications faster and easier.

Getting started

Admins and developers: This feature will be ON by default for all users using the new IDE experience. Use our developer documentation to learn more about working with Apps Script, setting a time zone for a project, adding script properties, testing add-ons, and using the debugger.

Rollout pace

Rapid Release and Scheduled Release domains: Gradual rollout (up to 15 days for feature visibility) starting on April 13, 2022

Availability

Available to Google Workspace Essentials, Business Starter, Business Standard, Business Plus, Enterprise Essentials, Enterprise Standard, and Enterprise Plus, as well as G Suite Basic, Business, Education, Enterprise for Education, and Nonprofits customers

Resources

Use the new Apps Script Integrated Development Environment (IDE) Script Editor

Monday, December 7, 2020

UpdateThis post has been updated to reflect a change in rollout pace. It is now an extended rollout (longer than 15 days for feature visibility), which we expect to complete in January 2021. We previously stated it would be a gradual rollout (up to 15 days for feature visibility) starting on December 7, 2020.

What’s changing We’ve redesigned the Integrated Development Environment (IDE) for Google Apps Script. The new IDE offers a more modern and simplified development experience which makes it quicker and easier to build solutions that make Google Workspace apps more useful for your organization.
You can learn more about these improvements in this video from our Next OnAir session earlier this year.

Who’s impacted Developers

Why it’s important Apps Script is a rapid application development platform that makes it fast and easy to create custom business solutions that integrate with Google Workspace and that increase the power of apps including Calendar, Docs, Drive, Gmail, Sheets, and Slides. With this launch, we’ve revamped the cloud-based IDE that helps you create, edit, and manage projects. The new IDE simplifies the experience of developing for Google Workspace and offers:

Getting started

Admins and developers: This feature will be ON by default for all users. However, users can opt out to use the legacy IDE by clicking on “Use legacy editor” in the toolbar next to the Execution log button. Use our developer documentation to learn more about working with Apps Script.

New Apps Script IDE

Improved code editing experience

Rollout pace

Rapid Release and Scheduled Release domains: Extended rollout (potentially longer than 15 days for feature visibility) starting on December 7, 2020.

Availability

Available to Google Workspace Essentials, Business Starter, Business Standard, Business Plus, Enterprise Essentials, Enterprise Standard, and Enterprise Plus, as well as G Suite Basic, Business, Education, Enterprise for Education, and Nonprofits customers

Resources

Google Developers: Apps Script overview
Google Next OnAir: Apps Script updates

Roadmap

This feature was listed as an upcoming release.

Automate and expand Connected Sheets updates with new APIs, connections, and capabilities

Wednesday, August 26, 2020

What’s changing We recently launched Connected Sheets, which connects Google Sheets and BigQuery to help you analyze large datasets using familiar spreadsheet tools. We’re now adding support for macros and APIs to help you automate tasks, as well as providing mobile access. Specifically, you can now use Connected Sheets with:

Sheets Macro Recorder, to record Apps Script scripts and automate daily tasks.
Apps Script and the Sheets API, to develop extensions, add-ons, and applications.
Sheets mobile apps, to view Connected Sheets on Android and iOS.

Who’s impacted Developers and end users

Why you’d use it
Sheets Macro recorder You can use the macro recorder to record when to create, edit, delete, and refresh Connected Sheets objects. This generates macros which you can then directly run in Sheets to refresh the data. This can automate common tasks, saving time and reducing errors.
Apps Script and Sheets API You can use these APIs to write scripts and applications that automate tasks. For example, you can automate CRUD functions for Connected Sheets objects, including sheets, formulas, pivot tables, and extracts. Additionally, you can use the APIs to refresh these objects, as well as to refresh charts.
Mobile app support You can now view Connected Sheets on mobile devices. You can also copy and paste data from Connected Sheets using the mobile apps. At this stage, you can’t create, edit, or refresh data in Connected Sheets on mobile.

Getting started

Rollout pace

Rapid and Scheduled Release domains:

Sheets Macro recorder: Gradual rollout (up to 15 days for feature visibility) starting on August 26, 2020.
Apps Script: Available now for all users.
Sheets API: Available in September.
Android app: Gradual rollout (up top 15 days for feature visibility) starting on August 17, 2020. To get access, update to the latest version of the Sheets Android app.
iOS app: Gradual rollout (up top 15 days for feature visibility) starting on August 24, 2020. To get access, update to the latest version of the Sheets iOS app.

Availability

Connected Sheets is available to G Suite Enterprise, G Suite Enterprise for Education, and G Suite Enterprise Essentials customers
Connected Sheets is not available to G Suite Basic, G Suite Business, G Suite for Education, G Suite for Nonprofits, and G Suite Essentials customers

Resources

More admin control over Apps Script projects with Google Cloud Console management

Thursday, May 16, 2019

What’s changing

We’re changing how Apps Script manages Google Cloud Platform (GCP) projects. This will help IT Admins govern these projects and simplify how developers manage projects as well. New Apps Script GCP projects will now live in a new folder (“apps-script”) in the GCP resource hierarchy. This means that new Apps Script projects will be governed by organization policies defined for GCP projects by IT admins.

Who’s impacted

Admins, Apps Script developers, and end-users of Apps Script projects

Why you’d use it

How to get started

Additional details

When an Apps Script project is created, a GCP project is also created and associated with it. This GCP project controls a range of configurations and settings, including API access, G Suite Marketplace API configuration for publishing add-ons, access to Stackdriver logs, and more.

Previously, these GCP Apps Script projects existed outside of the resource hierarchy. Now, new Apps Script projects will be parented by a new “apps-script” folder in the resource hierarchy, specifically at organization root > system-gsuite (new) > apps-script (new).

This means they will be governed by organization policies, which give you centralized and programmatic control over your organization's cloud resources. Policies that can be managed here include the ability to restrict domains that are allowed to be on the ACL for Cloud projects, specify restricted APIs that Cloud projects can access, and block GCP projects from creating new GCE instances.

Helpful links

Availability

Rollout details

G Suite editions

Available to all G Suite editions.

On/off by default?

This feature will be ON by default.

Stay up to date with G Suite launches

More control over which Apps Script projects can run in your organization

Thursday, August 2, 2018

You can already control the Apps Script projects that run in your organization using the G Suite API permissions settings located in the Admin console (at Security > API Permissions). Using these settings, you can block applications that request access to certain APIs—unless you’ve specifically whitelisted them. App Maker apps, add-ons, and scripts that request certain OAuth scopes (like Gmail, Calendar, Drive, etc.) are just some of the Apps Scripts projects that these settings control.

Now you can also control access to projects that request the following scopes:

Apps Script Runtime - Control access to projects that request certain high-risk scopes specific to Apps Script projects (e.g. UrlFetch, Container UI).
Apps Script API - Control access to any project (e.g. Apps Script, GCP, AWS, etc.) that requests scopes for Apps Script API (e.g. Manage Projects, Manage Deployments).

New G Suite API permissions in Admin console: Apps Script Runtime and Apps Script API

See the Help Center for instructions on whitelisting connected apps.

Launch Details
Release track:
Launching to both Rapid Release and Scheduled Release

Editions:
Available to all G Suite editions

Rollout pace:
Full rollout (1–3 days for feature visibility)

Impact:
Admins only

Action:
Admin action suggested/FYI

More Information
Help Center: Whitelisting connected apps

Launch release calendar
Launch detail categories
Get these product update alerts by email
Subscribe to the RSS feed of these updates

Google Apps Script and App Maker metrics now in the Admin console

Thursday, May 4, 2017

Apps Script lets you do more with Google, like create add-ons for Docs, develop custom functions for Sheets, and manage responses in Forms. Traditionally, G Suite admins have had little or no visibility into the extent of the Apps Script usage in their organizations. With this launch, however, admins will be able to view Apps Script metrics, including number of users and number of active projects, in the Aggregate reports section of the Admin console. Admins currently participating in the App Maker Early Adopter Program will see App Maker metrics listed as well.

For more details, please visit the Help Center.

Launch Details
Release track:
Launching to both Rapid release and Scheduled release

Editions:
Available to all G Suite editions

Rollout pace:
Gradual rollout (up to 15 days for feature visibility)

Impact:
Admins only

Action:
Admin action suggested/FYI

More Information
Help Center: Aggregate reports

Launch release calendar
Launch detail categories
Get these product update alerts by email
Subscribe to the RSS feed of these updates

Change to Mail Service in Apps Script

Wednesday, March 9, 2016

Posted by Saurabh Gupta, Product Manager, Google Apps Script

(Cross-posted on Google Apps Developer Blog)

There are two ways to send email in Apps Script: MailApp's sendEmail and GmailApp's sendEmail method. One of the differences between these two methods is that the MailApp’s sendEmail method doesn’t require the developer to be a Gmail user. For example, a Google Apps customer who doesn’t use Gmail, but uses Apps Script instead, can send emails through MailApp but not GmailApp.

Starting on September 13, 2016, users with free public Google Accounts (consumers) and Google Apps for Education and Google Apps Free edition users, will be required to have Gmail access to send messages through Apps Script’s Mail Service. Consumers can enable Gmail on their Google account after signing-in—note your Gmail will then become the primary address of your Google account. Administrators of Google Apps domains (Education and Free edition only) can use the Admin console to turn on Gmail for their domain.

This change does not require any updates to your code. You can continue to use MailApp as before; just make sure that you have signed up for Gmail. We realize that sometimes these changes are disruptive to our developers, but we can assure you that we put lot of care and deliberation into this process.

Launch release calendar
Launch detail categories
Get these product update alerts by email
Subscribe to the RSS feed of these updates

Useful Links

Join the official community for Google Workspace administrators

In the Google Cloud Community, connect with Googlers and other Google Workspace admins like yourself. Participate in product discussions, check out the Community Articles, and learn tips and tricks that will make your work and life easier. Be the first to know what's happening with Google Workspace.

______________

Learn about more Google Workspace launches

On the “What’s new in Google Workspace?” Help Center page, learn about new products and features launching in Google Workspace, including smaller changes that haven’t been announced on the Google Workspace Updates blog.

______________

Updates

Granular OAuth consent in Google Apps Script IDE executions

Google Workspace Updates Weekly Recap - August 2, 2024

Allowlist and Audit Logs for URLs accessed from Google Apps Script and Google Sheets

Google Workspace Updates Weekly Recap - March 15, 2024

Google Workspace Updates Weekly Recap - January 12, 2024

View & compare script versions with Apps Script project history

Google Workspace Updates Weekly Recap - September 23, 2022

Updated Apps Script integrated development environment will replace the legacy experience by Q4 2022

Build custom, integrated solutions across Google Workspace with the new AppSheet Apps Script connector

Additional functionality for the Apps Script Integrated Development Environment (IDE) Script Editor

Use the new Apps Script Integrated Development Environment (IDE) Script Editor

Automate and expand Connected Sheets updates with new APIs, connections, and capabilities

More admin control over Apps Script projects with Google Cloud Console management

More control over which Apps Script projects can run in your organization

Google Apps Script and App Maker metrics now in the Admin console

Change to Mail Service in Apps Script

Filter by product

Filter by date

Subscribe by feed

Subscribe by email

Localized Google Workspace Updates

Useful Links

Join the official community for Google Workspace administrators

Learn about more Google Workspace launches