I have a table on a Webflow site that contains a list of companies and has columns with different data relating to each company. I want this table to auto update. Each day the new data I need the table to have is published on a publicly available CSV doc.
The company names on this list don’t change, ie no companies are added or removed from day to day.
Ho do I use Zapier to update the Webflow CMS collection?
In Zapier I can schedule an import of that day’s CSV using a Zap with these actions:
- Trigger set to fire daily at set time
- Date/Time to format the current date to insert into the URL of that day’s CSV.
- Format>Utilities>import CSV file from the URL
But then, how am I going to use this to update the items in the CMS collection?
I can’t create a step 4 Webflow>Update Live Item because the required ‘Item’ field requires the item ID.
I can get the IDs into a Google Sheet by using Made by Marius’ two tab /2 Zap solution here 1
Ie. I would add a step 4 to above GSheets>Create New Spreadsheet Row(s).
Then another Zap triggers on GSheets > New or Updated Spreadsheet Row, then has action 2: Webflow>Create Live Item, and action 3: Create Spreadsheet Row in a second tab on the GSheet.
Now, then after doing the process once , I would have the company list on the GSheets’ first tab without IDs and on the second tab with a column of item IDs, and (if I’d deleted the CMS collection items before) then I would have a matching set companies in my CMS Collection.
But now what?
I can’t repeat this the next day as the Create New Spreadsheet Row(s) step at the end of the first Zap means I get all the companies listed twice on both the GSheets table and in the CMS collection. I only want to have the same companies once in the CMS collection.
Apart from the thread above, Ive also read with interest these other conversations on the forum including this one 1
but I can’t figure out how I can apply this in my case. Could anyone help me out?
Best answer by Troy Tessalone
A different possible solution would involved creating a Lookup Table.
If you can create a lookup table in GSheets or Airtable with the Webflow CMS Item IDs, then you can use one of these action steps in the Zap for each CSV row.
GSheets - Lookup Row
Airtable - Find Record