Hiya,
We run statements for approximately 100 clients monthly. I had the trigger setup to be the detection of a file in a Dropbox account, however, the issue is that the routine drops all 100 files in there at the same time and half way through, the process stops and doesn’t restart. I’m wondering if there’s a better way to say, run through a Google sheet one row at a time to pull the appropriate data for the rest of the automation, then on the next run (scheduled maybe?) run the next row, etc…
Any thoughts?