How to update several rows in Sheets after I have found 20 specific bundles with "Google Sheets Search Rows"?

[Tim_Schulz]

Hi! Thanks in advance for your help!

I am very new to Make so I hope this question is not too stupid, but I couldn’t find an answer anywhere. I have gotten 20 bundles from a Google sheet “search rows”. So far so good. Now I want to do several actions with these 20 bundles, e.g. send an email to the address in one of the fields in the bundle and update a field from No to Yes in a column in the original Google sheet. I assume this is somehow done with an iterator, but when I add one after my first step, I have no clue what to add here as array to loop over:

The options all just seem to focus on specific values - I would expect to be able to choose the whole bundle somehow.

I guess if I could understand this concept better, then the subsequent steps of sending an email and updating a field for each bundle/row, should be clearer for me. But if you already have advice about the “Update row” module in Sheets for my particular use case, I’d be thankful for any advice as well.

All the best, Tim

[samliew]

Welcome to the Make community!

You don’t need an iterator because they are already in 20 individual bundles which you seem to want to process separately. Iterators are only used when you have an array.

Every result (item/record) from a search/match module will output a bundle. To “combine” them into a single structure, you’ll need to use an aggregator of some sort.

Aggregators are modules that accumulate multiple bundles into one single bundle. An example of a commonly-used aggregator module is the Array aggregator module. The next popular aggregator is the Text Aggregator which is very flexible and has applies to many use-cases.

There are other types of aggregator modules, click the below links to find out more:

• Array aggregator
• Text aggregator
• Numeric aggregator
• Table aggregator
• JSON aggregator
• CSV aggregator
• Archive (ZIP) aggregator
• other app-specific aggregators

samliew – request private consultation

Join the unofficial Make Discord server to chat with other makers!

[Tim_Schulz]

Thank you, much appreciated that answer. It really helped me to understand the setup better and how iterators work!