Create a service account for google sheets

Create a service account in your project

Create a new key using json, download it as well as rename it and put it in the same folder as the code

Add your service account in your spredsheet

If you want to keep it private then don't publish it

The spredsheet ID

Spredsheet ID is the blue marked URL