Using your YouTube subtitles file and Google Sheets to make a video contents jump list
Read how you can use your YouTube subtitle file as an easy way to create a video contents/jump list in YouTube video descriptions and G+ posts
Google Sheets
Creating custom branching in Google Forms with Google Apps Script
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.
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
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
Redux: How to open a Google Sheet at a specific row for editing
Many years ago I posted a way you could open a Google Sheet at a specific row for editing. This let you do some url wrangling where you could direct […]
Using CiviCRM with Google Script/Google Drive with the new CiviService Google Script Library
At the Association for Learning Technology (ALT) we use the open source CiviCRM for membership and events management. I’ve previously described how we are able to do Custom regular reporting […]
TAGS Tricks: Making a searchable location map of your top Twitter contributors with Geocode by Awesome Table
In this post I’ll show you how to make a searchable Twitter contributor map like the one below in a couple of clicks, however I feel it’s my duty to educate you first…
Tips on emailing inline Google Charts from Sheets using Apps Script
There are various techniques for automatically distributing these using Apps Script and in this post I’m going to highlight one method for emailing inline charts.
Custom regular reporting from #CiviCRM with Google Sheets and Google Apps Script
At the Association for Learning Technology (ALT) one of the core tools we use for membership management is CiviCRM. In this post I show you how we use Google Apps Script to automate reporting and analysis
Batch changing Google Sheet cell background colours with Google Apps Script
At ALT we use Google Sheets as an easy way to share and collaborate on draft event timetables. Recent examples are the ALT Annual Conference 2014 and the OER15 timetables. […]