# Can't figure out how to process all rows in Google Sheet **URL:** \ **Category:** Beginner Questions\ **Tags:** google-sheets\ **Created:** [February 25, 2025, 7:45pm UTC](https://community.make.com/t/cant-figure-out-how-to-process-all-rows-in-google-sheet/71468 "2025-02-25T19:45:18Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![Terry\_Helliker](https://avatars.discourse-cdn.com/v4/letter/t/ba9def/32.png) [@Terry\_Helliker](https://community.make.com/u/Terry_Helliker)\ **Post date:** [February 25, 2025, 7:45pm UTC](https://community.make.com/t/cant-figure-out-how-to-process-all-rows-in-google-sheet/71468/1 "2025-02-25T19:45:18Z")
### What are you trying to achieve? Hi Everyone! Newbie here trying to figure things out with Google Sheets. I have a sheet that contains a list of products. I am using the Google Sheets Search Rows module that goes to a ChatGPT prompt (Generate Completion) which then goes to a Google Sheet Update Rows module. This works great for 1 row, but I am lost at how to get this scenario to run over and over again until all the rows in my file have been updated. I tried using a Repeater and just finished playing around with an Iterator. Both, unsuccessful. I am obviously missing something and would love some help. Can someone please point me in the right direction? Thanks, Terry ### Steps taken so far I have already tried a repeater, but that just repeated the same row over and over until I stopped it. I tried setting up an iterator but cant get it to read the line or process anything. The problem here is I simply can’t figure out the correct settings. I’ll add a screenshot of where I have just left off. ### Screenshots: scenario setup, module configuration, errors ![iterator-keywords.png](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/e/c/ecd5e800103dfd13a2d872bbc9e8f87568681d64.png) ---
**Author:** ![Stoyan\_Vatov](https://avatars.discourse-cdn.com/v4/letter/s/5daacb/32.png) [@Stoyan\_Vatov](https://community.make.com/u/Stoyan_Vatov)\ **Post date:** [February 26, 2025, 1:49pm UTC](https://community.make.com/t/cant-figure-out-how-to-process-all-rows-in-google-sheet/71468/2 "2025-02-26T13:49:09Z")
Hey Terry, Search Rows will already return all rows that match the search criteria. Check at the bottom if you have a limit on how many rows it will return. The iterator is used to process arrays one item at a time, so its not needed here. In your screenshot, the ChatGPT module has ran 70 times, so 70 rows have been processed. Then it looks like you stopped the scenario manually. ---
**Author:** ![Terry\_Helliker](https://avatars.discourse-cdn.com/v4/letter/t/ba9def/32.png) [@Terry\_Helliker](https://community.make.com/u/Terry_Helliker)\ **Post date:** [February 26, 2025, 2:32pm UTC](https://community.make.com/t/cant-figure-out-how-to-process-all-rows-in-google-sheet/71468/3 "2025-02-26T14:32:33Z")
Hi! Thank you so much for your reply. You are a genius. I removed the iterator and checked the settings on the Search Rows and found it was set to 1. I changed it to 100 but not sure its the best option. I would prefer if it could just run through the entire sheet and process every line until the end, but this is perfect for now as I continue to learn. As for the screenshot, you are correct, I ran it and it updated line 1, 70 times before I noticed and stopped the process. Learned my lesson on that one. Again, thank you so much for your help. I truly appreciate it, ---
**Author:** ![Stoyan\_Vatov](https://avatars.discourse-cdn.com/v4/letter/s/5daacb/32.png) [@Stoyan\_Vatov](https://community.make.com/u/Stoyan_Vatov)\ **Post date:** [February 26, 2025, 6:34pm UTC](https://community.make.com/t/cant-figure-out-how-to-process-all-rows-in-google-sheet/71468/4 "2025-02-26T18:34:09Z")
You can just delete it, then it will return all entries that match the search criteria. No need to have a value there unless you need it for handling some rate limits. ---
**Author:** ![Terry\_Helliker](https://avatars.discourse-cdn.com/v4/letter/t/ba9def/32.png) [@Terry\_Helliker](https://community.make.com/u/Terry_Helliker)\ **Post date:** [February 26, 2025, 7:16pm UTC](https://community.make.com/t/cant-figure-out-how-to-process-all-rows-in-google-sheet/71468/5 "2025-02-26T19:16:47Z")
Oh! Thanks. Another great tip. Noted and appreciated. Have a good one! ---
**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:** [March 12, 2025, 4:01pm UTC](https://community.make.com/t/cant-figure-out-how-to-process-all-rows-in-google-sheet/71468/6 "2025-03-12T16:01:49Z")