783 backend write a cron job to automatically update a google sheet with the members

jeffplays2005 commented 4 weeks ago

Still semi-draft...

*. Update dependencies in server workspace

Create new script in package.json
Created new cron job(note that the cron is currently disabled and has workflow-dispatch for now).
Create fetchUsers method that fetches users from the backend
Create getAllUsers that fetches all the users from the backend using fetchUsers
Create authenticateGoogle method that returns a google auth client
- Note that documentation will come soon...
Create appendToGoogleSheet and clearSheet
- appendToGoogleSheet takes in the logs and auth client and updates the google sheet rows
- clearSheet clears the google sheet so that appendToGoogleSheet doesn't overlap everything

[!Note] The logic is still somewhat rough and could have improvements. Quite a lot of duplicate code and possibly better ways to update the google sheet instead of just appending and clearing every time.