I was recently asked to write a guest post for Big Data Week on using Google Apps as an interface for Big Data. For the post I decided to revisit an old recipe which uses Google Sheets (Spreadsheets) and Google Apps Script to interface the Twitter and Google Analytics API. One of the results is the bubble graph shown below which shows who has been tweeting my blog posts, how many visits their tweet generated, the number of retweets and how many followers the person has (click on the image for the interactive version). You can read more about his this was done and get a copy of the template in Getting Creative with Big Data and Google Apps
Join the conversation
Comments are closed.
Krischan
Hi Martin, thanks for the interesting post! Would love to take a look at the template, but I get an error message when I try to make a copy (something along the lines of “owner changed sharing options”). Can you help? Thanks!
Martin Hawksey
Hi Krischan, Sorry to hear that. Try opening this url and File > Make a copy https://docs.google.com/spreadsheet/ccc?key=0AqGkLMU9sHmLdEdSanVLYXFrbkx0ZXZyQS13Tk1UZ3c
Martin