jQuery plugin to read data from google spreadsheets easy. This plugin uses Google Spreadsheets API version 3.0. Link. Created by quelicm based google-spreadsheet-javascript

• See example
• See documentation

• Code optimized thanks to the advice of @joseanpg

• Initial version

To run your spreadsheet in google must be published to the web. To do this go to File -> Publish to the web in the next screen select:

• in Sheets to publish you can publish all or just a specific sheet and press the button Start publishing
• in Get a link to the published data web page you must select the first selector, this will generate a url in the textarea below, this is the url that we use. Example

Add the meta script to your web page

<script src="js/jquery.google.spreadsheet.min.js"></script>

In your code introduces the following lines

var url = "https://docs.google.com/spreadsheet/pub?key=0AtIDg8Wg2JCFdGdibXdnaWd2eVRRR2xVM0RlMU55ekE&output=html";
var googleSpreadsheet = new GoogleSpreadsheet();
googleSpreadsheet.url(url);
googleSpreadsheet.load(function(result) {
	//result 
});

• var url Indicate the url's where our spreadsheet
• var googleSpreadsheet instance of the class
• googleSpreadsheet.url(url); add to our class to process the url
• googleSpreadsheet.load call the function that returns all data spreadsheet our json format.
• result as json object contains all the data from the spreadsheet that we have introduced.

If your spreadsheet has more than one page, you can access the contents of the following adding to the url parameter &gid=num be 0 for first, 1 for the second ... Example