Send on event Trigger Not Working in google sheet

[Gaurav]

As soon as the data is captured in google sheet through google forms, I have sorted the data in another tab in the same sheet. And have assigned the sheet2 webhook to pabbly connect for the automation. But send on event is not working. It is not sending the data to pabbly coneect for automation.

Link of the Workflow: https://connect.pabbly.com/workflow...ZV2sBFQUBAlQFdgYcUlABAlErVBlWZQVAW2gAXlhwAGE#

Sharing you the screenshot from where the data is sent and another screenshot where the data needs to be updated.

 

[Preeti Paryani]

Hello @Gaurav,

Thank you for sharing the workflow link and screenshots.

Could you also please share a screenshot showing the initial trigger setup in your workflow? Additionally, kindly confirm if any of the columns (especially the trigger column) contain a formula.

This information will help us better understand the behavior and assist you more accurately.

Looking forward to your response.

 

[Gaurav]

Hello @preeti,

Yes sending you the initial trigger setup. (Screenshot attached)
Yes the Trigger column contains a formula. (Screenshot attached)

 

[ArshilAhmad]

For Google Sheets, we currently do not support formula-based triggers. The data in the trigger column must be entered either manually or via an API. If the row is updated through a formula, it won't trigger the workflow, and the automation will not run as expected.

 

[Gaurav]

Will it work if the trigger column cell value is updated via app script in google sheet?

 

[ArshilAhmad]

No, it has to be updated either through the API or manually.