Mapping issue between google-sheets:watchRows and builtin:BasicFeeder

How To
,
1

Hi everyone,

I’m having an issue in my Make scenario. The google-sheets:watchRows module successfully retrieves data from my Google Sheets (see logs below), but the builtin:BasicFeeder module doesn’t receive it. I’ve tried mapping {{1.rows}} and {{1}}, but nothing works.

Logs from google-sheets:watchRows:

[
    { "0": "02/01/2025 14:48:59", "1": "2025-2026", "2": "gilles.bouchonneau@gmail.com", ... },
    { "0": "02/01/2025 21:07:45", "1": "2024-2025", "2": "gilles.bouchonneau@gmail.com", ... }
]

Issue:
The mapping array: {{1.rows}} or array: {{1}} doesn’t pass the data to builtin:BasicFeeder. The iterator logs show an empty array.

Questions:

  1. How can I properly map the data between these modules?
  2. Should I use an intermediate module to reformat the data?

Thanks for your help!
Gilles

2

Hello @Gilles,
Can you please share some screenshots related to it?

  • About your input/output.
  • About your filter integration.
  • About your data mapping.

That helps to understand and fix it quickly.

3

Hello

There is my screenshots. Thank you for help me.

Capture d’écran du 2025-01-06 12-22-07
Capture d’écran du 2025-01-06 12-22-071781×394 56.2 KB

there is my output (google sheets)

[
    {
        "0": "02/01/2025 14:48:59",
        "1": "2025-2026",
        "2": "xx@gmail.com",
        "3": "+00000000",
        "4": "Homme",
        "5": "xxx",
        "6": "xxx",
        "7": "05/09/1973",
        "8": "50 rue xxxx",
        "9": "51100",
        "10": "Reims",
        "11": "FRANCE",
        "12": "Individuel (25€)",
        "13": "Dirigeant (100€)",
        "14": "Virement",
        "15": "70",
        "16": "",
        "17": "Virement",
        "18": "",
        "19": "15",
        "20": "Virement",
        "21": "",
        "22": "15",
        "23": "Virement",
        "24": "0",
        "__ROW_NUMBER__": 2,
        "__SPREADSHEET_ID__": "xxxx",
        "__SHEET__": "2024-2025"
    },
    {
        "0": "02/01/2025 21:07:45",
        "1": "2024-2025",
        "2": "xxx@gmail.com",
        "3": "+000000000",
        "4": "Homme",
        "5": "xxx",
        "6": "xxx",
        "7": "05/09/1973",
        "8": "50 rue xxx",
        "9": "51100",
        "10": "REIMS",
        "11": "FRANCE",
        "12": "Individuel (25€)",
        "13": "Football masculin (200€) (+20ans)",
        "14": "Virement",
        "15": "100",
        "16": "",
        "17": "Virement",
        "18": "",
        "19": "50",
        "20": "Virement",
        "21": "",
        "22": "35",
        "23": "Virement",
        "24": "25",
        "__ROW_NUMBER__": 3,
        "__SPREADSHEET_ID__": "xxxx",
        "__SHEET__": "2024-2025"
    }
]

there is my input (iterator)

[
    {
        "array": null
    }
]

there is my output (iterator)

[]

Best regards
Gilles

4

Hello

I founded and I’m very happy.
Finally, i delete the second module “iterator”

There is my final scenario

Capture d’écran du 2025-01-08 14-57-23
Capture d’écran du 2025-01-08 14-57-231778×401 61.7 KB

Thanks your for seeing my post

2 Likes