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?
4
-
1You can use google app scripts which triggers an event and also we ca use javascript developers.google.com/apps-scriptJeevan Dongre– Jeevan Dongre2013-01-12 05:08:58 +00:00Commented Jan 12, 2013 at 5:08
-
Thanks but it needs to be run on our own web page.Crashalot– Crashalot2013-01-12 05:32:16 +00:00Commented 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– Alex W2013-01-12 05:41:17 +00:00Commented Jan 12, 2013 at 5:41
-
2Thanks, @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– Crashalot2013-01-12 10:05:51 +00:00Commented Jan 12, 2013 at 10:05
Add a comment
|
1 Answer
It is possible, though I found it difficult. See here for all the details: https://developers.google.com/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.com/accounts/docs/OAuth2
See here for how to do that with Javascript: http://code.google.com/p/google-api-javascript-client/wiki/Authentication
1 Comment
Sunny Sharma
any inputs for doing it using C#?
