Google sheet new row is not triggering

[digimarketmoz]

I am sending data from Google sheet to interakt whatsapp. I have enabled send on data too. During testing, the data was properly sent to interakt but now when i add a new row in google sheet, the data is not sent to interakt as if it stopped working. Please check on your side

 

[Pabblymember11]

Hey @digimarketmoz

Can you please confirm if you have selected the Pabbly Connects ad ("Send On Event" or "Auto Send On Event").

While setting up the Google Sheets, if you are getting the data from the Google Application or you are feeding the data manually then you can only use "Send On Event" and if the data is coming from a third-party application then you might need to select "Auto Send On Schedule" and "Send on Schedule" which will take exactly 1 hr to forward it.

Also, check whether the data was getting filled till your triggering column or not.

Furthermore, based on the latest history of your workflows, it is evident that the workflow has run as expected.

 

[digimarketmoz]

I have enabled send on event. You can check my screenshots

I am manually adding data copy paste in google sheet. when test it, it works fine and even after testing it works for few minutes or few action. Then after some time it doesn't work

 

[Pabblymember11]

Can you please create a brief video demonstrating how to set up the webhook URL in your Google Sheet and capture the webhook response?

 

[digimarketmoz]

Now its working. But i dont know why sometimes it dont work. Are there any specific rules to add data in google sheet for it to trigger

 

[Pabblymember11]

Now its working. But i dont know why sometimes it dont work. Are there any specific rules to add data in google sheet for it to trigger

There is no specific rule mentioned. You simply need to follow the precise steps and add-ons outlined in the help text of the Google Sheets trigger event to transfer data from your Google Sheets to the workflow.

Perhaps in your case, you may have overlooked a step, which is why the configuration did not work as expected. Let us know if you have further queries related to the same.

 

[Naveensurya]

Hello
Im also facing same issue i have master lead sheet i have created automation from facebook instent forms and google froms to add leads automatically to my master leads sheet this is working fine
when ever a new row added on my master lead sheet i want to copy that lead to another lead sheet call lead dashboad ( will do some operations here ) This is not working don't know why
In my master lead sheet i have put send on event it's not working
when i have put Send on Schedule its working but data added after 1hour dealy i dont want that i want send data instantly

 

[Pabblymember11]

Hey @Naveensurya

Can you please reconfigure the webhook URL to your Google Sheets once and then try again?

Further, you can only use "Send On Event" when setting up Google Sheets if the data is coming from a Google application or if you manually enter it. If the data is coming from a third-party application, however, you may need to choose "Auto Send On Schedule" which will forward the data in exactly one hour.

Additionally, make sure the data is filled up to your trigger column.