What’s the best way to ingest rows from spreadsheet?
I have received a spreadsheet with 1,589 rows, and I need to process each row sequentially - create records in a DB, download files from links included in each row etc.
There’s a lot of work to be performed for each row, so I want to pace this out over time.
This is a bit different from the ‘watch new row’ triggers that seem to be what the modules for Excel and Sheets are expecting.
In my case, there will not be any 'new ’ rows. I just want to process all the existing 1,589 rows in a single spreadsheet.
I am not sure what is the best way to trigger this activity, and how to pace it out over time?
What’s the easiest way to make this happen?
