AppsScriptPulse

Use the Google Cloud Identity API for Google Groups with some Google Apps Script helper functions

Use the new Google Cloud Identity API to manage your Google Groups on your G Suite domain. Find in this article some REST and Apps Script code to query the Cloud Identity API.

Stéphane Giron summaries some helpful Google Apps Script code for interacting with the Google Cloud Identity API via REST. In this post you’ll find functions for listing both Google Groups in your domain and the members of each of those groups.

Source: Use the Google Cloud Identity API for Google Groups

React on Google Calendar change with Apps Script and EventUpdated trigger

It is really amazing how it is simple to make this script and have an app that run on each change perform in your Google Calendar.

A quick post to deal with a script that run when a new event or an event is updated in my Google Calendar. Hopefully in Apps Script we have an EventUpdated trigger.

Source: React on Google Calendar change with Apps Script and EventUpdated trigger

Manage event registration with Apps Script, Google Calendar and Google Forms

Manage training or event registration with Apps Script, Google Forms and Google Calendar.

Using Google Calendar to setup a meeting is really easy and works like a charm for business or personal needs. But sometimes you want to manage event registration for an event, a training and in this case you need to share a form and register the participant after the submission. Hopefully Google Apps Script is at the rescue.

Source: Manage event registration with Apps Script, Google Calendar and Google Forms

BigQuery create partitioned table and load CSV with Apps Script

Work with partitioned table and upload a csv file in BigQuery with Apps Script.

BigQuery is the famous Google database to store huge amount of data and query them fastly. For a recent a project I had to use it for storing some logs so here the code used with Google Apps Script to create the table and load a csv file from Google Drive.

Source: BigQuery create partitioned table and load CSV with Apps Script

Change Google Drive Folder color with Apps Script – Stéphane Giron – Medium

In Apps Script you can use the DriveApp service to manage your files and folders, but the methods getColor and setColor do not exist. You can use the drive advanced service to query the API directly but with recent change you will have to activate the Drive API in GCP and will need a GCP project. To have a smooth integration and skip the Google Cloud project creation here is a function to manage Folder color in Apps Script. These functions queries the API directly with UrlFetchApp() service.

Source: Change Google Drive Folder color with Apps Script – Stéphane Giron – Medium

All Google G Suite Beta programs from Google Next ’19 to Now

Stéphane Giron provides a useful list of G Suite related beta programs announced at Google Next 19

Source: All Google G Suite Beta programs from Google Next ’19 to Now

How to deal with Google Drive API for Team Drive + some Apps Script code, now use the new Drives resource collection

How to use Google Drive API for Team Drive in Apps Script with specific focus for Administrator of G Suite domain to list Team Drive, view Sharing Settings and more

Source: How to deal with Google Drive API for Team Drive + some Apps Script code, now use the new Drives resource collection

Build your own Mail Service for Apps Script with Glitch & Gmail SMTP relay

Since this year (2019) Google will have more strict policy regarding the Gmail scope. If in the past for sending notifications we were used to request the Send Email scope to user, now it is less comprehensible and on Google side you will have to provided lot of more details and your application can be rejected. So it become time for thinking to send email as the application and not as the user. Say Hello to RelayApp service

Source: Build your own Mail Service for Apps Script with Glitch & Gmail SMTP relay

Subscribe to Apps Script Pulse...