I have several Google Sheets sending data to Little Green Light. In the past few days I have noticed that they are being triggered in the middle of the night and sending duplicate data, even though no one in touching the files or updating anything.
Facebook Upload Zap, Trigger: New or Updated Spreadhseet Row in Google Sheets.
I paste Facebook transaction data into the spreadsheet, it sends new gift information to Little Green Light.
But last night it triggered at 4:28 am, the night before it triggered at 4:01 am. Because the previously pasted data is still in there, it sent it all again.
This is happening on another Google Sheet with the same format; ironicaly, it is NOT happening on a different Google Sheet with the same format, one that I created just a few weeks ago.
Is there a way to prevent ghost triggers in Google Sheets?
Best answer by jesseView original