How can I access Google Sheet spreadsheets only with Javascript?

javascript google-api google-sheets-api google-data-api google-api-js-client
Pratik picture Pratik · Nov 10, 2010 · Viewed 145.9k times · Source

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.

Answer

Mike McKay picture Mike McKay · Jan 27, 2011

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

Related questions

Is there a link to the "latest" jQuery library on Google APIs?

I use the following for a jQuery link in my <script> tags: http://ajax.googleapis.com/ajax/libs/jquery/1.2.6/jquery.js Is there a link to the "latest" version? Something like the following (which doesn't work): http://ajax.…

Read More
How can I validate google reCAPTCHA v2 using javascript/jQuery?

I have a simple contact form in aspx. I want to validate the reCaptcha (client-side) before submitting the form. Please help. Sample code: <%@ Page Language="VB" AutoEventWireup="false" CodeFile="Default2.aspx.vb" Inherits="Default2" %> <!DOCTYPE html> &…

Read More
How can I get stock quotes using Google Finance API?

I'm looking for access to financial data from Google services. I found this URL that gets the stock data for Microsoft. What are all the possible parameters that Google allows for this kind of HTTP request? I'd like to see …

Read More