Here is my pipeline.
On Google Sheets module I search for rows and I receive the following result
On the final stage for sending the email I need the values both from Bundle 1 and from Bundle 2 of the Search Rows output
So the question is how to do it?
Hi @Ivan_Chobotar
Could you share a sample screenshot of a Google Sheet? We just want to get an idea of what it looks like.
Best regards,
Msquare Automation
Gold Partner of Make
@Msquare_Automation
Hi @Ivan_Chobotar
It is good to keep headers in the first row. IF you are using search module of google sheet it will provide values row by row as a bundle.
Sample sheet:
Example output:
Best regards,
Msquare Automation
Gold Partner of Make
@Msquare_Automation
Yeah, I understand how it works 
The Google Sheet search results in the output with two bundles which are my two rows that I was searching for.
My problem is that I have two roes as a result of the search and on the one of the next steps (sending the email) I only have access to the data in the first row.
That means that I can use as a variable the value of B column only from the first row, and I want to use the value from the second row as well
Hey @Ivan_Chobotar
While mapping the data, you will be only able to see the data from first bundle. However, once you will map it will take data from each next row one by one.
If you want to send the data to one email together, then you need to use aggregator. But I believe, this is not your concern. 
Best regards,
Msquare Automation
Gold Partner of Make
@Msquare_Automation
Welcome to the Make community!
Every result (item/record) from iterator/list/search/match modules will output a bundle. This can result in multiple bundles, which then trigger multiple operations in future modules (one operation per bundle). To “combine” multiple bundles into a single variable, 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 can apply to many use-cases like building of JSON, CSV, HTML.
There are other types of aggregator modules, click the below links to find out more:
Hope this helps! Let me know if there are any further questions or issues.
— @samliew
P.S.: Investing some effort into the Make Academy will save you lots of time and frustration using Make.
Actually the Aggregator could work, going to learn how does it works
Thank you for your help
