The TwtrService library for Google Apps Script centrally stores your Twitter access details allowing them to accessed from multiple script projects without the need for re-authentication. This post outline usage of the library.
Amazing to think the TAGS (Twitter Archiving Google Sheet) has been going for over 4 years now. Version 6 is a major code rewrite and the most important new feature is a better setup processes. Read this post to find out more.
Slides from presentation at #WebExpo on using Google Apps Script and Sheets for social data mining and analysis.
YouTube Analytics Channel Reports are restricted to the user authorizing the request must be the owner of the channel. This can cause issues in Apps Script when interacting with other services. This post highlights a workaround where the data is proxied via a separate script published as a web app.
There are regular reporting features built in to Google Analytics but what if you want to do customised reporting? One answer is Google Apps Script and this post walks you through access Google Analytics data in one line of code and setting up automated collection.
Highlighting how the Google Analytics Management API could be used by LMS/VLE vendors and platforms to manage the creation of course specific Google Analytics filtered views proving a Learning Analytics course and programme level actionable insight.
Revisiting my POST/GET Google Apps Script example which lets you submit data to a Google Sheet (and other destinations) using your own forms or other ajax calls
Presentation given at Google Apps for Education European User Group meeting (GEUG14) exploring the how Google Apps for Education can be customised with Google Apps Script.
Presentation given at University of York Google Apps for Education European User Group meeting (GEUG14) exploring how Google Analytics can be used for Learning Analytics
As part of some recent work with the Open University I explored the use of Google Fusion Tables as a queriable data source to use with Google Charts. This post highlights the result and notes some limitations and opportunities of using Google Fusion Tables as a datasource.