Google Apps Script – Page 18

And the most engaging OUseful.info post is…

August 18, 2011

This one Data Scraping Wikipedia with Google Spreadsheets … If you want to know how I arrived at this conclusion it’s mostly the same process as And the most engaging JISC Project is…, but as well as getting social bookmark/share counts I’m also counting the number of post comments (an important part of engagement). Here’s […]

And the most engaging JISC Project is…

August 15, 2011

[flickr]4814995807[/flickr] Recently I posted a Google Spreadsheet of all the live JISC funded project websites from the last 3 years. Not too long before that I also posted Google Spreadsheets as a lean mean social bookmark/share counting machine, which used Google Apps Script to query different social network providers for share/like counts for a specified […]

2 Comments

Open data equals open scrutiny but doesn’t always equal all of the answer

August 10, 2011

[flickr]64284665[/flickr] Last week I got frustrated at not being able to find some JISC funded project outputs, which was a little annoying. This led to a small exploration around JISC’s Programme Information Management System (PIMS). The system was originally only available to JISC executive staff but made available to all sometime last year and used […]

4 Comments

Free Google Apps Script solutions for education from simpleappssolutions.com

August 7, 2011

One of the resources I regularly dip into when Apps Scripting is James Ferreira’s simpleappssolutions.com. When introducing people to Google Apps Script I usually promote James’s work because he offers free consultation to education and non-profits. Today James sent me the following email and with his permission I’m sharing it here: Hello, I’ve been giving […]

3 Comments

Exporting more friends or followers from Twitter to a Google Spreadsheet

August 2, 2011

Back in March 2011 I published Export Twitter Followers and Friends using a Google Spreadsheet. One of the problems with this solution is if you were trying to import a lot of friends or followers users would get the error message “Exceeded absolute-time timeout in milliseconds”. This is because there is a limitation to the […]

21 Comments

Social media wars: Measuring the battle lines

July 13, 2011

As previously posted I was at the UKOLN Metrics and Social Web Services: Quantitative Evidence for their Use and Impact event on Monday. Before attending this event I thought I had a reasonably understanding of social media metrics but I left realising there was a lot I didn’t know, but with new ideas to help […]

3 Comments

Introduction to Google Apps Script with: Split my form entries to individual sheets by username

July 6, 2011

Just as Vincent van Gogh knocked out a few sunflower painting in his time my current muse is Google Apps Script. At the danger of boring you with yet more sunflowers here’s a recording of a webinar session I did with Dave Foord at A6 Training and Patrick Lander from Loughborough College. This session came […]

One Comment

Google Apps Script: Lite Contacts Directory for Sites or as a Service

July 5, 2011

A while back I came across a guest post on the Google Apps Developer blog by Steve Webster at Dito which demonstrated an Autocomplete Email Addresses in Apps Script. Not only was this a great demonstration of what you can do with the Apps Script UI but Steve and the guys at Dito had made […]

35 Comments

What you can’t do with Gmail and Document Services now available in Apps Script

June 16, 2011

Google recently announce Gmail and Document Services now available in Apps Script, which wasn’t a huge surprise as they had already announced it at the Google I/O and I had picked up on it in Automating your inbox with Google Apps Script. So when asked if I could create a gadget to sit in a […]