• Instructions to Ask a Question

    For any assistance, please click the "Ask a Question" button and select the Pabbly product for which you require support.

    We offer seven comprehensive applications designed to help you efficiently manage and grow your business:

    Our support team endeavors to respond within 24 business hours (Monday to Friday, 10:00 AM to 6:00 PM IST). We appreciate your understanding and patience.

    🚀 Exclusive Lifetime Offers 🚀

    We invite you to take advantage of our special one-time payment plans, providing lifetime access to select applications:

    • 🔥 Pabbly Connect — Lifetime Access for $249View Offer
    • 🔥 Pabbly Subscription Billing — Lifetime Access for $249View Offer

    Make a one-time investment and enjoy the advantages of robust business management tools for years to come.

Setup Rate Limit on Entire Workflow

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

Well-known member
Staff member
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.

1733463937487.png


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!
 
Top