Streaming live at 10am (PST)

Add and Update Live Item with Google Sheets

Hi everyone,
I was reading through the forum about Zapier integration that could help me update live items once a Google Sheets is updated but I’m a bit confused.

Here’s what I want to achieve: Create or Update live item every time Google Sheet add or update a row.

My plan:

  1. Add a row
  2. Create a Live Item
  3. Retrieve Live Item ID
  4. Update row with Live Item ID so I can reference it later
  5. Edit row
  6. Update item since I have a Live Item ID now

What I’m struggling with is #3 and #4

How can I actually retrieve Live Item ID with Zapier AND update the right row in Sheets?

I know I have to use API but a step by step help would be ideal or at least what kind of Zapier I have to use to get those two steps up and running.

2 Likes

Hi, @skacperski! I’ll make a video for you this weekend to show you how to accomplish this!

2 Likes

hi, do you have the video ? :smiley:

Video on this would be awesome! Please let me know when this is up.

Hi, @lemundibu and @MadeByMarius!

Here’s a link for you! :webflow_heart:

1 Like

Thank you Riley. However, I’m trying to submit items first to the google sheet > update Webflow and later update items on the google sheet and have that update Webflow.

You submit an item from Webflow to google sheets which gives you the ID and makes it easier to update items on google sheets once you have an ID…

The problem is that since im first posting content to the google sheet, so I won’t have a Webflow ID.
Planning on watching your youtube video on getting IDs via postman, but please let me know if there’s anyway we can start adding content to google sheets first and than still being up able to update that content later…

Thank you !

I figured it out! It took 1 Google sheet with 2 tabs and 2 Zaps. Here is how I did it, in case it helps anyone else…

I created 1 google sheet doc, with two tabs.
Tab 1 - to import/add new content
Tab 2 - where I can update the content on Webflow

ZAP 1 - ADD CONTENT & GET ID’s

Google sheet - Trigger - Create row
Pulls in new content that I add to Tab 1 in the google sheet.
+
Webflow - Action - Create live item
Displays the content on Webflow
+
Google sheet - Action - Create row
Webflow sends the item ID to Tab 2 so if I ever have to update the content I can.

ZAP 2 - UPDATE CONTENT FROM GOOGLE TO WEBFLOW
Now to update content I created another Zap-

Google sheet - Trigger - Create or Update Row
Any changes to the content in Tab 2 gets sent to Webflow, but all these rows have assigned IDs that Webflow sent back from my earlier zap.
+
Webflow - Action - Update live item
This displays the updated item.

So far its working well… (PS: updates for some reason take like 5m to trigger)

Hi everyone!

You can actually do this without even using Zapier or CMS (although w/ CMS is easier with multiple spreadsheets) with the Google Sheets API.

Here is a cloneable example of data coming from just a Google Sheet into Webflow. https://webflow.com/website/Google-Sheets-and-Chartjs

Google Sheet used: https://docs.google.com/spreadsheets/d/1Rz7bRjojp6CxhptfGIn7ITxGekd-RM7uUiBEE4V9cAQ/edit?usp=sharing

Hope this helps.