Serverless Finance

send balance in google sheets to SMS notification phone numbers. runs daily. SMS numbers stored in SSM parameter store.

• access to google sheets doc is via Google APIs Node.js Client. OAuth is used to authenticate and the first time requires user interaction. credentials.json contains the OAuth details and token.json contains access_token, refresh_token, etc.
• you must generate credentials.json and save in the root
• token.json is created on first run and required manual interaction
• To update functon with token.json, run locally which will generate token.json, then deploy.

Running

# install deps
npm install

# copy `.env.sample` and update
cp .env.sample .env

# run tests in watch mode
npm run test -- --watch

# run tests
npm run test

# deploy
npm run deploy

# manual run of `notifySubscribers` function
SLS_DEBUG=* ./node_modules/.bin/serverless invoke --function notifySubscribers

TODO

• store and maintain token.json contents in secrets manager