About Zapier Community
New to our Community? Get to know more about our space and how to make the most of your time here.

Code of Conduct Community FAQ's Zapier Common Questions What to Expect

Get Started With Zapier
New to Zapier? We have got you covered with our Zapier 101 Resources.

Zapier Essentials

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Zapier Reading
All of our best learning resources can be found here.

Featured Articles Show & Tell AI Hub Zapier Tools Hub

Learning Groups
Excited to meet other builders? Check out our interest areas full of doers, dreamers, and in-betweeners.

User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

Question

Daily updates in Excel to find and update items in Webflow

  • 19 May 2021
  • 2 replies
  • 107 views
P
Userlevel 1
Badge

Hi Everyone

I wanted to confirm that what I am trying to is possible, and also find out if there is an easier integration than the one I’m planning. 

I want to recreate the 3 tables and graph on this page (https://tinyurl.com/cp4mcrda) in Webflow. 

The data comes from 4 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.

Is this possible using Zapier? Perhaps the best way would be to somehow get a Google Sheet updated daily with new data and then integrate this with the Webflow CMS..

Can anybody help me figure out how I can do this?

Many thanks!

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

2 replies

SamB
Rank
Userlevel 7
Badge +11

Hey @P111x,

Perhaps you could email a copy of the CSV files to yourself and use an email app for the trigger step, like Gmail’s New Attachment trigger. Then use a Formatter (Utilities > Import CSV File) step to extract the contents of the CSV file and pass that over to a Google Sheet using a Create Spreadsheet Row(s) action. 

That would get the CSV information added into individual rows of a single spreadsheet. Then you can set up a second Zap that triggers whenever a New Spreadsheet Row is added in Google Sheets and use the Create Item Webflow action to add it into Webflow. 

If you’ve not worked with Formatter before, we’ve got a guide on how to use Formatter to import a CSV file here: Import CSV files into Zaps

I hope that helps get you pointed in the right direction!

P
Userlevel 1
Badge

Hi Sam. Thanks for your reply. 

I wondered about this first step. The emailing. Is this something I can automate? The thing is, new CSV files are created every day, and the URL of the new files have the date in. Could you explain to me how I could use email automatically to get these? Or is there a way to schedule an import of an Excel CSV daily from a URL that has the present day’s date in it.

I agree that getting the info I need into Google Sheets first sounds like a good way to go. Do you think I could overwrite the fields of a Google Sheet with new CSV data every day? Mapping the columns of a Google Sheet to update or create Webflow Live Items has been shown to work ( tho there’s a thing about getting the Webflow CMS item IDs - as covered and worked around nicely in this video https://www.youtube.com/watch?v=tkD0UhNJElA. )

I have so many doubts about the possibility of doing this - could you say something to give me some hope...  There must be a way, surely?

Terms & Conditions