google-sheets-bootstrapping v0.3.0

Google Sheets Bootstrapping

March 8, 2022

Intro

Bootstraps a project to a google sheets app Exposes three functions to help with tihs: 1. loadCredentials

• param - credPath: String
• return: GoogleCredentialsInterface
• loads in a google credentials file and stores in memory as a GoogleCredentialsInterface

2. createAuthToken

• param - SERVICE_ACCOUNT_EMAIL
• param - SERVICE_ACCOUNT_PRIVATE_KEY
• return: JWT
• given a google email and private key from the credentials file, creates a Javascript Web Token to google sheets

3. createSpreadSheetConnection

• param: authClientObject
• return: sheets object
• given a google credentials object, returns a connection to google sheets in object form

Usage

see src/api/tests

Authors and acknowledgment

Joseph Skaf joseph@skafsjustbasics.com

License

MIT