GoogleSheet new row add, but event not trigger

[1uptick]

I have created a workflow Google Sheets (New or Updated Spreadsheet Row) > Telegram. Everything works well on testing. However, the event is not triggered when a new row is added.

>"Send on event" checked.
> Data on the google sheet are imported by using "=importrange" from another sheet

Am I missing sth ?

 

[Supreme]

Hey @1uptick

Can you please try opting for the "Auto Send On Schedule" option from your Google Sheets and then check?

 

[1uptick]

Is it possible to set the frequency? It seems like the automation is not instant, with about 15-20 minutes of delay.

 

[ArshilAhmad]

Although not immediate, you can use App script to reduce the waiting time to 1 minute. To assist you in sending new rows every minute, I have included a link to the relevant thread.

Google Sheets (1 Minute Trigger) Send New rows in every 1 minute.

In this tutorial, we will see how can you set up Google sheets trigger "New or Updated Spreadsheet Row" in Google Sheet so that you can capture data every minute. Please note: We also offer a Pabbly Connect Webhooks addon for Google Sheets. The current limitations of the Google Sheets trigger...

forum.pabbly.com