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.
- Add a row
- Create a Live Item
- Retrieve Live Item ID
- Update row with Live Item ID so I can reference it later
- Edit row
- 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.