Hi,
The 40-minute exectime isn’t enough for me. I thought if I set a scheduler to run every 50 minutes, it would run forever. But unfortunately, there’s a problem with the IDs in Google Sheets. As far as I can see, it stops completely after 40 minutes, and upon restart, watch new row no longer knows where to start, so I would have to define and trigger it manually.
Which Sheets module allows me an infinite loop, line by line. After 40 minutes, it should restart after about 50 minutes and continue exactly where it left off.? I have ~10,000 rows to process, and I want it to simply run through.
That would be Search Rows. Then add a column to tag a row as processed and at the end of the scenario add a module to update the current row and tag it as processed.
Configure the search new rows module to only return rows that are not tagged as processed and you can keep restarting the scenario untill all rows are done.
Great, it worked. I would prefer it if I didn’t have to use a trigger word, but could search for an empty cell in the column. But {{nul}} etc. doesn’t work. Is there an option for that?
But then when you rerun it after it times out, it wont know how far it reached. So it will start over and redo the same rows.