These are utilities used to import answers from Google Drive into Coda. Coda is used as the central database for the Stampy project. It has an integration with Gdocs, where it will automatically detect new documents and add a row for them in the Answers table. The Coda sync process doesn't import the actual content of the Gdocs, only their metadata. This repo contains tools to do the actual import of the content to Coda, along with additional formatting of the data.
Make sure you have node installed, then run npm install
.
The project pulls and pushes data from Gdocs and Coda. It also can (optionally) notify Discord about certain
things. For this to work, it requires authentication keys etc. to be available via env variables. These can
(and probably should) be provided via an .env
file. The following vars should be set for things to have a
change of working:
CODA_TOKEN
- used to get RW access to the Coda tableGCLOUD_CREDENTIALS
- used to access Google Cloud. This can be skipped, if a valid credentials.json
file is provided insteadCreate a Coda token with RW access to the Answers table and set the CODA_TOKEN
variable.
This one is quite complicated. And may also change, since it's Google...
Set up a Google Cloud Platform (GCP) project and enable the Google Docs API. You can follow the instructions in the official documentation here.
Create a service account and download the service account key JSON file. You can follow the instructions in the official documentation here.
Either save the downloaded file as credentials.json
, or set GCLOUD_CREDENTIALS=
to its contents (without newlines)
Once the new project is created, click the hamburger menu in the top left corner of the page and select "APIs & Services" > "Dashboard".
Click the "+ ENABLE APIS AND SERVICES" button at the top of the page.
Search for "Google Docs API" in the search bar and select it from the results.
Click the "ENABLE" button to enable the API for your project.
Repeat steps 5-7 to enable "Google Drive API"
These are totally optional. If not provided, any logging to Discord will be skipped.
DISCORD_ERROR
- a secret webhook for a channel to which errors should be loggedDISCORD_FEED
- a secret webhook for a channel to which questions with hanging comments should be loggednode bin/importContent.js