# Iterating rows in Google Sheets and sending mails with specific data

**URL:** <https://community.make.com/t/iterating-rows-in-google-sheets-and-sending-mails-with-specific-data/57537>\
**Category:** Questions\
**Tags:** email, google-sheets\
**Created:** [October 10, 2024, 1:36pm UTC](https://community.make.com/t/iterating-rows-in-google-sheets-and-sending-mails-with-specific-data/57537 "2024-10-10T13:36:04Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Cetryn](https://avatars.discourse-cdn.com/v4/letter/c/41988e/32.png) [@Cetryn](https://community.make.com/u/Cetryn)\
**Post date:** [October 10, 2024, 1:36pm UTC](https://community.make.com/t/iterating-rows-in-google-sheets-and-sending-mails-with-specific-data/57537/1 "2024-10-10T13:36:04Z")

</div>

Hello,  
i have a scenario and do not yet understand how to generally iterate with data.

I have a Google sheet and there are 2 rows.  
Each row is a customer and I want to send a mail with specific data for each customer, e.g. tracking number and order number.

Which module and logic do I have to use to make a loop until all customers have a mail.  
Here are the screenshots

 ![Screenshot_1](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/5/0/50b8eb84576253dee135ad8dd1e6cc97fc48f1a9.png)  
 ![Screenshot_2](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/1/9/19d355a9ecab40dc9d25441fff711f9c9a0eacbc.png)

Thank you

---

<div class="post-metadata">

**Author:** ![NicoN](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/nicon/32/42439_2.png) [@NicoN](https://community.make.com/u/NicoN)\
**Post date:** [October 10, 2024, 5:33pm UTC](https://community.make.com/t/iterating-rows-in-google-sheets-and-sending-mails-with-specific-data/57537/2 "2024-10-10T17:33:16Z")

</div>

you need an iterator module after the sheets. In the Iterator settings, select the results array from the Google Sheet response. It’s usually something like “results” or “data.results”

---

<div class="post-metadata">

**Author:** ![Cetryn](https://avatars.discourse-cdn.com/v4/letter/c/41988e/32.png) [@Cetryn](https://community.make.com/u/Cetryn)\
**Post date:** [October 10, 2024, 7:56pm UTC](https://community.make.com/t/iterating-rows-in-google-sheets-and-sending-mails-with-specific-data/57537/3 "2024-10-10T19:56:10Z")

</div>

yeah it was total number of bundles. Thank you

 ![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/0/3/0398e5cea424e45289fbd36f7b2a68afe2dc19cb.png)

---

<div class="post-metadata">

**Author:** ![Make\_Bot](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/make_bot/32/14661_2.png) [@Make\_Bot](https://community.make.com/u/Make_Bot)\
**Post date:** [October 24, 2024, 8:09pm UTC](https://community.make.com/t/iterating-rows-in-google-sheets-and-sending-mails-with-specific-data/57537/4 "2024-10-24T20:09:41Z")

</div>