Setup Rate Limit on Entire Workflow

[JonathanDragonDJ]

I have an automation that is triggered when a new file is added to a dropbox folder. Later on, data is added to a google sheet row.

All of this works fine with small tests.

If I put a large batch of new files into the dropbox folder, it ends up hitting the rate limit error with Google sheets.

Is there a way to limit how often the entire workflow will run?

Since I have to wait for Pabbly to be triggered by Dropbox, it's hard to do this manually.

I want to put a delay into the entire workflow, since Pabbly always grabs files in batches from Dropbox.

If I put a delay INSIDE the workflow, all of them will have the same delay so the rate limit will just get hit one minute later.

I want to set up a frequency max for the ENTIRE workflow.

 

[Preeti Paryani]

Hello @JonathanDragonDJ

Currently, the workaround we suggest is to add two steps (one of which is free) after the Pabbly API action to introduce a random delay before adding a new row to the Google Sheet.

We’ve attached a workflow share URL from which you can copy these steps and paste them into your workflow.

Here’s how it works:

1. Spreadsheet Formula: This step generates a random number between 1 and 10.
2. Delay Step: The random number from the previous step is mapped to the "Delay For" field, introducing a randomized delay.

This approach helps distribute the requests over time and reduces the chances of hitting the Google Sheets rate limit. Let us know if you need help implementing this!

 

[Fagun Shah]

if you want random delay in seconds(max 23 seconds) then use this actions -