Facebook leads to google sheets

Current Scenario

Refer Similiar Topic

Facebook Leads has a output named platform ,while rest of the variables are getting updated in sheets , the variable platform is not being reflected in sheets

I have tried to add and remove other variables and checked the bundle content input and found only the platform variable missing and the rest of the variables present

Input Bundle


[
    {
        "from": "drive",
        "mode": "select",
        "values": {
            "0": "421492377300207",
            "1": "2024-05-04T10:32:35.000Z",
            "2": "immediately",
            "3": "++++++++++++++",
            "4": "+++++++++++++",
            "5": "***********",
            "6": "______________",
            "8": "false"
        },
        "sheetId": "*********",
        "spreadsheetId": "/*****************",
        "includesHeaders": true,
        "insertDataOption": "INSERT_ROWS",
        "valueInputOption": "USER_ENTERED",
        "insertUnformatted": false
    }
]




Hi @jebah

Welcome to community.

If you’re mapping an array, it will only propagate the first item from the array. To retrieve all items, use the get function. If you need different rows for each item, use the iterator.

If you require additional assistance, please don’t hesitate to reach out to us.
MSquare Support | Book Live Implementation
Visit us here
Youtube Channel

2 Likes

@Msquare_Automation

verified input bundle . Nil array map being used . Fault persists

Hi @jebah

Please ensure that the platform value is passed from the trigger in the output bundle. The platform value will only be added if it exists. From the provided input bundle, it seems there is no value present. If you can provide the output bundle of the trigger, we would be happy to assist you further.

1 Like

Output Bundle

[
    {
        "spreadsheetId": "*******",
        "tableRange": "*******!A1:I472",
        "updates": {
            "spreadsheetId": "1**********",
            "updatedRange": "********!A473:I473",
            "updatedRows": 1,
            "updatedColumns": 8,
            "updatedCells": 8
        },
        "sheetName": "*******",
        "rowNumber": 473
    }
]


Hi @jebah
Can you provide the output bundle of Facebook module?

Facebook Out Put Bundles


{
        "leadgenId": "3568548106729858",
        "formId": "2815431108605279",
        "isOrganic": false,
        "adId": "***",
        "adName": "***",
        "adsetId": "***",
        "adsetName": "New Leads Ad set with recommended settings",
        "campaignId": "***",
        "campaignName": "I{
        "leadgenId": "3568548106729858",
        "formId": "2815431108605279",
        "isOrganic": false,
        "adId": "120208243408220269",
        "adName": "***",
        "adsetId": "120208243408230269",
        "adsetName": "New Leads Ad set with recommended settings",
        "campaignId": "120208243408240269",
        "campaignName": "***",
        "dateCreated": "2024-05-04T08:14:02.000Z",
        "data": {
            "how_soon_you_want_to_start?": [
                "within_a_month"
            ],
            "full_name": "***",
            "email": "***",
            "phone_number": "***",
            "city": "***"
        }
    },",
        "dateCreated": "2024-05-04T08:14:02.000Z",
        "data": {
            "how_soon_you_want_to_start?": [
                "within_a_month"
            ],
            "full_name": "***",
            "email": "***",
            "phone_number": "***",
            "city": "***"
        }
    },


Blueprint


