# Iterate over Google Sheets rows

**URL:** <https://community.make.com/t/iterate-over-google-sheets-rows/7785>\
**Category:** Questions\
**Tags:** google-sheets\
**Created:** [February 7, 2023, 12:58am UTC](https://community.make.com/t/iterate-over-google-sheets-rows/7785 "2023-02-07T00:58:59Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![mrosborne](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/mrosborne/32/7538_2.png) [@mrosborne](https://community.make.com/u/mrosborne)\
**Post date:** [February 7, 2023, 12:59am UTC](https://community.make.com/t/iterate-over-google-sheets-rows/7785/1 "2023-02-07T00:59:00Z")

</div>

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.

 ![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/2X/6/6c2a742e7331c8efce97730dfc27bc29146b3f22.png)

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

 ![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/2X/c/c3670839fbd13ef2eb99ccdc3a1627f44a6ba0bb.png)

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:

 ![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/2X/8/870ebf8c5bffdb319ac990d7c868ab2294a5d83b.png)

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

---

<div class="post-metadata">

**Author:** ![Jonx-BlusectorTech](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/jonx-blusectortech/32/6985_2.png) [@Jonx-BlusectorTech](https://community.make.com/u/Jonx-BlusectorTech)\
**Post date:** [February 7, 2023, 8:16am UTC](https://community.make.com/t/iterate-over-google-sheets-rows/7785/2 "2023-02-07T08:16:46Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![Wemakefuture](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/wemakefuture/32/103_2.png) [@Wemakefuture](https://community.make.com/u/Wemakefuture)\
**Post date:** [February 7, 2023, 9:42am UTC](https://community.make.com/t/iterate-over-google-sheets-rows/7785/3 "2023-02-07T09:42:45Z")

</div>

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 😉

---

<div class="post-metadata">

**Author:** ![mrosborne](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/mrosborne/32/7538_2.png) [@mrosborne](https://community.make.com/u/mrosborne)\
**Post date:** [February 7, 2023, 9:44am UTC](https://community.make.com/t/iterate-over-google-sheets-rows/7785/4 "2023-02-07T09:44:28Z")

</div>

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

---

<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:** [September 7, 2023, 3:32pm UTC](https://community.make.com/t/iterate-over-google-sheets-rows/7785/5 "2023-09-07T15:32:48Z")

</div>