Google Apps Script – Page 5

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

April 13, 2018

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

Recording and saving user audio as .mp3 in Google Drive for Google Workspace Editor Add-ons and Google Apps Script projects

March 17, 2018

Matt Knoll (@KnollMatt) recently posed me an interesting question asking how to record audio to a user’s Google Drive using Google Apps Script. Having previously played around with WebRTC I knew capturing audio from the browser was possible but hadn’t looked at processing it. As it turns out skyllo’s blog has a great write-up explaining […]

Creating custom branching in Google Forms with Google Apps Script

March 4, 2018

I was recently asked me if I knew a way to create custom branching in Google Forms. The scenario was they had a list of employee names in a Google Sheet which they wanted to turn into a Google Form drop-down list which when selected would redirect the respondent to their own section of the form.

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

February 21, 2018

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

February 12, 2018

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

February 9, 2018

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

6 Comments

Google Apps Script Patterns: Getting a Google Sheet header row

February 7, 2018

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

Adding snow to Google Slides with the help of Google Apps Script

December 21, 2017

Note: TypeError: Cannot find function insertShape in object Slide error. There is an open issue ticket reporting this problem If you are looking for a way to add snowflakes to your Google Slide thanks to Google Apps Script this is very easy to do. As Google Apps Script uses a JavaScript syntax there is a […]

Using IFTTT with Google Apps Script for delayed THAT triggers and more

December 14, 2017

In this post I’m going to show you how you can use Google Apps Script with IFTTT to do more than this and that. As part of this I’m going to show you how I got my Wemo Smart Switch to turn on for a defined number of minutes with a Google Assistant applet.

Everything you always wanted to know about Google Apps Script Manifest Files (but were afraid to ask…)

November 22, 2017

On October 24, 2017 Google released Google Apps Script project manifests. The manifest is used to control script project properties and are also increasingly featured in new Google Apps Script services, in particular, Gmail Add-ons and Data Studio Community Connectors. Given their potential increasing importance this post explains manifest features and also highlights current opportunities for improving the user authentication flow and managing manifest files to aid project management including library versioning.