Google sheets trigger not working

[elhanan cohen]

Hi! The Google sheet trigger not working.
in the test, it's working, but after configuration, the data is not sent.

 

[elhanan cohen]

@ArshilAhmad
@Supreme

 

[ArshilAhmad]

Hi @elhanan cohen,

When entering the data into your Google Sheets, make sure to add the data to your trigger column as well in order to trigger the workflow.

To make automation work, you need to enable 'Send On Event' if you're manually entering data into your Google Sheets. If the data added to your Google Sheets comes from another API or third party application, you also need to enable 'Auto Send on Schedule'.

Note: If you enter data manually, your workflow will be executed instantly. However, if you add data through an API or third party application, it may take up to an hour for the trigger to be executed.

 

[TayDiers]

I am experiencing a similar problem. Sometimes the data sends immediately and sometimes nothing happens. The second row stopped sending altogether. I finally just put dummy info in that row. Very strange.

I manually copy and paste. I have both Send on Event and Auto Send on Schedule checked. I have data in the trigger column, and I am not signed into another Google Sheets Account. I really don't understand why it sometimes works and other times has delay or does not work at all.

 

[Pabblymember11]

Can you please record a short video? Also, 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.