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