Node Service to read/write to Google Sheets

Getting Started

• Enable the Google Sheets API in the Google Developers Console
  • Create a Service User account and email address
  • Copy the Project ID
  • Download the connection Keys JSON file, and save it in the root project directory as: google_service_account_credentials.json
• Create the .env file

cp .env.example .env

Test the Service

Export the env variables or pass them as arguments

SHEET_ID=######### SHEET_NAME=Sheet1 npm run test

References

• Google APIs: NPM googleapis
• Documentation for Google API Node.js client. https://github.com/googleapis/google-api-nodejs-client
• Official Google Sheets API reference. https://developers.google.com/sheets/api/reference/rest
• Google Developers Console: https://console.cloud.google.com/projectselector2/iam-admin/serviceaccounts?supportedpurview=project
• https://hackernoon.com/how-to-use-google-sheets-api-with-nodejs-cz3v316f
• https://developers.google.com/sheets/api/reference/rest#rest-resource:-v4.spreadsheets.values