I have set up a zap that triggers when a row is new or updated on a Google Sheets spreadsheet. This is working well and triggering consistently.
However, it also triggers every time a row is moved. So for example if I have 10 rows and delete the first row, the zap triggers for the following 9 rows as they have all moved up a row technically so it sees the cell it looks up as “new”.
I am struggling to figure out how to configure it so it only fires when a specific cell is updated and exclude when a row moves. I figured a Filter step would be a logical option, but I’m not sure how to set it up for my use case. Any ideas? Thanks!
Best answer
How do I stop my Google Sheets Zap from triggering when rows are moved?
Best answer by Dan Bell
Thanks. We found a workaround for our purposes by adding a date column in our sheet, and a filter step so the zap only runs if the date in that column matches whatever today’s date is. The zap does still trigger but it stops at the filter step for all of the rows we don’t want updates for.
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.