Tag Archives: Google Apps Script

Granular OAuth consent in Google Apps Script IDE executions

What’s changing

Google 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.
This screenshot shows the new OAuth consent screen, which lets the user provide consent for a subset of the requested OAuth scopes.


Additional details

To 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 


Availability 

  • Available to all Google Workspace customers and Workspace Individual Subscribers

Resources


Google Workspace Updates Weekly Recap – August 2, 2024

3 New updates

Unless 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 Sheets
Following 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.
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.

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

Use spaces in table names
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: 
Scheduled Release Domains: 
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. 

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

What’s changing

We’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 

Availability 

  • Available to all Google Workspace customers 

Resources

Google Workspace Updates Weekly Recap – March 15, 2024

4 New updates

Unless 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
We’ve added a number input next to all slider controls used for image and shape adjustments in Google Docs, Slides and Drawings. With this update, we hope it is easier for you to make adjustments more precisely. | Rolling out to Rapid Release domains now; launch to Scheduled Release domains planned for April 2, 2024. | Available to Google Workspace customers, Google Workspace Individual subscribers, and users with personal Google accounts. | Learn more about cropping and adjusting images.

Updated version history limits for Apps Script projects
Earlier 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: 
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

4 New updates

Unless 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 Drawings We’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. 
dropdown options on the sharing button

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.
Using functions in Connected Sheets for BigQuery


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.


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

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


Availability

  • Available to Google Workspace customers
  • Available to users with a personal Google account

Resources


Google Workspace Updates Weekly Recap – 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 Sites
In 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).

Google Workspace Updates Weekly Recap – 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 Sites
In 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

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 



Rollout pace 



Availability 

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

Resources 

Getting started is the hardest part: Find inspiration with Apps Script samples

Posted by Kara Ireland, Technical Writer & Charles Maxson, Developer Advocate

Google Apps Script is a hosted JavaScript development environment that makes it easy for anyone to build custom business solutions across several Google products. Figuring out where to begin can be a hurdle for such an expansive tool, so we've recently released 10 new inspirational sample solutions to help you get started. These additions bolster the Apps Script documentation, which now hosts more than 30 sample solutions.

Apps Script welcomes developers of all skill levels, from beginners to professionals. We’re consistently impressed with the creative and innovative ways developers have automated business processes with Apps Script–from published add-ons that help millions of users to simple automations that help small teams do big things. People all over the world use Apps Script to make work easier in ways we never could have imagined.

If you’re new to Apps Script, or simply looking for new ideas, we invite you to check out the sample solutions in our documentation.

Here are a few use cases our newest sample solutions address:

Summarize data from multiple sheets

Apps Script project type: Custom function

Coding level: Beginner

Custom functions can reduce spreadsheet complexity by replacing numerous built-in Sheets functions. If you have similarly structured data on multiple sheets in a spreadsheet, you can use this custom function to create a summary of each sheet.

You’ll learn how to programmatically:

  • Iterate through sheets in a spreadsheet to perform custom calculations.
  • Exclude specific sheets from your calculations.
  • Process spreadsheet data using optimized array objects.

Try this solution >>

Upload files to Google Drive from Google Forms

Project type: Automation with an event-driven trigger

Coding level: Beginner

Automations can programmatically perform tasks across Google products and can be set in motion by custom menus, buttons, user actions, or a time-based schedule. Use this automation to simultaneously upload and organize files in Drive using Forms. The customizable sample form includes inputs for the files to upload and how to organize them.

You’ll learn how to programmatically:

  • Implement a trigger to run a script with every form submission.
  • Capture and process user inputs from a form.
  • Organize uploaded files within Drive.

Try this solution >>

Clean up data in a spreadsheet

Project type: Editor Add-on

Coding level: Intermediate

Editor Add-ons are highly customizable and can automate common tasks in Google Docs, Sheets, Slides, or Forms. With this add-on, you can clean up spreadsheet data in Sheets by automatically removing empty rows and columns, cropping the spreadsheet to the edges of the data range, and filling in gaps in the data.

You’ll learn how to programmatically:

  • Use arrays to efficiently identify and delete empty rows and columns.
  • Fill in data gaps without overwriting non-empty cells.
  • Build an Editor Add-on menu that displays under the Extensions menu in Sheets.

Try this solution >>

Schedule meetings from Google Chat

Project type: Google Chat app

Coding level: Intermediate

Google Chap apps provide a conversational interface that lets Chat users interact with services as if the service were a person. Use this Chat app to schedule a meeting in Google Calendar from within a direct message or a space in Chat. You can set specific details for the meeting, such as subject, start time, or duration, or use the default settings for instant meeting scheduling.

You’ll learn how to programmatically:

  • Send a response when a Chat app is messaged or added to a space.
  • Gather user inputs with a custom dialog.
  • Add a new Calendar event and respond in Chat with the event URL.

Try this solution >>

Copy macros to other spreadsheets

Project type: Google Workspace Add-on
Coding level: Intermediate

Google Workspace Add-ons offer a standardized user interface and can be used across several Google Workspace applications. With this add-on, you can automatically copy a script project and attach it to a specified spreadsheet. Though this add-on focuses on Sheets macros, you can use it to copy and share any container-bound script.

You’ll learn how to programmatically:

  • Create a card-based interface for a Google Workspace Add-on.
  • Copy files from a container-bound Apps Script project.
  • Create a new container-bound Apps Script project and add the copied files.

Try this solution >>

Find more samples and connect with us

The above is just a sampling (pun intended) of the solutions we’ve built for our developer community. To get inspired for your next Apps Script project, view all the sample solutions in our documentation. Also, check out the latest feature updates of the Apps Script IDE to help you build quickly and easily.

We’d love to know what you think. To give feedback on a sample, at the top of the documentation page, click Send feedback. For more updates and news about the Google Workspace Platform, subscribe to our developer newsletter.