Add "Seconds to the "Delay" module
Status: Open · Asked by Shlomo Zaga on · 0 views
Today I had a huge Automation:
Trigger --> Google Sheets to ---> Google Drive --> Mark As Shared --> Save as PDF to DropBox.
The Automation was supposed to trigger a new row every 1-second.
There were approximately 100 Rows per sheet & 9 Sheets (Total 900 Triggers/Automations).
The problem was that it seems like the Trigger was happening too quickly from one row to the other & many rows were "missed" (The PDF never showed up in my Dropbox).
The only way it worked without "skipping" rows was when the trigger was delayed for approximately 7 seconds between each other (we waited 7 seconds between each trigger).
This could have been solved if I added a delay step of 7 or 10 seconds "Delay" on the last step of my workflow.
However, Pabbly does not allow a delay in seconds, we must use "minutes".
A 1-minute delay is too long between each trigger.
Please add "seconds" to the delay module to avoid issues like this in the future.
Cron has a minimum possible resolution of 1 minute and it is a default utility of the Unix systems and is very very stable.
There are other ways to do it but they are not 100% accurate.
So implementing them will create more problems like:
Why my delay didn't execute in exact 10 seconds. Instead, it triggered in 25 seconds.
Attachments

Hi @Neeraj ,
To add to this thread, I figured out a Google script which allows for “delays”.
but still have issues.
Please see this post that I just made regarding this automation:
https://forum.pabbly.com/threads/google-sheets-not-triggering-when-a-script-is-activating-the-trigger.2766/