Google sheets trigger not working

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

@ArshilAhmad
@Supreme

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.
[IMG alt="1691344967162.png"]https://forum.pabbly.com/attachments/1691344967162-png.29754/[/IMG]

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'.
[IMG alt="1691345126828.png"]https://forum.pabbly.com/attachments/1691345126828-png.29755/[/IMG]

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.

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.

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.

Here too, i am copying and pasting 5 rows manually and checked that the column triggering is there, send on event is sending it ok, but hourly as explained, but send on event did not...

Hello @DrMKT,

Sorry, but we are not able to fully understand the exact issue from your message.

However, as per our understanding, you are using the Google Sheets trigger and have enabled both the options: "Send on Event" and "Auto Send on Schedule".

If the data is getting captured in the workflow after some delay (for example within an hour), then it is likely being captured through the "Auto Send on Schedule" option and not through the "Send on Event" option.

In such cases, if the data is being added to Google Sheets via a third-party application, you can disable the "Send on Event" option and continue using the scheduled trigger, as the data should still be captured in the workflow task history within an hour.

Additionally, if you want the data to be captured faster than one hour, then you can add a 1-minute Apps Script trigger in your Google Sheet (provided no other Apps Script is already configured there).

You can follow this documentation for the setup:
https://forum.pabbly.com/threads/google-sheets-1-minute-trigger.12927/

Please check and let us know if we have understood your issue correctly.