How to Loop Through All Columns in a Google Sheet (A, B, C...) in My Scenario

[MCMAKEIT]

I’ve built a working scenario that does the following:

1. Reads values from column A (range A2:A99) in a sheet called "CITIES + KEYWORDS".
2. Aggregates the values into an array.
3. Sends that array to OpenAI to generate 10 SEO product names.
4. Parses the result JSON.
5. Adds the generated names to column A of another sheet called "CITIES + PRODUCT NAMES".

Now I want to loop this process through all columns (B, C, D, etc.) — so that it runs the same logic for each city column automatically without having to duplicate my scenario.

How can I dynamically read each column one by one, and write back to the corresponding column in the second sheet?

Thanks a lot in advance!

[Stoyan_Vatov]

Hey there,

the Search Rows module will return all columns in one row in the same bundle, maybe you can use that and then separate them to be processed one at a time.