Web-App

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.

Embedding image URL from google drive is actually easy. We just have to convert the URL we got from google drive from this format https://drive.google.com/file/d/[image_id]/view?usp=sharing to this format https://drive.google.com/uc?export=view&id=[image_id]. Even easier, just use this tool I make: gdrive-url-converter I build this tool using React as I have not got a chance to play with React for a long time. It is a good exercise to flex my front-end muscle. ...