How can I get the first empty row/cell from the top?

[rym413]

Hi peeps!

I am trying to get the first empty row using Googlesheet Search Rows module and update only the first empty row from the top using the scenario like in the attached.

The current setting is in this attached. With this setting, I get all the rows where Column B is NOT empty and I can get the row number and total number of bundles.

However, even though I just want to update only the first empty row once, it updates as many times as the total row number. (11 times executed on Open AI module as well)

How can I achieve to get the first empty row and execute OpenAI module and update a row module only once?

Thanks in advance!

[abhilash_naik]

Hi @rym413 , welcome to the community. In order to get empty rows, you need to select doesn’t exist

[Yogesh_Borad]

Hello @rym413,
I have tried your use-case scenario.
you can try this one, it may work for you!

Detailed explanation of each module:
→ search rows: get all the rows without filters

→ Array AG: get your required field, don’t forget raw number.

e
→ Iterator:
→ Filter:

[rym413]

Thanks, @abhilash_naik ! I always thought this works but it didn’t:/

[rym413]

@Yogesh_Borad this worked, thanks a lot! Really appreciate it.