Google Apps Script Patterns: Keeping a gam generated users report up-to-date with Google Apps Script

In Google Workspace gam is probably the ‘go to’ tool command line tool which allows administrators to easily manage domain and user settings. Recently I was asked about how you can keep gam generated reports up-to-date using Google Apps Script. It’s worth remember that gam uses public Google Workspace APIs when it performs actions and reports. In this post I show you a pattern for building script to keep gam reports fresh.

Example JSON output

Google Apps Script Patterns: Writing rows of data to Google Sheets the V8 way

Currently one of the most popular posts on this site is my Google Apps Script Patterns: Writing rows of data to Google Sheets. Given Google’s recent announcement of the general availability of the new V8 runtime I thought it was worth revisiting this particular pattern and using the modern syntax now available to Google Apps Script developers.

Mail Merge

Google Apps Script Patterns: Celebrating 10 years by revisiting mail merge/bulk emailing

TL;DR A new solution for creating and distribute visually rich bulk emails with Gmail and Google Sheets. On 19 August 2019 Google Apps Script celebrated 10 years of general access. Apps Script has come a long way in the 10 years as you can see from the announcement blog post and launch video also embedded […]

Google Apps Script Patterns: Writing custom formulas/functions and handling single and range inputs

Custom functions have been in Google Apps Script since it’s public launch in 2009. These let you extend Google Sheets function list allowing you to create and share your own spreadsheet formula. The official Google Developer docs for Custom Functions are very comprehensive and in this post I just want to highlight one pattern for detecting and handling user inputs.

Google Apps Script Patterns: Creating conversational interfaces with Dialogflow

In a recent episode of Totally Unscripted I demonstrated how you can use the Dialogflow service as a way to allow you to add conversational interfaces to your Google Apps Script projects. Dialogflow is now owned by Google and it already integrates with a number of its existing services like Cloud Speech-to-Text. Dialogflow isn’t limited […]

Google Analytics and Google Apps Script

Google Apps Script Patterns: Google Analytics in Google Add-ons and Apps Script projects

In this post I’ll show you some patterns you can use for using Google Analytics client side in HTMLService and server side with any Google Apps Script code you are running backend. As part of this I include GATrack, a Google Analytics tracking helper class for Google Apps Script

Google Apps Script Patterns: Writing rows of data to Google Sheets

In the previous post in the Google Apps Script Pattern series we looked at selectively updating rows of data in a Google Sheet. For this post we will look at a couple of patterns for inserting multiple rows of data into Google Sheets.

Google Apps Script Patterns: Conditionally updating rows of Google Sheet data by reading and writing data once

In the previous post in this Google Apps Script Patterns series we finished with an example of how you can read and use row data from a Google Sheet. In this post we are going to extend this pattern so that as well as reading the data we also update rows.

Google Apps Script Patterns: Using the destructuring assignment syntax and object arrays to process Google Sheet rows

In my last post I shared a Google Apps Script Pattern for getting a Google Sheet header row. In this post we are going to extend this to look at some patterns for processing rows of data from Google Sheets

Google Apps Script Patterns: Getting a Google Sheet header row

Often in Google Sheets you want to grab the header row, this might be in preparation to read/write data, to populate some UI, or something else. Here are some Google Apps Script patterns for doing this

css.php