Google Sheet Convenience Methods
npm install @zaneray/google-sheetWraps sheet authentication and provides utility methods for transforming the
data in the Google Sheet 'tabs' cells to more convenient, static data structures.
See test/test.js for usage example.
Making it easier to manipulate Google Sheets
* checkout project using GIT
* copy .env-sample to .env, and fill in meaningful values
** GOOGLE_PRIVATE_KEY is a Google Cloud JSON private key for the service account used to access the sheet. You would need to share the sheet to the account belonging to the key.
** GOOGLE_SHEET_ID is the ID if the Google Sheet, found in the URL. Fot this URL https://docs.google.com/spreadsheets/d/1xs4B1w-gKbfJJDtPpIiTbAww1Nkpx_HyhqZ334uasvc/edit?gid=1040014352#gid=1040014352 the GOOGLE_SHEET_ID is '1xs4B1w-gKbfJJDtPpIiTbAww1Nkpx_HyhqZ334uasvc'
* npm install
* npm run test
* Writing tests
* Code review
* Other guidelines
* yourself, it's kind of scary