I decided to try it out myself, but rather than build a photo gallery I wanted my fantasy football league’s website to be automically updated with every new transaction (add/drop/trade), and believe it or not it’s actually even easier than it sounds.
This is how it turned out:
Wait for the recipe to be triggered — this creates your new spreadsheet:
Open your newly created spreadsheet and go to: File > Publish to Web. You’ll then be provided with an HTML version of your spreadsheet along with it’s URL. Copy the URL below and replace INSERT-KEY with your spreadsheet’s key given to you in the public HTML URL:
Viola! You’re able to access your spreadsheet’s data via JSON. Now you can use the URL you just created to write some simple jQuery & HTML to make them play nicely together.
Here’s a look at mine (excuse the ugly data names):
That’s it. Easy, fast, and pretty awesome. You can see it in action over at my fantasy football league’s website.