{ "name": "EDUZZ - Template", "flow": [ { "id": 1, "module": "gateway:CustomWebHook", "version": 1, "parameters": { "hook": 820816, "maxResults": 2 }, "mapper": {}, "metadata": { "designer": { "x": 0, "y": 900 }, "restore": { "hook": { "label": "Eduzz - Teste" } }, "parameters": [ { "name": "hook", "type": "hook", "label": "Webhook", "required": true }, { "name": "maxResults", "type": "number", "label": "Maximum number of results" } ], "interface": [] } }, { "id": 3, "module": "builtin:BasicRouter", "version": 1, "mapper": null, "metadata": { "designer": { "x": 300, "y": 900 } }, "routes": [ { "flow": [ { "id": 8, "module": "google-sheets:addRow", "version": 2, "parameters": { "__IMTCONN__": 1707060 }, "filter": { "name": "BOLETO", "conditions": [ [ { "a": "{{1.trans_status}}", "b": "1", "o": "text:equal" }, { "a": "{{1.trans_paymentmethod}}", "b": "1", "o": "text:equal" } ] ] }, "mapper": { "mode": "select", "values": { "0": "{{formatDate(now; \"DD/MM/YYYY - HH:mm\")}}", "1": "{{replace(startcase(1.cus_name); \"/\\s(?<=[\\s]).*/g\"; emptystring)}}", "2": "{{replace(startcase(1.cus_name); \"/.*(?<=[\\s])/g\"; emptystring)}}", "3": "{{1.cus_email}}", "4": "{{1.cus_address_country}}", "6": "{{1.cus_cel}}", "7": "=HYPERLINK(\"https://api.whatsapp.com/send?phone=+55{{1.cus_cel}}&text={{encodeURL(\"Oi *\" + replace(startcase(1.cus_name); \"/\\s(?<=[\\s]).*/g\"; emptystring) + \"*, tudo bem?\")}} me chamo *XXXXX*, faço parte da equipe da *XXXXXX* e estou aqui para te ajudar no que for possível.\n \nVi aqui que você emitiu o boleto para garantir a sua vaga no curso *XXXXXXX*. Então, só para garantir que você não esqueça de pagar e ficar fora da turma, estou te lembrando aqui, tá bom?\n\nAh, vou te enviar o link por aqui tb ok? é só clicar aqui embaixo 👇\n\n{{encodeURL(1.trans_bankslip)}}\n \n*Caso já tenha feito o pagamento do boleto*, é só esperar o prazo de até *24 horas* para o pagamento ser compensado. Após isso, *o acesso será enviado para o e-mail* que você cadastrou no momento da compra.\n \nÉ isso, estou aqui para o que precisar.\";\"BOLETO\")" }, "sheetId": "Recuperação de Carrinho", "spreadsheetId": "1s1Tn9oJYzHDyA8hxgFXmzvWsRyfKdqTTn737VFemGnY", "includesHeaders": true, "insertDataOption": "INSERT_ROWS", "valueInputOption": "USER_ENTERED" }, "metadata": { "designer": { "x": 600, "y": 0, "name": "BOLETO IMPRESSO" }, "restore": { "mode": { "label": "Select spreadsheet and sheet" }, "sheetId": { "label": "Recuperação de Carrinho" }, "__IMTCONN__": { "label": "Google - Thales (thaleslaray@gmail.com)" }, "spreadsheetId": { "label": "EDUZZ - (TEMPLATE)" }, "includesHeaders": { "label": "Yes" }, "insertDataOption": { "mode": "chose", "label": "Insert rows" }, "valueInputOption": { "mode": "chose", "label": "User entered" } }, "parameters": [ { "name": "__IMTCONN__", "type": "account", "label": "Connection", "required": true } ], "expect": [ { "name": "mode", "type": "select", "label": "Mode", "required": true, "validate": { "enum": [ "select", "map" ] } }, { "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": "spreadsheetId", "type": "select", "label": "Spreadsheet", "required": true }, { "name": "sheetId", "type": "select", "label": "Sheet", "required": true }, { "name": "includesHeaders", "type": "select", "label": "Table contains headers", "required": true, "validate": { "enum": [ true, false ] } }, { "name": "values", "spec": [ { "name": "0", "type": "text", "label": "Data/Hora (A)" }, { "name": "1", "type": "text", "label": "Nome (B)" }, { "name": "2", "type": "text", "label": "Sobrenome (C)" }, { "name": "3", "type": "text", "label": "E-mail (D)" }, { "name": "4", "type": "text", "label": "País (E)" }, { "name": "5", "type": "text", "label": "DDD (F)" }, { "name": "6", "type": "text", "label": "Celular (G)" }, { "name": "7", "type": "text", "label": "WhatsApp (H)" }, { "name": "8", "type": "text", "label": "Meio de Pagamento (I)" }, { "name": "9", "type": "text", "label": "Motivo da Recusa (J)" }, { "name": "10", "type": "text", "label": "Status (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)" } ], "type": "collection", "label": "Values" } ] } } ] }, { "flow": [ { "id": 9, "module": "google-sheets:addRow", "version": 2, "parameters": { "__IMTCONN__": 1707060 }, "filter": { "name": "COMPRA APROVADA", "conditions": [ [ { "a": "{{1.trans_status}}", "b": "3", "o": "text:equal" } ] ] }, "mapper": { "mode": "select", "values": { "0": "{{formatDate(now; \"DD/MM/YYYY - HH:mm\")}}", "1": "{{startcase(1.cus_name)}}", "2": "{{replace(startcase(1.cus_name); \"/\\s(?<=[\\s]).*/g\"; emptystring)}}", "3": "{{replace(startcase(1.cus_name); \"/.*(?<=[\\s])/g\"; emptystring)}}", "4": "{{1.cus_email}}", "5": "{{1.cus_taxnumber}}", "6": "{{1.cus_address_country}}", "8": "{{1.cus_cel}}", "9": "=HYPERLINK(\"https://api.whatsapp.com/send?phone=+55{{1.cus_cel}}&text={{encodeURL(\"Oi *\" + replace(startcase(1.cus_name); \"/\\s(?<=[\\s]).*/g\"; emptystring) + \"*, tudo bem?\")}} Eu sou a *XXXXX* assistente da *XXXXXXX*. \n\nEstou passando aqui para lhe dar as *boas-vindas* ao curso xxxxxxxxxx com a *xxxxxxx* e para lhe informar que seus dados de acesso a nossa plataforma acabaram de ser enviados pro seu e-mail. \n\nQualquer dúvida estou disponível para te ajudar ☺️\";\"BOAS-VINDAS\")", "10": "{{1.product_name}}" }, "sheetId": "Compra Aprovada", "spreadsheetId": "1s1Tn9oJYzHDyA8hxgFXmzvWsRyfKdqTTn737VFemGnY", "includesHeaders": true, "insertDataOption": "INSERT_ROWS", "valueInputOption": "USER_ENTERED" }, "metadata": { "designer": { "x": 600, "y": 300, "name": "COMPRA APROVADA" }, "restore": { "mode": { "label": "Select spreadsheet and sheet" }, "sheetId": { "label": "Compra Aprovada" }, "__IMTCONN__": { "label": "Google - Thales (thaleslaray@gmail.com)" }, "spreadsheetId": { "label": "EDUZZ - (TEMPLATE)" }, "includesHeaders": { "label": "Yes" }, "insertDataOption": { "mode": "chose", "label": "Insert rows" }, "valueInputOption": { "mode": "chose", "label": "User entered" } }, "parameters": [ { "name": "__IMTCONN__", "type": "account", "label": "Connection", "required": true } ], "expect": [ { "name": "mode", "type": "select", "label": "Mode", "required": true, "validate": { "enum": [ "select", "map" ] } }, { "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": "spreadsheetId", "type": "select", "label": "Spreadsheet", "required": true }, { "name": "sheetId", "type": "select", "label": "Sheet", "required": true }, { "name": "includesHeaders", "type": "select", "label": "Table contains headers", "required": true, "validate": { "enum": [ true, false ] } }, { "name": "values", "spec": [ { "name": "0", "type": "text", "label": "Data/Hora (A)" }, { "name": "1", "type": "text", "label": "Nome Completo (B)" }, { "name": "2", "type": "text", "label": "Nome (C)" }, { "name": "3", "type": "text", "label": "Sobrenome (D)" }, { "name": "4", "type": "text", "label": "E-mail (E)" }, { "name": "5", "type": "text", "label": "CPF (F)" }, { "name": "6", "type": "text", "label": "País (G)" }, { "name": "7", "type": "text", "label": "DDD (H)" }, { "name": "8", "type": "text", "label": "Celular (I)" }, { "name": "9", "type": "text", "label": "WhatsApp (J)" }, { "name": "10", "type": "text", "label": "PRODUTO (K)" }, { "name": "11", "type": "text", "label": "Obs. (L)" } ], "type": "collection", "label": "Values" } ] } }, { "id": 61, "module": "google-sheets:filterRows", "version": 2, "parameters": { "__IMTCONN__": 1707060 }, "mapper": { "filter": [ [ { "a": "D", "b": "{{1.cus_email}}", "o": "text:equal" } ] ], "orderBy": "__ROW_NUMBER__", "sheetId": "Recuperação de Carrinho", "sortOrder": "desc", "spreadsheetId": "1s1Tn9oJYzHDyA8hxgFXmzvWsRyfKdqTTn737VFemGnY", "tableFirstRow": "A1:CZ1", "includesHeaders": true, "valueRenderOption": "FORMATTED_VALUE", "dateTimeRenderOption": "FORMATTED_STRING" }, "metadata": { "designer": { "x": 900, "y": 300, "name": "PESQUISA C. CANCELADA" }, "restore": { "orderBy": { "mode": "chose", "label": "Row number" }, "sheetId": { "mode": "chose", "label": "Recuperação de Carrinho" }, "sortOrder": { "mode": "chose", "label": "Descending" }, "__IMTCONN__": { "label": "Google - Thales (thaleslaray@gmail.com)" }, "spreadsheetId": { "mode": "chose", "label": "EDUZZ - (TEMPLATE)" }, "tableFirstRow": { "label": "A-CZ" }, "includesHeaders": { "mode": "chose", "label": "Yes" }, "valueRenderOption": { "mode": "chose", "label": "Formatted value" }, "dateTimeRenderOption": { "mode": "chose", "label": "Formatted string" } }, "parameters": [ { "name": "__IMTCONN__", "type": "account", "label": "Connection", "required": true } ], "expect": [ { "name": "spreadsheetId", "type": "select", "label": "Spreadsheet", "required": true }, { "name": "valueRenderOption", "type": "select", "label": "Value render option", "validate": { "enum": [ "FORMATTED_VALUE", "UNFORMATTED_VALUE", "FORMULA" ] } }, { "name": "dateTimeRenderOption", "type": "select", "label": "Date and time render option", "validate": { "enum": [ "SERIAL_NUMBER", "FORMATTED_STRING" ] } }, { "name": "limit", "type": "number", "label": "Maximum number of returned rows" }, { "name": "sheetId", "type": "select", "label": "Sheet", "required": true }, { "name": "includesHeaders", "type": "select", "label": "Table contains headers", "required": true, "validate": { "enum": [ true, false ] } }, { "name": "tableFirstRow", "type": "select", "label": "Column range", "required": true, "validate": { "enum": [ "A1:Z1", "A1:BZ1", "A1:CZ1", "A1:DZ1", "A1:MZ1", "A1:ZZ1" ] } }, { "name": "filter", "type": "filter", "label": "Filter", "options": { "store": "rpc://google-sheets@2/rpcGetFilterKeys?includesHeaders=true" } }, { "name": "sortOrder", "type": "select", "label": "Sort order", "validate": { "enum": [ "asc", "desc" ] } }, { "name": "orderBy", "type": "select", "label": "Order by" } ], "interface": [ { "name": "__IMTLENGTH__", "type": "uinteger", "label": "Total number of bundles" }, { "name": "__IMTINDEX__", "type": "uinteger", "label": "Bundle order position" }, { "name": "__ROW_NUMBER__", "type": "number", "label": "Row number" }, { "name": "__SPREADSHEET_ID__", "type": "text", "label": "Spreadsheet ID" }, { "name": "__SHEET__", "type": "text", "label": "Sheet" }, { "name": "0", "type": "text", "label": "Data/Hora (A)" }, { "name": "1", "type": "text", "label": "Nome (B)" }, { "name": "2", "type": "text", "label": "Sobrenome (C)" }, { "name": "3", "type": "text", "label": "E-mail (D)" }, { "name": "4", "type": "text", "label": "País (E)" }, { "name": "5", "type": "text", "label": "DDD (F)" }, { "name": "6", "type": "text", "label": "Celular (G)" }, { "name": "7", "type": "text", "label": "WhatsApp (H)" }, { "name": "8", "type": "text", "label": "Meio de Pagamento (I)" }, { "name": "9", "type": "text", "label": "Motivo da Recusa (J)" }, { "name": "10", "type": "text", "label": "Status (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)" }, { "name": "51", "type": "text", "label": "(AZ)" }, { "name": "52", "type": "text", "label": "(BA)" }, { "name": "53", "type": "text", "label": "(BB)" }, { "name": "54", "type": "text", "label": "(BC)" }, { "name": "55", "type": "text", "label": "(BD)" }, { "name": "56", "type": "text", "label": "(BE)" }, { "name": "57", "type": "text", "label": "(BF)" }, { "name": "58", "type": "text", "label": "(BG)" }, { "name": "59", "type": "text", "label": "(BH)" }, { "name": "60", "type": "text", "label": "(BI)" }, { "name": "61", "type": "text", "label": "(BJ)" }, { "name": "62", "type": "text", "label": "(BK)" }, { "name": "63", "type": "text", "label": "(BL)" }, { "name": "64", "type": "text", "label": "(BM)" }, { "name": "65", "type": "text", "label": "(BN)" }, { "name": "66", "type": "text", "label": "(BO)" }, { "name": "67", "type": "text", "label": "(BP)" }, { "name": "68", "type": "text", "label": "(BQ)" }, { "name": "69", "type": "text", "label": "(BR)" }, { "name": "70", "type": "text", "label": "(BS)" }, { "name": "71", "type": "text", "label": "(BT)" }, { "name": "72", "type": "text", "label": "(BU)" }, { "name": "73", "type": "text", "label": "(BV)" }, { "name": "74", "type": "text", "label": "(BW)" }, { "name": "75", "type": "text", "label": "(BX)" }, { "name": "76", "type": "text", "label": "(BY)" }, { "name": "77", "type": "text", "label": "(BZ)" }, { "name": "78", "type": "text", "label": "(CA)" }, { "name": "79", "type": "text", "label": "(CB)" }, { "name": "80", "type": "text", "label": "(CC)" }, { "name": "81", "type": "text", "label": "(CD)" }, { "name": "82", "type": "text", "label": "(CE)" }, { "name": "83", "type": "text", "label": "(CF)" }, { "name": "84", "type": "text", "label": "(CG)" }, { "name": "85", "type": "text", "label": "(CH)" }, { "name": "86", "type": "text", "label": "(CI)" }, { "name": "87", "type": "text", "label": "(CJ)" }, { "name": "88", "type": "text", "label": "(CK)" }, { "name": "89", "type": "text", "label": "(CL)" }, { "name": "90", "type": "text", "label": "(CM)" }, { "name": "91", "type": "text", "label": "(CN)" }, { "name": "92", "type": "text", "label": "(CO)" }, { "name": "93", "type": "text", "label": "(CP)" }, { "name": "94", "type": "text", "label": "(CQ)" }, { "name": "95", "type": "text", "label": "(CR)" }, { "name": "96", "type": "text", "label": "(CS)" }, { "name": "97", "type": "text", "label": "(CT)" }, { "name": "98", "type": "text", "label": "(CU)" }, { "name": "99", "type": "text", "label": "(CV)" }, { "name": "100", "type": "text", "label": "(CW)" }, { "name": "101", "type": "text", "label": "(CX)" }, { "name": "102", "type": "text", "label": "(CY)" }, { "name": "103", "type": "text", "label": "(CZ)" } ] } }, { "id": 62, "module": "google-sheets:deleteRow", "version": 2, "parameters": { "__IMTCONN__": 1707060 }, "mapper": { "sheetId": 1034739142, "rowNumber": "{{61.`__ROW_NUMBER__`}}", "spreadsheetId": "1s1Tn9oJYzHDyA8hxgFXmzvWsRyfKdqTTn737VFemGnY" }, "metadata": { "designer": { "x": 1200, "y": 300, "name": "DELETA C. CANCELADA" }, "restore": { "sheetId": { "mode": "chose", "label": "Recuperação de Carrinho" }, "__IMTCONN__": { "label": "Google - Thales (thaleslaray@gmail.com)" }, "spreadsheetId": { "mode": "chose", "label": "EDUZZ - (TEMPLATE)" } }, "parameters": [ { "name": "__IMTCONN__", "type": "account", "label": "Connection", "required": true } ], "expect": [ { "name": "spreadsheetId", "type": "select", "label": "Spreadsheet", "required": true }, { "name": "rowNumber", "type": "uinteger", "label": "Row number", "required": true }, { "name": "sheetId", "type": "select", "label": "Sheet", "required": true } ] }, "onerror": [ { "id": 81, "module": "builtin:Ignore", "version": 1, "metadata": { "designer": { "x": 1500, "y": 300 } } } ] } ] }, { "flow": [ { "id": 17, "module": "google-sheets:addRow", "version": 2, "parameters": { "__IMTCONN__": 1707060 }, "filter": { "name": "ABANDONOU", "conditions": [ [ { "a": "{{1.trans_action}}", "b": "Abandono de carrinho", "o": "text:equal" } ] ] }, "mapper": { "mode": "select", "values": { "0": "{{formatDate(now; \"DD/MM/YYYY - HH:mm\")}}", "1": "{{replace(startcase(1.cus_name); \"/\\s(?<=[\\s]).*/g\"; emptystring)}}", "2": "{{replace(startcase(1.cus_name); \"/.*(?<=[\\s])/g\"; emptystring)}}", "3": "{{1.cus_email}}", "4": "{{1.cus_address_country}}", "6": "{{1.cus_cel}}", "7": "=HYPERLINK(\"https://api.whatsapp.com/send?phone=+55{{1.cus_cel}}&text={{encodeURL(\"Oi *\" + replace(startcase(1.cus_name); \"/\\s(?<=[\\s]).*/g\"; emptystring) + \"*, tudo bem?\")}} me chamo *XXXXX*, faço parte da equipe da *XXXXXXX* e estou aqui para te ajudar no que for possível.\n\nVi que você chegou a preencher seus dados para adquirir sua vaga na próxima turma do curso *XXXXXX*, mas infelizmente *não chegou* a finalizar a compra.\n\nVocê teve alguma dificuldade? Ficou alguma *dúvida* em relação ao curso ou *forma de pagamento*?\";\"ABANDONOU\")", "8": "{{1.trans_paymentmethod}}" }, "sheetId": "Recuperação de Carrinho", "spreadsheetId": "1s1Tn9oJYzHDyA8hxgFXmzvWsRyfKdqTTn737VFemGnY", "includesHeaders": true, "insertDataOption": "INSERT_ROWS", "valueInputOption": "USER_ENTERED" }, "metadata": { "designer": { "x": 600, "y": 600, "name": "ABANDONOU O CARRINHO" }, "restore": { "mode": { "label": "Select spreadsheet and sheet" }, "sheetId": { "label": "Recuperação de Carrinho" }, "__IMTCONN__": { "label": "Google - Thales (thaleslaray@gmail.com)" }, "spreadsheetId": { "label": "EDUZZ - (TEMPLATE)" }, "includesHeaders": { "label": "Yes" }, "insertDataOption": { "mode": "chose", "label": "Insert rows" }, "valueInputOption": { "mode": "chose", "label": "User entered" } }, "parameters": [ { "name": "__IMTCONN__", "type": "account", "label": "Connection", "required": true } ], "expect": [ { "name": "mode", "type": "select", "label": "Mode", "required": true, "validate": { "enum": [ "select", "map" ] } }, { "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": "spreadsheetId", "type": "select", "label": "Spreadsheet", "required": true }, { "name": "sheetId", "type": "select", "label": "Sheet", "required": true }, { "name": "includesHeaders", "type": "select", "label": "Table contains headers", "required": true, "validate": { "enum": [ true, false ] } }, { "name": "values", "spec": [ { "name": "0", "type": "text", "label": "Data/Hora (A)" }, { "name": "1", "type": "text", "label": "Nome (B)" }, { "name": "2", "type": "text", "label": "Sobrenome (C)" }, { "name": "3", "type": "text", "label": "E-mail (D)" }, { "name": "4", "type": "text", "label": "País (E)" }, { "name": "5", "type": "text", "label": "DDD (F)" }, { "name": "6", "type": "text", "label": "Celular (G)" }, { "name": "7", "type": "text", "label": "WhatsApp (H)" }, { "name": "8", "type": "text", "label": "Meio de Pagamento (I)" }, { "name": "9", "type": "text", "label": "Motivo da Recusa (J)" }, { "name": "10", "type": "text", "label": "Status (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)" } ], "type": "collection", "label": "Values" } ] } } ] }, { "flow": [ { "id": 12, "module": "google-sheets:addRow", "version": 2, "parameters": { "__IMTCONN__": 1707060 }, "filter": { "name": "COMPRA CANCELADA", "conditions": [ [ { "a": "{{1.trans_status}}", "b": "1", "o": "text:equal" }, { "a": "{{1.trans_paymentmethod}}", "b": "1", "o": "time:greater" }, { "a": "{{1.trans_paymentmethod}}", "b": "32", "o": "time:less" } ] ] }, "mapper": { "mode": "select", "values": { "0": "{{formatDate(now; \"DD/MM/YYYY - HH:mm\")}}", "1": "{{replace(startcase(1.cus_name); \"/\\s(?<=[\\s]).*/g\"; emptystring)}}", "2": "{{replace(startcase(1.cus_name); \"/.*(?<=[\\s])/g\"; emptystring)}}", "3": "{{1.cus_email}}", "4": "{{1.cus_address_country}}", "6": "{{1.cus_cel}}", "7": "=HYPERLINK(\"https://api.whatsapp.com/send?phone=+55{{1.cus_cel}}&text={{encodeURL(\"Oi *\" + replace(startcase(1.cus_name); \"/\\s(?<=[\\s]).*/g\"; emptystring) + \"*, tudo bem?\")}} me chamo *XXXXXX*, faço parte da equipe da *XXXXXX* e estou aqui para te ajudar no que for possível.\n\nE eu preciso te avisar sobre o status de aprovação do pagamento do seu pedido, seu curso de *XXXXXXX* foi cancelado!\n\nAlguma coisa pode ter acontecido no seu cartão de crédito! Fique atenta aos itens abaixo:\n\n✅ Confira o número *CVV* do cartão digitado no momento da compra;\n✅ Confira a *bandeira* do cartão escolhida no momento da compra;\n✅ Confira a *data de validade* digitada no momento da compra;\n✅ *Falta de limite* no cartão;\n✅ Dados inseridos de forma *incorreta* (data de vencimento, código de segurança).\n\nConfira se esses dados estão corretos. Se nada funcionar tente pagar via boleto.\n\nAh, tb temos a opção de pagamento por *2 cartões de crédito*, você pode dividir com *o valor que deseja no primeiro cartão*, e no segundo cartão o sistema já puxa o restante do valor que sobrou para pagamento.\n\nEntre no link abaixo para tentar novamente 👇 \n\n{{1.billet_url}}\n\nSe estiver com *alguma dúvida* com as formas de pagamento, *estou aqui para ajudar* :)\";\"COMPRA CANCELADA\")", "8": "{{1.trans_paymentmethod}}" }, "sheetId": "Recuperação de Carrinho", "spreadsheetId": "1s1Tn9oJYzHDyA8hxgFXmzvWsRyfKdqTTn737VFemGnY", "includesHeaders": true, "insertDataOption": "INSERT_ROWS", "valueInputOption": "USER_ENTERED" }, "metadata": { "designer": { "x": 600, "y": 900, "name": "COMPRA CANCELADA" }, "restore": { "mode": { "label": "Select spreadsheet and sheet" }, "sheetId": { "label": "Recuperação de Carrinho" }, "__IMTCONN__": { "label": "Google - Thales (thaleslaray@gmail.com)" }, "spreadsheetId": { "label": "EDUZZ - (TEMPLATE)" }, "includesHeaders": { "label": "Yes" }, "insertDataOption": { "mode": "chose", "label": "Insert rows" }, "valueInputOption": { "mode": "chose", "label": "User entered" } }, "parameters": [ { "name": "__IMTCONN__", "type": "account", "label": "Connection", "required": true } ], "expect": [ { "name": "mode", "type": "select", "label": "Mode", "required": true, "validate": { "enum": [ "select", "map" ] } }, { "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": "spreadsheetId", "type": "select", "label": "Spreadsheet", "required": true }, { "name": "sheetId", "type": "select", "label": "Sheet", "required": true }, { "name": "includesHeaders", "type": "select", "label": "Table contains headers", "required": true, "validate": { "enum": [ true, false ] } }, { "name": "values", "spec": [ { "name": "0", "type": "text", "label": "Data/Hora (A)" }, { "name": "1", "type": "text", "label": "Nome (B)" }, { "name": "2", "type": "text", "label": "Sobrenome (C)" }, { "name": "3", "type": "text", "label": "E-mail (D)" }, { "name": "4", "type": "text", "label": "País (E)" }, { "name": "5", "type": "text", "label": "DDD (F)" }, { "name": "6", "type": "text", "label": "Celular (G)" }, { "name": "7", "type": "text", "label": "WhatsApp (H)" }, { "name": "8", "type": "text", "label": "Meio de Pagamento (I)" }, { "name": "9", "type": "text", "label": "Motivo da Recusa (J)" }, { "name": "10", "type": "text", "label": "Status (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)" } ], "type": "collection", "label": "Values" } ] } } ] }, { "flow": [ { "id": 72, "module": "google-sheets:addRow", "version": 2, "parameters": { "__IMTCONN__": 1707060 }, "filter": { "name": "SOLICITOU REEMBOLSO", "conditions": [ [ { "a": "{{1.trans_status}}", "b": "6", "o": "text:equal" } ] ] }, "mapper": { "mode": "select", "valueInputOption": "USER_ENTERED", "insertDataOption": "INSERT_ROWS", "spreadsheetId": "1s1Tn9oJYzHDyA8hxgFXmzvWsRyfKdqTTn737VFemGnY", "sheetId": "Reembolso", "includesHeaders": true, "values": { "0": "{{formatDate(now; \"DD/MM/YYYY - HH:mm\")}}", "1": "{{startcase(1.cus_name)}}", "2": "{{replace(startcase(1.cus_name); \"/\\s(?<=[\\s]).*/g\"; emptystring)}}", "3": "{{replace(startcase(1.cus_name); \"/.*(?<=[\\s])/g\"; emptystring)}}", "4": "{{1.cus_email}}", "5": "{{1.cus_taxnumber}}", "6": "{{1.cus_address_country}}", "8": "{{1.cus_cel}}", "9": "=HYPERLINK(\"https://api.whatsapp.com/send?phone=+55{{1.cus_cel}}&text={{encodeURL(\"Oi *\" + replace(startcase(1.cus_name); \"/\\s(?<=[\\s]).*/g\"; emptystring) + \"*, tudo bem?\")}} Eu sou a *XXXXX* assistente da *XXXXXXX*. \n\nEstou passando aqui pra avisar que seu pedido de reembolso foi processado, você vai receber um e-mail de confirmação da EDUZZ.\n\nQualquer dúvida estou disponível para te ajudar ☺️\";\"REEMBOLSO SOLICITADO\")", "10": "{{1.product_name}}" } }, "metadata": { "designer": { "x": 600, "y": 1200, "name": "SOLICITOU REEMBOLSO" }, "restore": { "__IMTCONN__": { "label": "Google - Thales (thaleslaray@gmail.com)" }, "mode": { "label": "Select spreadsheet and sheet" }, "valueInputOption": { "mode": "chose", "label": "User entered" }, "insertDataOption": { "mode": "chose", "label": "Insert rows" }, "spreadsheetId": { "label": "EDUZZ - (TEMPLATE)" }, "sheetId": { "label": "Reembolso" }, "includesHeaders": { "label": "Yes" } }, "parameters": [ { "name": "__IMTCONN__", "type": "account", "label": "Connection", "required": true } ], "expect": [ { "name": "mode", "type": "select", "label": "Mode", "required": true, "validate": { "enum": [ "select", "map" ] } }, { "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": "spreadsheetId", "type": "select", "label": "Spreadsheet", "required": true }, { "name": "sheetId", "type": "select", "label": "Sheet", "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", "label": "Data/Hora (A)", "type": "text" }, { "name": "1", "label": "Nome Completo (B)", "type": "text" }, { "name": "2", "label": "Nome (C)", "type": "text" }, { "name": "3", "label": "Sobrenome (D)", "type": "text" }, { "name": "4", "label": "E-mail (E)", "type": "text" }, { "name": "5", "label": "CPF (F)", "type": "text" }, { "name": "6", "label": "País (G)", "type": "text" }, { "name": "7", "label": "DDD (H)", "type": "text" }, { "name": "8", "label": "Celular (I)", "type": "text" }, { "name": "9", "label": "WhatsApp (J)", "type": "text" }, { "name": "10", "label": "PRODUTO (K)", "type": "text" }, { "name": "11", "label": "(L)", "type": "text" } ] } ] } }, { "id": 73, "module": "google-sheets:filterRows", "version": 2, "parameters": { "__IMTCONN__": 1707060 }, "mapper": { "spreadsheetId": "1s1Tn9oJYzHDyA8hxgFXmzvWsRyfKdqTTn737VFemGnY", "valueRenderOption": "FORMATTED_VALUE", "dateTimeRenderOption": "FORMATTED_STRING", "sheetId": "Compra Aprovada", "includesHeaders": true, "tableFirstRow": "A1:CZ1", "filter": [ [ { "a": "E", "o": "text:equal", "b": "{{1.cus_email}}" } ] ], "sortOrder": "desc", "orderBy": "__ROW_NUMBER__" }, "metadata": { "designer": { "x": 900, "y": 1200, "name": "PESQUISA REEMBOLSO" }, "restore": { "__IMTCONN__": { "label": "Google - Thales (thaleslaray@gmail.com)" }, "spreadsheetId": { "mode": "chose", "label": "EDUZZ - (TEMPLATE)" }, "valueRenderOption": { "mode": "chose", "label": "Formatted value" }, "dateTimeRenderOption": { "mode": "chose", "label": "Formatted string" }, "sheetId": { "mode": "chose", "label": "Compra Aprovada" }, "includesHeaders": { "mode": "chose", "label": "Yes" }, "tableFirstRow": { "label": "A-CZ" }, "sortOrder": { "mode": "chose", "label": "Descending" }, "orderBy": { "mode": "chose", "label": "Row number" } }, "parameters": [ { "name": "__IMTCONN__", "type": "account", "label": "Connection", "required": true } ], "expect": [ { "name": "spreadsheetId", "type": "select", "label": "Spreadsheet", "required": true }, { "name": "valueRenderOption", "type": "select", "label": "Value render option", "validate": { "enum": [ "FORMATTED_VALUE", "UNFORMATTED_VALUE", "FORMULA" ] } }, { "name": "dateTimeRenderOption", "type": "select", "label": "Date and time render option", "validate": { "enum": [ "SERIAL_NUMBER", "FORMATTED_STRING" ] } }, { "name": "limit", "type": "number", "label": "Maximum number of returned rows" }, { "name": "sheetId", "type": "select", "label": "Sheet", "required": true }, { "name": "includesHeaders", "type": "select", "label": "Table contains headers", "required": true, "validate": { "enum": [ true, false ] } }, { "name": "tableFirstRow", "type": "select", "label": "Column range", "required": true, "validate": { "enum": [ "A1:Z1", "A1:BZ1", "A1:CZ1", "A1:DZ1", "A1:MZ1", "A1:ZZ1" ] } }, { "name": "filter", "type": "filter", "label": "Filter", "options": { "store": "rpc://google-sheets@2/rpcGetFilterKeys?includesHeaders=true" } }, { "name": "sortOrder", "type": "select", "label": "Sort order", "validate": { "enum": [ "asc", "desc" ] } }, { "name": "orderBy", "type": "select", "label": "Order by" } ], "interface": [ { "name": "__IMTLENGTH__", "label": "Total number of bundles", "type": "uinteger" }, { "name": "__IMTINDEX__", "label": "Bundle order position", "type": "uinteger" }, { "name": "__ROW_NUMBER__", "label": "Row number", "type": "number" }, { "name": "__SPREADSHEET_ID__", "label": "Spreadsheet ID", "type": "text" }, { "name": "__SHEET__", "label": "Sheet", "type": "text" }, { "name": "0", "label": "Data/Hora (A)", "type": "text" }, { "name": "1", "label": "Nome Completo (B)", "type": "text" }, { "name": "2", "label": "Nome (C)", "type": "text" }, { "name": "3", "label": "Sobrenome (D)", "type": "text" }, { "name": "4", "label": "E-mail (E)", "type": "text" }, { "name": "5", "label": "CPF (F)", "type": "text" }, { "name": "6", "label": "País (G)", "type": "text" }, { "name": "7", "label": "DDD (H)", "type": "text" }, { "name": "8", "label": "Celular (I)", "type": "text" }, { "name": "9", "label": "WhatsApp (J)", "type": "text" }, { "name": "10", "label": "PRODUTO (K)", "type": "text" }, { "name": "11", "label": "Obs. (L)", "type": "text" }, { "name": "12", "label": "(M)", "type": "text" }, { "name": "13", "label": "(N)", "type": "text" }, { "name": "14", "label": "(O)", "type": "text" }, { "name": "15", "label": "(P)", "type": "text" }, { "name": "16", "label": "(Q)", "type": "text" }, { "name": "17", "label": "(R)", "type": "text" }, { "name": "18", "label": "(S)", "type": "text" }, { "name": "19", "label": "(T)", "type": "text" }, { "name": "20", "label": "(U)", "type": "text" }, { "name": "21", "label": "(V)", "type": "text" }, { "name": "22", "label": "(W)", "type": "text" }, { "name": "23", "label": "(X)", "type": "text" }, { "name": "24", "label": "(Y)", "type": "text" }, { "name": "25", "label": "(Z)", "type": "text" }, { "name": "26", "label": "(AA)", "type": "text" }, { "name": "27", "label": "(AB)", "type": "text" }, { "name": "28", "label": "(AC)", "type": "text" }, { "name": "29", "label": "(AD)", "type": "text" }, { "name": "30", "label": "(AE)", "type": "text" }, { "name": "31", "label": "(AF)", "type": "text" }, { "name": "32", "label": "(AG)", "type": "text" }, { "name": "33", "label": "(AH)", "type": "text" }, { "name": "34", "label": "(AI)", "type": "text" }, { "name": "35", "label": "(AJ)", "type": "text" }, { "name": "36", "label": "(AK)", "type": "text" }, { "name": "37", "label": "(AL)", "type": "text" }, { "name": "38", "label": "(AM)", "type": "text" }, { "name": "39", "label": "(AN)", "type": "text" }, { "name": "40", "label": "(AO)", "type": "text" }, { "name": "41", "label": "(AP)", "type": "text" }, { "name": "42", "label": "(AQ)", "type": "text" }, { "name": "43", "label": "(AR)", "type": "text" }, { "name": "44", "label": "(AS)", "type": "text" }, { "name": "45", "label": "(AT)", "type": "text" }, { "name": "46", "label": "(AU)", "type": "text" }, { "name": "47", "label": "(AV)", "type": "text" }, { "name": "48", "label": "(AW)", "type": "text" }, { "name": "49", "label": "(AX)", "type": "text" }, { "name": "50", "label": "(AY)", "type": "text" }, { "name": "51", "label": "(AZ)", "type": "text" }, { "name": "52", "label": "(BA)", "type": "text" }, { "name": "53", "label": "(BB)", "type": "text" }, { "name": "54", "label": "(BC)", "type": "text" }, { "name": "55", "label": "(BD)", "type": "text" }, { "name": "56", "label": "(BE)", "type": "text" }, { "name": "57", "label": "(BF)", "type": "text" }, { "name": "58", "label": "(BG)", "type": "text" }, { "name": "59", "label": "(BH)", "type": "text" }, { "name": "60", "label": "(BI)", "type": "text" }, { "name": "61", "label": "(BJ)", "type": "text" }, { "name": "62", "label": "(BK)", "type": "text" }, { "name": "63", "label": "(BL)", "type": "text" }, { "name": "64", "label": "(BM)", "type": "text" }, { "name": "65", "label": "(BN)", "type": "text" }, { "name": "66", "label": "(BO)", "type": "text" }, { "name": "67", "label": "(BP)", "type": "text" }, { "name": "68", "label": "(BQ)", "type": "text" }, { "name": "69", "label": "(BR)", "type": "text" }, { "name": "70", "label": "(BS)", "type": "text" }, { "name": "71", "label": "(BT)", "type": "text" }, { "name": "72", "label": "(BU)", "type": "text" }, { "name": "73", "label": "(BV)", "type": "text" }, { "name": "74", "label": "(BW)", "type": "text" }, { "name": "75", "label": "(BX)", "type": "text" }, { "name": "76", "label": "(BY)", "type": "text" }, { "name": "77", "label": "(BZ)", "type": "text" }, { "name": "78", "label": "(CA)", "type": "text" }, { "name": "79", "label": "(CB)", "type": "text" }, { "name": "80", "label": "(CC)", "type": "text" }, { "name": "81", "label": "(CD)", "type": "text" }, { "name": "82", "label": "(CE)", "type": "text" }, { "name": "83", "label": "(CF)", "type": "text" }, { "name": "84", "label": "(CG)", "type": "text" }, { "name": "85", "label": "(CH)", "type": "text" }, { "name": "86", "label": "(CI)", "type": "text" }, { "name": "87", "label": "(CJ)", "type": "text" }, { "name": "88", "label": "(CK)", "type": "text" }, { "name": "89", "label": "(CL)", "type": "text" }, { "name": "90", "label": "(CM)", "type": "text" }, { "name": "91", "label": "(CN)", "type": "text" }, { "name": "92", "label": "(CO)", "type": "text" }, { "name": "93", "label": "(CP)", "type": "text" }, { "name": "94", "label": "(CQ)", "type": "text" }, { "name": "95", "label": "(CR)", "type": "text" }, { "name": "96", "label": "(CS)", "type": "text" }, { "name": "97", "label": "(CT)", "type": "text" }, { "name": "98", "label": "(CU)", "type": "text" }, { "name": "99", "label": "(CV)", "type": "text" }, { "name": "100", "label": "(CW)", "type": "text" }, { "name": "101", "label": "(CX)", "type": "text" }, { "name": "102", "label": "(CY)", "type": "text" }, { "name": "103", "label": "(CZ)", "type": "text" } ] } }, { "id": 74, "module": "google-sheets:updateRow", "version": 2, "parameters": { "__IMTCONN__": 1707060 }, "mapper": { "mode": "select", "values": { "9": "=HYPERLINK(\"https://api.whatsapp.com/send?phone=+55{{1.cus_cel}}&text={{encodeURL(\"Oi *\" + replace(startcase(1.cus_name); \"/\\s(?<=[\\s]).*/g\"; emptystring) + \"*, tudo bem?\")}} Eu sou a *XXXXX* assistente da *XXXXXXX*. \n\nEstou passando aqui pra avisar que seu pedido de reembolso foi processado, você vai receber um e-mail de confirmação da EDUZZ.\n\nQualquer dúvida estou disponível para te ajudar ☺️\";\"REEMBOLSO SOLICITADO\")", "11": "REEMBOLSO SOLICITADO" }, "sheetId": "Compra Aprovada", "rowNumber": "{{73.`__ROW_NUMBER__`}}", "spreadsheetId": "1s1Tn9oJYzHDyA8hxgFXmzvWsRyfKdqTTn737VFemGnY", "includesHeaders": true, "valueInputOption": "USER_ENTERED" }, "metadata": { "designer": { "x": 1200, "y": 1200, "name": "ATUALIZA REEMBOLSO" }, "restore": { "mode": { "label": "Select spreadsheet and sheet" }, "sheetId": { "label": "Compra Aprovada" }, "__IMTCONN__": { "label": "Google - Thales (thaleslaray@gmail.com)" }, "spreadsheetId": { "label": "EDUZZ - (TEMPLATE)" }, "includesHeaders": { "label": "Yes" }, "valueInputOption": { "mode": "chose", "label": "User entered" } }, "parameters": [ { "name": "__IMTCONN__", "type": "account", "label": "Connection", "required": true } ], "expect": [ { "name": "mode", "type": "select", "label": "Mode", "required": true, "validate": { "enum": [ "select", "map" ] } }, { "name": "valueInputOption", "type": "select", "label": "Value input option", "validate": { "enum": [ "USER_ENTERED", "RAW" ] } }, { "name": "spreadsheetId", "type": "select", "label": "Spreadsheet", "required": true }, { "name": "sheetId", "type": "select", "label": "Sheet", "required": true }, { "name": "rowNumber", "type": "uinteger", "label": "Row number", "required": true }, { "name": "includesHeaders", "type": "select", "label": "Table contains headers", "required": true, "validate": { "enum": [ true, false ] } }, { "name": "values", "spec": [ { "name": "0", "type": "text", "label": "Data/Hora (A)" }, { "name": "1", "type": "text", "label": "Nome Completo (B)" }, { "name": "2", "type": "text", "label": "Nome (C)" }, { "name": "3", "type": "text", "label": "Sobrenome (D)" }, { "name": "4", "type": "text", "label": "E-mail (E)" }, { "name": "5", "type": "text", "label": "CPF (F)" }, { "name": "6", "type": "text", "label": "País (G)" }, { "name": "7", "type": "text", "label": "DDD (H)" }, { "name": "8", "type": "text", "label": "Celular (I)" }, { "name": "9", "type": "text", "label": "WhatsApp (J)" }, { "name": "10", "type": "text", "label": "PRODUTO (K)" }, { "name": "11", "type": "text", "label": "Obs. (L)" } ], "type": "collection", "label": "Values" } ] }, "onerror": [ { "id": 82, "module": "builtin:Ignore", "version": 1, "metadata": { "designer": { "x": 1500, "y": 1200 } } } ] } ] }, { "flow": [ { "id": 78, "module": "builtin:BasicRouter", "version": 1, "filter": { "name": "REEMBOLSO CONCLUÍDO", "conditions": [ [ { "a": "{{1.trans_status}}", "b": "7", "o": "text:equal" } ] ] }, "mapper": null, "metadata": { "designer": { "x": 600, "y": 1650 } }, "routes": [ { "flow": [ { "id": 76, "module": "google-sheets:filterRows", "version": 2, "parameters": { "__IMTCONN__": 1707060 }, "mapper": { "spreadsheetId": "1s1Tn9oJYzHDyA8hxgFXmzvWsRyfKdqTTn737VFemGnY", "valueRenderOption": "FORMATTED_VALUE", "dateTimeRenderOption": "FORMATTED_STRING", "sheetId": "Compra Aprovada", "includesHeaders": true, "tableFirstRow": "A1:CZ1", "filter": [ [ { "a": "E", "o": "text:equal", "b": "{{1.cus_email}}" } ] ], "sortOrder": "desc", "orderBy": "__ROW_NUMBER__" }, "metadata": { "designer": { "x": 900, "y": 1500, "name": "PESQUISA REEMBOLSO" }, "restore": { "__IMTCONN__": { "label": "Google - Thales (thaleslaray@gmail.com)" }, "spreadsheetId": { "mode": "chose", "label": "EDUZZ - (TEMPLATE)" }, "valueRenderOption": { "mode": "chose", "label": "Formatted value" }, "dateTimeRenderOption": { "mode": "chose", "label": "Formatted string" }, "sheetId": { "mode": "chose", "label": "Compra Aprovada" }, "includesHeaders": { "mode": "chose", "label": "Yes" }, "tableFirstRow": { "label": "A-CZ" }, "sortOrder": { "mode": "chose", "label": "Descending" }, "orderBy": { "mode": "chose", "label": "Row number" } }, "parameters": [ { "name": "__IMTCONN__", "type": "account", "label": "Connection", "required": true } ], "expect": [ { "name": "spreadsheetId", "type": "select", "label": "Spreadsheet", "required": true }, { "name": "valueRenderOption", "type": "select", "label": "Value render option", "validate": { "enum": [ "FORMATTED_VALUE", "UNFORMATTED_VALUE", "FORMULA" ] } }, { "name": "dateTimeRenderOption", "type": "select", "label": "Date and time render option", "validate": { "enum": [ "SERIAL_NUMBER", "FORMATTED_STRING" ] } }, { "name": "limit", "type": "number", "label": "Maximum number of returned rows" }, { "name": "sheetId", "type": "select", "label": "Sheet", "required": true }, { "name": "includesHeaders", "type": "select", "label": "Table contains headers", "required": true, "validate": { "enum": [ true, false ] } }, { "name": "tableFirstRow", "type": "select", "label": "Column range", "required": true, "validate": { "enum": [ "A1:Z1", "A1:BZ1", "A1:CZ1", "A1:DZ1", "A1:MZ1", "A1:ZZ1" ] } }, { "name": "filter", "type": "filter", "label": "Filter", "options": { "store": "rpc://google-sheets@2/rpcGetFilterKeys?includesHeaders=true" } }, { "name": "sortOrder", "type": "select", "label": "Sort order", "validate": { "enum": [ "asc", "desc" ] } }, { "name": "orderBy", "type": "select", "label": "Order by" } ], "interface": [ { "name": "__ROW_NUMBER__", "label": "Row number", "type": "number" }, { "name": "__SPREADSHEET_ID__", "label": "Spreadsheet ID", "type": "text" }, { "name": "__SHEET__", "label": "Sheet", "type": "text" }, { "name": "0", "label": "Data/Hora (A)", "type": "text" }, { "name": "1", "label": "Nome Completo (B)", "type": "text" }, { "name": "2", "label": "Nome (C)", "type": "text" }, { "name": "3", "label": "Sobrenome (D)", "type": "text" }, { "name": "4", "label": "E-mail (E)", "type": "text" }, { "name": "5", "label": "CPF (F)", "type": "text" }, { "name": "6", "label": "País (G)", "type": "text" }, { "name": "7", "label": "DDD (H)", "type": "text" }, { "name": "8", "label": "Celular (I)", "type": "text" }, { "name": "9", "label": "WhatsApp (J)", "type": "text" }, { "name": "10", "label": "PRODUTO (K)", "type": "text" }, { "name": "11", "label": "Obs. (L)", "type": "text" }, { "name": "12", "label": "(M)", "type": "text" }, { "name": "13", "label": "(N)", "type": "text" }, { "name": "14", "label": "(O)", "type": "text" }, { "name": "15", "label": "(P)", "type": "text" }, { "name": "16", "label": "(Q)", "type": "text" }, { "name": "17", "label": "(R)", "type": "text" }, { "name": "18", "label": "(S)", "type": "text" }, { "name": "19", "label": "(T)", "type": "text" }, { "name": "20", "label": "(U)", "type": "text" }, { "name": "21", "label": "(V)", "type": "text" }, { "name": "22", "label": "(W)", "type": "text" }, { "name": "23", "label": "(X)", "type": "text" }, { "name": "24", "label": "(Y)", "type": "text" }, { "name": "25", "label": "(Z)", "type": "text" }, { "name": "26", "label": "(AA)", "type": "text" }, { "name": "27", "label": "(AB)", "type": "text" }, { "name": "28", "label": "(AC)", "type": "text" }, { "name": "29", "label": "(AD)", "type": "text" }, { "name": "30", "label": "(AE)", "type": "text" }, { "name": "31", "label": "(AF)", "type": "text" }, { "name": "32", "label": "(AG)", "type": "text" }, { "name": "33", "label": "(AH)", "type": "text" }, { "name": "34", "label": "(AI)", "type": "text" }, { "name": "35", "label": "(AJ)", "type": "text" }, { "name": "36", "label": "(AK)", "type": "text" }, { "name": "37", "label": "(AL)", "type": "text" }, { "name": "38", "label": "(AM)", "type": "text" }, { "name": "39", "label": "(AN)", "type": "text" }, { "name": "40", "label": "(AO)", "type": "text" }, { "name": "41", "label": "(AP)", "type": "text" }, { "name": "42", "label": "(AQ)", "type": "text" }, { "name": "43", "label": "(AR)", "type": "text" }, { "name": "44", "label": "(AS)", "type": "text" }, { "name": "45", "label": "(AT)", "type": "text" }, { "name": "46", "label": "(AU)", "type": "text" }, { "name": "47", "label": "(AV)", "type": "text" }, { "name": "48", "label": "(AW)", "type": "text" }, { "name": "49", "label": "(AX)", "type": "text" }, { "name": "50", "label": "(AY)", "type": "text" }, { "name": "51", "label": "(AZ)", "type": "text" }, { "name": "52", "label": "(BA)", "type": "text" }, { "name": "53", "label": "(BB)", "type": "text" }, { "name": "54", "label": "(BC)", "type": "text" }, { "name": "55", "label": "(BD)", "type": "text" }, { "name": "56", "label": "(BE)", "type": "text" }, { "name": "57", "label": "(BF)", "type": "text" }, { "name": "58", "label": "(BG)", "type": "text" }, { "name": "59", "label": "(BH)", "type": "text" }, { "name": "60", "label": "(BI)", "type": "text" }, { "name": "61", "label": "(BJ)", "type": "text" }, { "name": "62", "label": "(BK)", "type": "text" }, { "name": "63", "label": "(BL)", "type": "text" }, { "name": "64", "label": "(BM)", "type": "text" }, { "name": "65", "label": "(BN)", "type": "text" }, { "name": "66", "label": "(BO)", "type": "text" }, { "name": "67", "label": "(BP)", "type": "text" }, { "name": "68", "label": "(BQ)", "type": "text" }, { "name": "69", "label": "(BR)", "type": "text" }, { "name": "70", "label": "(BS)", "type": "text" }, { "name": "71", "label": "(BT)", "type": "text" }, { "name": "72", "label": "(BU)", "type": "text" }, { "name": "73", "label": "(BV)", "type": "text" }, { "name": "74", "label": "(BW)", "type": "text" }, { "name": "75", "label": "(BX)", "type": "text" }, { "name": "76", "label": "(BY)", "type": "text" }, { "name": "77", "label": "(BZ)", "type": "text" }, { "name": "78", "label": "(CA)", "type": "text" }, { "name": "79", "label": "(CB)", "type": "text" }, { "name": "80", "label": "(CC)", "type": "text" }, { "name": "81", "label": "(CD)", "type": "text" }, { "name": "82", "label": "(CE)", "type": "text" }, { "name": "83", "label": "(CF)", "type": "text" }, { "name": "84", "label": "(CG)", "type": "text" }, { "name": "85", "label": "(CH)", "type": "text" }, { "name": "86", "label": "(CI)", "type": "text" }, { "name": "87", "label": "(CJ)", "type": "text" }, { "name": "88", "label": "(CK)", "type": "text" }, { "name": "89", "label": "(CL)", "type": "text" }, { "name": "90", "label": "(CM)", "type": "text" }, { "name": "91", "label": "(CN)", "type": "text" }, { "name": "92", "label": "(CO)", "type": "text" }, { "name": "93", "label": "(CP)", "type": "text" }, { "name": "94", "label": "(CQ)", "type": "text" }, { "name": "95", "label": "(CR)", "type": "text" }, { "name": "96", "label": "(CS)", "type": "text" }, { "name": "97", "label": "(CT)", "type": "text" }, { "name": "98", "label": "(CU)", "type": "text" }, { "name": "99", "label": "(CV)", "type": "text" }, { "name": "100", "label": "(CW)", "type": "text" }, { "name": "101", "label": "(CX)", "type": "text" }, { "name": "102", "label": "(CY)", "type": "text" }, { "name": "103", "label": "(CZ)", "type": "text" } ] } }, { "id": 77, "module": "google-sheets:updateRow", "version": 2, "parameters": { "__IMTCONN__": 1707060 }, "mapper": { "mode": "select", "valueInputOption": "USER_ENTERED", "spreadsheetId": "1s1Tn9oJYzHDyA8hxgFXmzvWsRyfKdqTTn737VFemGnY", "sheetId": "Compra Aprovada", "rowNumber": "{{76.`__ROW_NUMBER__`}}", "includesHeaders": true, "values": { "9": "=HYPERLINK(\"https://api.whatsapp.com/send?phone=+55{{1.cus_cel}}&text={{encodeURL(\"Oi *\" + replace(startcase(1.cus_name); \"/\\s(?<=[\\s]).*/g\"; emptystring) + \"*, tudo bem?\")}} Eu sou a *XXXXX* assistente da *XXXXXXX*. \n\nEstou passando aqui pra avisar que seu pedido de reembolso foi concluído com sucesso.\n\nQualquer dúvida estou disponível para te ajudar ☺️\";\"REEMBOLSO CONCLUÍDO\")", "11": "REEMBOLSO CONCLUÍDO" } }, "metadata": { "designer": { "x": 1201, "y": 1463, "name": "ATUALIZA ABA COMPRA APROVADA" }, "restore": { "__IMTCONN__": { "label": "Google - Thales (thaleslaray@gmail.com)" }, "mode": { "label": "Select spreadsheet and sheet" }, "valueInputOption": { "mode": "chose", "label": "User entered" }, "spreadsheetId": { "label": "EDUZZ - (TEMPLATE)" }, "sheetId": { "label": "Compra Aprovada" }, "includesHeaders": { "label": "Yes" } }, "parameters": [ { "name": "__IMTCONN__", "type": "account", "label": "Connection", "required": true } ], "expect": [ { "name": "mode", "type": "select", "label": "Mode", "required": true, "validate": { "enum": [ "select", "map" ] } }, { "name": "valueInputOption", "type": "select", "label": "Value input option", "validate": { "enum": [ "USER_ENTERED", "RAW" ] } }, { "name": "spreadsheetId", "type": "select", "label": "Spreadsheet", "required": true }, { "name": "sheetId", "type": "select", "label": "Sheet", "required": true }, { "name": "rowNumber", "type": "uinteger", "label": "Row number", "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", "label": "Data/Hora (A)", "type": "text" }, { "name": "1", "label": "Nome Completo (B)", "type": "text" }, { "name": "2", "label": "Nome (C)", "type": "text" }, { "name": "3", "label": "Sobrenome (D)", "type": "text" }, { "name": "4", "label": "E-mail (E)", "type": "text" }, { "name": "5", "label": "CPF (F)", "type": "text" }, { "name": "6", "label": "País (G)", "type": "text" }, { "name": "7", "label": "DDD (H)", "type": "text" }, { "name": "8", "label": "Celular (I)", "type": "text" }, { "name": "9", "label": "WhatsApp (J)", "type": "text" }, { "name": "10", "label": "PRODUTO (K)", "type": "text" }, { "name": "11", "label": "Obs. (L)", "type": "text" } ] } ] }, "onerror": [ { "id": 83, "module": "builtin:Ignore", "version": 1, "metadata": { "designer": { "x": 1500, "y": 1500 } } } ] } ] }, { "flow": [ { "id": 79, "module": "google-sheets:filterRows", "version": 2, "parameters": { "__IMTCONN__": 1707060 }, "mapper": { "spreadsheetId": "1s1Tn9oJYzHDyA8hxgFXmzvWsRyfKdqTTn737VFemGnY", "valueRenderOption": "FORMATTED_VALUE", "dateTimeRenderOption": "FORMATTED_STRING", "sheetId": "Reembolso", "includesHeaders": true, "tableFirstRow": "A1:CZ1", "filter": [ [ { "a": "E", "o": "text:equal", "b": "{{1.cus_email}}" } ] ], "sortOrder": "desc", "orderBy": "__ROW_NUMBER__" }, "metadata": { "designer": { "x": 900, "y": 1800, "name": "PESQUISA REEMBOLSO" }, "restore": { "__IMTCONN__": { "label": "Google - Thales (thaleslaray@gmail.com)" }, "spreadsheetId": { "mode": "chose", "label": "EDUZZ - (TEMPLATE)" }, "valueRenderOption": { "mode": "chose", "label": "Formatted value" }, "dateTimeRenderOption": { "mode": "chose", "label": "Formatted string" }, "sheetId": { "mode": "chose", "label": "Reembolso" }, "tableFirstRow": { "label": "A-CZ" }, "sortOrder": { "mode": "chose", "label": "Descending" }, "orderBy": { "mode": "chose", "label": "Row number" }, "includesHeaders": { "mode": "chose", "label": "Yes" } }, "parameters": [ { "name": "__IMTCONN__", "type": "account", "label": "Connection", "required": true } ], "expect": [ { "name": "spreadsheetId", "type": "select", "label": "Spreadsheet", "required": true }, { "name": "valueRenderOption", "type": "select", "label": "Value render option", "validate": { "enum": [ "FORMATTED_VALUE", "UNFORMATTED_VALUE", "FORMULA" ] } }, { "name": "dateTimeRenderOption", "type": "select", "label": "Date and time render option", "validate": { "enum": [ "SERIAL_NUMBER", "FORMATTED_STRING" ] } }, { "name": "limit", "type": "number", "label": "Maximum number of returned rows" }, { "name": "sheetId", "type": "select", "label": "Sheet", "required": true }, { "name": "includesHeaders", "type": "select", "label": "Table contains headers", "required": true, "validate": { "enum": [ true, false ] } }, { "name": "tableFirstRow", "type": "select", "label": "Column range", "required": true, "validate": { "enum": [ "A1:Z1", "A1:BZ1", "A1:CZ1", "A1:DZ1", "A1:MZ1", "A1:ZZ1" ] } }, { "name": "filter", "type": "filter", "label": "Filter", "options": { "store": "rpc://google-sheets@2/rpcGetFilterKeys?includesHeaders=true" } }, { "name": "sortOrder", "type": "select", "label": "Sort order", "validate": { "enum": [ "asc", "desc" ] } }, { "name": "orderBy", "type": "select", "label": "Order by" } ], "interface": [ { "name": "__ROW_NUMBER__", "label": "Row number", "type": "number" }, { "name": "__SPREADSHEET_ID__", "label": "Spreadsheet ID", "type": "text" }, { "name": "__SHEET__", "label": "Sheet", "type": "text" }, { "name": "0", "label": "Data/Hora (A)", "type": "text" }, { "name": "1", "label": "Nome Completo (B)", "type": "text" }, { "name": "2", "label": "Nome (C)", "type": "text" }, { "name": "3", "label": "Sobrenome (D)", "type": "text" }, { "name": "4", "label": "E-mail (E)", "type": "text" }, { "name": "5", "label": "CPF (F)", "type": "text" }, { "name": "6", "label": "País (G)", "type": "text" }, { "name": "7", "label": "DDD (H)", "type": "text" }, { "name": "8", "label": "Celular (I)", "type": "text" }, { "name": "9", "label": "WhatsApp (J)", "type": "text" }, { "name": "10", "label": "PRODUTO (K)", "type": "text" }, { "name": "11", "label": "(L)", "type": "text" }, { "name": "12", "label": "(M)", "type": "text" }, { "name": "13", "label": "(N)", "type": "text" }, { "name": "14", "label": "(O)", "type": "text" }, { "name": "15", "label": "(P)", "type": "text" }, { "name": "16", "label": "(Q)", "type": "text" }, { "name": "17", "label": "(R)", "type": "text" }, { "name": "18", "label": "(S)", "type": "text" }, { "name": "19", "label": "(T)", "type": "text" }, { "name": "20", "label": "(U)", "type": "text" }, { "name": "21", "label": "(V)", "type": "text" }, { "name": "22", "label": "(W)", "type": "text" }, { "name": "23", "label": "(X)", "type": "text" }, { "name": "24", "label": "(Y)", "type": "text" }, { "name": "25", "label": "(Z)", "type": "text" }, { "name": "26", "label": "(AA)", "type": "text" }, { "name": "27", "label": "(AB)", "type": "text" }, { "name": "28", "label": "(AC)", "type": "text" }, { "name": "29", "label": "(AD)", "type": "text" }, { "name": "30", "label": "(AE)", "type": "text" }, { "name": "31", "label": "(AF)", "type": "text" }, { "name": "32", "label": "(AG)", "type": "text" }, { "name": "33", "label": "(AH)", "type": "text" }, { "name": "34", "label": "(AI)", "type": "text" }, { "name": "35", "label": "(AJ)", "type": "text" }, { "name": "36", "label": "(AK)", "type": "text" }, { "name": "37", "label": "(AL)", "type": "text" }, { "name": "38", "label": "(AM)", "type": "text" }, { "name": "39", "label": "(AN)", "type": "text" }, { "name": "40", "label": "(AO)", "type": "text" }, { "name": "41", "label": "(AP)", "type": "text" }, { "name": "42", "label": "(AQ)", "type": "text" }, { "name": "43", "label": "(AR)", "type": "text" }, { "name": "44", "label": "(AS)", "type": "text" }, { "name": "45", "label": "(AT)", "type": "text" }, { "name": "46", "label": "(AU)", "type": "text" }, { "name": "47", "label": "(AV)", "type": "text" }, { "name": "48", "label": "(AW)", "type": "text" }, { "name": "49", "label": "(AX)", "type": "text" }, { "name": "50", "label": "(AY)", "type": "text" }, { "name": "51", "label": "(AZ)", "type": "text" }, { "name": "52", "label": "(BA)", "type": "text" }, { "name": "53", "label": "(BB)", "type": "text" }, { "name": "54", "label": "(BC)", "type": "text" }, { "name": "55", "label": "(BD)", "type": "text" }, { "name": "56", "label": "(BE)", "type": "text" }, { "name": "57", "label": "(BF)", "type": "text" }, { "name": "58", "label": "(BG)", "type": "text" }, { "name": "59", "label": "(BH)", "type": "text" }, { "name": "60", "label": "(BI)", "type": "text" }, { "name": "61", "label": "(BJ)", "type": "text" }, { "name": "62", "label": "(BK)", "type": "text" }, { "name": "63", "label": "(BL)", "type": "text" }, { "name": "64", "label": "(BM)", "type": "text" }, { "name": "65", "label": "(BN)", "type": "text" }, { "name": "66", "label": "(BO)", "type": "text" }, { "name": "67", "label": "(BP)", "type": "text" }, { "name": "68", "label": "(BQ)", "type": "text" }, { "name": "69", "label": "(BR)", "type": "text" }, { "name": "70", "label": "(BS)", "type": "text" }, { "name": "71", "label": "(BT)", "type": "text" }, { "name": "72", "label": "(BU)", "type": "text" }, { "name": "73", "label": "(BV)", "type": "text" }, { "name": "74", "label": "(BW)", "type": "text" }, { "name": "75", "label": "(BX)", "type": "text" }, { "name": "76", "label": "(BY)", "type": "text" }, { "name": "77", "label": "(BZ)", "type": "text" }, { "name": "78", "label": "(CA)", "type": "text" }, { "name": "79", "label": "(CB)", "type": "text" }, { "name": "80", "label": "(CC)", "type": "text" }, { "name": "81", "label": "(CD)", "type": "text" }, { "name": "82", "label": "(CE)", "type": "text" }, { "name": "83", "label": "(CF)", "type": "text" }, { "name": "84", "label": "(CG)", "type": "text" }, { "name": "85", "label": "(CH)", "type": "text" }, { "name": "86", "label": "(CI)", "type": "text" }, { "name": "87", "label": "(CJ)", "type": "text" }, { "name": "88", "label": "(CK)", "type": "text" }, { "name": "89", "label": "(CL)", "type": "text" }, { "name": "90", "label": "(CM)", "type": "text" }, { "name": "91", "label": "(CN)", "type": "text" }, { "name": "92", "label": "(CO)", "type": "text" }, { "name": "93", "label": "(CP)", "type": "text" }, { "name": "94", "label": "(CQ)", "type": "text" }, { "name": "95", "label": "(CR)", "type": "text" }, { "name": "96", "label": "(CS)", "type": "text" }, { "name": "97", "label": "(CT)", "type": "text" }, { "name": "98", "label": "(CU)", "type": "text" }, { "name": "99", "label": "(CV)", "type": "text" }, { "name": "100", "label": "(CW)", "type": "text" }, { "name": "101", "label": "(CX)", "type": "text" }, { "name": "102", "label": "(CY)", "type": "text" }, { "name": "103", "label": "(CZ)", "type": "text" } ] } }, { "id": 80, "module": "google-sheets:updateRow", "version": 2, "parameters": { "__IMTCONN__": 1707060 }, "mapper": { "mode": "select", "valueInputOption": "USER_ENTERED", "spreadsheetId": "1s1Tn9oJYzHDyA8hxgFXmzvWsRyfKdqTTn737VFemGnY", "sheetId": "Reembolso", "rowNumber": "{{79.`__ROW_NUMBER__`}}", "includesHeaders": true, "values": { "9": "=HYPERLINK(\"https://api.whatsapp.com/send?phone=+55{{1.cus_cel}}&text={{encodeURL(\"Oi *\" + replace(startcase(1.cus_name); \"/\\s(?<=[\\s]).*/g\"; emptystring) + \"*, tudo bem?\")}} Eu sou a *XXXXX* assistente da *XXXXXXX*. \n\nEstou passando aqui pra avisar que seu pedido de reembolso foi concluído com sucesso.\n\nQualquer dúvida estou disponível para te ajudar ☺️\";\"REEMBOLSO CONCLUÍDO\")" } }, "metadata": { "designer": { "x": 1203, "y": 1774, "name": "ATUALIZA ABA REEMBOLSO" }, "restore": { "__IMTCONN__": { "label": "Google - Thales (thaleslaray@gmail.com)" }, "mode": { "label": "Select spreadsheet and sheet" }, "valueInputOption": { "mode": "chose", "label": "User entered" }, "spreadsheetId": { "label": "EDUZZ - (TEMPLATE)" }, "sheetId": { "label": "Reembolso" }, "includesHeaders": { "label": "Yes" } }, "parameters": [ { "name": "__IMTCONN__", "type": "account", "label": "Connection", "required": true } ], "expect": [ { "name": "mode", "type": "select", "label": "Mode", "required": true, "validate": { "enum": [ "select", "map" ] } }, { "name": "valueInputOption", "type": "select", "label": "Value input option", "validate": { "enum": [ "USER_ENTERED", "RAW" ] } }, { "name": "spreadsheetId", "type": "select", "label": "Spreadsheet", "required": true }, { "name": "sheetId", "type": "select", "label": "Sheet", "required": true }, { "name": "rowNumber", "type": "uinteger", "label": "Row number", "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", "label": "Data/Hora (A)", "type": "text" }, { "name": "1", "label": "Nome Completo (B)", "type": "text" }, { "name": "2", "label": "Nome (C)", "type": "text" }, { "name": "3", "label": "Sobrenome (D)", "type": "text" }, { "name": "4", "label": "E-mail (E)", "type": "text" }, { "name": "5", "label": "CPF (F)", "type": "text" }, { "name": "6", "label": "País (G)", "type": "text" }, { "name": "7", "label": "DDD (H)", "type": "text" }, { "name": "8", "label": "Celular (I)", "type": "text" }, { "name": "9", "label": "WhatsApp (J)", "type": "text" }, { "name": "10", "label": "PRODUTO (K)", "type": "text" }, { "name": "11", "label": "(L)", "type": "text" } ] } ] }, "onerror": [ { "id": 84, "module": "builtin:Ignore", "version": 1, "metadata": { "designer": { "x": 1500, "y": 1800 } } } ] } ] } ] } ] } ] } ], "metadata": { "version": 1, "scenario": { "roundtrips": 1, "shatter": false, "maxErrors": 3, "autoCommit": false, "sequential": false, "confidential": false, "dataloss": false, "dlq": false }, "designer": { "orphans": [] }, "zone": "eu1.integromat.com" } }