I have a ZAP that is triggering anywhere from 2-4 times on a single row in Google Sheets; here is the ZAP run….
This is the ZAP trigger on the same row about 10 minutes apart.
There are 2 Google Sheets; Google Sheet #1 is the primary sheet and in that sheet is an array formula that will complete a blank column when a “match” is found. The second Google Sheet is just a Query function of the first Google Sheet, and when a match is found it is exported to the Google Sheet. I chose to set up my ZAP this way because I wanted it to trigger on a ROW as opposed to triggering on a correct value in a column (ie., triggering on a change in a row).
What I guess is happening is that Google Sheet #1 cycles or calculates the array formula as new data comes in and the values in the array column disappear and re-appear (which means the Query function data in Google Sheet #2 disappears too) and thus the ZAP interprets it as a new row once it is calculated again. I don’t that should be because it is not a new row as the data is not new and data just disappears and reappears after the calculation on Sheet #1.
Once again, I chose not to use the change in row function as the trigger because I found this ZAP process somewhat unreliable.
Thoughts?
GML
