I'm using the 'New or Updated Spreadsheet Row in Google Sheets' as the entry point to one of my Zaps.
When a new row is added to the spreadsheet, the Zap triggers as expected.
I have a filter as the send step in my Zap. This filter stops the following steps if a particular cell is empty in the row.
For a new row to the spreadsheet, as I said this Zap is working correctly. The new row is added, the cell in question is empty, and the filter stops the Zap right there. Perfect.
The problem is that when I go in later and update the cell to a value that will pass the filter, the Zap isn't triggering.
It's as if the 'New or Updated Spreadsheet Row in Google Sheets' is only triggering for a new row, not an updated row.
Is anyone else having this issue? Where you able to figure out what the problem was?
Ideally, the Zap should trigger with the changed cell and it should pass the filter and perform the remaining steps in the Zap.
I feel like I'm doing something wrong, but I can't see it.
Best answer by jesse
Hey friends! Just wanted to summarize and provide clarity on some of the issues here:
If you have a Y in the cell, then delete it, and then add the Y back in, the Zap won't trigger. The way that the Zap checks for updates isn't all that sophisticated - it 'remembers' the cell and the value in it, it will only trigger if changes are made that it hasn't 'seen' before.
Upon further investigation, the fact that sometimes the Zap isn’t triggering even when the update is new, appears to be a bug that our support team is currently investigating. We’ll update this thread once we know more.