Getting data from Google spreadsheet
Having this spreadsheet from Google: https://docs.google.com/spreadshee…
This is what I did to show the quote daily:
<script src="http://ajax.googleapis.com/ajax/libs/jquery/1.7.0/jquery.min.js"> </script> <div id="result">loading</div> <script> var today = new Date(); var aday = today.getDate(); var amonth = today.getMonth(); var sq = "amonth=" + amonth + " and aday=" + aday; var url = "https://spreadsheets.google.com/feeds/list/0AjgIgMIuXFo2dF9fQnUybkFLeE5ybHE0bVJ4Z3F0Unc/od6/public/values?alt=json"; $.getJSON(url, { "sq": sq }, function (data) { $("#result").html(data.feed.entry[0]["gsx$atext"]["$t"]); }); </script>