Template Node.js and Express web backend server.

Follow these instructions to create a new Google Cloud Platform project and enable the Google Sheets API.

Download the Client JSON file and rename it to credentials.json. Place it in this directory (it will be ignored by Git).

Start the server with one of the following commands:

npm start

node app.js

Google will guide you through a process to authenticate the server. This will only occur the first time.

After creating the Google Cloud Platform project in Setup above, create a new set of credentials for the Service Account. Download the secret file and keep it safe.

Create a Heroku application with whichever method you prefer. In your deployment environment, set the following environment variables using values from the secret file:

Ensure that the client email has access to the Sheet; share access to it manually if necessary.