Retrieving Data From Google Spreadsheet
HTML
<div class="test"></div>
JavaScript
//Link to the example sheet is here: https://docs.google.com/spreadsheets/d/1xo6dUfcVOwPA5Lkd8pKevLj6lP-0gOaPXNBZk4jyuGw/edit#gid=0
//Sheet id is: 1xo6dUfcVOwPA5Lkd8pKevLj6lP-0gOaPXNBZk4jyuGw
//Worksheet is: od6 but can also be the #gid. Example: http://screencast.com/t/Ebvd7Pa8G
//Make sure your spreadsheet is published: File>Publish to Web
//Below, 'largeimage' and 'imagetitle' are the names of headers in the Sheet.
var url = "https://spreadsheets.google.com/feeds/list/1IcYvDJ6fmmfVLRYlKU6LKHH5OqJSS0olA0gRfN-lfSw/od6/public/values?alt=json-in-script";
$.getJSON(url, function(data) {
conosle.log(data);
var output = "";
$.each(data.feed.entry, function(index,value) {
});
$(".test").append(output);
});