Zapier - update CMS live items via update csv

For those looking for a solution to updating live items in a collection with #nocode here’s how I did it with just Zapier.

  1. Create a form in Webflow to capture data (or spreadsheet or any data source Zapier supports) then setup the first step of your zap get the data.

  2. Create a Webflow collection with whatever data fields you want, but make sure you create a field called “Item ID” or whatever you prefer and leave that collection field empty and not required (I don’t recommend just “ID” because it will confuse you later).

  3. Use the “Create Live Item” step to turn your data from the first step into collection items. Map it all how you want. You wont link any fields to the “Item ID” field yet.

  4. Create another step to “Update Live Item”. This is the third step in your zap (FYI you’ll have to pay for a Starter plan to use 3 or more steps). Now in this step choose the data output from the previous “Create Live Item” step and you’ll see that the ID of the new live item is now in the list to choose from! (This is why you don’t want to label your custom field “ID” in step 2 above because you won’t be able to tell them apart) Map this ID to the “Item” field AND map it to your custom “Item ID” field so you can use it later.

Boom. That’s it. Now you can create more zaps that can update live items because you’ve saved the Item ID in your own custom field that will show up in any new zap!

6 Likes