We can read our google spreadsheets via pandas to be used in our analysis. We just have to get this part of the sharing URL https://docs.google.com/spreadsheets/d/[sheet_id]/edit?usp=sharing and the sheet name, then put it into this format https://docs.google.com/spreadsheets/d/[sheet_id]/gviz/tq?tqx=out:csv&sheet=[sheet_name].
We can then put this url into pandas.read_csv().
And of course I build a react app for this. It’s this one. Because why not.