How to Speed Up Pay All Functionality?

Status: Closed · Asked by Jeffrey Yu on · 0 views

JeffreyYu — Question ·
Task History ID: IjU3NjIwNTZjMDYzNzA0M2Q1MjZlNTUzMDUxMzQ1MTYwNTQzMSI_3D_pc

In my "Mark All as Paid" workflow, I'm trying to manually update the status of multiple assignments across two spreadsheets to Paid: one in the master spread, and one in the secondary spreadsheet. However, with each array in the Iterator containing sometimes up to 50-60 entries at a time (as we run Payroll biweekly), it takes like 5-10 seconds between entries to process, not to mention, Google Sheets limits write requests to 60 per minute. Since we also have 10+ staff, this becomes a really slow process (instead of just one quick click)

Is there a faster, more efficient (or even instantaneous) way to implement this functionality in Pabbly? What information would be required? (e.g. do we need the Row ID of the Master Spread)

Pabblymember11 — Reply ·

Hey @JeffreyYu

At present, there is no alternative method for executing bulk automation tasks, either by utilizing or abstaining from the use of additional modules.

JeffreyYu — Reply ·

Got it! thanks

Back to all forum threads · Log in to reply