{
    "name": "[LTV] [Imersão] - Adiciona Lead Google Sheets",
    "flow": [
        {
            "id": 1,
            "module": "gateway:CustomWebHook",
            "version": 1,
            "parameters": {
                "hook": 776895,
                "maxResults": 1
            },
            "mapper": {},
            "metadata": {
                "designer": {
                    "x": 0,
                    "y": 0
                },
                "restore": {
                    "parameters": {
                        "hook": {
                            "data": {
                                "editable": "true"
                            },
                            "label": "LTV Sheet - Hotmart"
                        }
                    }
                },
                "parameters": [
                    {
                        "name": "hook",
                        "type": "hook:gateway-webhook",
                        "label": "Webhook",
                        "required": true
                    },
                    {
                        "name": "maxResults",
                        "type": "number",
                        "label": "Maximum number of results"
                    }
                ]
            }
        },
        {
            "id": 2,
            "module": "google-sheets:addRow",
            "version": 2,
            "parameters": {
                "__IMTCONN__": 822997
            },
            "mapper": {
                "mode": "select",
                "insertUnformatted": false,
                "valueInputOption": "USER_ENTERED",
                "insertDataOption": "INSERT_ROWS",
                "from": "drive",
                "spreadsheetId": "/1JHiyizdCK1-sdysVQg9w8RrTUx0l3sge/1A9VwwjfscJWOpt3yy93UaEPInx7rimsOl5pTxp2StPQ",
                "sheetId": "Cópia de DB",
                "includesHeaders": true,
                "values": {
                    "0": "{{formatDate(now; \"DD/MM/YY\")}}",
                    "1": "{{1.Nome}}",
                    "2": "{{1.`E-mail`}}",
                    "3": "{{1.wpp}}",
                    "4": "{{false}}",
                    "5": "{{1.utm_source}}",
                    "6": "{{1.utm_medium}}",
                    "7": "{{1.utm_campaign}}"
                }
            },
            "metadata": {
                "designer": {
                    "x": 300,
                    "y": 0
                },
                "restore": {
                    "parameters": {
                        "__IMTCONN__": {
                            "label": "My Google connection (ma.domingues.dias@gmail.com)",
                            "data": {
                                "scoped": "true",
                                "connection": "google"
                            }
                        }
                    },
                    "expect": {
                        "mode": {
                            "label": "Select by path"
                        },
                        "insertUnformatted": {
                            "mode": "chose"
                        },
                        "valueInputOption": {
                            "mode": "chose",
                            "label": "User entered"
                        },
                        "insertDataOption": {
                            "mode": "chose",
                            "label": "Insert rows"
                        },
                        "from": {
                            "label": "My Drive"
                        },
                        "spreadsheetId": {
                            "path": [
                                "Planilhas",
                                "[LTV] [Imersão Gestor de Automação] - Leads"
                            ]
                        },
                        "sheetId": {
                            "label": "Cópia de DB"
                        },
                        "includesHeaders": {
                            "nested": [
                                {
                                    "name": "values",
                                    "spec": [
                                        {
                                            "name": "0",
                                            "type": "text",
                                            "label": "DATE (A)"
                                        },
                                        {
                                            "name": "1",
                                            "type": "text",
                                            "label": "LEAD_NAME (B)"
                                        },
                                        {
                                            "name": "2",
                                            "type": "text",
                                            "label": "LEAD_EMAIL (C)"
                                        },
                                        {
                                            "name": "3",
                                            "type": "text",
                                            "label": "LEAD_WPP (D)"
                                        },
                                        {
                                            "name": "4",
                                            "type": "text",
                                            "label": "UPGRADE (E)"
                                        },
                                        {
                                            "name": "5",
                                            "type": "text",
                                            "label": "UTM_SOURCE (F)"
                                        },
                                        {
                                            "name": "6",
                                            "type": "text",
                                            "label": "UTM_MEDIUM (G)"
                                        },
                                        {
                                            "name": "7",
                                            "type": "text",
                                            "label": "UTM_CAMPAIGN (H)"
                                        },
                                        {
                                            "name": "8",
                                            "type": "text",
                                            "label": "UTM_CONTENT (I)"
                                        },
                                        {
                                            "name": "9",
                                            "type": "text",
                                            "label": "UTM_TERM (J)"
                                        },
                                        {
                                            "name": "10",
                                            "type": "text",
                                            "label": "MANYCHAT_USER (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)"
                                        },
                                        {
                                            "name": "26",
                                            "type": "text",
                                            "label": "(AA)"
                                        },
                                        {
                                            "name": "27",
                                            "type": "text",
                                            "label": "(AB)"
                                        },
                                        {
                                            "name": "28",
                                            "type": "text",
                                            "label": "(AC)"
                                        },
                                        {
                                            "name": "29",
                                            "type": "text",
                                            "label": "(AD)"
                                        },
                                        {
                                            "name": "30",
                                            "type": "text",
                                            "label": "(AE)"
                                        },
                                        {
                                            "name": "31",
                                            "type": "text",
                                            "label": "(AF)"
                                        },
                                        {
                                            "name": "32",
                                            "type": "text",
                                            "label": "(AG)"
                                        },
                                        {
                                            "name": "33",
                                            "type": "text",
                                            "label": "(AH)"
                                        },
                                        {
                                            "name": "34",
                                            "type": "text",
                                            "label": "(AI)"
                                        },
                                        {
                                            "name": "35",
                                            "type": "text",
                                            "label": "(AJ)"
                                        },
                                        {
                                            "name": "36",
                                            "type": "text",
                                            "label": "(AK)"
                                        },
                                        {
                                            "name": "37",
                                            "type": "text",
                                            "label": "(AL)"
                                        },
                                        {
                                            "name": "38",
                                            "type": "text",
                                            "label": "(AM)"
                                        },
                                        {
                                            "name": "39",
                                            "type": "text",
                                            "label": "(AN)"
                                        },
                                        {
                                            "name": "40",
                                            "type": "text",
                                            "label": "(AO)"
                                        },
                                        {
                                            "name": "41",
                                            "type": "text",
                                            "label": "(AP)"
                                        },
                                        {
                                            "name": "42",
                                            "type": "text",
                                            "label": "(AQ)"
                                        },
                                        {
                                            "name": "43",
                                            "type": "text",
                                            "label": "(AR)"
                                        },
                                        {
                                            "name": "44",
                                            "type": "text",
                                            "label": "(AS)"
                                        },
                                        {
                                            "name": "45",
                                            "type": "text",
                                            "label": "(AT)"
                                        },
                                        {
                                            "name": "46",
                                            "type": "text",
                                            "label": "(AU)"
                                        },
                                        {
                                            "name": "47",
                                            "type": "text",
                                            "label": "(AV)"
                                        },
                                        {
                                            "name": "48",
                                            "type": "text",
                                            "label": "(AW)"
                                        },
                                        {
                                            "name": "49",
                                            "type": "text",
                                            "label": "(AX)"
                                        },
                                        {
                                            "name": "50",
                                            "type": "text",
                                            "label": "(AY)"
                                        }
                                    ],
                                    "type": "collection",
                                    "label": "Values"
                                }
                            ],
                            "label": "Yes"
                        }
                    }
                },
                "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",
                        "type": "collection",
                        "label": "Values",
                        "spec": [
                            {
                                "name": "0",
                                "type": "text",
                                "label": "DATE (A)"
                            },
                            {
                                "name": "1",
                                "type": "text",
                                "label": "LEAD_NAME (B)"
                            },
                            {
                                "name": "2",
                                "type": "text",
                                "label": "LEAD_EMAIL (C)"
                            },
                            {
                                "name": "3",
                                "type": "text",
                                "label": "LEAD_WPP (D)"
                            },
                            {
                                "name": "4",
                                "type": "text",
                                "label": "UPGRADE (E)"
                            },
                            {
                                "name": "5",
                                "type": "text",
                                "label": "UTM_SOURCE (F)"
                            },
                            {
                                "name": "6",
                                "type": "text",
                                "label": "UTM_MEDIUM (G)"
                            },
                            {
                                "name": "7",
                                "type": "text",
                                "label": "UTM_CAMPAIGN (H)"
                            },
                            {
                                "name": "8",
                                "type": "text",
                                "label": "UTM_CONTENT (I)"
                            },
                            {
                                "name": "9",
                                "type": "text",
                                "label": "UTM_TERM (J)"
                            },
                            {
                                "name": "10",
                                "type": "text",
                                "label": "MANYCHAT_USER (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)"
                            },
                            {
                                "name": "26",
                                "type": "text",
                                "label": "(AA)"
                            },
                            {
                                "name": "27",
                                "type": "text",
                                "label": "(AB)"
                            },
                            {
                                "name": "28",
                                "type": "text",
                                "label": "(AC)"
                            },
                            {
                                "name": "29",
                                "type": "text",
                                "label": "(AD)"
                            },
                            {
                                "name": "30",
                                "type": "text",
                                "label": "(AE)"
                            },
                            {
                                "name": "31",
                                "type": "text",
                                "label": "(AF)"
                            },
                            {
                                "name": "32",
                                "type": "text",
                                "label": "(AG)"
                            },
                            {
                                "name": "33",
                                "type": "text",
                                "label": "(AH)"
                            },
                            {
                                "name": "34",
                                "type": "text",
                                "label": "(AI)"
                            },
                            {
                                "name": "35",
                                "type": "text",
                                "label": "(AJ)"
                            },
                            {
                                "name": "36",
                                "type": "text",
                                "label": "(AK)"
                            },
                            {
                                "name": "37",
                                "type": "text",
                                "label": "(AL)"
                            },
                            {
                                "name": "38",
                                "type": "text",
                                "label": "(AM)"
                            },
                            {
                                "name": "39",
                                "type": "text",
                                "label": "(AN)"
                            },
                            {
                                "name": "40",
                                "type": "text",
                                "label": "(AO)"
                            },
                            {
                                "name": "41",
                                "type": "text",
                                "label": "(AP)"
                            },
                            {
                                "name": "42",
                                "type": "text",
                                "label": "(AQ)"
                            },
                            {
                                "name": "43",
                                "type": "text",
                                "label": "(AR)"
                            },
                            {
                                "name": "44",
                                "type": "text",
                                "label": "(AS)"
                            },
                            {
                                "name": "45",
                                "type": "text",
                                "label": "(AT)"
                            },
                            {
                                "name": "46",
                                "type": "text",
                                "label": "(AU)"
                            },
                            {
                                "name": "47",
                                "type": "text",
                                "label": "(AV)"
                            },
                            {
                                "name": "48",
                                "type": "text",
                                "label": "(AW)"
                            },
                            {
                                "name": "49",
                                "type": "text",
                                "label": "(AX)"
                            },
                            {
                                "name": "50",
                                "type": "text",
                                "label": "(AY)"
                            }
                        ]
                    }
                ]
            }
        }
    ],
    "metadata": {
        "instant": true,
        "version": 1,
        "scenario": {
            "roundtrips": 1,
            "maxErrors": 3,
            "autoCommit": true,
            "autoCommitTriggerLast": true,
            "sequential": false,
            "confidential": false,
            "dataloss": false,
            "dlq": false,
            "freshVariables": false
        },
        "designer": {
            "orphans": []
        },
        "zone": "us1.make.com"
    }
}