Google Sheets Watch Changes Webhook is triggered 3 times in the same second instead of once

How To
1

I’m using the “Watch Changes” module of Google Sheets. My objective is to trigger an automation from changing the value of a specific column in my spreadsheet.

The issues I’m facing is the following: As soon as I’m changing the value of a cell in that specific watched column, the webhook extension from make in google sheets sends 3 POST request in the span of a second triggering the make automation 3 times instead of once. Those requests all get accepted even though I’ve added filters for duplicates, because it happens in a span of a second not giving the automation to set the specific row as processed.

My primary goal is to fix the webhook logic, limiting make’s google sheet extension to only send one POST request at a time for each change in the watched column.

Thank you in advance for taking the time to help me.

2 Likes
2

I’m having the same issue but its only sending twice. Can’t even array then deduplicate since trigger is instant.

3

Me too, but mine is sending two identical duplicates. Filters are not usable bcz all the informations are all the same;(
image

4

I’m experiencing the same issue: my scenario is triggered 2 times instead of just 1.
This is a critical bug, because I can’t stop the second run.

5

I figured it out! on the google sheet go to the make extension settings and make sure that the field for both Sheet (Optional) and Range (Optional) are left blank. I think there is a glitch with the extension that marks a change multiple times if those fields are filled out.

6

Same issue here. Leaving the mentioned fields blank does not help in my case. Any other solution?