I would like to create a Zap that cyles through each row of a Google Sheet… slowly. For example, I create a sheet with 1000 rows of data and it would do some action to each of those rows, but with, say 20 minutes between each, and only during the hours of 9am-6pm CST.
The practical purpose is to do something like send one text message to a list of people every 10 minutes, instead of all at once, so that we don’t have to copy/paste data in a sheet every time we want a new batch sent.
I see the Schedule by Zapire app, but I can’t quite figure how to refer to “the top-most row that has not already had a Zap run on it” to determine which row to proceed with after a delay.
Best answer by PaulKortmanView original