Thursday, 12 November 2020 at 1200 PST / 1500 EST / 2000 UTC
Guests – Mike Rhemtulla (Product Manager, Google Workspace), Steven Bazyl (Developer Relations, Google Cloud) and Steve Webster (SW gApps LLC, President)
In this episode we are joined by Mike Rhemtulla and Steven Bazyl exploring Google Workspace Add-on development. As part of this with Mike will share the impact and opportunity of being of contributing to the Google Workspace Marketplace, while Steven will share tips on building Add-ons. Finally, Steve will share tips on migrating existing HTMLService based Add-ons to the new Card Service
Use the YouTube comments to share any Marketplace and Workspace Add-on questions before the show or email them to [email protected]
If you have ever done any work in Google Sheets you might have come across the incredibly useful UNIQUE function. This function can take a single row or multiple rows and generate a list of unique cell values.
Sometime you might have a use case where you need to replicate the UNIQUE functionality in Google Apps Script. … Whatever the case, knowing how to to create a unique array from a 1-dimensional array or a 2-dimensional array is an important part of your toolkit as a coding goat 🐐.
This tutorial will look at how to create this with modern Javascript that is incorporated into the Google Apps Script language.
Learn how to use Google Cloud’s Natural Language API to do sentiment analysis on tickets submitted to a Google Tables Support Issue Tracker. We’ll use Google Tables as the platform for our Support Tracker and Apps Script to connect to the Cloud Natural Language API.
Great example from Ben Collins building on the work of Alicia Williams which shows how you can interact with your Google Tables with Google Apps Script. As part of this solution Ben uses the new Tables Service, which is the latest Advanced Service to hit Google Apps Script, connecting to the Google Cloud Natural Language API. Click through to the source for all the details you need to get started.
Note: Google Tables beta is currently only available in the U.S.
Totally Unscripted is a Google Workspace and Apps Script developer show organized by the community for the community. We invite members of the community to share their Google Workspace developer tips, tricks and triumphs.
Totally Unscripted the Google Workspace and Apps Script developer community show returns! The shows are an opportunity to learn about the very latest Google Workspace and Apps Script updates from both the community and Google. We are returning with a series of six weekly shows starting with ‘Meet the new Google Workspace Developers Experts‘ on 05 November 2020 at 20:00 UTC (TZ conversion).
In this show you have an opportunity to meet some of the new Google Developers Experts (GDE) in Google Apps Script. As well as finding out how our experts got involved in Apps Script, we find out why they think it is different to other platforms, their favourite killer app and why you should learn Apps Script. The show is also an opportunity to find out if you’ve got what it takes to become our next newest GDEs. For this episode we are joined by:
If your school is considering conducting an online ‘Virtual Parents’ Evening’ due to covid restrictions, this project might save your staff time. The Google Sheet (make a copy at https://bit.ly/vpeassistant ) uses Google Apps Scripts to automatically create a Calendar event (in your default Calendar), create a Meet link as part of the event, paste the Meet link back into the Sheet and create a draft email to the parent containing the Meet link and time/date.
A simple and effective solution from Luke Craig to help you manage virtual parents evenings … and more. In particular useful to see how you can add Google Meet video calls to you calendar invites. The video description also includes a link to the source code on Github.
Monitor your Google Drive automatically and get email alerts when important files and folders are deleted from your Google Drive. You can also watch file activity in Shared Drives
Search through rows of a Google Sheet simultaneously looking for certain criteria all in one single loop. I needed a way of doing this without multiple loops despite searching for separate information and here is a way of achieving that via true/false flags.
Back when G Suite, err… Google Workspace Add-ons launched, support for Docs, Sheets, and Slides was conspicuously absent. Sure, they’ve long supported their own flavor of add-ons, but the idea of building an add-on two different ways didn’t sit well with me. Thankfully I didn’t have to wait too long for the editors to catch up. … Now that add-ons work in the editors I had the chance to build a few small demos to try them out.
Recently it was announced that Google Workspace Add-ons now support the extension of the Editors (Docs, Sheets and Slides). Steven Bazyl (Google, DevRel) has shared an overview to help you get started with Workspace Add-ons. The examples Steven shares are particularly useful if you want to start developing add-ons that work across editors as well as in Gmail. This post is particularly useful for tips on handling different host applications. Follow the link to the source for all the code and more details…
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.
Google Apps Script, Google Sheets, Javascript Have you ever wanted to have a Google Sheet available for only those users who need to edit and then once they are done, take their edit permissions away to maintain the integrity of the sheet? I know that I have come across these conditions a number of times … Continue reading “Google Apps Script: How to Add and Remove Editors to a Google Sheet based on Sheet Data”
