@zaneray/google-sheet
v0.3.2
Published
Google Sheet Convenience Methods
Downloads
13
Maintainers
Keywords
Readme
@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.
What is this repository for?
Making it easier to manipulate Google Sheets
How do I get set up?
- 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
Contribution guidelines
- Writing tests
- Code review
- Other guidelines
Who do I talk to?
- yourself, it's kind of scary