Skip to main content
Create / Update
Delete

Hi Zapier community! Thank you in advance and im sorry for the noob question but its my first time getting a automation done.

I'm working on a

and I’m running into a logic issue. My goal is:

- When a row is edited in Google Sheets, Zapier should:
   - If `Visibility` is TRUE:
     - Check if the item exists in Webflow (based on a slug).
     - If it doesn’t exist, create it.
     - If it exists and any field has changed, update it.
   - If `Visibility` is FALSE:
     - Check if the item exists in Webflow.
     - If it exists, delete it.

Right now, I have one Zap for create/update logic and another one for deletion and im using a AppScript for an automatic update as any line is edited to work as a trigger. However, I’m seeing two issues:
1. When I change a visible row, only the deletion Zap is triggered, not the one for create/update.
2. I’m not sure how to ensure Zapier makes the right decision when the row is edited — especially to avoid missing updates or performing the wrong action.

What’s the best practice for this kind of conditional workflow? Should I:
- Split the logic into three Zaps (create, update, delete)?
- Use Paths or filters in a single Zap?
- Or is there a better approach altogether?

Thanks for any insight!
 

Hi ​@prvisualdesign 
Zap trigger: GSheets - New or Updated Row

This will trigger for NEW Rows AND for UPDATED Rows, so make sure to include a Filter as Zap step 2 to check the desired row data conditions are met.

 

Help links for using GSheets in Zaps: https://zapier.com/apps/google-sheets/integrations#help

NOTE: GSheets Zap triggers are not instant and trigger in near real-time.

Check your Zap Runs history details for activity and errors: https://zapier.com/app/history/

 

Probably best to use 1 Zap with Paths to handle the different conditions.


Hi there, ​@prvisualdesign 👋

How did you get on with Troy’s suggestions here. Were you able to get the conditional logic for the Zap sorted?

Keep us posted on how it went, want to make sure you’re all set!


Reply