/GoogleSheetsAPI_boilerplate

service to service with service account (2LO)

Primary LanguageJavaScript

All credits to [the fusebit tutorial]

Prereqs :

  1. npm ci to install exact dependency versions from package-lock.json

  2. You must share the sheet's file spreadsheetId@string on Google Drive to the service account provided on Google Cloud Console (hereinafter – GCC) at IAM section (Service Accounts)

  3. Once steps 1 & 2 completed, run the command npm run dev

NOTE : make sure the port in the index.js is freed (unallocated) on your OS, to db-check the port is free , use the command (Windows-oriented solution) : netstat -an | grep ':443' # instead of 443 put any other required port to check

Other documentation

  • Scopes to match against the ones granted through Google Cloud Console [list of scopes]

  • Google Sheets REST API : basic reading, writing, etc [generic reference]

  • Sheets API -> Reference -> Method : spreadsheets.values.get [reference]

    • Sheets API glossary, cells, ranges, ranges notation, etc. [reference]