How to extract data(each row)from google sheet, want to iterate all data from google sheets by going through each row

How To
, ,
1

Here as mentioned in the screenshot below

Here I have a Google sheet containing some data, on how I have to iterate every row when a row is not empty and I have to send all iterated data through the email, which one I have to use iterator (or) array aggregator (or) repeater?

(Image of google sheet)

image
image1645×637 60.2 KB

2

Hi Sujay,
You can use an iterator combined with the Google Sheets Search Row Module to iterate through every non-empty row in your data set.
After which, employ a text aggregator to craft the email content based on the iterated data before sending it via the Gmail Module.