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 .
See what I’ve started on below! (but please note, it’s still in progress and there isn’t tracking anything yet!)