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. […]
Basic little Google Sheet template for generating download links of new Google Sheets in different formats including pdf, csv and xlsx
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 […]
You can imagine the scenario, you’ve got a Google Form perhaps setup as a booking form and a select option for picking timeslots. As the slots fill up you’d like the option to be removed. I was surprised not to find an example of this so here is a rough sketch of some code that might do the job
A quick example of how you can use Google Apps Script to automatically allow anyone to add YouTube videos to one of your playlists
You’ll find lots of blog posts explaining how to do this the other way, converting a table from Wikipedia into a spreadsheet. This post looks at taking a .csv or a spreadsheet and formatting it as a Wikipedia table.
Very basic Google Sheet template to let you draft tweets which are published to Twitter when you click a link.
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.