AppsScriptPulse

Google launches a YouTube channel dedicated to Google Workspace development

Welcome to the Google Workspace Developers YouTube Channel, where developers of all types can learn about building solutions with Google Workspace. Explore the full range of the Google Workspace Platform from Apps Script to Chat Apps to Workspace APIs and more. Leverage Google Workspace’s products such as Gmail, Docs, Sheets, Slides, Drive, and many more to customize, integrate, or extend these products with our developer tools. Visit our website → developers.google.com/workspace

Google has just launched a new YouTube channel dedicated to Google Workspace developers. Google Apps Script community members might recognise the first featured video series on the ‘Anatomy of Google Chat apps’, which is presented by Chanel Greco who recently joined the Google Workspace Developer Relations team. As well as featuring a curated collection of previous Google content on topics from no to low code solutions the channel also includes content from the wider community.

Source: Google Workspace Developers

Must see Google Workspace Platform sessions at Google I/O

In the latest Google Workspace Developers Newsletter – April 2022 (if not already you can subscribe here), there is a handy summary of ‘Must see Google Workspace Platform sessions’ at Google I/O, 11-12 May 2022. Google I/O is being run as a hybrid event and anyone online can register for free and the program is worth exploring:

Join us for Google I/O 2022. Connect with experts, get inspired, and expand your knowledge. From no-code platforms to automated Chat applications, the team has put together an informative and educational set of sessions to get you up to date with the Google Workspace Platform.

Keynote

The cloud built for developers: Learn how Google Cloud and Workspace teams are building cloud services to help developers and technologists create transformative applications.

Sessions

Learn how to enable shared experiences across platforms: Explore how to enable shared experiences across platforms (Android, iOS, web).

What’s new in the world of Google Chat apps: Integrate services with Google Chat, explore visual improvements to Google Chat apps, and discover new Google Chat API features.

Extending Google Workspace with AppSheet’s no-code platform and Apps Script: Learn how to configure the new Apps Script Connector in your AppSheet apps.

Conversational AI for business messaging: Create messaging experiences for consumers on Google Search and Maps using Google’s Business Messages.

Workshop

Building AppSheet apps with the new Apps Script connector: Building connected AppSheet and Apps Script apps using AppSheet’s new Apps Script connector.

Register now

New features in the Apps Script integrated development environment (IDE) | Release Notes | April 13, 2022


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

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.

Source: Release Notes | Apps Script | Google Developers

For Google Workspace Add-ons, an Attachment class has been added to the Card Service that lets you add custom attachments to Calendar events | Release Notes | March 24, 2022 | Apps Script | Google Developers

March 24, 2022

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 .

You can read more about attaching files to Google Calendar events in this related Google Workspace Updates post:

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:

You can now develop add-ons that support attaching files from sources other than Google Drive. To get started, learn more about extending Calendar with Google Workspace add-ons and adding attachments with a callback function.

Source: Release Notes  |  Apps Script  |  Google Developers

The get methods for several color objects in the Spreadsheet Service have been deprecated | Release Notes | March 18, 2022 | Apps Script | Google Developers

March 18, 2022

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.

Source: Release Notes  |  Apps Script  |  Google Developers

Owners receive email alerts when someone outside the owner’s organization edits a script project | Release Notes | February 14, 2022 | Apps Script | Google Developers

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.

Source: Release Notes  |  Apps Script  |  Google Developers

Google Workspace Add-ons now generally available in Google Docs, Sheets, and Slides

Google Workplace Add-ons are now available for Google Docs, Sheets, and Slides. Google Workspace Add-ons are already available for Calendar, Gmail, and Google Drive.

There have been Editor Add-ons for a number of years, with Google Workspace Add-ons developers can tap into a new integrated user experience. One of the main differences with Workspace Add-ons is the use of the Card service rather than custom HTML (HTMLService). The benefit of switching to a Card service is cross platform support including integration into Google’s Workspace mobile apps.

Follow the link to the source post for links to all the relevant developer documentation.

Source: Google Workspace Add-ons now generally available in Google Docs, Sheets, and Slides

When to use AppSheet or Apps Script in Google Workspace | Google Cloud Blog

AppSheet and Apps Script bring together a lot of powerful customization and functionality to Google Workspace, but you may be wondering when to use which platform. Here’s the answer.

This post covers various scenarios where you might want to use “AppSheet, Google Cloud’s no-code development platform, and Apps Script, Google Workspace’s integrated low-code development platform”.

It was the last line in the post that particularly caught my eye:

We plan to continue to integrate AppSheet and Apps Script in interesting ways, and to make it even easier for you to build powerful solutions. We’re eager to see what you create.

Source: When to use AppSheet or Apps Script in Google Workspace | Google Cloud Blog