Iterator Module Not Recognizing {{rows}} Array from Google Sheets Search Rows - UI Mapping Issue or Skill Issue?

[CIT_BV]

Hi community!

I’m building an automation to sync data from a Google Sheets to another sheet (expanding one row per product with 5 image URLs into 5 separate rows for posting).

The Google Sheets > Search Rows module is working perfectly, fetching 5 rows with product names in field 0 and URLs in 1-5.

But when I try to feed this into an Iterator to loop over each product row, the mapping panel refuses to show the rows array, and typing {{2.rows}} in the Array field results in no output (e.g., bundles with value: 2, value: 3 for row numbers only).

Has anyone run into this?

Is it a UI caching bug, or am I missing a config tweak?

I’d love any insights or workarounds (screenshots attached for details)

Quick Setup Recap

• Trigger: Google Sheets > Watch Rows (A-F columns).

• Module 2: Google Sheets > Search Rows (fetch all populated rows):

  • Spreadsheet ID: [redacted].

  • Sheet: Same as above.

  • Table Contains Headers: Yes.

  • Table First Row: A1:F1.

  • Filter: Field “0” Exists (product names in A).

  • Order By: Row number, Ascending.

  • Value Render Option: Formatted Value.

  • Limit: 100.

• Output from Module 2 (runs fine, 5 rows as expected):

  • Array of 5 items, e.g.:

    [
      {
        "0": "SpaceBox",
        "1": "https://s3-placid...nbq80ocl.jpg",
        "2": "https://s3-placid...7ys30zxt.jpg",
        "3": "https://s3-placid...sgzcivmb.jpg",
        "4": "https://s3-placid...qiqbegdq.jpg",
        "5": "https://s3-placid...3a7fptlc.jpg",
        "__ROW_NUMBER__": 2
      },
      // ... 4 more similar rows for "BoomPop Lite", etc.
    ]
    

• Module 3: Iterator (to loop over each product row):

  • Array field: Typed {{2.rows}} (manually, since not visible in panel).

  • Expected: 5 bundles, each with 0 (product name) and 1-5 (URLs).

  • Actual: 5 bundles, each with only value: 2 (or row number) and _IMTINDEX_: 1, _IMTLENGTH_: 1. No product data or URLs.

What I’ve Tried

• Rerun Search Rows multiple times to refresh schema.

