How can change repeater so it gets data from each row in Google Sheets

What are you trying to achieve?

How can change repeater so it gets data from each row in Google Sheets.

In Google Sheets I get image URL from cell A1 with cat image.

Currently Repeater, repeats 2 times but the alt text is for same cat image URL, I want the 2nd row to be dog image URL.

Question 1: How can I repeat to get image URL all rows in A column?

Question 2: How can I get the image alt text added to the same row e.g. cell A1 image URL has image alt text added to cell B1

Screenshots: scenario setup, module configuration, errors







image alt text from URLs blueprint.json (31.3 KB)

Hello!

For this, you don’t need a repeater. What you need is to use “Google Sheets / Search Rows” or “Google Sheets / Watch Rows” if you want to pick only the new rows you will add later.

When you do this, it will return the 2 rows, it will generate what we call “Bundles” (a Bundle can be compared with a Record). Then, the next steps (OpenAI, and Google Sheet) will be repeated twice, the looping will be done automatically.

But, for the next steps after OpenAI, what you need is only Google Sheets / Update a row.
In this module you will be able to map the RowID of the first step, and the column B.

If you need an example let me know.

Benjamin

2 Likes