Probably relevant:
https://groups.google.com/d/topic/google-spreadsheets-api/TxFry-Uoqo4/discussion
On Tuesday, August 11, 2015 at 5:17:39 AM UTC-4, Panagiota Mitsopoulou
wrote:
>
> Hi,
>
> I am working on a web application that needs to send data to a non-public
> google spreadsheet, so I need to implement OAuth2 for authorization and
> authentication. After some research I managed to authorize using OAuth2.
> Here's my sample code in python.
>
> from oauth2client.file import Storage
> from oauth2client.tools import run_flow, argparser
> from oauth2client.client import OAuth2WebServerFlow
> import json
>
> import gdata.spreadsheets.client
> import gdata.spreadsheets.data
> import gdata.gauth
> import flask
>
> app = flask.Flask(__name__)
>
> @app.route('/')
> def index():
> storage = Storage("creds.dat")
> credentials = storage.get()
> if credentials is None:
> CLIENT_ID = 'XXXXX'
> CLIENT_SECRET = 'YYYYYY'
>
> flow = OAuth2WebServerFlow(
> client_id = CLIENT_ID,
> client_secret = CLIENT_SECRET,
> scope = 'https://spreadsheets.google.com/feeds',
> )
> credentials = run_flow(flow, storage, argparser.parse_args([]))
>
> gd_client = gdata.spreadsheets.client.SpreadsheetsClient()
> gd_client.auth_token =
> gdata.gauth.OAuth2TokenFromCredentials(credentials)
> print
> gd_client.GetWorksheets('1kQYXDck9IE4B2vcfvx79rxJSIWx0WKjLMvj9jmfKF58').title.text
>
> entry = gdata.spreadsheets.data.ListEntry()
> entry.set_value('jobid', '456')
> entry.set_value('searchquery', 'test2')
> entry.set_value('url', 'http://example2.com')
> gd_client.add_list_entry(entry, 'SPREADSHEET_ID', 'WORKSHEET_ID')
>
> return 'OK'
>
>
> if __name__ == '__main__':
> import uuid
> app.secret_key = str(uuid.uuid4())
> app.debug = True
> app.run(host='0.0.0.0', port=8080)
>
> Using this sample code, I was able to use google spreadsheets api and add
> new entries in the specified spreadsheet.
>
> My problem now is that access_token expires after one hour, so I've read
> that I need to use refresh token instead. In this post
> http://stackoverflow.com/questions/7964711/authorizing-requests-with-oauth-2-0-in-google-spreadsheet-api
>
> in the accepted answer, it is mentioned that I should generate a refresh
> token, but question is how?
>
> I was also wondering maybe I am in the wrong direction and I should use
> Server to Server authentication
> https://developers.google.com/identity/protocols/OAuth2ServiceAccount
> instead? Because I have a web form, where different users submit their
> answers and I want to save their entries in a common spreadsheet. If Server
> to Server Application is my case, then question is if I need a Google Apps
> domain. I got stuck in this section "Delegating domain-wide authority to
> the service account" where there was a link to the Admin console and I
> figured out that I need to buy a google app domain. Is this step mandatory
> or I can still use Service account from the developer console without
> google app domain?
>
> Thanks,
> Panagiota
>
--
You received this message because you are subscribed to the Google Groups
"Google Spreadsheets API" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.