{
    "name": "Integration Facebook Lead Ads, Google Sheets",
    "flow": [
        {
            "id": 1,
            "module": "facebook-lead-ads:WatchLeads",
            "version": 2,
            "parameters": {
                "__IMTCONN__": 1543473,
                "pageId": "******",
                "limit": 20,
                "formId": "*****"
            },
            "mapper": {},
            "metadata": {
                "designer": {
                    "x": 0,
                    "y": 0
                },
                "restore": {
                    "parameters": {
                        "__IMTCONN__": {
                            "label": "*************)",
                            "data": {
                                "scoped": "true",
                                "connection": "facebook"
                            }
                        },
                        "pageId": {
                            "mode": "chose",
                            "label": "***"
                        },
                        "formId": {
                            "mode": "chose",
                            "label": "***"
                        }
                    }
                },
                "parameters": [
                    {
                        "name": "__IMTCONN__",
                        "type": "account:facebook",
                        "label": "Connection",
                        "required": true
                    },
                    {
                        "name": "pageId",
                        "type": "select",
                        "label": "Page",
                        "required": true
                    },
                    {
                        "name": "limit",
                        "type": "uinteger",
                        "label": "Limit",
                        "required": true
                    },
                    {
                        "name": "formId",
                        "type": "select",
                        "label": "Form",
                        "required": true
                    }
                ],
                "interface": [
                    {
                        "name": "leadgenId",
                        "label": "Lead ID",
                        "type": "text"
                    },
                    {
                        "name": "formId",
                        "label": "Form ID",
                        "type": "text"
                    },
                    {
                        "name": "dateCreated",
                        "label": "Date created",
                        "type": "date"
                    },
                    {
                        "name": "adId",
                        "label": "Ad ID",
                        "type": "text"
                    },
                    {
                        "name": "data",
                        "label": "Field data",
                        "type": "collection",
                        "spec": [
                            {
                                "name": "how_soon_you_want_to_start?",
                                "label": "How soon you want to start?",
                                "type": "array"
                            },
                            {
                                "name": "full_name",
                                "label": "Full name",
                                "type": "text"
                            },
                            {
                                "name": "email",
                                "label": "Email",
                                "type": "text"
                            },
                            {
                                "name": "phone_number",
                                "label": "Phone number",
                                "type": "text"
                            },
                            {
                                "name": "city",
                                "label": "City",
                                "type": "text"
                            }
                        ]
                    },
                    {
                        "name": "isOrganic",
                        "label": "Is organic",
                        "type": "boolean"
                    },
                    {
                        "name": "adName",
                        "label": "Ad name",
                        "type": "text"
                    },
                    {
                        "name": "adsetId",
                        "label": "Ad set ID",
                        "type": "text"
                    },
                    {
                        "name": "adsetName",
                        "label": "Adset name",
                        "type": "text"
                    },
                    {
                        "name": "campaignId",
                        "label": "Campaign ID",
                        "type": "text"
                    },
                    {
                        "name": "campaignName",
                        "label": "Campaign name",
                        "type": "text"
                    },
                    {
                        "name": "customDisclaimerResponses",
                        "label": "Custom disclaimer responses",
                        "type": "collection"
                    },
                    {
                        "name": "homeListing",
                        "label": "Home listing",
                        "type": "collection"
                    },
                    {
                        "name": "partnerName",
                        "label": "Partner name",
                        "type": "text"
                    },
                    {
                        "name": "platform",
                        "label": "Platform",
                        "type": "text"
                    },
                    {
                        "name": "retailerItemId",
                        "label": "Retailer item ID",
                        "type": "text"
                    },
                    {
                        "name": "vehicle",
                        "label": "Vehicle",
                        "type": "collection"
                    }
                ]
            }
        },
        {
            "id": 2,
            "module": "google-sheets:addRow",
            "version": 2,
            "parameters": {
                "__IMTCONN__": 1543493
            },
            "mapper": {
                "from": "drive",
                "mode": "select",
                "values": {
                    "0": "{{1.leadgenId}}",
                    "1": "{{1.dateCreated}}",
                    "2": "{{1.data.`how_soon_you_want_to_start?`}}",
                    "3": "{{1.data.full_name}}",
                    "4": "{{1.data.email}}",
                    "5": "{{1.data.phone_number}}",
                    "6": "{{1.data.city}}",
                    "7": "{{1.platform}}",
                    "8": "{{1.isOrganic}}"
                },
                "sheetId": "***",
                "spreadsheetId": "/1***",
                "includesHeaders": true,
                "insertDataOption": "INSERT_ROWS",
                "valueInputOption": "USER_ENTERED",
                "insertUnformatted": false
            },
            "metadata": {
                "designer": {
                    "x": 300,
                    "y": 0
                },
                "restore": {
                    "expect": {
                        "from": {
                            "label": "My Drive"
                        },
                        "mode": {
                            "label": "Select by path"
                        },
                        "sheetId": {
                            "label": "***"
                        },
                        "spreadsheetId": {
                            "path": [
                                "***"
                            ]
                        },
                        "includesHeaders": {
                            "label": "Yes",
                            "nested": [
                                {
                                    "name": "values",
                                    "spec": [
                                        {
                                            "name": "0",
                                            "type": "text",
                                            "label": "A"
                                        },
                                        {
                                            "name": "1",
                                            "type": "text",
                                            "label": "B"
                                        },
                                        {
                                            "name": "2",
                                            "type": "text",
                                            "label": "C"
                                        },
                                        {
                                            "name": "3",
                                            "type": "text",
                                            "label": "D"
                                        },
                                        {
                                            "name": "4",
                                            "type": "text",
                                            "label": "E"
                                        },
                                        {
                                            "name": "5",
                                            "type": "text",
                                            "label": "F"
                                        },
                                        {
                                            "name": "6",
                                            "type": "text",
                                            "label": "G"
                                        },
                                        {
                                            "name": "7",
                                            "type": "text",
                                            "label": "H"
                                        },
                                        {
                                            "name": "8",
                                            "type": "text",
                                            "label": "I"
                                        },
                                        {
                                            "name": "9",
                                            "type": "text",
                                            "label": "J"
                                        },
                                        {
                                            "name": "10",
                                            "type": "text",
                                            "label": "K"
                                        },
                                        {
                                            "name": "11",
                                            "type": "text",
                                            "label": "L"
                                        },
                                        {
                                            "name": "12",
                                            "type": "text",
                                            "label": "M"
                                        },
                                        {
                                            "name": "13",
                                            "type": "text",
                                            "label": "N"
                                        },
                                        {
                                            "name": "14",
                                            "type": "text",
                                            "label": "O"
                                        },
                                        {
                                            "name": "15",
                                            "type": "text",
                                            "label": "P"
                                        },
                                        {
                                            "name": "16",
                                            "type": "text",
                                            "label": "Q"
                                        },
                                        {
                                            "name": "17",
                                            "type": "text",
                                            "label": "R"
                                        },
                                        {
                                            "name": "18",
                                            "type": "text",
                                            "label": "S"
                                        },
                                        {
                                            "name": "19",
                                            "type": "text",
                                            "label": "T"
                                        },
                                        {
                                            "name": "20",
                                            "type": "text",
                                            "label": "U"
                                        },
                                        {
                                            "name": "21",
                                            "type": "text",
                                            "label": "V"
                                        },
                                        {
                                            "name": "22",
                                            "type": "text",
                                            "label": "W"
                                        },
                                        {
                                            "name": "23",
                                            "type": "text",
                                            "label": "X"
                                        },
                                        {
                                            "name": "24",
                                            "type": "text",
                                            "label": "Y"
                                        },
                                        {
                                            "name": "25",
                                            "type": "text",
                                            "label": "Z"
                                        }
                                    ],
                                    "type": "collection",
                                    "label": "Values"
                                }
                            ]
                        },
                        "insertDataOption": {
                            "mode": "chose",
                            "label": "Insert rows"
                        },
                        "valueInputOption": {
                            "mode": "chose",
                            "label": "User entered"
                        },
                        "insertUnformatted": {
                            "mode": "chose"
                        }
                    },
                    "parameters": {
                        "__IMTCONN__": {
                            "data": {
                                "scoped": "true",
                                "connection": "google"
                            },
                            "label": "***"
                        }
                    }
                },
                "parameters": [
                    {
                        "name": "__IMTCONN__",
                        "type": "account:google",
                        "label": "Connection",
                        "required": true
                    }
                ],
                "expect": [
                    {
                        "name": "mode",
                        "type": "select",
                        "label": "Choose a Method",
                        "required": true,
                        "validate": {
                            "enum": [
                                "select",
                                "fromAll",
                                "map"
                            ]
                        }
                    },
                    {
                        "name": "insertUnformatted",
                        "type": "boolean",
                        "label": "Unformatted",
                        "required": true
                    },
                    {
                        "name": "valueInputOption",
                        "type": "select",
                        "label": "Value input option",
                        "validate": {
                            "enum": [
                                "USER_ENTERED",
                                "RAW"
                            ]
                        }
                    },
                    {
                        "name": "insertDataOption",
                        "type": "select",
                        "label": "Insert data option",
                        "validate": {
                            "enum": [
                                "INSERT_ROWS",
                                "OVERWRITE"
                            ]
                        }
                    },
                    {
                        "name": "from",
                        "type": "select",
                        "label": "Choose a Drive",
                        "required": true,
                        "validate": {
                            "enum": [
                                "drive",
                                "share",
                                "team"
                            ]
                        }
                    },
                    {
                        "name": "spreadsheetId",
                        "type": "file",
                        "label": "Spreadsheet ID",
                        "required": true
                    },
                    {
                        "name": "sheetId",
                        "type": "select",
                        "label": "Sheet Name",
                        "required": true
                    },
                    {
                        "name": "includesHeaders",
                        "type": "select",
                        "label": "Table contains headers",
                        "required": true,
                        "validate": {
                            "enum": [
                                true,
                                false
                            ]
                        }
                    },
                    {
                        "name": "values",
                        "spec": [
                            {
                                "name": "0",
                                "type": "text",
                                "label": "A"
                            },
                            {
                                "name": "1",
                                "type": "text",
                                "label": "B"
                            },
                            {
                                "name": "2",
                                "type": "text",
                                "label": "C"
                            },
                            {
                                "name": "3",
                                "type": "text",
                                "label": "D"
                            },
                            {
                                "name": "4",
                                "type": "text",
                                "label": "E"
                            },
                            {
                                "name": "5",
                                "type": "text",
                                "label": "F"
                            },
                            {
                                "name": "6",
                                "type": "text",
                                "label": "G"
                            },
                            {
                                "name": "7",
                                "type": "text",
                                "label": "H"
                            },
                            {
                                "name": "8",
                                "type": "text",
                                "label": "I"
                            },
                            {
                                "name": "9",
                                "type": "text",
                                "label": "J"
                            },
                            {
                                "name": "10",
                                "type": "text",
                                "label": "K"
                            },
                            {
                                "name": "11",
                                "type": "text",
                                "label": "L"
                            },
                            {
                                "name": "12",
                                "type": "text",
                                "label": "M"
                            },
                            {
                                "name": "13",
                                "type": "text",
                                "label": "N"
                            },
                            {
                                "name": "14",
                                "type": "text",
                                "label": "O"
                            },
                            {
                                "name": "15",
                                "type": "text",
                                "label": "P"
                            },
                            {
                                "name": "16",
                                "type": "text",
                                "label": "Q"
                            },
                            {
                                "name": "17",
                                "type": "text",
                                "label": "R"
                            },
                            {
                                "name": "18",
                                "type": "text",
                                "label": "S"
                            },
                            {
                                "name": "19",
                                "type": "text",
                                "label": "T"
                            },
                            {
                                "name": "20",
                                "type": "text",
                                "label": "U"
                            },
                            {
                                "name": "21",
                                "type": "text",
                                "label": "V"
                            },
                            {
                                "name": "22",
                                "type": "text",
                                "label": "W"
                            },
                            {
                                "name": "23",
                                "type": "text",
                                "label": "X"
                            },
                            {
                                "name": "24",
                                "type": "text",
                                "label": "Y"
                            },
                            {
                                "name": "25",
                                "type": "text",
                                "label": "Z"
                            }
                        ],
                        "type": "collection",
                        "label": "Values"
                    }
                ],
                "advanced": true
            }
        }
    ],
    "metadata": {
        "instant": false,
        "version": 1,
        "scenario": {
            "roundtrips": 1,
            "maxErrors": 3,
            "autoCommit": true,
            "autoCommitTriggerLast": true,
            "sequential": false,
            "slots": null,
            "confidential": false,
            "dataloss": false,
            "dlq": false,
            "freshVariables": false
        },
        "designer": {
            "orphans": []
        },
        "zone": "eu2.make.com"
    }
}