Open dangerdak opened 7 years ago
The tutorials I've looked at which use googlesheets as a database, such as this one, all rely on making the data public (e.g. accessible by anyone with the link). The google sheets docs mention accessing private data using OAuth 2.0, but the flow they describe includes displaying a webpage to the user asking for their permission to share the data, which in this case would mean someone with permission for the FAC drive logging in to their google account. This seems to be targeted at user to server as opposed to server to server authentication.
It might be possible to do it by creating a 'service account' and granting it access to the private google sheet; service accounts are for server to server authentication. There is a tutorial for this here, and here are the google docs.
@BartBucknill using a config.json instead of config.env seems to deal with the Error: Error: error:0906D06C:PEM routines:PEM_read_bio:no start line
we were getting and make our test-run work. Maybe it deals with the "Special note to heroku users" in the docs.
The google spreadsheet api gets called during our tests atm as part of the test for '/report with querystring' in src.test.js
As an applicant I can see info about my meetup attendance. As a selection panel member I can see info about an applicants meetup attendance.
Acceptance criteria: