Response not received in 25 seconds - Google Sheets

[NickJSI]

workflow ID:

Pabbly

connect.pabbly.com

1 out of every 20 fails. The instructions to delay the api call do not apply to a google sheets connection.

How do I remedy this? It's breaking my entire flow.

 

[ArshilAhmad]

Hi @NickJSI,

Pabbly Connect waits for 25 seconds to receive a response from any application. The issue you are describing occurs when an application (Google Sheets) takes more than 25 seconds to process a request, and because of this, Pabbly Connect does not receive the response within 25 seconds, leading to the error you encountered.

Currently, the only workaround for this issue is to enable the Auto Re-Execution feature, which will automatically re-execute your failed tasks. Please read the attached thread below to understand how this feature works.

How to enable auto re-execution for workflows?

The Auto Re-Execution Feature: Automatically Re-Execute Failed and Skipped Steps The Auto Re-Execution feature in Pabbly Connect allows you to automatically re-execute failed and skipped steps in your workflow. With this feature, you can ensure the smooth flow of your workflows and reduce...

forum.pabbly.com

 

[NickJSI]

Thanks Arshil. I'll update the flow to do this.
As an alternative approach, could I use the api call to engage with google sheets to do the same thing, and utilize the response ID method?

 

[ArshilAhmad]

You can execute the endpoint through a Custom API Request, but that wouldn't necessarily solve the issue you are encountering, as it would take the same amount of time to search for a value in your spreadsheet.