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

How To
1

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

1.png
1.png2748Ă—1756 271 KB

2.png
2.png854Ă—344 26.7 KB

3.png
3.png2738Ă—1522 301 KB

4.png
4.png2576Ă—912 142 KB

5.png
5.png2608Ă—1710 336 KB

6.png
6.png2704Ă—1716 406 KB

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

2

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
3

I have a situation where I am using Google sheet search row and bundles are populate. In this I want check the value of one column say “test” and if it is zero I will route in one direction , and Not zero route in another direction … how to use it.