Deprecated – By @mhawksey

Backup Twitter Status Updates to a Google Spreadsheet

December 18, 2012

It looks like Twitter are finally rolling out the option to download all your tweets. If you are still itching to get your data this Google Spreadsheet template should help.

5 Comments

Revisiting: Experiment to dynamically timeline media posted on Twitter using Topsy and Timeline

April 17, 2012

Another look at feeding the Timeline tool developed by Verite using media extract from tweets by Topsy. This time the spreadsheet template is designed to be more flexible so that anyone can use it.

4 Comments

Experiment to dynamically timeline media posted on Twitter using Topsy and Timeline (my contribution to @Arras95) #arras95

April 5, 2012

Update: New version of this spreadsheet template here There’s a new kid on the block if you are considering an open source timeline tools. For a long time the Simile Exhibit Timeline tool has been the tool of choice appearing in places like Freebase.com (click on Timeline in this page to see a history of […]

17 Comments

Turning Google+ Search results into a RSS feed (for Google Reader)

March 19, 2012

In Using Google Reader to create a searchable archive of Twitter mentions Alan Cann commented: Subscribing to RSS feeds in Google Reader is my bog standard way of archiving Twitter feeds. Now to figure out how to get an RSS feed from a Google+ hashtag… Lets look at how it might be possible. So there’s […]

2 Comments

Using Google Spreadsheets to extract Google+ friend/follower information for analysis in NodeXL, Gephi

December 2, 2011

I keep getting this nagging voice in my head to do something with Google+ and Google Spreadsheets. I’ve resisted until now as I don’t think there is enough of an official API there to satisfy my current interest in social network analysis. This hasn’t stopped other people from getting off the beaten track and developing […]

11 Comments

Using Google Spreadsheet/Apps Script and Google Social Graph to get Twitter edges for visualizing in NodeXL and Gephi

September 5, 2011

One of the things I really liked about the network analysis and visualisation tool NodeXL which I wrote about last week was the built-in tools for grabbing data from Twitter. I said: The advantage of NodeXL, particularly for graphing Twitter communities, is it has built-in features for grabbing the data for you. Not only that […]

3 Comments

Ported: Tony Hirst’s Using Protovis to Visualise Twitter Connections to Google Spreadsheet with Embeddable Gadget

June 6, 2011

Update: The Social Graph API has been deprecated by Google and Protovis is no longer being developed. I’ve revisited this recipe using new tools in Deprecated Bye-bye Protovis Twitter Community Visualizer: Hello D3 Twitter Community Visualizer with EDGESExplorer Gadget RT @psychemedia: How do folk who send you twitter messages connect? http://bit.ly/dNoKGK < see address bar […]

16 Comments

gEVS – An idea for a Google Form/Visualization mashup for electronic voting

December 13, 2010

First I should say I don’t think this is the best solution, in fact an earlier post from 2008 DIY: A wi-fi student response system is probably a solution, if perhaps needing more tidying up, but I’m posting anyway just on the of chance that this might inspire or help solve someone else’s problem. This […]