@zaneray/google-sheet #

Wraps 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.

$3

Making it easier to manipulate Google Sheets

$3

* 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

$3

* Writing tests
* Code review
* Other guidelines

$3

* yourself, it's kind of scary