Join us to find out about analytics in Google Add-ons and the new Google App Maker 16 Dec @ 3pm GMT

Back in June 2016 a couple of us in the Google Apps Script community have been putting on a monthly gathering. We are now going into our sixth episode of ‘Totally Unscripted’ which you can join on Friday 16 December at 3pm GMT. Join us for our next instalment of Totally Unscripted. In this show […]

Using the Google Slides API with Google Apps Script

Google recently announced the general availability of the Google Slides API. The announcement was accompanied by video from the new G Suite Dev Show presented by Wesley Chun embedded below, and a post by Wesley on Using the Google Slides API with Python. Wesley mentioned that “If you’re not a Python developer, it’ll be your […]

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 someone to open a Google Sheet in what was ‘List View’ and edit the row: Sadly List View disappeared in the Google Sheets update announced […]

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 from #CiviCRM with Google Sheets and Google Apps Script which is able to trigger reports from Civi which are emailed to a Gmail account before […]

23ThingsEdUni: Thinking about things by doing things #23things

I’d heard about the 23Things course from various people and my boss Maren, who is in rhizo16 withdrawal, was keen that the ALT team got involved.   The course is described as: The University of Edinburgh’s 23 Things for Digital Knowledge is a self-directed course, run by Information Services Group. The programme seeks to expose you […]

Working with Github repository files using Google Apps Script: Examples in getting, writing and committing content

In a recent post I demonstrated how you can use Google Apps Script to add new tweets to a downloaded Twitter archive hosted on Github Pages. This project used the Github API to commit files to the repository. Given the demise of Google Drive web hosting and the potential usefulness of this approach I’ve extracted […]

Keeping your Twitter Archive fresh and freely hosted on Github Pages

tl;dr How do you keep your downloaded Twitter archive fresh on Github Pages using Google Apps Script? By running this Google Apps Script powered web app. Note: As Ken Bauer has discovered Twitter now offers two different archive options – you need to request the one from If you were to ask me which of my […]

Social Media Analytics: Using Data to Understand Public Conversations (course feat. TAGS) #FLsocmed

Queensland University of Technology have just started a free FutureLearn course on ‘Social Media Analytics: Using Data to Understand Public Conversations’. The course is described as: From the personal to the political, social media conversations are at the heart of cultural and social change. In this course you will be introduced to digital methods to […]

Totally Unscripted: A new Google Apps Script community hangout (Hangout On Air Tips)

The day job at the Association for Learning Technology (ALT) and my Google Apps Script hobby made an unexpected collision recently  when I was asked by Bruce Mcpherson to contribute to a new monthly hangout for the Google Apps Script community.  At ALT we’ve started to explore using Google Hangouts On Air for more of […]

#IWMW16: The Google Analytics of Things (recording and slides)

I recently got to try out a new talk  at IWMW16 in Liverpool on ‘The Google Analytics of Things’: The majority of websites are using Google Analytics for tracking and reporting (W3Techs report 82.9% of tracked sites are using Google Analytics). Since launching Google Analytics in November 2005 the Internet has radically changed moving away […]

Next Page »