This is a question about Zapier more than Webflow but I hope my case use can nevertheless be informative for Webflow users.
I want to recreate the 3 tables and graph on this page https://tinyurl.com/cp4mcrda in Webflow. The data comes from Excel csv docs which are hosted publicly - new docs are created daily with the date in the URL. And so I would like, somehow, that relevant fields in the Excel docs get mapped to, and update, live items in the Webflow CMS.
In Webflow I can then create tables that update daily and use Chart.js to create the graphs.
My thinking would be to somehow get a Google Sheet updated daily with new data and then integrate with the Webflow CMS through Zapier.
Can anybody help me figure this out?
ps. I havnt included a link to my site as I havn’t even started the relevant page