I have a public google sheet that has a bunch of license keys. I am trying to automate the read and write process from said sheet. eg. take code, run it, mark it as used.

After reading https://medium.com/analytics-vidhya/how-to-read-and-write-data-to-google-spreadsheet-using-python-ebf54d51a72c

as well as the Google's tutorial https://developers.google.com/workspace/guides/create-project

Both of those instructed me to create a google cloud platform account. Since the sheet is public, has anyone managed to read/write without it?

CodePudding user response：

To make requests to a Google Workspace API with a Python command-line application, you need to complete a couple of steps in the Google Cloud Platform Console. In this case if you're using the Google Sheets API to access a Google Sheet even if is public, you need the following prerequisites which asks you to have a Google Cloud Platform project with the API enabled and create credentials for your application in the GCP console.