fetch JSON from google spreadsheet using javascript

Question

I want to fetch JSON from google spreadsheet, I searched few links but cannot find the exact solution.

Can someone help me with the solution.

https://developers.google.com/gdata/docs/json
http://www.mail-archive.com/[email protected]/msg01924.html
http://code.google.com/apis/gdata/docs/js.html
http://code.google.com/apis/spreadsheets/gadgets/
http://code.google.com/apis/documents/docs/3.0developers_guide_protocol.html#UploadingDocs

Regards
Anup Singh

What specifically are you unsure about? And you'll need to accept some more answers to previous questions if you want people to continue to help you. — Daniel Roseman
– Daniel Roseman, Commented Jun 8, 2012 at 12:14

Community · Accepted Answer · 2017-05-23 12:18:58Z

2

A little late but here's the workflow:

See the answer here for proper OAuth authorization if your spreadsheet is private.

Your spreadsheet key can be found by going to Google Drive and looking at your spreadsheet. In the url is the string "key=xxxx". The 'xxxx' is your Spreadsheet key.

Then merely do the following:

var token = gapi.auth.getToken().access_token;
var urlLocation = ''; //put the spreadsheet key here
var url = 'https://spreadsheets.google.com/feeds/list/' + urlLocation + '/od6/private/full?alt=json-in-script&access_token=' + token + '&callback=?';

$.getJSON(url, function(data) {
    console.log(data);
});

edited May 23, 2017 at 12:18

CommunityBot

11 silver badge

answered Feb 8, 2013 at 7:14

Josh

3,4526 gold badges26 silver badges46 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Paul Watson Over a year ago

Thanks for this, it finished the start of the solution I found in the Google Docs where you had to get the gapi token set up with the rights scopes (spreadsheets.google.com/feeds) etc. developers.google.com/api-client-library/javascript/features/…

est · Accepted Answer · 2012-07-06 04:41:58Z

1

https://developers.google.com/gdata/samples/spreadsheet_sample

here is an example.

Note this JSON only works for "published" spreadsheets.

answered Jul 6, 2012 at 4:41

est

12k15 gold badges74 silver badges124 bronze badges

Collectives™ on Stack Overflow

fetch JSON from google spreadsheet using javascript

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related