I’ve gotten a little bit further, but unfortunately there is a ‘wall’ that i hit.
You can only get the ID of (new) items if you also have a Zap for “create new item”.
There currently is no way to get newly added items in Google Sheets for example to sync on changes or new rows.
I haven’t set this up yet, but i believe you need 2 multi-step Zaps.
A Zap “Create new item” that adds a new Webflow CMS item when a new row is added in Google Sheets. This is the only way to get the (new) Item ID (or _id in the API). When this is being created, you need another step to add this Item ID to your Google Sheet as well, so when doing future updates/changes Webflow knows exactly what Item needs updating.
The second Zap is “Update (Live) Item” which can check other changes in your (existing) Google Sheet. It should then also have a column with the Item ID, and with that ID you can update a (Live) CMS item in the Webflow CMS.
If you already have items in your CMS/Collection in Webflow, then you need to use the API to retrieve all the Item ID’s (it’s called _id) and add them manually to your Google Sheet. Unfortunately there’s a limit of 100, but with an extra parameter “Offset” you can run the command multiple times if you have more than 100 items.
Then you need to get the (JSON) data merged into a temporary new Google Sheet and (carefully) merge the _id’s with your actual Google Sheet.
I have requested to get more functionality out of this.
I think more people start filling a Webflow Collection manually at first, or do a CSV import. But by doing so, you will get into quite the trouble if you want to sync this collection in the future.
I’d like to be able to get a new action in Webflow that can find the right Item ID, with the help of the “Item name” or possibly other variabel (your own custom ID# f.e.)
The workflow/sync does (only) work properly when you populate your Webflow Collection with Google Sheet data from the start - currently you can only get the Item ID when doing a “Create Item”.
The work around with the API, exporting the data and then reimporting into Google Sheets is quite the hassle, especially if you have more than 100 items.