download credentials.json: https://developers.google.com/sheets/api/quickstart/python
example spreadsheet:
https://docs.google.com/spreadsheets/d/1CX34Lyg2MDEV2TIzie-YoKhY5ZijoCFf9HmwQJePGNE/edit?usp=sharing
install it:
pip install --upgrade google-api-python-client google-auth-httplib2 google-auth-oauthlib
pip install jinja2
pip install setuptools