Category: Google

Twitter: How to archive event hashtags and create an interactive visualization of the conversation

The use of Twitter to collecting tweets around an event hashtag allowing participants to share and contribute continues to grow and has even become part of mass media events, various TV shows now having and publicising their own tag. This resource is often lost in time, only tiny snippets being captured in blog posts or […]

194 Comments

I’ve fallen out with Google Reader, we’re on a trail separation (I’m having a fling with Tiny Tiny RSS)

Back in July I started drafting a post about how I use Google Reader as part of my workflow as a RSC e-Learning Advisor. Those days are behind me but I still like to keep up to date with what’s going and highlight stories that I find interesting and others in my network might like too. […]

4 Comments

Visualising the #ili2011 Twitter archive

Over on UK Web Focus Brian Kelly has posted What Twitter Told Us About ILI 2011which gives a breakdown of twitter statistics the recent Internet Librarian International conference #ili2011. These statistics give some of the headline figures of number of tweets, top tweeters etc from Andy Powell’s Summarizr interface for the TwapperKeeper service (recent bought […]

8 Comments

TAGSExplorer: Interactively visualising Twitter conversations archived from a Google Spreadsheet

Graphs can be a powerful way to represent relationships between data, but they are also a very abstract concept, which means that they run the danger of meaning something only to the creator of the graph. Often, simply showing the structure of the data says very little about what it actually means, even though it’s […]

12 Comments

A template for rendering small NodeXL visualisations on the web using the d3.js

Having put in the toil getting my head around the d3.js library I wanted to revisit a problem I had rendering NodeXL generated data in a scalable vector graphic based webpage. In my post The art of discovery: Looking at how UK Web Focus, OUseful.info and MASHe interconnect using Google Spreadsheets and NodeXL I said: […]

2 Comments

Updates to Twitter Archiving Google Spreadsheet v2.3 [TAGS]

Recently I’ve started exploring extended Twitter conversations using data captured from my Twitter Archiver Google Spreadsheet (think I going to rename this TAGS) and one of the problems was “The user ids in the Search API are different from those in the REST API … This defect is being tracked by Issue 214. This means […]

One Comment

SpreadEmbed: Turning a Google Spreadsheet of links into a page of embedded objects

#embedly_twitter_83506155{background:url(http://a1.twimg.com/images/themes/theme19/bg.gif) #FFF04D; padding:20px;} #embedly_twitter_83506155 p{background:#fff;padding:10px 12px 0px 12px;margin:0;min-height:48px;color:#000;font-size:18px;line-height:22px;-moz-border-radius:5px;-webkit-border-radius:5px} #embedly_twitter_83506155 .embedly_tweet_content{background:#fff;padding:10px 12px 10px 12px;margin:0;min-height:48px;color:#000;font-size:18px !important;line-height:22px;-moz-border-radius:5px;-webkit-border-radius:5px} #embedly_twitter_83506155 p span.metadata{display:block;width:100%;clear:both;margin-top:0px;height:40px; padding-bottom: 12px;} #embedly_twitter_83506155 p span.metadata span.author{line-height:15px;color:#999;font-size:14px} #embedly_twitter_83506155 p span.metadata span.author a{line-height:15px;font-size:20px;vertical-align:middle} #embedly_twitter_83506155 p span.metadata span.author img{float:left;margin:0 10px 0 0px;width:48px;height:48px} #embedly_twitter_83506155 p a {color: #0099CC; text-decoration:none;} #embedly_twitter_83506155 p a:hover{text-decoration:underline} #embedly_twitter_83506155 .embedly_timestamp{font-size:13px;display:inline-block;margin-top: 5px;} #embedly_twitter_83506155 .components-above span.embedly_timestamp{font-size:10px;margin-top: 1px;line-height:12px} #embedly_twitter_83506155 a {color: […]

2 Comments

Suggest an article for The GAS: Google Apps Script Scoop

For a while I’ve been curating ‘The GAS’ which is a collection of Google Apps Script examples and news pulled together using scoop.it. I started it mainly because I’m a ‘patterns programmer’, that is I have limited formal coding skills so learn and produce things from other people’s examples. Because others getting started with Apps […]

One Comment

Google Spreadsheets as a Database – INSERT with Apps Script form POST/GET submit method

Update 04/07/2014: I’ve revisited this code and made a number of improvements. Read more in Google Sheets as a Database – INSERT with Apps Script using POST/GET methods (with ajax example) Update: See comment by James to streamline this even more. I was recently rediscovering an old Hirst post on Google Spreadsheets as a Database […]

84 Comments

Live Twitter data from FOTE #fote11 [Top Tweeters, Sentiment, Hashtag Network Diagram, Conversation Diagram]

Not at FOTE11 today (you can follow the live stream) but was interested in what data I could extract from the #fote11 twitter stream and process as the event unfolds. Most of the data here comes from a mashup of my Google Spreadsheet mashup. (This is perhaps putting Google Spreadsheets to the limit in terms […]

« Previous Page — Next Page »
css.php