Google Sheet mulitlpe column help

[Craig_Dennis]

I have a google sheet, with two columns (A and B) and X amount of rows.

I want to pass in A1 and B1 into ChatGPT as a message.

I then want the result from chatGPT to go into the google sheet in column C

I want to loop this until all the rows have been looped.

Does anyone know how best to achieve this?

[ponvaskon]

Hi @Craig_Dennis

1. You can use a Search Rows module and specify such filters: A column value exists, B column value exists, C column value doesn’t exist.
   
   
2. Set up the Make scenario filter before the ChatGPT module to only proceed if the total number of returned bundles is not equal to 0.
   
   
3. Update the C column with the ChatGPT output.