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
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.
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,
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.
Oh! Thanks. Another great tip. Noted and appreciated. Have a good one!
