Hi there @Dan Bell 

There’s a Trigger Column field on New or Updated Spreadsheet Row trigger can be used to set it to only look at updates in a specific column, but it will always trigger for a new row that’s added. Google Sheets identifies each row by it’s row number and uses that as it’s unique ID. When you remove a row at the top of the spreadsheet that will change the row number/IDs of all the rows below it so the Zap will see it as new information that has appeared in each of those rows.

So it’s recommended that you don’t delete existing rows or columns while the Zap is switched on. If you do need to delete a row, instead of adding a filter it’s best to turn the Zap off first, then delete the row before then turning the Zap back on again. 

Can you try that approach and let me know whether that allows you to make the necessary changes to your Zap without it triggering unexpectedly?

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.

That’s a fantastic workaround @Dan Bell! And thanks so much for sharing it here. I’m sure that approach will be super useful to other folks running into similar issues with Google Sheets and come across this post. 

If you have any further questions or if there's anything else we can help with do let us know. Thanks again!