Show OKR week trends from Google Sheets on a Mozaïk dashboard
JavaScript CSS
Switch branches/tags
Nothing to show
Clone or download
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Permalink
Failed to load latest commit information.
src
styl
.babelrc
.eslintrc
.gitignore
.npmignore
LICENSE
README.md
client.js
components.js
package.json
yarn.lock

README.md

mozaik-ext-okrs

Setup

  • Install module

    npm install --save mozaik-ext-okrs
  • Create a project and service account in Google Developer Console

  • Enable API: Drive API

  • Collect service email and .p12 file

  • Convert .p12 file into .PEM openssl pkcs12 -in *.p12 -nodes -nocerts > sheets.pem

  • Configure service key and .PEM file into dashboard config.js file and environment variables / .env file:

    api: {
      okrs: {
        googleServiceEmail: process.env.GOOGLE_SERVICE_EMAIL,
        googleServiceKeypath: process.env.GOOGLE_SERVICE_KEYPATH
      }
    }