On: Connecting to Google Sheets with Python

[franciscop]

I made the same thing for Node.js but without credentials. The main gotcha is that your spreadsheet is public (but unlisted). It also has some basic commands to use it as a Mongo database, or just use the array of data:

https://github.com/franciscop/drive-db/

I also made a small tutorial of how to use it:

https://serverjs.io/tutorials/spreadsheet/