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