Hi everyone,
I had an objective to update a sheet with information coming from a 3rd party website.
I've managed to make a first workflow with Bridge that works:
I'm calling the API, receiving an array of data, then I have a child workflow to add a row for each line from the array.
It works. But I have 6000 lines to come so it takes about a day to add all the rows. So problem number 1, it's a bit slow. Which brings me to problem 2: how do I keep this data up to date?
Initially (and because I'm not experienced with this), I thought: maybe I'll just delete all the rows and re-initiate the workflow everyday. But since it takes a whole day to update, I don't think that's a good idea.
Is there another way, such as checking the difference between the API array and the sheet data and updating only the lines that need it? or did I start this process the wrong way? Is there another way to add the data other than line by line?
