Getting Values from Google Sheet form existing Rows One by One

How To
,
1

Hi, i have a google sheet with 6k URLs. I want to give every single URL to an api call and save the result. i only find how to make a trigger when a new row is added to the sheet, but not, when all information are allready in the sheet. How can i setup a workflow, so make performs this action 6k times ? thanks daniel

2

Hi Daniel,

you can use the List module to go through all the rows one by one.

But considering the amount of information that needs to be processed, this may result in a timeout. You can start with the Search module instead and add something to tag rows that have been processed already or something like that. This way you can just restart the scenario and keep going from where it stopped.

3 Likes
3

Thanks for your answer. I use GetRangeValue, that seems to work…