Category: Google Apps Script

Google App Script: Scheduling timed triggers

I noticed a couple of search referrals around scheduling timed triggers in Google Apps Script so here is what I know and how to do it. Within Google Apps Script you can create basic time-based triggers (poor mans cron) to run functions on specific date/time intervals. Using the ‘Current Script’s triggers’ dialog (accessed from Script […]

2 Comments

[FREE] Receive SMS messages in a Google Spreadsheet for a textwall, voting and more (UK only)

A solution for making a free SMS inbox in a Google Spreadsheet using the IntelliSoftware SMS Gateway and 30 liines of Google Apps Script code. This particular example is used to collect votes for a poster competition but there are many other things you could use it for.

2 Comments

Templated Export for Google Spreadsheets

Templated Export allows users to reshape and selectively publish data from Google Spreadsheets in custom formats. The tool is powered by Google App Script which allows integration with Google Spreadsheets using existing authenticated access. The videos and instructions in this post demonstrate how to setup and use Template Export.

66 Comments

How JISC CETIS dashboard social activity around blog posts using a splash of data science

Behind the scences look at how we (JISC CETIS) can quickly develop dashboards to monitor activty around blog posts (using Google Spreadsheets of course 😉

4 Comments

Google Spreadsheet Template for getting social activity around RSS feeds

Here’s a Google Spreadsheet template I’ve developed from some leftovers which pulls data together from comment feeds, Twitter and Delicious (with social counts for these plus Facebook, LinkedIn and Google+)

4 Comments

Data Shaping in Google Spreadsheet – Generating New Rows from Multiple Values in a Single Column

Today Tony Hirst posted Data Shaping in Google Refine – Generating New Rows from Multiple Values in a Single Column. Coincidently I faced a similar problem today working with a Google Spreadsheet so thought I’d share my solution.

6 Comments

Google I/O 2012 Notes: New features in Google Apps Script (NoSQL, HTML/Content publishing and Chrome app publishing)

Notes from final bunch of session I want to talk about from Google I/O on Google Apps Script. It includes NoSQL databases, HTML/Content publishing, Managed Libraries and Chrome app publishing

2 Comments

RSS Feed Social Share Counting Google Spreadsheet

Sheila MacNeill recently shared Some thoughts on web analytics using our work on analytics in which she mentioned a tool I developed which allows us to quickly get social share and page view counts for out blog, category or project feeds. Here’s the basic version of the template I’ve developed that we use.

14 Comments

Making Google Reader Mobile sing using your Gmail inbox for personal productivity to save bookmarks and tweet links

In this post I introduce a little Google Apps Script producivity tool that lets me send tweets and save bookmarks to Delicious and Diigo from Google Reader Mobile

2 Comments

88% of Universities UK members use Google Analytics: How I calculated the answer in under 10 minutes

Writing another blog post today which included reference to Google Analytics I pondered ‘how many institutions are using google analytics? The initial response wasn’t promising but 10 minutes later I had calculated it myself

5 Comments
« Previous Page — Next Page »
css.php