# How to extract data(each row)from google sheet, want to iterate all data from google sheets by going through each row

**URL:** <https://community.make.com/t/how-to-extract-data-each-row-from-google-sheet-want-to-iterate-all-data-from-google-sheets-by-going-through-each-row/62150>\
**Category:** Questions\
**Tags:** arrays, iterator, google-sheets\
**Created:** [November 22, 2024, 9:29am UTC](https://community.make.com/t/how-to-extract-data-each-row-from-google-sheet-want-to-iterate-all-data-from-google-sheets-by-going-through-each-row/62150 "2024-11-22T09:29:21Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Sujay\_Reddy](https://avatars.discourse-cdn.com/v4/letter/s/c0e974/32.png) [@Sujay\_Reddy](https://community.make.com/u/Sujay_Reddy)\
**Post date:** [November 22, 2024, 9:29am UTC](https://community.make.com/t/how-to-extract-data-each-row-from-google-sheet-want-to-iterate-all-data-from-google-sheets-by-going-through-each-row/62150/1 "2024-11-22T09:29:21Z")

</div>

Here as mentioned in the screenshot below

Here I have a Google sheet containing some data, on how I have to iterate every row when a row is not empty and I have to send all iterated data through the email, which one I have to use iterator (or) array aggregator (or) repeater?

(Image of google sheet)

 ![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/4/4/444604dc6f7200151796e84d852514dc18009c53.png)

---

<div class="post-metadata">

**Author:** ![Fario\_Consulting](https://avatars.discourse-cdn.com/v4/letter/f/5daacb/32.png) [@Fario\_Consulting](https://community.make.com/u/Fario_Consulting)\
**Post date:** [November 22, 2024, 1:47pm UTC](https://community.make.com/t/how-to-extract-data-each-row-from-google-sheet-want-to-iterate-all-data-from-google-sheets-by-going-through-each-row/62150/2 "2024-11-22T13:47:04Z")

</div>

Hi Sujay,  
You can use an iterator combined with the Google Sheets Search Row Module to iterate through every non-empty row in your data set.  
After which, employ a text aggregator to craft the email content based on the iterated data before sending it via the Gmail Module.

---

<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:** [February 20, 2025, 2:01pm UTC](https://community.make.com/t/how-to-extract-data-each-row-from-google-sheet-want-to-iterate-all-data-from-google-sheets-by-going-through-each-row/62150/3 "2025-02-20T14:01:44Z")

</div>