My first concern is that all my Gsheet webhooks are the same URL?
Shouldn't they be different?
I set up multiple GSheets to trigger an automation to transfer data to Encharge and they do not trigger. I have to manually check and trigger them.
I too have a similar scenario where I got stuck, but later got clarification from the team.
To send data from Google sheet to Encharge or any other application (ClientJoy) in my case, you need to select both "Send on Event" and "Send on Schedule" as well.
Then whenever there is new data in your sheets, it will automatically go to the connected app. However, there is a catch/limitation as of now. You have to wait for 30/40 mins (1 hour in my case) before the automatic scheduling triggers and sends your data to that app.
You can select the above-mentioned 2 checkboxes, put some new data and wait! If your integrations are correct, you will see the data flowing within an hour (maybe)..