README.md

Google Sheets Python

Simple proof of concept to read and write from Google Sheets using OAuth2 and gspread.

Documentation on creating auth credentials

Setup

Install the required dependencies:

pip install -r requirements.txt

Run main.py:

python main.py

Note about permissions:

Any spreadsheet you intend to access with this library has to first be shared with the client-email generated in your OAuth credentials JSON.

Example email:

"client_email": "python-sheets@api-test-1234567890123.iam.gserviceaccount.com",