# Iteration through Google Sheet bungles

**URL:** <https://community.make.com/t/iteration-through-google-sheet-bungles/66975>\
**Category:** Questions\
**Tags:** chatgpt, google-sheets\
**Created:** [January 21, 2025, 1:48am UTC](https://community.make.com/t/iteration-through-google-sheet-bungles/66975 "2025-01-21T01:48:43Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![Valera\_Voronin](https://avatars.discourse-cdn.com/v4/letter/v/779978/32.png) [@Valera\_Voronin](https://community.make.com/u/Valera_Voronin)\
**Post date:** [January 21, 2025, 1:48am UTC](https://community.make.com/t/iteration-through-google-sheet-bungles/66975/1 "2025-01-21T01:48:43Z")

</div>

Hey, I’m trying to find ways to iterate through each bundle that Google Sheets (Search Rows) produces and send it to GPT for processing. ChatGPT uses 3 unique data points to produce an output. But for some reason, it only does so for the first bundle. See the screenshot below.

I have tried adding an iterator in between, but it didn’t seem to help.

Thanks

 ![Screenshot 2025-01-20 at 5.48.02 PM](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/b/b/bbeda4e89b8ea56ad6f6db4e9e51bd39449278ff.png)

---

<div class="post-metadata">

**Author:** ![Emmie\_Aderemi](https://avatars.discourse-cdn.com/v4/letter/e/9de0a6/32.png) [@Emmie\_Aderemi](https://community.make.com/u/Emmie_Aderemi)\
**Post date:** [January 21, 2025, 1:58am UTC](https://community.make.com/t/iteration-through-google-sheet-bungles/66975/2 "2025-01-21T01:58:17Z")

</div>

Ensure that the iterator is correctly set up to loop through each bundle.

Click on the googlesheet module and send the screenshot

---

<div class="post-metadata">

**Author:** ![Valera\_Voronin](https://avatars.discourse-cdn.com/v4/letter/v/779978/32.png) [@Valera\_Voronin](https://community.make.com/u/Valera_Voronin)\
**Post date:** [January 21, 2025, 2:21am UTC](https://community.make.com/t/iteration-through-google-sheet-bungles/66975/3 "2025-01-21T02:21:20Z")

</div>

Here is the Google Sheets output and the Iterator settings I used. Thanks!

 ![Screenshot 2025-01-20 at 6.18.37 PM](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/c/4/c4bbaa0f4bc3a38d743327a2676494a4778ff6f5.png)  
 ![Screenshot 2025-01-20 at 6.21.12 PM](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/b/5/b56f676c3ef1b4bf7e431a4854b9fd4b3165d029.png)

---

<div class="post-metadata">

**Author:** ![Valera\_Voronin](https://avatars.discourse-cdn.com/v4/letter/v/779978/32.png) [@Valera\_Voronin](https://community.make.com/u/Valera_Voronin)\
**Post date:** [January 21, 2025, 4:40am UTC](https://community.make.com/t/iteration-through-google-sheet-bungles/66975/4 "2025-01-21T04:40:40Z")

</div>

Here’s my full automation at the moment.

It iterates by default and goes to send 5 individual emails. But I want 1 email with aggregated information received after iterating through 5 bundles.

I’ve been breaking my brain for a few hours with this. LOL HeLp.

 ![Screenshot 2025-01-20 at 8.37.45 PM](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/0/a/0a61c793aa630c1634a53b551dc6d979edc67897.png)

---

<div class="post-metadata">

**Author:** ![Valera\_Voronin](https://avatars.discourse-cdn.com/v4/letter/v/779978/32.png) [@Valera\_Voronin](https://community.make.com/u/Valera_Voronin)\
**Post date:** [January 22, 2025, 3:23am UTC](https://community.make.com/t/iteration-through-google-sheet-bungles/66975/5 "2025-01-22T03:23:22Z")

</div>

I guess I will just store the output data in a single file (in above scenario) and email the content from that doc in a separate Scenario. No point in struggling so much.

---

<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:** [April 22, 2025, 2:31am UTC](https://community.make.com/t/iteration-through-google-sheet-bungles/66975/6 "2025-04-22T02:31:47Z")

</div>


