Iterator is not taking all inputs in the Array

I am creating an Blog Publishing Automation containing

Google Sheets (search rows advanced) >> Iterator (MAP ON with {{2. B}}) >> HTTP module.

But on running scenario, then Google Sheets is working properly and sending me all 33 outputs but Iterator is not receiving all the as an Input to send it to the HTTP module.



And Showing this error -

I almost tried everything but nothing is happening…what should I do now?

Hello @Kamalkant_Choudhary,
Your sheet returns bundles and the Iterator needs Array as input.
In terms of Make Bundles, they are separate collections or you can say objects.

Just use the Array Aggregator after Sheets(Search Rows) and before the Iterator.


:bulb:P.S.: Always search first, Check Make Academy. If this is helpful, Mark Best as Solutions :white_check_mark: and give :+1:
If you need expert help or have questions? Contact or comment below! :point_down:

1 Like

Thank you Dilip Sir, It helped me to solve the problem :smiling_face: SEE-

But Now I got another problem…let me tell you the whole story…

I am getting channel names and IDs from my google sheets (With headers, Channel Names [Column A] and Channel IDs [Column B]).


But on running the scenario, it is showing me the error of 400 bad request.

As I checked all inputs (Query String parameters) is correct but i don’t know how to stop referencing the column header "Channel IDs" in the query string. I don’t know how to reference the actual values from Column B in my Google Sheet, rather than the column header. SEE -


This is the Value in the HTTP module i am using as an input from Iterator. SEE-

Now what should I do SIR? :thinking:

(Plus, thank you for helping me out…)

Hello @Kamkalkant_Chaudhary,

You need to add Filters before your HTTP module.
Read this for more information https://www.make.com/en/help/scenarios/filtering

After reading it set negative filters like, your column value not equal to "Channel Names and “Channel IDs”.

If you are still confused about filters check this video tutorial. https://academy.make.com/courses/FoundationC02

I hope this helps you.
:+1: