I am hitting limits on google sheets when updating more than 150 rows. Is there a way to iterate say the first 50, then pause, then continue?
You can add a Sleep module after updating each record.
Or you can add a repeater for the number of “50” item slices, slice the array accordingly for each repeat, add a sleep module, before the iterator module, which then updates the row.
3 Likes
how would I slice the array into 50 record chunks?
Very nice! I’ll have a go and report back.
I edited this thread’s title to “Pause After Iterating Each Batch of 50 Records” to better reflect on the problem, and make it easier for others with the same issue to search for it.
4 Likes