Get Sheets Rows + Iterator

[vemarketing]

How do I use the Google Sheets - Get Rows and Pabbly Iterator together. When I get the rows using Google Sheets and add Iterator after that step the Array in Iterator doesnt let me choose anything. Am I doing something wrong?

Thanks

 

[vemarketing]

I think i figured it out on my own, you must turn off the "Simple Response" to get the data in an Array format, then it lets you choose "Response Results" in the Iterator screen.

 

[Pabblymember11]

Hey @vemarketing

Yes, you need to toggle the "Simple Response" button first and then have to capture the advanced API response in the Trigger and Action step in the array format.

You can also refer to the following video tutorial for a better understanding.

 

[e0979d]

I´m unsure on how the iterator works as well. I want to "read" through a number of rows in a google sheets file, that is not the trigger, to obtain data for my next step. How can I use it?

 

[Pabblymember11]

I´m unsure on how the iterator works as well. I want to "read" through a number of rows in a google sheets file, that is not the trigger, to obtain data for my next step. How can I use it?

When configuring the workflow with the iterator action step, you will initially see only the first item of the array.
However, once the workflow is triggered, it dynamically goes through each row to all the numbers within the array.

Whereas you don't need to worry about missing out on any important information - the iterator action step ensures that every item in the array is accounted for and processed accordingly. So, rest assured that your workflow will efficiently handle all the numbers in the array in execution, enabling you to effectively manage your tasks without any omissions.