Random delay

[Marketer]

Hello Pabbly Team

I want to set a random delay between (say 1 seconds to 50 seconds) between executions of google sheet rows.

When I checked delay trigger, it has minutes and doesnt have seconds or randomizing delay

How can I achieve random delay? Are there any options to do this

Thanks
Mark

 

[Pabblymember11]

Hey @Marketer

Currently, the Delay action step is only available with Mins, Hours, Days, Weeks. So as of now, it is not possible to set the delay action steps randomly in seconds.

Regards

 

[Marketer]

Hey @Marketer

Currently, the Delay action step is only available with Mins, Hours, Days, Weeks. So as of now, it is not possible to set the delay action steps randomly in seconds.

Regards

yeah I saw that, is there any alternative

 

[Neeraj]

There are 2 ways,

1. Either you can use a delay that is at least 1 minute and put that before the Google Sheets step.

I am assuming you are trying to do this because of the rate limit that is applied by Google Sheets and you do not want your tasks to fail.

2. Here is another recommendation that I have for you.

A lot of people want to do heavy data operations with Google Sheets.

However, Google Sheets have limits on executions and often time fails on intensive read/write operations.

The solution to this is to have a professional database to manage your data load.

We do have a MySQL integration inside Pabbly Connect so if you need to do a data-heavy operation to read, write or update rows, you can use the MySQL database to do it.

 

[Marketer]

There are 2 ways,

1. Either you can use a delay that is at least 1 minute and put that before the Google Sheets step.

I am assuming you are trying to do this because of the rate limit that is applied by Google Sheets and you do not want your tasks to fail.

2. Here is another recommendation that I have for you.

Is there any possibility to bring delay in seconds please

 

[Pabblymember11]

Is there any possibility to bring delay in seconds please

As of now, we don't have any plan to introduce delay in seconds.

 

[LSF]

Hey @Supreme what happened to the MySQL App in Pabbly Connect. I cannot find it in the list of App?

 

[Fagun Shah]

MySQL actions are there, no triggers - https://www.pabbly.com/connect/integrations/mysql-beta/

 

[LSF]

Thank you @Fagun Shah I looked for it under "Triggers"