Programmatically update Google Spreadsheet with JavaScript? - Stack Overflow

admin管理员组

文章数量:1421921

Is it possible to update a Google Spreadsheet using JavaScript from a web page?

Scenario:

1) User lands on web page

2) JS script executes, modifying Google Spreadsheet

How can this be done?

Is it possible to update a Google Spreadsheet using JavaScript from a web page?

Scenario:

1) User lands on web page

2) JS script executes, modifying Google Spreadsheet

How can this be done?

• javascript

Share Improve this question Follow asked Jan 12, 2013 at 4:57 CrashalotCrashalot 34.6k6363 gold badges284284 silver badges461461 bronze badges 4

• 1 You can use google app scripts which triggers an event and also we ca use javascript developers.google./apps-script – Jeevan Dongre Commented Jan 12, 2013 at 5:08
• Thanks but it needs to be run on our own web page. – Crashalot Commented Jan 12, 2013 at 5:32
• @Crashalot Javascript can only access the current page, so you can't access Google's spreadsheet pages from your own web page. – Alex W Commented Jan 12, 2013 at 5:41
• 2 Thanks, @AlexW! We're aware of this, which is why we're asking if any APIs or Google libraries exist to allow JavaScript on external web pages to modify a Google Spreadsheet. – Crashalot Commented Jan 12, 2013 at 10:05

Add a ment  | 

1 Answer 1

Sorted by: Reset to default 1

It is possible, though I found it difficult. See here for all the details: https://developers.google./google-apps/spreadsheets/

If it is a private Google Spreadsheet then you'll need to deal with oAuth 2.0 (Google's authentication). https://developers.google./accounts/docs/OAuth2

See here for how to do that with Javascript: http://code.google./p/google-api-javascript-client/wiki/Authentication

本文标签： Programmatically update Google Spreadsheet with JavaScriptStack Overflow