• Typed {{2.rows}} manually (panel shows only _IMTLENGTH_, _IMTINDEX_, _ROW_NUMBER_, _SHEET_, and individual A-Z fields – no rows.

• Refreshed page, deleted/re-added Iterator.

• Switched Table Contains Headers to No (fields become A-F, but still no rows.

• Tried BasicFeeder instead, same issue.

Expected Output:

SHEET 1 INPUT

SHEET 2 expected OUTPUT

[Stoyan_Vatov]

Hey there,

Search modules already return separate bundles for each item found. There is no need to use an iterator afterwards.
Your screenshot also shows that the item you have is a Collection and not an Array.

[CIT_BV]

Thank you for your answer !

How should I proceed next then ?

[Stoyan_Vatov]

Remove the iterator and map whatever it is you need in the next module. When you run the scenario it will get executed as many times as there are rows returned by the Search module.

[CIT_BV]

That’s what i’m trying to figure out..

How to go from Sheet 1

to Sheet 2

Knowing that I get all 5 bundles this way from Sheet 1

What’s the best course to translate these bundles in order to have them added in a 2 column, Name & Links

[Stoyan_Vatov]

Ah ok, well there are multiple ways to do that. You can use an Aggregator to turn the Search module in an array and use that to map the values in a Bulk Update module.

Or you can use an incremental formula with Update a Cell module to transfer them that way.

If you need help with specifics, can you copy paste the output of the Search module here so we can test with it and give easy to implement solutions?

[CIT_BV]

I’ve been trying to use an aggregator with no success yet (i’m not so familiar with functions, and Grok is just making up non existent functions).

I’m open to whatever is the easiest/quickest (or whatever works )

Sure, here’s the output from Search:

[
    {
        "0": "SpaceBox",
        "1": "https://s3-placid.s3.eu-central-1.amazonaws.com/production/rest-images/soaofx0o4rr1r/int-62cf95e109e704a2fe87b8e548ddc5f4-nbq80ocl.jpg",
        "2": "https://s3-placid.s3.eu-central-1.amazonaws.com/production/rest-images/soaofx0o4rr1r/int-af5efcd1780bb23bf03ad4ceca3fe4d9-7ys30zxt.jpg",
        "3": "https://s3-placid.s3.eu-central-1.amazonaws.com/production/rest-images/soaofx0o4rr1r/int-efcaae9f52290255ae7b2d66a38ee1c4-sgzcivmb.jpg",
        "4": "https://s3-placid.s3.eu-central-1.amazonaws.com/production/rest-images/soaofx0o4rr1r/int-12df4e5ffbbfb5d96426251b48fe27bc-qiqbegdq.jpg",
        "5": "https://s3-placid.s3.eu-central-1.amazonaws.com/production/rest-images/soaofx0o4rr1r/int-c88621732958a311c6e188a684bdb537-3a7fptlc.jpg",
        "__ROW_NUMBER__": 2,
        "__SPREADSHEET_ID__": "145NP7i2yxIySPdjQHmCjSFOcouX8Hmde-DogzxPGRoM",
        "__SHEET__": "Image Link",
        "__IMTLENGTH__": 5,
        "__IMTINDEX__": 1
    },
    {
        "0": "BoomPop Lite",
        "1": "https://s3-placid.s3.eu-central-1.amazonaws.com/production/rest-images/soaofx0o4rr1r/int-3eb89cf7ffc714c0ed23bb7b2dde51b9-puytd1cw.jpg",
        "2": "https://s3-placid.s3.eu-central-1.amazonaws.com/production/rest-images/soaofx0o4rr1r/int-7a90b83686b084012e334a4247dc5a5d-kzo3pezh.jpg",
        "3": "https://s3-placid.s3.eu-central-1.amazonaws.com/production/rest-images/soaofx0o4rr1r/int-ad82b6859662ace29a850bcd47b7354e-lhyose92.jpg",
        "4": "https://s3-placid.s3.eu-central-1.amazonaws.com/production/rest-images/soaofx0o4rr1r/int-831210085505bc356b4d05aae6b4244a-9wombroe.jpg",
        "5": "https://s3-placid.s3.eu-central-1.amazonaws.com/production/rest-images/soaofx0o4rr1r/int-8d3bdb3f9dc01b12e3b8f47e80e46e26-prhqglrp.jpg",
        "__ROW_NUMBER__": 3,
        "__SPREADSHEET_ID__": "145NP7i2yxIySPdjQHmCjSFOcouX8Hmde-DogzxPGRoM",
        "__SHEET__": "Image Link",
        "__IMTLENGTH__": 5,
        "__IMTINDEX__": 2
    },
    {
        "0": "SpaceBudsPro",
        "1": "https://s3-placid.s3.eu-central-1.amazonaws.com/production/rest-images/soaofx0o4rr1r/int-d92ac6cb36d4d1fe0a0fdcf691ed962f-khrq6udp.jpg",
        "2": "https://s3-placid.s3.eu-central-1.amazonaws.com/production/rest-images/soaofx0o4rr1r/int-037fc6eb93d744046604c3dbf96831d5-21uhhv1f.jpg",
        "3": "https://s3-placid.s3.eu-central-1.amazonaws.com/production/rest-images/soaofx0o4rr1r/int-a665ff7c65d802d538f7c98e85f0cd68-36afkcmq.jpg",
        "4": "https://s3-placid.s3.eu-central-1.amazonaws.com/production/rest-images/soaofx0o4rr1r/int-db2c8826de9baf5d175fab7b038f0375-9jomlfow.jpg",
        "5": "https://s3-placid.s3.eu-central-1.amazonaws.com/production/rest-images/soaofx0o4rr1r/int-d6f5dc7a8dee77a5b0968dfd9dfc1989-zzju85km.jpg",
        "__ROW_NUMBER__": 4,
        "__SPREADSHEET_ID__": "145NP7i2yxIySPdjQHmCjSFOcouX8Hmde-DogzxPGRoM",
        "__SHEET__": "Image Link",
        "__IMTLENGTH__": 5,
        "__IMTINDEX__": 3
    },
    {
        "0": "Watch Pro AM",
        "1": "https://s3-placid.s3.eu-central-1.amazonaws.com/production/rest-images/soaofx0o4rr1r/int-e48472278a0bc18bae73a619674de8c4-tnw0wuum.jpg",
        "2": "https://s3-placid.s3.eu-central-1.amazonaws.com/production/rest-images/soaofx0o4rr1r/int-241149107b80ec3db04d9ac6964558fd-v1xo1vgy.jpg",
        "3": "https://s3-placid.s3.eu-central-1.amazonaws.com/production/rest-images/soaofx0o4rr1r/int-a75f6a43c8382bed21c92fa06f4a4311-8knasi4g.jpg",
        "4": "https://s3-placid.s3.eu-central-1.amazonaws.com/production/rest-images/soaofx0o4rr1r/int-1b7a0388be34f49c5306f7a10ae398cf-jhnl2mvh.jpg",
        "5": "https://s3-placid.s3.eu-central-1.amazonaws.com/production/rest-images/soaofx0o4rr1r/int-6f73d0b2ae4a65fca15627c97ad09091-cxxai59f.jpg",
        "6": "",
        "7": "",
        "8": "",
        "9": "",
        "10": "",
        "11": "16",
        "__ROW_NUMBER__": 5,
        "__SPREADSHEET_ID__": "145NP7i2yxIySPdjQHmCjSFOcouX8Hmde-DogzxPGRoM",
        "__SHEET__": "Image Link",
        "__IMTLENGTH__": 5,
        "__IMTINDEX__": 4
    },
    {
        "0": "OpenCirclet 2",
        "1": "https://s3-placid.s3.eu-central-1.amazonaws.com/production/rest-images/soaofx0o4rr1r/int-4bc71496c5d3526dedce4820d2825b58-v05iqrse.jpg",
        "2": "https://s3-placid.s3.eu-central-1.amazonaws.com/production/rest-images/soaofx0o4rr1r/int-7d1b978c9b9234389efe1aae97e1937b-irfl1ch9.jpg",
        "3": "https://s3-placid.s3.eu-central-1.amazonaws.com/production/rest-images/soaofx0o4rr1r/int-55458cbb9912a39b10c79ce91c0535bc-2mw3gjgm.jpg",
        "4": "https://s3-placid.s3.eu-central-1.amazonaws.com/production/rest-images/soaofx0o4rr1r/int-2a871afd812b28134232f83529e20dfa-5gghplod.jpg",
        "5": "https://s3-placid.s3.eu-central-1.amazonaws.com/production/rest-images/soaofx0o4rr1r/int-dcb14c8add24ea64c09a1e3b81e5e16c-5gmslgri.jpg",
        "6": "",
        "7": "",
        "8": "",
        "9": "",
        "10": "",
        "11": "17",
        "__ROW_NUMBER__": 6,
        "__SPREADSHEET_ID__": "145NP7i2yxIySPdjQHmCjSFOcouX8Hmde-DogzxPGRoM",
        "__SHEET__": "Image Link",
        "__IMTLENGTH__": 5,
        "__IMTINDEX__": 5
    }
]

[Stoyan_Vatov]

Transformer.blueprint.json (31.5 KB)

Here, something like this should do the transformation and be easily scalable.

But if you want to look into it deeper, I’m fairly certain you can do this within the sheet itself using an app script and not use Make at all.