PYTHON TOOL FOR GOOLGE SHEETS

This tool is intended for connecting and reading data from the online spreadsheet of Google Sheets API.

Create virtual environment

python -m venv venv

Activate virtual environment (windows)

venv\Scripts\activate.bat

Install requirements

pip install -r requirements.txt

Readmore

https://gspread.readthedocs.io/en/latest/user-guide.html#getting-all-values-from-a-row-or-a-column
https://developers.google.com/sheets/api/quickstart/python
http://googleapis.github.io/google-api-python-client/docs/dyn/sheets_v4.html