How much time does Pabbly connect need to get data from googlesheets trigger to the API action ? (update / cycle / interval time)

[Albert]

Hello,

how long is the cycle time for every update in googlesheets from trigger to an API action?
My googlesheets is updated since 15min and the action task is not started yet.

Thanks

 

[Pabblymember11]

Hey @Albert

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" or "Send on Schedule," which will forward the data in exactly one hour.

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

 

[Albert]

Hello,

I try to create a workaround, but have a question.
Is it possible to get data from a third-party application to Googlesheets, then transfer the data from one googlesheet to another googlesheets with one task and then use the "send on event" function?

In this example the trigger googlesheets, which is used for the "send on event" got the data before from googlesheets.

Or is this also not possible and I would need to use the "Auto send on Schedule" function?

Thx

 

[Pabblymember11]

Or is this also not possible and I would need to use the "Auto send on Schedule" function?

Yes, it is possible to get data from a third-party application to Google sheets, then transfer the data from one Google Sheet to another Google sheet by selecting Googesheet again as an action event. However, if you select the "Send on event" option, it will trigger your workflow instantly and if you also select the "Auto Send On Schedule" option it will trigger your data in exactly one hour.