javascriptgoogle-apigoogle-sheets-apigoogle-analytics-apigoogle-api-js-client

How can I access Google Sheets spreadsheets only with Javascript?

I want to access Google Spreadsheets using JavaScript only (no .NET, C#, Java, etc.)

I came here and was shocked to know that there is NO API for JavaScript to access Google Sheets.

Please tell me how to access (CREATE/EDIT/DELETE) Google Sheets using JavaScript or any of its frameworks like jQuery.

Solution

  • I have created a simple javascript library that retrieves google spreadsheet data (if they are published) via the JSON api:

    https://github.com/mikeymckay/google-spreadsheet-javascript

    You can see it in action here:

    http://mikeymckay.github.com/google-spreadsheet-javascript/sample.html