Sankey your Google Spreadsheet Data #d3js

“Sankey diagrams are a specific type of flow diagram, in which the width of the arrows is shown proportionally to the flow quantity.” In this post I introduce a basic wrapper to render data from a Google Spreadsheet with a d3js generated sankey diagram

#LAK13: Recipes in capturing and analyzing data - Google Groups Dashboard using Yahoo Pipes (no code)

As part of LAK13 I’ve highlighted a couple of ways to extract data from Canvas. Prompted by a question by On and my colleague Sheila MacNeill I wanted to show you a way of getting feed data into a spreadsheet without using any code. The solution is to use Yahoo Pipes, but as this post will highlight this isn’t entirely straight forward and you need to be aware of several tricks to get the job done.

For a couple of years I’ve been sharing a Google Sheet template for archiving searches from Twitter. In September 2012 Twitter announced the release of a new version of their API (the spreadsheet uses this to request data from Twitter). Around the same time Twitter also announced that the old version of their API would be switched off in March 2013. So here is a new version…