google-sheets-reader

Node script to read private google sheet

Pre-requisites

node v9.4.0 or higher
Create a google console project
Enable google sheets API on the project from this link
Enable google Drive API from this link
Create a service account to access the google sheets from this link
Download client_secret json file for the created service account and add it to the root dir with name client_secret.json to access the sheet
Give the service account access to the sheet using the auto-created mail(from the downloaded json file)
Replace values in example.env with the correct values

Development requires installation of Javascript library modules using the Node Package manager.

The following command is run from the project's root directory.

  npm install

Then just run npm start to run the script.