Members Page

[srujandeshpande]

We need a page with all the members.

Rough Idea

• The data is currently stored in a Google Sheet
• The Google Sheet is linked to a Google Form
• We'd like to keep the form and sheet intact, in order to dynamically reflect changes now and in the future.
• The website must dynamically load data
• Some latency is allowed (and expected tbh)

Possible Approaches Option A. Find a way of directly interacting with Google Sheets. Option B. Once the data enters the sheet, it should update into Firebase

Things to consider

• Firebase is free
• Google Sheets has unlimited storage (Workspace account)
• AppScripts/GitHub Actions can be leveraged
• Sticking to the current stack is not necessary. If something like react-firebase is easier, that portion of the website can be in React.

[srujandeshpande]

Leave any suggestions here. Developments will also be updated here

[shreyaskaundinya]

I'd love to work on this!

Plan :

• Create the firebase firestore db
• Connect google sheets to firestore using the google sheets script to sync with the database
• Use the Firebase web SDK and react-query to communicate with react app
• Create reusable components in the react app to show the members