Zapier - CMS Update Item

Hello!

I want to update a CMS Item, but I do not know how to provide the ID for the Zap.

Does anyone know what to write here?

I can’t find any simple solutions on the internet, and no one seems to tell how to do it on similar posts.

Best
Malthe

I get mine from an API call. No reason you can’t populate a google sheet from the JSON returned from the; https://developers.webflow.com/#get-all-items-for-a-collection api call. You would need to just convert the JSON to CSV. There is an online converter at the top of a Google search.

You could use getpostman.com to work with the API.

1 Like

Not sure if @Malthe_Risager_Jorge needs this as well:

But i need to populate the Webflow CMS from a Google sheet.
To make Zapier work, i need the “item ID”.

As far as my research has gone, this is a variabel from the e-commerce collection(s) on webflow, and somewhat strangely, isn’t available in regular collections.

I really need this, because we change data to around 400 data-items regularly, and i can’t update them in Webflow, but to do them manually one-by-one.

Can anyone help to get (or sync) data from Google Sheets to Webflow and update/change existing data?

1 Like

Add a step in your Create Item zap using Zapier Storage to store the _id of the newly created webflow item. You can then retrieve the value of _id from Zapier Storage and use it in the Update Item zap.

Toggl Updated Project
+
Zapier Storge (get value)
+
Webflow Update Item

1 Like

I think I just solved this in another thread: Zapier - update CMS live items via update csv

Byteline has just launched an Upsert task to add or update Webflow CMS items using a single task.

You don’t need to implement any logic to figure out the ID to update. We recently did a Webflow showcase to demonstrate it. Please check it out here for details. We would love to get your feedback.

(Disclaimer: I work on this startup)