How can I retrieve a Live Item ID and update the corresponding row in Google Sheets using Zapier integration with Webflow?
TL;DR
- Trigger a Zap from Webflow on item creation or update, capturing the Live Item ID.
- Store that ID in Google Sheets, then use it for future lookups and row updates to keep data synced.
To retrieve a Live Item ID from Webflow and update a corresponding row in Google Sheets using Zapier, follow these steps to sync collection item changes efficiently.
1. Understand Why the Live Item ID Matters
- Webflow CMS items have two types of IDs: a Draft ID and a Live Item ID.
- Most API actions—including updates or deletions—require the Live Item ID.
- Zapier’s standard Webflow triggers (like “Item Created” or “Item Updated”) often return the Live Item ID, but you need to capture and store it properly in Google Sheets.
2. Set Up Webflow Trigger in Zapier
- Create a new Zap in Zapier.
- Choose Webflow as the app.
- Choose the trigger event: either "Item Created" or "Item Updated".
- Connect your Webflow account and select your site and collection.
- The trigger should return all live item details, including the Live Item ID (
_id).
3. Store the Live Item ID in Google Sheets
- Add a new action step in your Zap:
- App: Google Sheets
- Action Event: Create Spreadsheet Row
- Map the Webflow data fields into the spreadsheet columns.
- Make sure to include a column in your spreadsheet for the Live Item ID (
_id). This is crucial for identifying and updating the correct row later.
4. Use Lookup to Find the Right Row Later
- To update an existing row in future updates (instead of creating duplicates):
- Insert a step before the Google Sheets update that uses the “Lookup Spreadsheet Row” action.
- Search by a unique field from Webflow, such as slug, name, or preferably the Live Item ID.
- After the lookup, use the returned Row ID in the next step to update it.
5. Update the Row in Google Sheets
- Add another action:
- App: Google Sheets
- Action Event: Update Spreadsheet Row
- Use the Row ID from the lookup step.
- Map the fields again with the latest data from Webflow.
6. Test the Full Zap Workflow
- Make changes in your Webflow CMS Collection.
- Manually run or wait for the Zap to trigger.
- Confirm the correct row in Google Sheets was found and updated using the Live Item ID as a key.
Summary
To update a Google Sheets row using a Webflow Live Item ID, trigger a Zap on a Webflow CMS change, capture the Live Item ID in Sheets, then use a lookup and row update logic in future Zaps to ensure synced updates without duplicates.