Connecting to google spreadsheets using python Reference link:- https://erikrood.com/Posts/py_gsheets.html (1) Google Drive API, credentials Head over to Google sheets and create a file called “gps”. Add some dummy columns which could be programmatically accessed later when required.
Further, we need to create a service account and OAuth2 credentials from the Google API console. Follow the steps below to authorize the API and take hold of the credentials.
- Head over to the Google API console.
- Create a new project by selecting MyProject ->+button.
- Search for a ‘Google API drive’ and enable it.
- Move on to ‘Credentials’(side bar) and click on ‘Create Credentials’ -> ‘Service Account Key’.
- Select Compute Engine service, JSON, click create
- Open up the JSON file , share your spreadsheet with the XXX-compute@developer.gservice.com email listed.
- Save the JSON file wherever you are hosting the project because it will be needed to load in through python later.
(2) Connecting Python to Google Sheets: Install pygsheets (Refer link :- https://github.com/nithinmurali/pygsheets ) for more information about installing pygsheets . This library will allow to practically read/write to the sheet through Python. Once that is installed you are all set.
(3) Done-Check the sheet to see if the data is uploaded.
