Category: Google Apps

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

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

Tracking activity: Diigo site bookmark activity data in a Google Spreadsheet (who is saving your stuff)

Recently I’ve been interested in tracking activity around resources. This comes off the back of the OER Visualisation project where I started looking at social share data around educational resources, the beginnings of a PostRank style RSS social engagement tracker, and more recently Using Google Spreadsheets to combine Twitter and Google Analytics data to find […]

One Comment

Sending free SMS messages to students by mashing up Google Calendar notifications

Finding free ways to send and receive SMS messages is something I’ve covered before (Twitter Ye! Twitter Ye! Keep your students informed with free SMS text message broadcasts! and Free SMS voting using intelliSoftware SMS Gateway service). Browsing the Google Apps Script site I saw there is a new tutorial by Romain Vialard which lets […]

3 Comments

Bye-bye Protovis Twitter Community Visualizer: Hello D3 Twitter Community Visualizer with EDGESExplorer Gadget

The problem with starting my new OER Visualisation job is I’ve got less time to explorer my own little projects. This may be a blessing for some of my readers as it means I can do less waffling. So in brief: Tony came up with this brilliant solution for plotting twitter hashtag community graphs (it […]

2 Comments

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

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

NodeGL: An online interactive viewer for NodeXL graphs uploaded to Google Spreadsheet

Recently Tony (Hirst) tipped me off about a new viewer for Gephi graphs. Developed by Raphaël Velt it uses JavaScript to parse Gephi .gefx files and output the result on a HTML5 canvas. The code for the viewer is on github available under a MIT license if you want to download and remash, I’ve also […]

7 Comments

Sentiment Analysis of tweets: Comparison of ViralHeat and Text-Processing Sentiment APIs

So I make yet another foray into a world that I know little about, potentially making statements that are factually incorrect or just stupid, but I do so hoping that I can share some of my discoveries. All the data is available for your own analysis and comments are open if you want to put […]

One Comment

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

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

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