I have a table 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.
The company names on this list don’t change, ie no companies are added or removed from day to day.
What about using 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
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, has action 2 as Webflow>Create Live Item, and action 3 of 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 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
but I can’t figure out how I can apply this in my case. Could anyone help me out?