Hello! I am having issues getting my webhook to work properly. My goal is to use a column in google sheets to trigger a webhook for another scenario to run. Ideally, when I change a row in my approval column to approve/ reject, it should trigger a webhook in the next scenario to send out different messaging.
When I connect the webhook via make extension within google sheets OR google sheets>apps script, it does not immediately trigger the next scenario UNLESS, i have the log (History) open on the side or if I manually run the scenario (which defeats the purpose of the trigger). I am having the same exact issue using watch changes module as well as the custom webhook module.
i have copied the correct webhook URL to both make extension within google sheets and google apps script. I cant think of any other ways to try.
I dont understand what i need to do to have it immediately trigger correctly and have been trying to get it right for hours. Any help is greatly appreciated.