Iterate over Google Sheets rows

I think I want to do something relatively simple: Read all the rows from a spreadsheet and process each row for updates to a CRM.

I’m using the Search Rows (Advanced) Sheets module and get back 30 bundles:

What I really want to do is iterate over each bundle, but the mapping only allows me to use the first bundle, with no array to select:

I’m still trying to wrap my head around some of the basic functionality. Thanks!

It works for me. Could you show the output of the aggregator in a screenshot.

1 Like

Hi. I think you don’t need aggregate ant iterate the Google Sheet results. The results from GS is generate as bundles so they will be processed one by one in the next steps. What you see in the map is only the data visualization for help you mapping no the first result.


Thanks, Helio!
Wemakefuture
If you have questions reach out :wink:

1 Like

Yeah, I got it working also. I used the standard search rows module and I wasn’t specifying the fields in the aggregator correctly.

1 Like