You can read more about the script editor updates in this related Google Workspace Updates post, which provides more details of note is:
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.
Add custom integrations to your app using Apps Script. … You can use custom logic from within your AppSheet app by calling Apps Script from an AppSheet automation bot.
Examples of custom logic that you can implement include:
Create a calendar appointment when a button is clicked
Add a slide to a presentation when a new row is added
Save photos to Drive and share with specific individuals when uploaded using a form
Create an audit log by generating a Google Docs file with data from a table
Call an external service for machine learning prediction using data from a newly added row and write back model prediction
If you are not familiar with AppSheet it’s Google Cloud’s no-code platform that allows users to create custom applications that can be deployed across mobile and web, often setup using Google Sheets as a data source. AppSheet can be customised with workflows and automations, and those automations have recently been extended with a new preview integration to Google Apps Script. The video in the Call Apps Script from an automation page provides a great summary of how the Apps Script integration works.
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.
Google Workspace developers can now create Google Workspace add-ons that attach files to a Google Calendar event from any third-party service. This feature enables developers to create add-ons that support attachments from a wide range of sources beyond Google Drive, such as digital whiteboard, content creation, or file management tools.
The update includes the following additional guidance for developers:
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().
Check out the source link for details of which Spreadsheet Services have been updated.
For the first time, Google Forms has an API and we are going to show you how you can use it and what’s in it. The new Google Forms API joins the large family of APIs available to developers under the Google Workspace Platform. The Forms API provides programmatic access for managing forms, acting on responses, and empowering developers to build powerful integrations on top of Forms.
Some additional resources to support the general availability of the Google Forms API have been published. This post includes information on the key use cases which are supported by the API:
Automated form creation and editing: Enables automated form creation and editing. Enables rapid form generation from large volume question banks or other data backends.
Reaction to Form responses: The API also enables developers to build automations for acting on incoming responses. Examples include developing real-time dashboards or visualizations and triggering business workflows based on response data.
Given the existing widespread use of Google Forms in education it was nice for this to be acknowledged and also to see Automagical Forms getting mentioned.
The Google Forms API provides programmatic access for managing Google Forms and acting on responses— empowering developers to build powerful integrations on top of Forms.
Available to all Google Workspace customers, as well as legacy G Suite Basic and Business customers and users with personal Google Accounts
We’ve shared a couple of updates on the new Google Forms API previously here on Apps Script Pulse. The good news is the Forms API is now out of beta and available for testing and deployment. For Google Apps Script devs I’m sure you are thinking ‘but we can use the Forms Service?’ You can and likely in most instances to be the first port of call, but the new API brings some additional functionality not supported in Forms Service, in particular, a trigger when a Google Form is edited.
Google Cloud Innovator’s inaugural event, Innovators Hive is a virtual, global, and free event limited to 1,000 developers and practitioners. Organized for and with the Cloud community, it focuses on deep technical content presented by Champion Innovator and Google thought leaders and luminaries.
Google Cloud Innovators is a new program created by Google for anyone using Google Cloud to come together as a community to learn, share and collaborate:
You know Google Cloud. Now it’s time for Google Cloud to get to know you.
Join the program by claiming the Innovators Program badge on your developer profile. From the beginning, you will receive invitations to hear from Google Cloud executives and Developer Advocates, roadmap presentations, and a chance for an invitation to join our new series of Innovator community events.
We’re just getting started. We are working on customizing experiences across Google Cloud to incorporate your identity as an Innovator, and make your time with Cloud a more personal and collaborative journey.
As part of the Google Cloud Innovator program Google is hosting ‘Innovators Hive’, 29-30 March 2022. This is a free event where you can hear from Google and community contributors about the latest developments in Google Cloud. There isn’t a published programme yet but you can get a sense of what will be talked about from the featured speakers page.
A number of Google Workspace experts will be contributing sessions to Innovator Hive, many of whom we’ve featured regularly here in Apps Script Pulse, including:
Charles Maxson
Christian Schalk
Clay Smith
Adam Morris
Alice Keeler
Jasper Duizendstra
Scott Donald
Sourabh Choraria
There will be a couple of community meetups for folks who build solutions on Google Workspace or for folks who are curious about what the possibilities are. One of these will be a Totally Unscripted reunion where I’ll be joining Charles Maxson which will be an opportunity to ask a question or share your ideas about Workspace Development.
To join this event if not already a Google Cloud Innovator check out the Google Cloud Innovators program page to become a member, then register for Innovators Hive 2022. Both Google Cloud Innovator and Innovator Hive are FREE!
As a little experiment for Apps Script Pulse fans we are going to start reposting the official Google Apps Script release notes on this site. Why? The release notes can be incredibly useful to keep up-to-date with latest Google Apps Script developments but currently unless you keep checking the page (or know someone with an unofficial RSS feed), they can be hard to monitor.
The February 14, 2022 release note contains a very useful security update which will let yo know when someone outside your organisation updates a script project. Details and link below:
February 14, 2022
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.
You can improve the performance of Google Sheets and speed up calculations.
Via Sourabh Choraria (@schoraria911) we picked up this tweet from
Michael Avrukin who is working on the Google Sheets help center documentation:
Hi there dedicated #sheets users, we are starting to work on our help center content – here is our first article in the new format. I’ll appreciate thoughts / feedback anyone has. #googlesheetshttps://t.co/1wJ5abJZiI@benlcollins
The page includes a number of useful tips to speed up Google Sheet calculations and whilst not specifically Google Apps Script related provides useful information on some things you can look out for when your Google Sheet starts getting slow.
2021 was also a year for Platform milestones, Google Workspace grew to more than 3 billion users globally, we reached more than 5,300 public apps in the Google Workspace Marketplace, and we crossed over 4.8 billion apps installed (up from 1 billion in 2020)! We were also busy bringing Platform innovations and improving our developer experience to help building for Google Workspace easier and faster. Here’s a look at some of the key enhancements the Google Workspace Platform brought to the developer community.
There were a number of announcements for Google Workspace developers in 2021 and in this post Charles Maxson provides a summary of the key points.
