I am following this guide by google, on how to access a spreadsheet with a python library. But: Then I have to write my google username and password without encryption in a python script, which is a huge security issue for me, especially, when you give the script away to others.
So: Is there a way to write to a (public) Google spreadsheet with python without providing a username & password?
The OAuth 2 hint was a good one. I found PyDrive.
From the docs of PyDrive:
Drive API requires OAuth2.0 for authentication. PyDrive makes your life much easier by handling complex authentication steps for you.
http://localhost:8080/ for both ‘Redirect URIs’ and ‘JavaScript origins’.client_secrets.json is the file that has all authentication information of your application. Put this file in your working directory.
from pydrive.auth import GoogleAuth gauth = GoogleAuth() gauth.LocalWebserverAuth() # Creates local webserver and auto handles authentication Run this code and you will see a web browser asking you for authentication. Click Accept and you are done with authentication. For more details, take a look at documentation: OAuth made easy.
auth.py, than just import it in your main file. And never shareauth.pyClientLoginis only one of the authentication mechanisms, and not the usual one you want to use. You can also useAuthSub,OAuth, or (usually the best)OAuth 2. Read more of the documentation than just the hello world example, e.g., Authorizing Requests in the Google Spreadsheets documentation.