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

@mhawksey just used the twitteralytics script to create the following tweet archive: http://t.co/8aE8DwHM . thx for the awesome script! :)
Oct 06 via webFavoriteRetweetReply

One of the great things about open development is people take your stuff and do interesting things with it that you never thought about. As you’ll see from the embedded tweet above that’s exactly what Saqib Ali did, taking my Google Spreadsheet Twitter Archive mashup and combining it with the Embed.ly oEmbed API to create this curated page of tweets, brilliant!

Inspired by this, in this post I highlight why using a spreadsheet as a data source for embedded objects might be useful and how I made the SpreadEmbed prototype which allows you to do this.

What is SpreadEmbed?


You take a spreadsheet like this with a column of links, run it through SpreadEmbed and get a page like this. That’s all there is to it.

On a technical level SpreadEmbed reads a column using the Google Visualization API, passes the links to Embed.ly and generates a page from the result.

Why use a Google Spreadsheet as a data source?

Of course you could use a tool like Storify (which also is powered by Embed.ly) to do this but as I highlighted in this recent post there are limitations to far back you can go in the twitter search. I also like the concept of reusing a spreadsheet of tweets because as I’m discovering in my own analysis of event hashtags there are some very complex and interesting stories to tell which would benefit from some actual quotations. So for me I can filter a large archive of tweets and render it in a more visually appealing way (rather than as in this post directing people to a spreadsheet of data).

Another consideration is Google Spreadsheets are in themselves very collaborative environments allowing multiple editors, submissions via Google Forms or custom interfaces (I’ve started collecting article suggestions using a custom bookmarklet).

How SpreadEmbed was made: Some highlights

Putting this prototype together took about 4 hours to get it working and about the same again with tweaks. Fortunately there was already an example on the Embed.ly github, which embeds YouTube clips from a Twitter search. As my prototype iterates across cells most of the work has already been done.

The remaining headache was providing a way to access cell data from a user defined spreadsheet. The solution was using Tony Hirst’s Google Spreadsheets as a Database code (just for fun … (more because I wanted to see if I could do it) I wrote some code to generate a dropdown list of sheet names to allow the user to indicate where there links were). The source code is here, feel free to re-use/mod.

Limitations and better ways

One of the reasons I’m presenting SpreadEmbed as a proof of concept/4 hr hack and not a service is if you are making more than 10,000 calls a month the the embed.ly API you gotta pay. Also there are probably better ways of doing it. Saqib hasn’t said how exactly he did his version, but I’m guessing you can just copy and paste a list of urls into a post and if you’ve got an embed.ly type plugin it’ll do the rest of your work for you.

Anyway it was all just for fun  …

By me: SpreadEmbed: Turning a Google Spreadsheet of links into a page of embedded objects http://t.co/GtpmfaHW
Oct 12 via Tweet ButtonFavoriteRetweetReply

Comments are closed.