Blog

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. 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 […]

Becoming a watch maker

Find out how I got on creating a watch face for Android Wear only using my mobile phone.

Generate a PDF (csv/xlsx/ods) download/publish to the web link for new Google Sheets

Basic little Google Sheet template for generating download links of new Google Sheets in different formats including pdf, csv and xlsx

Creating a Twitter Question/Revision Bot using Google Sheets

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

How to explore the Twitter API without code using the console

The non tech savvy way to peel back Twitter and see the data in your tweets.

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

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’ […]

Open call for contributions: TAGS talk at #OER15 – how are you using Twitter to support education

In a couple of weeks I’ll be talking about TAGS at OER15 (14:30-15:00, 15th April). Whilst parallel sessions aren’t going to be streamed I’ve got a couple of ideas for broadcasting my session. If I pull this off I’ll be co-tagging my presentation #oer15 #740. My notes for structuring the session so far is: Networks […]

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

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)

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.

« Previous Page — Next Page »
css.php