Can someone further explain to me the dedup column? I have a google sheet being read as the trigger when a row is updated, and I have it writing to another google sheet as the action (all test stuff). I have set the Trigger column to something like ‘COL$H’, and its looking for cell data within a certain row like ‘Spreadsheet Row D’, the data in the row gets sent to the other google sheet when that data has been updated.
Now the trigger only happens when the cell under ‘COL$H’ and Spreadsheet Row D is updated. Which is how I want it, since the zap would fire too many times otherwise. Can someone explain to me why that works? Why only changing the cell data in COL$H - Row D makes the trigger happen?
Best answer by ZaneView original