Loop + Find Rows from Google Sheets

[Spyros]

Hi Team,

I’m trying to create the following flow.

• Every X minutes
• Go through a Google Sheet, and pull the rows that have 1 in X column. This is feasible with FindRows
• Loop the data and send 1x custom email to each email (one per row). The email is another column of this sheet

My problem:

• I make the loop iterate properly, but I do not get the correct data, although I take the items from within the loop piece (which was the most common problem I noticed in the community)

I have started thinking that I should edit the data with an extra step.

I’d appreciate some help. Screenshots attached.

Thanks a lot!

[kishanprmr]

@Spyros

I make the loop iterate properly, but I do not get the correct data, although I take the items from within the loop piece (which was the most common problem I noticed in the community)

Hello @Spyros,

Can you provide an example of the missing data? For instance, do a few columns show incorrect data, such as null values or empty text?

[Spyros]

Yes, thanks! I get empty fields. Like nothing.

[abuaboud]

Hi @Spyros

Please retest the loop step, and remap the data, It should be fixed now.

Thank you so much.
Mo.