Response not received in 25 seconds - Google Sheets

workflow ID:

https://connect.pabbly.com/workflow/mapping/IjU3NjUwNTZmMDYzNzA0MzQ1MjZiNTUzYzUxMzMi_pc

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.

Attachments

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.
https://forum.pabbly.com/threads/how-to-enable-auto-re-execution-for-workflows.15088/

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?

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.