Iterating through Google Sheet Rows

[MikePearce]

I think I'm missing something simple here, when I use Get ROws for Google SHeets, how can I then iterate through each of those rows and do something with them?

 

[Arshita]

Hey @MikePearce

Kindly provide us with the workflow name in which you are getting the issue so we can check on it and guide you further.

Also, please refer to the below video tutorial to understand more clearly on Iterator module:

 

[MikePearce]

Hi,

Thanks - I did watch that, but it uses the iterator to read JSON and post to Google sheets. What I want to is _read_ several rows from google sheets, then do something with each of them.

Pabbly - Online Marketing & Sales Software

Automate your sales and marketing with Pabbly. Unite email marketing, lead capture, WordPress themes, subscription all at one place.

connect.pabbly.com

 

[ArshilAhmad]

Hey @MikePearce,

This is how you are supposed to use Iterator with Google Sheets: Get Row(s) action event.

1. Google Sheet: Get Row(s) captures the entire data from your spreadsheet.
2. The Iterator processes each row of your spreadsheet one at a time.

You can then use the responses from the Iterator in whatever way you desire.