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

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

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…)

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.

Using OpenCV, Raspberry Pi and Google Analytics to measure audience levels via face detection

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.

Machina a machina: An introduction to APIs with Google Sheets

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

Embedding almost anything like a Twitter Search widget in new Google Sites with Google Apps Script

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

A Google Calendar Widget for Google Sites created with Google Apps Script

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

Changing the color of all links in Google Slides with Google Apps Script

My goto theme in Google Slides is Material and for the Totally Unscripted show use the ‘one column text’ layout for highlight news/community updates. One annoyance with this theme is the text hyperlink color defaults to light blue (HEX: #4FC3F7), which isn’t so great in the sidebar column: You can override the link color in […]

Getting YouTube Analytics with Google Apps Script when you get authentication loops

In my previous post I provided a tutorial on using the YouTube Data API with Google Apps Script for situations where you were using branded channels (channels not directly owned by a Google account). In this post I’m going to revisit this topic looking at the YouTube Analytics API.

Identity crisis: Using the YouTube Data API with Google Apps Script and Scheduling Live Broadcasts from Google Sheets

Details of how you can use a custom YouTube Data API library to interact with any YouTube account even if it’s owned by a Google+ page

Next Page »