In yesterday’s article, Green Twitter Google Pie, I mentioned that I had created additional gadgets from the Green Twitter RSS feed imported into Google Spreadsheets.
The first is a word cloud of the top green tweeters per last 20 tweets – this uses the same spreadsheet data used to create the pie chart. I wanted to create a cloud from the actual tweet but common words such as the and and the most common in the cloud. I don’t know how to remove them. I also don’t like the border around the cloud but I haven’t been able to figure out how to remove that either.
The second gadget is a table of the twitter username and the tweet. What I like about this gadget is that it can be filtered by field. What I don’t like about it that even though the tweets are linked withing the original spreadsheet they aren’t in the gadget
Finally, this is an iframe of the three primary fields from the spreadsheet. This is embedded html and is not a gadget so the tweet url’s are linked. The link will open within the frame but to return to the spreadsheet you have to right click and select back.
There are a lot more things that can be done with RSS feeds within Google spreadsheets. If anyone has any creative ideas, please let me know in the comments.