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.
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
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
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 […]
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.
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.
How to setup a Raspberry Pi and OpenCV to count how many faces there are in the audience sending counts to Google Analytics for analysis.
I recently had the pleasure of attending and presenting at MozFest 2017. MozFest had been on my bucket list to attend for a while and the event did not disappoint. My contribution to the event was a session as part of the web literacy space designed to introduce people to APIs. This post has more information and links to resources available for reuse
If you have some content you’d like to embed into a new Google Site that isn’t accepted by the ‘Embed URL’ feature in Sites you can try following these steps
As Google also recently announced that Google Apps Script Web Apps can be embedded in new Google Sites and given the majority of Chrome Extensions are just a wrapper for HTML/JS/CSS I thought I’d have a look at porting Google’s Calendar Chrome Extension code to Google Apps Script