Initial WIP -- doesn't do anything yet except auth with google
App to run locally to make charts out of google sheets data, because google sheets charts suck.
- Create a new project in Google's developer console and set up oauth credentials. Download the credentials json file.
cp secrets.example.json secrets.json
and copy the credentials you downloaded into it. Note that there are other secrets in this file so don't just overwrite it.- Create your master sheet in google drive and add its id to secrets.json.
- Create an initial empty tokens.json file:
echo '{}' > tokens.json
. node app.js
- Visit http://localhost:5000 and authorize with google.
- ... still working on the rest ... for now put some data in cells A1:F1 of your master sheet and you should see the output at http://localhost:5000.
- Going to be using C3.js.
- All chart options will be read from the main sheet, which might point to other sheets.