Google Apps Script – Page 9

Getting the details of uploads to any YouTube channel into a Google Sheet

July 2, 2015

As of yesterday TED have uploaded 1,903 videos totaling 1,622,120 seconds of playtime which have been viewed 428,117,012 times and received 4,360,903 likes. This post highlights how to work with Google Apps Script advanced services and other Google API documentation

Using import.io authenticated data sources with Google Apps Script

July 1, 2015

Last year I wrote about how you can use Google Apps Script to integrate with import.io. In this post I look at using authenticated data sources for import.io with Google Apps Script

Custom regular reporting from #CiviCRM with Google Sheets and Google Apps Script

June 21, 2015

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

June 1, 2015

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. One of the reasons for publishing draft timetables using Google Sheets is we can get a static url for people to download it as PDFs […]

Creating a Twitter Question/Revision Bot using Google Sheets

April 29, 2015

My old colleague at Cetis, David Sherlock, posted a nice little ‘Twitter Question/Revision Bot’. This uses a .csv file of questions and multiple choice answers which get randomly tweeted out using a Python script. David designed the project with a Raspberry Pi in mind but also highlights it can be easily run on any Unix […]

4 Comments

TAGSPresenter (alpha) – A Twitter/Google Sheets based presentation concept

April 15, 2015

Update: Didn’t go well but revised version on this I’ve used successfully is here and slides published here. Later today (2.30pmUTC) I’ll be presenting at #oer15 about Twitter in open education (tune in here). As I wanted to highlight the network effect of Twitter I wanted to engage not just the room, but leave ‘footprints’ […]

Google Sheets: Move a row of data to another sheet based on cell value

March 10, 2015

There was a question that came up in the Google Apps Script G+ community about moving a row of data to another sheet. In this post I look at how to solve this for Google new Sheets

3 Comments

Tutorial: Interacting With Your Google Drive with Apps Script (including parsing/writing .csv files)

February 25, 2015

A question came in on the Google Apps Script Google+ Community which in part was asking about parsing .csv files into a Google Sheet. I intially pointed the asker to some dated documentation so for my penance have updated it.

Revisiting issuing Mozilla Open Badges with Google Apps Script and Google Sites: Notes on new options

February 17, 2015

Back in 2012 I shared some of the exploratory work I did issuing Mozilla Open Badges with using a combination of Google Apps Script and Google Sites. I revisit this idea with new knowledge of the Mozilla Issuer API

Notes on feature request to access Fullscreen API in Google Apps Script

December 22, 2014

Recently I was trying to get full screen access in Google Drive using Google Apps Script and I couldn’t get it to work resulting in this feature request. In this post I want to share some of my thought processes and highlight why this would be a useful feature.