Google Sheet to API Request

[meankur1]

Your Task History ID

IjU3NjIwNTZlMDYzNDA0MzM1MjY5NTUzMDUxMzM1MTY2NTQzMSI_3D_pc

Hi Team,

I am currently developing a workflow in which new rows are added to a Google Sheet. In the second step, an API is called. The process works fine when I update 200 rows in the Google sheet simultaneously, but it fails when updating a larger number of records. I suspect this issue is due to the simultaneous multiple API calls. Is there a function available that allows for processing one row at a time, or a way to queue all requests from the Google Sheet to process each record individually? Your assistance on this matter would be greatly appreciated.

 

[Himesh]

Try using "Delay Action" in between.

 

[meankur1]

Delay Action might not work because we are updating multiple google rows same time. We need que these request somehow so that it works one by one.

 

[Himesh]

If you want to add it to queue try Variables by pabbly connect. You can add the data in Variable. Please refer below video.