Set up Oauth for wins data google sheet

[jbubar]

Overview

The wins data is currently in a spreadsheet that is visible to anyone with the link. Bonnie pointed out, that this is not ideal. In order to make this work we have to set up Oath.

Action Items

• set up OAuth with through the developer console
• Change sharing settings to restricted to test it locally
• change share settings back
• change share settings to restricted after this is merged

Resources/Instructions

sheet
Oauth documentation from google
Helpful article about connecting a team roster
https://github.com/google/google-api-javascript-client/blob/master/docs/auth.md

[jbubar]

Currently setting up Oauth. On the second step of the google guideline, and I am trying to learn how it works along the way.
I will continue working on this tomorrow

[jbubar]

i am anticipating significant progress on this next week.
progress: found some great resources, with the help of akib and bonnie
blocker: this is new to me
availability: I will be a bit more available next week
ETA: 2 weeks

[jbubar]

Made some progress. Put a few hours into this test repo.. Looks promising.
I think I should have this done before next weeks meeting

[jbubar]

thanks @akibrhast for your help, and for taking this over.

• Tutorial I've been using
• working repo after following tutorial
• Attempt to integrate with gh actions

[akibrhast]

Progress

Work in Progress

Blockers

Awaiting closure on

• 1255 refactor current data into data external #1267
• 1268 reorganize data only collection to data subdir #1269

Availability

Here and There

ETA

Approximately not more than 2 weeks from when the above pull requests will be closed

[akibrhast]

Progress

WIP

Blockers

Needs permission to google cloud console from @ExperimentsInHonesty

Availability

ETA

[qiqicodes]

@akibrhast Can you let us know your progress in regards to this issue? Thank you =]

Progress:
Blockers:

[akibrhast]

Progress: None
Blockers: Vrms,civictechindex
ETA: 2 weeks?

[erikaBell]

• Figure out how to trigger google app script through a cron job, within the context of the app script
• Implement, said trigger, every 24hours and extract "TRUE" data from sheets & write to file in hack4la/website/_data/external/_wins-data.json

[qiqicodes]

@erikaBell Can you let us know your progress in regards to this issue? Thank you =]

Progress:
Blockers:

[erikaBell]

FINISHED (-:

Google App Script maintaining wins page data updates