Iterating through Google Sheet Rows

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?

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:

youtube.com/watch?v=zJaGQ-SIB0I

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.

https://connect.pabbly.com/workflow/mapping/IjU3NjUwNTZkMDYzNjA0MzQ1MjZiNTUzNjUxMzAi_pc

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.