How can I retrieve a Live Item ID and update the corresponding row in Google Sheets using Zapier integration with Webflow?
TL;DR
- Retrieve the Webflow Live Item ID via Zapier output after item creation or by using a Webhook with a GET request and filtering results.
- Match and update the corresponding Google Sheets row using "Find Row" and "Update Row" actions, storing the Live Item ID for future Zap updates.
To retrieve a Live Item ID from Webflow and use it to update a matching row in Google Sheets via Zapier, follow these steps.
1. Understand Why the Live Item ID Is Needed
- Webflow CMS items are uniquely identified by a Live Item ID.
- Zapier’s “Update Live Item” Webflow action requires this ID to make changes.
- You often obtain this ID after a form submission or trigger, or by querying the collection.
2. Retrieve the Live Item ID from Webflow
There are two common ways to get a Live Item ID via Zapier:
- After Creation: If the item was just created in Webflow (e.g. from a form), the Create Live Item action will automatically output the new Live Item ID.
- Search Existing Items: Use the Webhooks by Zapier action to make a
GETrequest to the Webflow CMS API to find the item: - Endpoint:
https://api.webflow.com/collections/{collection_id}/items?live=true - Add filters in the query (client-side) to match the item by name, slug, etc.
- Parse the result using a Zapier Code step or Filter to extract the correct Live Item ID based on matching fields.
3. Match and Update the Row in Google Sheets
Assuming you already inserted or have a row in Google Sheets representing the item:
- Use “Find Row” action in Google Sheets:
- Match the row using a unique identifier (e.g. name, email, slug) that corresponds with the Webflow item.
- Use “Update Row” action:
- Once the row is found, write the Webflow Live Item ID into a column (e.g.,
webflow_id). - This prepares your sheet for future updates triggered by changes.
4. Optional: Store the Live Item ID for Reuse
- Saving the Live Item ID in Google Sheets means you don’t have to retrieve it each time.
- On future Zaps (e.g. submission from Airtable or another update trigger), you can:
- Use this stored ID directly in the Update Live Item in Webflow.
5. Use Zapier’s “Update Live Item” Step
- In your Zap, add an "Update Live Item" action.
- Choose the Webflow site, collection, and then map the Live Item ID (either retrieved or stored).
- Map the CMS fields you want to update with dynamic data.
Summary
To update a Webflow CMS item via Zapier and also keep your Google Sheets synced, you need to (1) retrieve the Live Item ID using Zapier output or Webhooks, (2) use that ID to update the matching row in Sheets, and (3) leverage stored ID values for future updates.