Skip to content

Pulls the MVP data from a Google Spreadsheet and makes it available as a JSON document.

License

Notifications You must be signed in to change notification settings

forestsync/mvp-data

Repository files navigation

MVP Data

Pulls data from this spreadsheet and makes it available as a JSON document.

Set up a Google Account to fetch the data

Using the Google Drive API

WARNING! Use a blank Google Account when setting this up on Continuous Integration

  1. Enable the Drive API: https://console.cloud.google.com/flows/enableapi?apiid=drive.googleapis.com
  2. Enable the Sheets API: https://console.cloud.google.com/flows/enableapi?apiid=sheets.googleapis.com
  3. Follow the Create the service account and credentials instructions and generate a key for the service account
  4. Store that file in the project folder as jwt.keys.json

You can now run

node export-to-json.js

GitHub Actions setup

Configure the secret service_account_jwt in the production environment with the contents of the file jwt.keys.json.

About

Pulls the MVP data from a Google Spreadsheet and makes it available as a JSON document.

Resources

License

Code of conduct

Stars

Watchers

Forks