Streaming live at 10am (PST)

Help w/ Live Data Viz ? COVID-19 Vaccine Tracker pulling from Google Sheet

Hi there,

I am currently trying to create a live COVID Vaccine Tracker with some friends, we are trying to pull data from this open-source Google Sheet.

I would like it to be able to pull info from this Google sheets as it’s updated. I am aware of the zapier integration, and have made a quick testing page where the chart inherits data from CMS values (using this tutorial, thanks @pixelgeek !) from a re-formatted CSV sheet.

But I’m wondering if there is an easier way to pull the data from the source live, so this tracker would auto-update as vaccines move in development.

Can someone recommend the best way of going about this? I am not a strong coder but could learn a bit of .js if needed, but would prefer the “no code” route :wink: .

See what I’ve started on below! (but please note, it’s still in progress and there isn’t tracking anything yet!)
https://preview.webflow.com/preview/1p-vac-trac-testing?utm_medium=preview_link&utm_source=dashboard&utm_content=1p-vac-trac-testing&preview=9e363236034b28c4aaf751d4c3c8c11f&mode=preview

Page doesn’t exist, I can’t see the site. I studied vaccination quite a lot and read a lot of works on this topic https://studydriver.com/vaccination-essay/. I also collected feedback and experience from my friends and people around me, consulted with doctors. If you have any questions during the work, you can write me PM and I will try to help you.