# Varredura de segredos em texto puro Data: 2026-09-17 12:35 UTC Escopo: /opt/mia/scripts, /opt/mia/workspace/clientes, /opt/mia-bot Exclui: __pycache__, node_modules, .venv, venv, *.bak_*, *.deprecated_*, .git, logs ## GHL_PIT — 24 ocorrência(s) ``` /opt/mia/scripts/relatorio_px3_meta.py:42:GHL_TOKEN = "[REDACTED_GHL_PIT]" /opt/mia/workspace/clientes/sweet_angels/update_fesqua_ghl.py:11:TOKEN = "[REDACTED_GHL_PIT]" /opt/mia/workspace/clientes/px3lab/exportar_contatos.py:7:TOKEN = "[REDACTED_GHL_PIT]" /opt/mia/workspace/clientes/sweet_angels/sdr_medio_porte/setup_import.py:14:TOKEN = "[REDACTED_GHL_PIT]" /opt/mia/workspace/clientes/px3lab/cnpj_import_santa_fe.py:35:TOKEN = "[REDACTED_GHL_PIT]" /opt/mia/workspace/clientes/px3lab/config_ghl.py:4:PX3_TOKEN = "[REDACTED_GHL_PIT]" /opt/mia/workspace/clientes/sweet_angels/sdr_medio_porte/patch_custom_fields.py:14:TOKEN = "[REDACTED_GHL_PIT]" /opt/mia/workspace/clientes/px3lab/lancamento_photorf2/waitlist-lp/app.py:29: "[REDACTED_GHL_PIT]", /opt/mia/workspace/clientes/px3lab/lancamento_photorf2/waitlist-lp/reprocess_failed.py:27:TOKEN = "[REDACTED_GHL_PIT]" /opt/mia/workspace/clientes/px3lab/dinastia_webhook/instancias.json:4: "ghl_token": "[REDACTED_GHL_PIT]", /opt/mia/workspace/clientes/px3lab/dinastia_webhook/instancias.json:10: "ghl_token": "[REDACTED_GHL_PIT]", /opt/mia/workspace/clientes/px3lab/dinastia_webhook/instancias.json:17: "ghl_token": "[REDACTED_GHL_PIT]", /opt/mia/workspace/clientes/px3lab/dinastia_webhook/instancias.json:24: "ghl_token": "[REDACTED_GHL_PIT]", /opt/mia/workspace/clientes/px3lab/dinastia_webhook/instancias.json:31: "ghl_token": "[REDACTED_GHL_PIT]", /opt/mia/workspace/clientes/px3lab/dinastia_webhook/instancias.json:37: "ghl_token": "[REDACTED_GHL_PIT]", /opt/mia/workspace/clientes/px3lab/n8n_backups/vra_workflow_pre_fix_mapping_20260824_191424.json:1:{"updatedAt":"2026-08-24T17:50:01.874Z","createdAt":"2026-04-16T20:09:08.538Z","id":"QcJuvqhV98vIYtA6","name":"VRA – NOVOS CADASTROS AREA DO CLIENTE","description":null,"active":true,"isArchived":false,"nodes":[{"parameters":{"operation":"append","documentId":{"__rl":true,"mode":"url","value":"https://docs.google.com/spreadsheets/d/1Y_H8f5_BZs0CoRbDLmvd5nvgmC7lrTg6KZt-zP3miYQ/edit?usp=sharing","__regex":"https:\\/\\/(?:drive|docs)\\.google\\.com(?:\\/.*|)\\/d\\/([0-9a-zA-Z\\-_]+)(?:\\/.*|)"},"sheetName":{"__rl":true,"value":"gid=0","mode":"list","cachedResultName":"CADASTRO","cachedResultUrl":"https://docs.google.com/spreadsheets/d/1Y_H8f5_BZs0CoRbDLmvd5nvgmC7lrTg6KZt-zP3miYQ/edit#gid=0"},"columns":{"mappingMode":"defineBelow","value":{"PESSOA":"={{ $json.body.PESSOA }}","CNPJ":"={{ $json.body.DADOS_DA_EMPRESA.CNPJ }}","RAZAO_SOCIAL":"={{ $json.body.DADOS_DA_EMPRESA.RAZAO_SOCIAL }}","CEP":"={{ $json.body.DADOS_DA_EMPRESA.CEP }}","RUA":"={{ $json.body.DADOS_DA_EMPRESA.RUA }}","NUMERO":"={{ $json.body.DADOS_DA_EMPRESA.NUMERO }}","COMPLEMENTO":"={{ $json.body.DADOS_DA_EMPRESA.COMPLEMENTO }}","BAIRRO":"={{ $json.body.DADOS_DA_EMPRESA.BAIRRO }}","CIDADE":"={{ $json.body.DADOS_DA_EMPRESA.CIDADE }}","ESTADO":"={{ $json.body.DADOS_DA_EMPRESA.ESTADO }}","NOME_COMPLETO_REP":"={{ $json.body.REPRESENTANTE.NOME_COMPLETO }}","CPF_REP":"={{ $json.body.REPRESENTANTE.CPF }}","RG_REP":"={{ $json.body.REPRESENTANTE.RG }}","CEP_REP":"={{ $json.body.REPRESENTANTE.CEP }}","RUA_REP":"={{ $json.body.REPRESENTANTE.RUA }}","NUMERO_REP":"={{ $json.body.REPRESENTANTE.NUMERO }}","COMPLEMENTO_REP":"={{ $json.body.REPRESENTANTE.COMPLEMENTO }}","BAIRRO_REP":"={{ $json.body.REPRESENTANTE.BAIRRO }}","CIDADE_REP":"={{ $json.body.REPRESENTANTE.CIDADE }}","ESTADO_REP":"={{ $json.body.REPRESENTANTE.ESTADO }}","EMAIL_REP":"={{ $json.body.REPRESENTANTE['E-MAIL'] }}","TELEFONE_REP":"={{ $json.body.REPRESENTANTE.TELEFONE }}","DATA E HORA":"={{ $now.setZone('America/Sao_Paulo').toFormat('dd/MM/yyyy HH:mm:ss') }}"},"matchingColumns":[],"schema":[{"id":"DATA E HORA","displayName":"DATA E HORA","required":false,"defaultMatch":false,"display":true,"type":"string","canBeUsedToMatch":true,"removed":false},{"id":"PESSOA","displayName":"PESSOA","required":false,"defaultMatch":false,"display":true,"type":"string","canBeUsedToMatch":true,"removed":false},{"id":"CNPJ","displayName":"CNPJ","required":false,"defaultMatch":false,"display":true,"type":"string","canBeUsedToMatch":true,"removed":false},{"id":"RAZAO_SOCIAL","displayName":"RAZAO_SOCIAL","required":false,"defaultMatch":false,"display":true,"type":"string","canBeUsedToMatch":true,"removed":false},{"id":"CEP","displayName":"CEP","required":false,"defaultMatch":false,"display":true,"type":"string","canBeUsedToMatch":true,"removed":false},{"id":"RUA","displayName":"RUA","required":false,"defaultMatch":false,"display":true,"type":"string","canBeUsedToMatch":true,"removed":false},{"id":"NUMERO","displayName":"NUMERO","required":false,"defaultMatch":false,"display":true,"type":"string","canBeUsedToMatch":true,"removed":false},{"id":"COMPLEMENTO","displayName":"COMPLEMENTO","required":false,"defaultMatch":false,"display":true,"type":"string","canBeUsedToMatch":true,"removed":false},{"id":"BAIRRO","displayName":"BAIRRO","required":false,"defaultMatch":false,"display":true,"type":"string","canBeUsedToMatch":true,"removed":false},{"id":"CIDADE","displayName":"CIDADE","required":false,"defaultMatch":false,"display":true,"type":"string","canBeUsedToMatch":true,"removed":false},{"id":"ESTADO","displayName":"ESTADO","required":false,"defaultMatch":false,"display":true,"type":"string","canBeUsedToMatch":true,"removed":false},{"id":"NOME_COMPLETO_REP","displayName":"NOME_COMPLETO_REP","required":false,"defaultMatch":false,"display":true,"type":"string","canBeUsedToMatch":true,"removed":false},{"id":"CPF_REP","displayName":"CPF_REP","required":false,"defaultMatch":false,"display":true,"type":"string","canBeUsedToMatch":true,"removed":false},{"id":"RG_REP","displayName":"RG_REP","required":false,"defaultMatch":false,"display":true,"type":"string","canBeUsedToMatch":true,"removed":false},{"id":"CEP_REP","displayName":"CEP_REP","required":false,"defaultMatch":false,"display":true,"type":"string","canBeUsedToMatch":true,"removed":false},{"id":"RUA_REP","displayName":"RUA_REP","required":false,"defaultMatch":false,"display":true,"type":"string","canBeUsedToMatch":true,"removed":false},{"id":"NUMERO_REP","displayName":"NUMERO_REP","required":false,"defaultMatch":false,"display":true,"type":"string","canBeUsedToMatch":true,"removed":false},{"id":"COMPLEMENTO_REP","displayName":"COMPLEMENTO_REP","required":false,"defaultMatch":false,"display":true,"type":"string","canBeUsedToMatch":true,"removed":false},{"id":"BAIRRO_REP","displayName":"BAIRRO_REP","required":false,"defaultMatch":false,"display":true,"type":"string","canBeUsedToMatch":true,"removed":false},{"id":"CIDADE_REP","displayName":"CIDADE_REP","required":false,"defaultMatch":false,"display":true,"type":"string","canBeUsedToMatch":true,"removed":false},{"id":"ESTADO_REP","displayName":"ESTADO_REP","required":false,"defaultMatch":false,"display":true,"type":"string","canBeUsedToMatch":true,"removed":false},{"id":"EMAIL_REP","displayName":"EMAIL_REP","required":false,"defaultMatch":false,"display":true,"type":"string","canBeUsedToMatch":true,"removed":false},{"id":"TELEFONE_REP","displayName":"TELEFONE_REP","required":false,"defaultMatch":false,"display":true,"type":"string","canBeUsedToMatch":true,"removed":false}],"attemptToConvertTypes":false,"convertFieldsToString":false},"options":{}},"type":"n8n-nodes-base.googleSheets","typeVersion":4.7,"position":[448,-240],"id":"e3789810-ec89-4b6a-a8cc-33d101deec82","name":"Append row in sheet","credentials":{"googleSheetsOAuth2Api":{"id":"6TVIGfPIghjLjfhr","name":"VRA - CADASTRO USUARIOS"}},"onError":"continueErrorOutput"},{"parameters":{"httpMethod":"POST","path":"5230b458-f2b1-4e7a-9216-c709fe28b9ff","options":{"rawBody":true,"responseData":"200 OK"}},"type":"n8n-nodes-base.webhook","typeVersion":2.1,"position":[240,-240],"id":"0526f2cc-0b40-41a5-9026-dd8436f695eb","name":"CADASTRO DE CLIENTES","webhookId":"5230b458-f2b1-4e7a-9216-c709fe28b9ff"},{"parameters":{"httpMethod":"POST","path":"a0e1aac5-c99d-495f-abd2-7a6da3784093","options":{"responseData":"200 OK"}},"type":"n8n-nodes-base.webhook","typeVersion":2.1,"position":[-96,176],"id":"21cda2fd-2c53-4525-8b4a-2107b349e5e7","name":"PLANILHA DE VENDAS","webhookId":"a0e1aac5-c99d-495f-abd2-7a6da3784093","onError":"continueRegularOutput"},{"parameters":{"operation":"append","documentId":{"__rl":true,"mode":"url","value":"https://docs.google.com/spreadsheets/d/1Y_H8f5_BZs0CoRbDLmvd5nvgmC7lrTg6KZt-zP3miYQ/edit?usp=sharing","__regex":"https:\\/\\/(?:drive|docs)\\.google\\.com(?:\\/.*|)\\/d\\/([0-9a-zA-Z\\-_]+)(?:\\/.*|)"},"sheetName":{"__rl":true,"value":46089070,"mode":"list","cachedResultName":"VENDAS","cachedResultUrl":"https://docs.google.com/spreadsheets/d/1Y_H8f5_BZs0CoRbDLmvd5nvgmC7lrTg6KZt-zP3miYQ/edit#gid=46089070"},"columns":{"mappingMode":"defineBelow","value":{"PESSOA":"={{ $json.body.PESSOA }}","CNPJ":"={{ $json.body.DADOS_DA_EMPRESA.CNPJ }}","RAZAO_SOCIAL":"={{ $json.body.DADOS_DA_EMPRESA.RAZAO_SOCIAL }}","CEP":"={{ $json.body.DADOS_DA_EMPRESA.CEP }}","RUA":"={{ $json.body.DADOS_DA_EMPRESA.RUA }}","NUMERO":"={{ $json.body.DADOS_DA_EMPRESA.NUMERO }}","COMPLEMENTO":"={{ $json.body.DADOS_DA_EMPRESA.COMPLEMENTO }}","BAIRRO":"={{ $json.body.DADOS_DA_EMPRESA.BAIRRO }}","CIDADE":"={{ $json.body.DADOS_DA_EMPRESA.CIDADE }}","ESTADO":"={{ $json.body.DADOS_DA_EMPRESA.ESTADO }}","NOME_COMPLETO_REP":"={{ $json.body.REPRESENTANTE.NOME_COMPLETO }}","CPF_REP":"={{ $json.body.REPRESENTANTE.CPF }}","RG_REP":"={{ $json.body.REPRESENTANTE.RG }}","CEP_REP":"={{ $json.body.REPRESENTANTE.CEP }}","RUA_REP":"={{ $json.body.REPRESENTANTE.RUA }}","NUMERO_REP":"={{ $json.body.REPRESENTANTE.NUMERO }}","COMPLEMENTO_REP":"={{ $json.body.REPRESENTANTE.COMPLEMENTO }}","BAIRRO_REP":"={{ $json.body.REPRESENTANTE.BAIRRO }}","CIDADE_REP":"={{ $json.body.REPRESENTANTE.CIDADE }}","ESTADO_REP":"={{ $json.body.REPRESENTANTE.ESTADO }}","EMAIL_REP":"={{ $json.body.REPRESENTANTE['E-MAIL'] }}","TELEFONE_REP":"={{ $json.body.REPRESENTANTE.TELEFONE }}","DATA E HORA":"={{ $now.setZone('America/Sao_Paulo').toFormat('dd/MM/yyyy HH:mm:ss') }}","SOFTWARE":"={{ $json.body.DADOS_VENDA.SOFTWARE }}","TOTAL DE CRÉDITO":"={{ $json.body.DADOS_VENDA.TOTAL_DE_CREDITO }}","TIPO DE CRÉDITO":"={{ $json.body.DADOS_VENDA.TIPO_DE_DE_CREDITO }}","VENDEDOR":"={{ $json.body.DADOS_VENDA.VENDEDOR }}","PREÇO":"={{ $json.body.DADOS_VENDA['PREÇO'] }}"},"matchingColumns":[],"schema":[{"id":"PESSOA","displayName":"PESSOA","required":false,"defaultMatch":false,"display":true,"type":"string","canBeUsedToMatch":true,"removed":false},{"id":"CNPJ","displayName":"CNPJ","required":false,"defaultMatch":false,"display":true,"type":"string","canBeUsedToMatch":true,"removed":false},{"id":"RAZAO_SOCIAL","displayName":"RAZAO_SOCIAL","required":false,"defaultMatch":false,"display":true,"type":"string","canBeUsedToMatch":true,"removed":false},{"id":"CEP","displayName":"CEP","required":false,"defaultMatch":false,"display":true,"type":"string","canBeUsedToMatch":true,"removed":false},{"id":"RUA","displayName":"RUA","required":false,"defaultMatch":false,"display":true,"type":"string","canBeUsedToMatch":true,"removed":false},{"id":"NUMERO","displayName":"NUMERO","required":false,"defaultMatch":false,"display":true,"type":"string","canBeUsedToMatch":true,"removed":false},{"id":"COMPLEMENTO","displayName":"COMPLEMENTO","required":false,"defaultMatch":false,"display":true,"type":"string","canBeUsedToMatch":true,"removed":false},{"id":"BAIRRO","displayName":"BAIRRO","required":false,"defaultMatch":false,"display":true,"type":"string","canBeUsedToMatch":true,"removed":false},{"id":"CIDADE","displayName":"CIDADE","required":false,"defaultMatch":false,"display":true,"type":"string","canBeUsedToMatch":true,"removed":false},{"id":"ESTADO","displayName":"ESTADO","required":false,"defaultMatch":false,"display":true,"type":"string","canBeUsedToMatch":true,"removed":false},{"id":"NOME_COMPLETO_REP","displayName":"NOME_COMPLETO_REP","required":false,"defaultMatch":false,"display":true,"type":"string","canBeUsedToMatch":true,"removed":false},{"id":"CPF_REP","displayName":"CPF_REP","required":false,"defaultMatch":false,"display":true,"type":"string","canBeUsedToMatch":true,"removed":false},{"id":"RG_REP","displayName":"RG_REP","required":false,"defaultMatch":false,"display":true,"type":"string","canBeUsedToMatch":true,"removed":false},{"id":"CEP_REP","displayName":"CEP_REP","required":false,"defaultMatch":false,"display":true,"type":"string","canBeUsedToMatch":true,"removed":false},{"id":"RUA_REP","displayName":"RUA_REP","required":false,"defaultMatch":false,"display":true,"type":"string","canBeUsedToMatch":true,"removed":false},{"id":"NUMERO_REP","displayName":"NUMERO_REP","required":false,"defaultMatch":false,"display":true,"type":"string","canBeUsedToMatch":true,"removed":false},{"id":"COMPLEMENTO_REP","displayName":"COMPLEMENTO_REP","required":false,"defaultMatch":false,"display":true,"type":"string","canBeUsedToMatch":true,"removed":false},{"id":"BAIRRO_REP","displayName":"BAIRRO_REP","required":false,"defaultMatch":false,"display":true,"type":"string","canBeUsedToMatch":true,"removed":false},{"id":"CIDADE_REP","displayName":"CIDADE_REP","required":false,"defaultMatch":false,"display":true,"type":"string","canBeUsedToMatch":true,"removed":false},{"id":"ESTADO_REP","displayName":"ESTADO_REP","required":false,"defaultMatch":false,"display":true,"type":"string","canBeUsedToMatch":true,"removed":false},{"id":"EMAIL_REP","displayName":"EMAIL_REP","required":false,"defaultMatch":false,"display":true,"type":"string","canBeUsedToMatch":true,"removed":false},{"id":"TELEFONE_REP","displayName":"TELEFONE_REP","required":false,"defaultMatch":false,"display":true,"type":"string","canBeUsedToMatch":true,"removed":false},{"id":"DATA E HORA","displayName":"DATA E HORA","required":false,"defaultMatch":false,"display":true,"type":"string","canBeUsedToMatch":true,"removed":false},{"id":"SOFTWARE","displayName":"SOFTWARE","required":false,"defaultMatch":false,"display":true,"type":"string","canBeUsedToMatch":true,"removed":false},{"id":"TOTAL DE CRÉDITO","displayName":"TOTAL DE CRÉDITO","required":false,"defaultMatch":false,"display":true,"type":"string","canBeUsedToMatch":true,"removed":false},{"id":"TIPO DE CRÉDITO","displayName":"TIPO DE CRÉDITO","required":false,"defaultMatch":false,"display":true,"type":"string","canBeUsedToMatch":true,"removed":false},{"id":"VENDEDOR","displayName":"VENDEDOR","required":false,"defaultMatch":false,"display":true,"type":"string","canBeUsedToMatch":true,"removed":false},{"id":"PREÇO","displayName":"PREÇO","required":false,"defaultMatch":false,"display":true,"type":"string","canBeUsedToMatch":true,"removed":false}],"attemptToConvertTypes":false,"convertFieldsToString":false},"options":{}},"type":"n8n-nodes-base.googleSheets","typeVersion":4.7,"position":[80,352],"id":"9b2432ea-d0f9-4084-b12d-da970785bb14","name":"Append row in sheet1","credentials":{"googleSheetsOAuth2Api":{"id":"6TVIGfPIghjLjfhr","name":"VRA - CADASTRO USUARIOS"}},"onError":"continueErrorOutput"},{"parameters":{"rules":{"values":[{"conditions":{"options":{"caseSensitive":true,"leftValue":"","typeValidation":"strict","version":2},"conditions":[{"leftValue":"={{ $json.Software }}","rightValue":"CLOUD PHOTORF","operator":{"type":"string","operation":"equals"},"id":"c294f0dd-0180-45f3-bfdc-a6162149d3d4"}],"combinator":"and"}},{"conditions":{"options":{"caseSensitive":true,"leftValue":"","typeValidation":"strict","version":2},"conditions":[{"id":"46d44a44-44d8-4b93-9a97-f00a46205b02","leftValue":"={{ $json.Software }}","rightValue":"FASTALBUM","operator":{"type":"string","operation":"equals","name":"filter.operator.equals"}}],"combinator":"and"}},{"conditions":{"options":{"caseSensitive":true,"leftValue":"","typeValidation":"strict","version":2},"conditions":[{"id":"920fc7f9-33e8-45b6-a402-6695fb99d7ec","leftValue":"={{ $json.Software }}","rightValue":"PHOTO DRIVE","operator":{"type":"string","operation":"equals","name":"filter.operator.equals"}}],"combinator":"and"}},{"conditions":{"options":{"caseSensitive":true,"leftValue":"","typeValidation":"strict","version":2},"conditions":[{"id":"18cd5db1-f789-46e2-a7e8-f583f705cd48","leftValue":"={{ $json.Software }}","rightValue":"E-PHOTORF","operator":{"type":"string","operation":"equals","name":"filter.operator.equals"}}],"combinator":"and"}},{"conditions":{"options":{"caseSensitive":true,"leftValue":"","typeValidation":"strict","version":2},"conditions":[{"id":"4b25dc63-d7e5-4001-b3d4-5fb24e46609f","leftValue":"={{ $json.Software }}","rightValue":"CHECKOUT PHOTORF","operator":{"type":"string","operation":"equals","name":"filter.operator.equals"}}],"combinator":"and"}}]},"options":{}},"type":"n8n-nodes-base.switch","typeVersion":3.3,"position":[704,176],"id":"ba14b4f0-8b71-4023-8458-1d49cfe9c99b","name":"Switch"},{"parameters":{"method":"POST","url":"https://services.leadconnectorhq.com/hooks/W7PGxpfbsFaEEUoQOtUb/webhook-trigger/67173ce7-5b85-41a7-be6b-6fd23450fe0f","sendBody":true,"specifyBody":"json","jsonBody":"={\n \"firstName\": \"{{ $json.Nome.split(' ')[0] }}\",\n \"lastName\": \"{{ $json.Nome.split(' ').slice(1).join(' ') }}\",\n \"email\": \"{{ $json.Email }}\",\n \"phone\": \"{{ $json.Telefon.replace(/[^0-9]/g, '').length === 11 ? '+55' + $json.Telefon.replace(/[^0-9]/g, '') : $json.Telefon }}\",\n \"companyName\": \"{{ $json.Empresa }}\",\n \"software\": \"{{ $json.Software }}\",\n \"tipoCredito\": \"{{ $json['Tipo de crédito'] }}\",\n \"tag\": \"{{ $json.tag }}\"\n}","options":{}},"type":"n8n-nodes-base.httpRequest","typeVersion":4.3,"position":[1312,-208],"id":"145d91b7-d217-4352-b7ab-ec4ab2cf1913","name":"Cloud PhotoRf"},{"parameters":{"method":"POST","url":"https://services.leadconnectorhq.com/hooks/W7PGxpfbsFaEEUoQOtUb/webhook-trigger/jZLaAHiYuQfYRlWnvm02","sendBody":true,"specifyBody":"json","jsonBody":"={\n \"firstName\": \"{{ $json.Nome.split(' ')[0] }}\",\n \"lastName\": \"{{ $json.Nome.split(' ').slice(1).join(' ') }}\",\n \"email\": \"{{ $json.Email }}\",\n \"phone\": \"{{ $json.Telefon.replace(/[^0-9]/g, '').length === 11 ? '+55' + $json.Telefon.replace(/[^0-9]/g, '') : $json.Telefon }}\",\n \"companyName\": \"{{ $json.Empresa }}\",\n \"software\": \"{{ $json.Software }}\",\n \"tipoCredito\": \"{{ $json['Tipo de crédito'] }}\",\n \"tag\": \"{{ $json.tag }}\"\n}","options":{}},"type":"n8n-nodes-base.httpRequest","typeVersion":4.3,"position":[1312,144],"id":"a1a598a7-c121-47ef-9694-4b4986ade720","name":"Fast Album"},{"parameters":{"method":"POST","url":"https://services.leadconnectorhq.com/hooks/W7PGxpfbsFaEEUoQOtUb/webhook-trigger/L3hnryrDfkGV4Qad7TmX","sendBody":true,"specifyBody":"json","jsonBody":"={\n \"firstName\": \"{{ $json.Nome.split(' ')[0] }}\",\n \"lastName\": \"{{ $json.Nome.split(' ').slice(1).join(' ') }}\",\n \"email\": \"{{ $json.Email }}\",\n \"phone\": \"{{ $json.Telefon.replace(/[^0-9]/g, '').length === 11 ? '+55' + $json.Telefon.replace(/[^0-9]/g, '') : $json.Telefon }}\",\n \"companyName\": \"{{ $json.Empresa }}\",\n \"software\": \"{{ $json.Software }}\",\n \"tipoCredito\": \"{{ $json['Tipo de crédito'] }}\",\n \"tag\": \"{{ $json.tag }}\"\n}","options":{}},"type":"n8n-nodes-base.httpRequest","typeVersion":4.3,"position":[1312,432],"id":"df176781-5767-4431-aead-257e185600e6","name":"Photo Drive"},{"parameters":{"method":"POST","url":"https://services.leadconnectorhq.com/hooks/W7PGxpfbsFaEEUoQOtUb/webhook-trigger/CArJ6aJnMyWMqoEfafEY","sendBody":true,"specifyBody":"json","jsonBody":"={\n \"firstName\": \"{{ $json.Nome.split(' ')[0] }}\",\n \"lastName\": \"{{ $json.Nome.split(' ').slice(1).join(' ') }}\",\n \"email\": \"{{ $json.Email }}\",\n \"phone\": \"{{ $json.Telefon.replace(/[^0-9]/g, '').length === 11 ? '+55' + $json.Telefon.replace(/[^0-9]/g, '') : $json.Telefon }}\",\n \"companyName\": \"{{ $json.Empresa }}\",\n \"software\": \"{{ $json.Software }}\",\n \"tipoCredito\": \"{{ $json['Tipo de crédito'] }}\",\n \"tag\": \"{{ $json.tag }}\"\n}","options":{}},"type":"n8n-nodes-base.httpRequest","typeVersion":4.3,"position":[1328,752],"id":"e94f3fac-ca8b-4cd4-aa57-b0f52232945a","name":"E-PhotoRf"},{"parameters":{"method":"POST","url":"https://services.leadconnectorhq.com/hooks/W7PGxpfbsFaEEUoQOtUb/webhook-trigger/olggbUnO2yz5sTksXgwY","sendBody":true,"specifyBody":"json","jsonBody":"={\n \"firstName\": \"{{ $json.Nome.split(' ')[0] }}\",\n \"lastName\": \"{{ $json.Nome.split(' ').slice(1).join(' ') }}\",\n \"email\": \"{{ $json.Email }}\",\n \"phone\": \"{{ $json.Telefon.replace(/[^0-9]/g, '').length === 11 ? '+55' + $json.Telefon.replace(/[^0-9]/g, '') : $json.Telefon }}\",\n \"companyName\": \"{{ $json.Empresa }}\",\n \"software\": \"{{ $json.Software }}\",\n \"tipoCredito\": \"{{ $json['Tipo de crédito'] }}\",\n \"tag\": \"{{ $json.tag }}\"\n}","options":{}},"type":"n8n-nodes-base.httpRequest","typeVersion":4.3,"position":[1072,976],"id":"f0bb4f07-184d-4b3c-9a10-2d501a08ef7a","name":"Checkout PhotoRf"},{"parameters":{"assignments":{"assignments":[{"id":"dfc306b1-e212-4e17-b8ff-7aff85085655","name":"Tag","value":"={{ $json['Tipo de crédito'] === 'PERÍODO DE TESTE' ? 'trial' : 'comprou' }}","type":"string"}]},"includeOtherFields":true,"options":{}},"type":"n8n-nodes-base.set","typeVersion":3.4,"position":[528,336],"id":"bd755522-5d50-4b8b-855e-63fb43ff5da5","name":"Set tag"},{"parameters":{"assignments":{"assignments":[{"id":"50079c22-fd07-4b72-9e5e-5aa64abcff64","name":"Nome","value":"={{ $json.NOME_COMPLETO_REP }}","type":"string"},{"id":"13bbc0d6-9231-4374-b238-a3d18f1f0823","name":"Telefon","value":"={{ $json.TELEFONE_REP }}","type":"string"},{"id":"cf57c9a2-e404-48e2-abd3-923ef925bcb9","name":"Email","value":"={{ $json.EMAIL_REP }}","type":"string"},{"id":"d447094f-5632-46e3-8c88-3e37ecdd5406","name":"Software","value":"={{ $json.SOFTWARE }}","type":"string"},{"id":"9c65620a-aefd-4441-a40e-39a62f7db02d","name":"Tipo de crédito","value":"={{ $json['TIPO DE CRÉDITO'] }}","type":"string"},{"id":"0fd3e205-9e07-4186-b796-850a13770c76","name":"Empresa","value":"={{ $json.RAZAO_SOCIAL }}","type":"string"}]},"options":{}},"type":"n8n-nodes-base.set","typeVersion":3.4,"position":[352,176],"id":"b3f9bcf4-55a6-4e9b-9c1c-35a41464a536","name":"Dados"},{"parameters":{"conditions":{"options":{"caseSensitive":true,"leftValue":"","typeValidation":"strict","version":2},"conditions":[{"id":"42280267-fad4-44cf-8e29-1b26e5ca2577","leftValue":"tag","rightValue":"trial","operator":{"type":"string","operation":"equals","name":"filter.operator.equals"}}],"combinator":"and"},"options":{}},"type":"n8n-nodes-base.if","typeVersion":2.2,"position":[1040,-288],"id":"cdd2a370-b7a6-4e23-a59e-39cfb0a5468f","name":"trial?"},{"parameters":{"conditions":{"options":{"caseSensitive":true,"leftValue":"","typeValidation":"strict","version":2},"conditions":[{"id":"42280267-fad4-44cf-8e29-1b26e5ca2577","leftValue":"tag","rightValue":"trial","operator":{"type":"string","operation":"equals","name":"filter.operator.equals"}}],"combinator":"and"},"options":{}},"type":"n8n-nodes-base.if","typeVersion":2.2,"position":[1024,0],"id":"53f61e0a-d275-4922-82d8-be4ca9833dc8","name":"trial?1"},{"parameters":{"conditions":{"options":{"caseSensitive":true,"leftValue":"","typeValidation":"strict","version":2},"conditions":[{"id":"42280267-fad4-44cf-8e29-1b26e5ca2577","leftValue":"tag","rightValue":"trial","operator":{"type":"string","operation":"equals","name":"filter.operator.equals"}}],"combinator":"and"},"options":{}},"type":"n8n-nodes-base.if","typeVersion":2.2,"position":[1024,288],"id":"880255e0-e553-410b-8f02-ee79907a4f52","name":"trial?2"},{"parameters":{"conditions":{"options":{"caseSensitive":true,"leftValue":"","typeValidation":"strict","version":2},"conditions":[{"id":"42280267-fad4-44cf-8e29-1b26e5ca2577","leftValue":"tag","rightValue":"trial","operator":{"type":"string","operation":"equals","name":"filter.operator.equals"}}],"combinator":"and"},"options":{}},"type":"n8n-nodes-base.if","typeVersion":2.2,"position":[1024,544],"id":"ecf162fd-1ab9-4d5b-b6ca-9feb28d62c6c","name":"trial?3"},{"parameters":{"conditions":{"options":{"caseSensitive":true,"leftValue":"","typeValidation":"strict","version":2},"conditions":[{"id":"42280267-fad4-44cf-8e29-1b26e5ca2577","leftValue":"tag","rightValue":"trial","operator":{"type":"string","operation":"equals","name":"filter.operator.equals"}}],"combinator":"and"},"options":{}},"type":"n8n-nodes-base.if","typeVersion":2.2,"position":[896,752],"id":"511b9756-c120-47cc-8e31-555e3cf09ddb","name":"trial?4"},{"id":"8716138f-57ee-4233-87e6-5a4d29c30034","name":"Linkia Tag Cloud","type":"n8n-nodes-base.httpRequest","typeVersion":4.2,"position":[1520,-128],"parameters":{"method":"POST","url":"https://services.leadconnectorhq.com/contacts/upsert","sendHeaders":true,"headerParameters":{"parameters":[{"name":"Authorization","value":"Bearer [REDACTED_GHL_PIT]"},{"name":"Version","value":"2021-07-28"},{"name":"Content-Type","value":"application/json"}]},"sendBody":true,"specifyBody":"json","jsonBody":"={\n \"locationId\": \"W7PGxpfbsFaEEUoQOtUb\",\n \"email\": \"{{ $json.Email }}\",\n \"phone\": \"{{ $json.Telefon.replace(/[^0-9]/g, '').length === 11 ? '+55' + $json.Telefon.replace(/[^0-9]/g, '') : $json.Telefon }}\",\n \"firstName\": \"{{ $json.Nome.split(' ')[0] }}\",\n \"lastName\": \"{{ $json.Nome.split(' ').slice(1).join(' ') }}\",\n \"tags\": [\"comprou-claud-photorf\"],\n \"customFields\": [\n { \"key\": \"software_comprado\", \"field_value\": \"{{ $json.Software }}\" }\n ]\n}","options":{}},"onError":"continueRegularOutput"},{"id":"e6900008-f9b0-41fd-b761-4691e57bd1f6","name":"CAPI Cloud","type":"n8n-nodes-base.httpRequest","typeVersion":4.2,"position":[1760,-128],"parameters":{"method":"POST","url":"https://track-capi-px3.agentesclimb.us/purchase","sendHeaders":true,"headerParameters":{"parameters":[{"name":"Content-Type","value":"application/json"}]},"sendBody":true,"specifyBody":"json","jsonBody":"={\n \"email\": \"{{ $json.Email }}\",\n \"phone\": \"{{ $json.Telefon.replace(/[^0-9]/g, '') }}\",\n \"first_name\": \"{{ $json.Nome.split(' ')[0] }}\",\n \"last_name\": \"{{ $json.Nome.split(' ').slice(1).join(' ') }}\",\n \"city\": \"{{ $('PLANILHA DE VENDAS').item.json.body.REPRESENTANTE.CIDADE }}\",\n \"state\": \"{{ $('PLANILHA DE VENDAS').item.json.body.REPRESENTANTE.ESTADO }}\",\n \"zip\": \"{{ $('PLANILHA DE VENDAS').item.json.body.REPRESENTANTE.CEP }}\",\n \"country\": \"BR\",\n \"value\": {{ Number($('PLANILHA DE VENDAS').item.json.body.DADOS_VENDA['PREÇO']) * Number($('PLANILHA DE VENDAS').item.json.body.DADOS_VENDA.TOTAL_DE_CREDITO) }},\n \"currency\": \"BRL\",\n \"content_name\": \"{{ $json.Software }}\",\n \"content_ids\": [\"{{ $json.Software }}\"],\n \"num_items\": {{ Number($('PLANILHA DE VENDAS').item.json.body.DADOS_VENDA.TOTAL_DE_CREDITO) }},\n \"event_id\": \"vra-{{ $execution.id }}\"\n}","options":{}},"onError":"continueRegularOutput"},{"id":"ba151b24-db54-4e43-a7af-8e7ffdfbdd98","name":"Linkia Tag Fast","type":"n8n-nodes-base.httpRequest","typeVersion":4.2,"position":[1504,160],"parameters":{"method":"POST","url":"https://services.leadconnectorhq.com/contacts/upsert","sendHeaders":true,"headerParameters":{"parameters":[{"name":"Authorization","value":"Bearer [REDACTED_GHL_PIT]"},{"name":"Version","value":"2021-07-28"},{"name":"Content-Type","value":"application/json"}]},"sendBody":true,"specifyBody":"json","jsonBody":"={\n \"locationId\": \"W7PGxpfbsFaEEUoQOtUb\",\n \"email\": \"{{ $json.Email }}\",\n \"phone\": \"{{ $json.Telefon.replace(/[^0-9]/g, '').length === 11 ? '+55' + $json.Telefon.replace(/[^0-9]/g, '') : $json.Telefon }}\",\n \"firstName\": \"{{ $json.Nome.split(' ')[0] }}\",\n \"lastName\": \"{{ $json.Nome.split(' ').slice(1).join(' ') }}\",\n \"tags\": [\"comprou-fast-album\"],\n \"customFields\": [\n { \"key\": \"software_comprado\", \"field_value\": \"{{ $json.Software }}\" }\n ]\n}","options":{}},"onError":"continueRegularOutput"},{"id":"5108f0f7-a89c-43b4-a13f-eb93167d9e44","name":"CAPI Fast","type":"n8n-nodes-base.httpRequest","typeVersion":4.2,"position":[1744,160],"parameters":{"method":"POST","url":"https://track-capi-px3.agentesclimb.us/purchase","sendHeaders":true,"headerParameters":{"parameters":[{"name":"Content-Type","value":"application/json"}]},"sendBody":true,"specifyBody":"json","jsonBody":"={\n \"email\": \"{{ $json.Email }}\",\n \"phone\": \"{{ $json.Telefon.replace(/[^0-9]/g, '') }}\",\n \"first_name\": \"{{ $json.Nome.split(' ')[0] }}\",\n \"last_name\": \"{{ $json.Nome.split(' ').slice(1).join(' ') }}\",\n \"city\": \"{{ $('PLANILHA DE VENDAS').item.json.body.REPRESENTANTE.CIDADE }}\",\n \"state\": \"{{ $('PLANILHA DE VENDAS').item.json.body.REPRESENTANTE.ESTADO }}\",\n \"zip\": \"{{ $('PLANILHA DE VENDAS').item.json.body.REPRESENTANTE.CEP }}\",\n \"country\": \"BR\",\n \"value\": {{ Number($('PLANILHA DE VENDAS').item.json.body.DADOS_VENDA['PREÇO']) * Number($('PLANILHA DE VENDAS').item.json.body.DADOS_VENDA.TOTAL_DE_CREDITO) }},\n \"currency\": \"BRL\",\n \"content_name\": \"{{ $json.Software }}\",\n \"content_ids\": [\"{{ $json.Software }}\"],\n \"num_items\": {{ Number($('PLANILHA DE VENDAS').item.json.body.DADOS_VENDA.TOTAL_DE_CREDITO) }},\n \"event_id\": \"vra-{{ $execution.id }}\"\n}","options":{}},"onError":"continueRegularOutput"},{"id":"2368e16f-93dc-481f-b543-a5cbadf62602","name":"Linkia Tag Drive","type":"n8n-nodes-base.httpRequest","typeVersion":4.2,"position":[1504,448],"parameters":{"method":"POST","url":"https://services.leadconnectorhq.com/contacts/upsert","sendHeaders":true,"headerParameters":{"parameters":[{"name":"Authorization","value":"Bearer [REDACTED_GHL_PIT]"},{"name":"Version","value":"2021-07-28"},{"name":"Content-Type","value":"application/json"}]},"sendBody":true,"specifyBody":"json","jsonBody":"={\n \"locationId\": \"W7PGxpfbsFaEEUoQOtUb\",\n \"email\": \"{{ $json.Email }}\",\n \"phone\": \"{{ $json.Telefon.replace(/[^0-9]/g, '').length === 11 ? '+55' + $json.Telefon.replace(/[^0-9]/g, '') : $json.Telefon }}\",\n \"firstName\": \"{{ $json.Nome.split(' ')[0] }}\",\n \"lastName\": \"{{ $json.Nome.split(' ').slice(1).join(' ') }}\",\n \"tags\": [\"comprou-photo-drive\"],\n \"customFields\": [\n { \"key\": \"software_comprado\", \"field_value\": \"{{ $json.Software }}\" }\n ]\n}","options":{}},"onError":"continueRegularOutput"},{"id":"b72d622e-12f9-41bd-8299-a0aea8abb882","name":"CAPI Drive","type":"n8n-nodes-base.httpRequest","typeVersion":4.2,"position":[1744,448],"parameters":{"method":"POST","url":"https://track-capi-px3.agentesclimb.us/purchase","sendHeaders":true,"headerParameters":{"parameters":[{"name":"Content-Type","value":"application/json"}]},"sendBody":true,"specifyBody":"json","jsonBody":"={\n \"email\": \"{{ $json.Email }}\",\n \"phone\": \"{{ $json.Telefon.replace(/[^0-9]/g, '') }}\",\n \"first_name\": \"{{ $json.Nome.split(' ')[0] }}\",\n \"last_name\": \"{{ $json.Nome.split(' ').slice(1).join(' ') }}\",\n \"city\": \"{{ $('PLANILHA DE VENDAS').item.json.body.REPRESENTANTE.CIDADE }}\",\n \"state\": \"{{ $('PLANILHA DE VENDAS').item.json.body.REPRESENTANTE.ESTADO }}\",\n \"zip\": \"{{ $('PLANILHA DE VENDAS').item.json.body.REPRESENTANTE.CEP }}\",\n \"country\": \"BR\",\n \"value\": {{ Number($('PLANILHA DE VENDAS').item.json.body.DADOS_VENDA['PREÇO']) * Number($('PLANILHA DE VENDAS').item.json.body.DADOS_VENDA.TOTAL_DE_CREDITO) }},\n \"currency\": \"BRL\",\n \"content_name\": \"{{ $json.Software }}\",\n \"content_ids\": [\"{{ $json.Software }}\"],\n \"num_items\": {{ Number($('PLANILHA DE VENDAS').item.json.body.DADOS_VENDA.TOTAL_DE_CREDITO) }},\n \"event_id\": \"vra-{{ $execution.id }}\"\n}","options":{}},"onError":"continueRegularOutput"},{"id":"717f3077-1cc9-41c0-bd8b-aeb16a2447e3","name":"Linkia Tag EPhoto","type":"n8n-nodes-base.httpRequest","typeVersion":4.2,"position":[1504,704],"parameters":{"method":"POST","url":"https://services.leadconnectorhq.com/contacts/upsert","sendHeaders":true,"headerParameters":{"parameters":[{"name":"Authorization","value":"Bearer [REDACTED_GHL_PIT]"},{"name":"Version","value":"2021-07-28"},{"name":"Content-Type","value":"application/json"}]},"sendBody":true,"specifyBody":"json","jsonBody":"={\n \"locationId\": \"W7PGxpfbsFaEEUoQOtUb\",\n \"email\": \"{{ $json.Email }}\",\n \"phone\": \"{{ $json.Telefon.replace(/[^0-9]/g, '').length === 11 ? '+55' + $json.Telefon.replace(/[^0-9]/g, '') : $json.Telefon }}\",\n \"firstName\": \"{{ $json.Nome.split(' ')[0] }}\",\n \"lastName\": \"{{ $json.Nome.split(' ').slice(1).join(' ') }}\",\n \"tags\": [\"comprou-e-photorf\"],\n \"customFields\": [\n { \"key\": \"software_comprado\", \"field_value\": \"{{ $json.Software }}\" }\n ]\n}","options":{}},"onError":"continueRegularOutput"},{"id":"08634f82-e9c6-4fa6-b01f-fdea84f2a531","name":"CAPI EPhoto","type":"n8n-nodes-base.httpRequest","typeVersion":4.2,"position":[1744,704],"parameters":{"method":"POST","url":"https://track-capi-px3.agentesclimb.us/purchase","sendHeaders":true,"headerParameters":{"parameters":[{"name":"Content-Type","value":"application/json"}]},"sendBody":true,"specifyBody":"json","jsonBody":"={\n \"email\": \"{{ $json.Email }}\",\n \"phone\": \"{{ $json.Telefon.replace(/[^0-9]/g, '') }}\",\n \"first_name\": \"{{ $json.Nome.split(' ')[0] }}\",\n \"last_name\": \"{{ $json.Nome.split(' ').slice(1).join(' ') }}\",\n \"city\": \"{{ $('PLANILHA DE VENDAS').item.json.body.REPRESENTANTE.CIDADE }}\",\n \"state\": \"{{ $('PLANILHA DE VENDAS').item.json.body.REPRESENTANTE.ESTADO }}\",\n \"zip\": \"{{ $('PLANILHA DE VENDAS').item.json.body.REPRESENTANTE.CEP }}\",\n \"country\": \"BR\",\n \"value\": {{ Number($('PLANILHA DE VENDAS').item.json.body.DADOS_VENDA['PREÇO']) * Number($('PLANILHA DE VENDAS').item.json.body.DADOS_VENDA.TOTAL_DE_CREDITO) }},\n \"currency\": \"BRL\",\n \"content_name\": \"{{ $json.Software }}\",\n \"content_ids\": [\"{{ $json.Software }}\"],\n \"num_items\": {{ Number($('PLANILHA DE VENDAS').item.json.body.DADOS_VENDA.TOTAL_DE_CREDITO) }},\n \"event_id\": \"vra-{{ $execution.id }}\"\n}","options":{}},"onError":"continueRegularOutput"},{"id":"8c22418f-0338-4357-ad2a-69381e0ad454","name":"Linkia Tag Checkout","type":"n8n-nodes-base.httpRequest","typeVersion":4.2,"position":[1376,912],"parameters":{"method":"POST","url":"https://services.leadconnectorhq.com/contacts/upsert","sendHeaders":true,"headerParameters":{"parameters":[{"name":"Authorization","value":"Bearer [REDACTED_GHL_PIT]"},{"name":"Version","value":"2021-07-28"},{"name":"Content-Type","value":"application/json"}]},"sendBody":true,"specifyBody":"json","jsonBody":"={\n \"locationId\": \"W7PGxpfbsFaEEUoQOtUb\",\n \"email\": \"{{ $json.Email }}\",\n \"phone\": \"{{ $json.Telefon.replace(/[^0-9]/g, '').length === 11 ? '+55' + $json.Telefon.replace(/[^0-9]/g, '') : $json.Telefon }}\",\n \"firstName\": \"{{ $json.Nome.split(' ')[0] }}\",\n \"lastName\": \"{{ $json.Nome.split(' ').slice(1).join(' ') }}\",\n \"tags\": [\"comprou-checkout-photorf\"],\n \"customFields\": [\n { \"key\": \"software_comprado\", \"field_value\": \"{{ $json.Software }}\" }\n ]\n}","options":{}},"onError":"continueRegularOutput"},{"id":"d090004e-7111-466e-9639-1462fcfa276d","name":"CAPI Checkout","type":"n8n-nodes-base.httpRequest","typeVersion":4.2,"position":[1616,912],"parameters":{"method":"POST","url":"https://track-capi-px3.agentesclimb.us/purchase","sendHeaders":true,"headerParameters":{"parameters":[{"name":"Content-Type","value":"application/json"}]},"sendBody":true,"specifyBody":"json","jsonBody":"={\n \"email\": \"{{ $json.Email }}\",\n \"phone\": \"{{ $json.Telefon.replace(/[^0-9]/g, '') }}\",\n \"first_name\": \"{{ $json.Nome.split(' ')[0] }}\",\n \"last_name\": \"{{ $json.Nome.split(' ').slice(1).join(' ') }}\",\n \"city\": \"{{ $('PLANILHA DE VENDAS').item.json.body.REPRESENTANTE.CIDADE }}\",\n \"state\": \"{{ $('PLANILHA DE VENDAS').item.json.body.REPRESENTANTE.ESTADO }}\",\n \"zip\": \"{{ $('PLANILHA DE VENDAS').item.json.body.REPRESENTANTE.CEP }}\",\n \"country\": \"BR\",\n \"value\": {{ Number($('PLANILHA DE VENDAS').item.json.body.DADOS_VENDA['PREÇO']) * Number($('PLANILHA DE VENDAS').item.json.body.DADOS_VENDA.TOTAL_DE_CREDITO) }},\n \"currency\": \"BRL\",\n \"content_name\": \"{{ $json.Software }}\",\n \"content_ids\": [\"{{ $json.Software }}\"],\n \"num_items\": {{ Number($('PLANILHA DE VENDAS').item.json.body.DADOS_VENDA.TOTAL_DE_CREDITO) }},\n \"event_id\": \"vra-{{ $execution.id }}\"\n}","options":{}},"onError":"continueRegularOutput"}],"connections":{"CADASTRO DE CLIENTES":{"main":[[{"node":"Append row in sheet","type":"main","index":0}]]},"PLANILHA DE VENDAS":{"main":[[{"node":"Append row in sheet1","type":"main","index":0}]]},"Append row in sheet":{"main":[[]]},"Append row in sheet1":{"main":[[{"node":"Dados","type":"main","index":0}]]},"Switch":{"main":[[{"node":"trial?","type":"main","index":0}],[{"node":"trial?1","type":"main","index":0}],[{"node":"trial?2","type":"main","index":0}],[{"node":"trial?3","type":"main","index":0}],[{"node":"trial?4","type":"main","index":0}]]},"Set tag":{"main":[[{"node":"Switch","type":"main","index":0}]]},"Dados":{"main":[[{"node":"Set tag","type":"main","index":0}]]},"trial?":{"main":[[],[{"node":"Cloud PhotoRf","type":"main","index":0},{"node":"Linkia Tag Cloud","type":"main","index":0}]]},"trial?1":{"main":[[],[{"node":"Fast Album","type":"main","index":0},{"node":"Linkia Tag Fast","type":"main","index":0}]]},"trial?2":{"main":[[],[{"node":"Photo Drive","type":"main","index":0},{"node":"Linkia Tag Drive","type":"main","index":0}]]},"trial?3":{"main":[[],[{"node":"E-PhotoRf","type":"main","index":0},{"node":"Linkia Tag EPhoto","type":"main","index":0}]]},"trial?4":{"main":[[],[{"node":"Checkout PhotoRf","type":"main","index":0},{"node":"Linkia Tag Checkout","type":"main","index":0}]]},"Linkia Tag Cloud":{"main":[[{"node":"CAPI Cloud","type":"main","index":0}]]},"CAPI Cloud":{"main":[[]]},"Linkia Tag Fast":{"main":[[{"node":"CAPI Fast","type":"main","index":0}]]},"CAPI Fast":{"main":[[]]},"Linkia Tag Drive":{"main":[[{"node":"CAPI Drive","type":"main","index":0}]]},"CAPI Drive":{"main":[[]]},"Linkia Tag EPhoto":{"main":[[{"node":"CAPI EPhoto","type":"main","index":0}]]},"CAPI EPhoto":{"main":[[]]},"Linkia Tag Checkout":{"main":[[{"node":"CAPI Checkout","type":"main","index":0}]]},"CAPI Checkout":{"main":[[]]}},"settings":{"executionOrder":"v1"},"staticData":null,"meta":{"templateCredsSetupCompleted":true},"nodeGroups":[],"pinData":{"PLANILHA DE VENDAS":[{"json":{"headers":{"host":"webhook.app.px3lab.com.br","user-agent":"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/124.0.0.0 Safari/537.36","content-length":"703","accept":"*/*","accept-encoding":"deflate, gzip, br","content-type":"application/json","x-forwarded-for":"162.241.61.25","x-forwarded-host":"webhook.app.px3lab.com.br","x-forwarded-port":"443","x-forwarded-proto":"https","x-forwarded-server":"e07a7d861314","x-real-ip":"162.241.61.25"},"params":{},"query":{},"body":{"PESSOA":"FISICA","REPRESENTANTE":{"NOME_COMPLETO":"Thiago Oliveira Alves","CPF":"44300871809","RG":"552411838","E-MAIL":"thiagoolialvess@gmail.com","TELEFONE":"+5517997778588","CEP":"15084-110","RUA":"Rua Independência","NUMERO":"4412","COMPLEMENTO":"Studio Pintando 7","BAIRRO":"Vila São Joaquim","CIDADE":"São José do Rio Preto","ESTADO":"SP"},"DADOS_VENDA":{"SOFTWARE":"CHECKOUT PHOTORF","TOTAL_DE_CREDITO":"1000","TIPO_DE_DE_CREDITO":"REGULAR","VENDEDOR":"Monique Miranda","PREÇO":"0"}},"webhookUrl":"https://webhook.app.px3lab.com.br/webhook/a0e1aac5-c99d-495f-abd2-7a6da3784093","executionMode":"production"}}]},"versionId":"ea99f622-a817-4748-804a-5546cabe8f95","activeVersionId":"ea99f622-a817-4748-804a-5546cabe8f95","versionCounter":115,"triggerCount":2,"sourceWorkflowId":null,"shared":[{"updatedAt":"2026-04-16T20:09:08.538Z","createdAt":"2026-04-16T20:09:08.538Z","role":"workflow:owner","workflowId":"QcJuvqhV98vIYtA6","projectId":"bBDdfx0jJUQ6r7vy","project":{"updatedAt":"2025-06-18T16:58:42.767Z","createdAt":"2025-06-18T16:53:00.350Z","id":"bBDdfx0jJUQ6r7vy","name":"Vinicius Amaral ","type":"personal","icon":null,"description":null,"customTelemetryTags":[],"creatorId":"ba006ce7-0d34-471b-addf-5e747ca68eaf"}}],"tags":[],"activeVersion":{"updatedAt":"2026-08-24T17:50:01.882Z","createdAt":"2026-08-24T17:50:01.882Z","versionId":"ea99f622-a817-4748-804a-5546cabe8f95","workflowId":"QcJuvqhV98vIYtA6","nodes":[{"parameters":{"operation":"append","documentId":{"__rl":true,"mode":"url","value":"https://docs.google.com/spreadsheets/d/1Y_H8f5_BZs0CoRbDLmvd5nvgmC7lrTg6KZt-zP3miYQ/edit?usp=sharing","__regex":"https:\\/\\/(?:drive|docs)\\.google\\.com(?:\\/.*|)\\/d\\/([0-9a-zA-Z\\-_]+)(?:\\/.*|)"},"sheetName":{"__rl":true,"value":"gid=0","mode":"list","cachedResultName":"CADASTRO","cachedResultUrl":"https://docs.google.com/spreadsheets/d/1Y_H8f5_BZs0CoRbDLmvd5nvgmC7lrTg6KZt-zP3miYQ/edit#gid=0"},"columns":{"mappingMode":"defineBelow","value":{"PESSOA":"={{ $json.body.PESSOA }}","CNPJ":"={{ $json.body.DADOS_DA_EMPRESA.CNPJ }}","RAZAO_SOCIAL":"={{ $json.body.DADOS_DA_EMPRESA.RAZAO_SOCIAL }}","CEP":"={{ $json.body.DADOS_DA_EMPRESA.CEP }}","RUA":"={{ $json.body.DADOS_DA_EMPRESA.RUA }}","NUMERO":"={{ $json.body.DADOS_DA_EMPRESA.NUMERO }}","COMPLEMENTO":"={{ $json.body.DADOS_DA_EMPRESA.COMPLEMENTO }}","BAIRRO":"={{ $json.body.DADOS_DA_EMPRESA.BAIRRO }}","CIDADE":"={{ $json.body.DADOS_DA_EMPRESA.CIDADE }}","ESTADO":"={{ $json.body.DADOS_DA_EMPRESA.ESTADO }}","NOME_COMPLETO_REP":"={{ $json.body.REPRESENTANTE.NOME_COMPLETO }}","CPF_REP":"={{ $json.body.REPRESENTANTE.CPF }}","RG_REP":"={{ $json.body.REPRESENTANTE.RG }}","CEP_REP":"={{ $json.body.REPRESENTANTE.CEP }}","RUA_REP":"={{ $json.body.REPRESENTANTE.RUA }}","NUMERO_REP":"={{ $json.body.REPRESENTANTE.NUMERO }}","COMPLEMENTO_REP":"={{ $json.body.REPRESENTANTE.COMPLEMENTO }}","BAIRRO_REP":"={{ $json.body.REPRESENTANTE.BAIRRO }}","CIDADE_REP":"={{ $json.body.REPRESENTANTE.CIDADE }}","ESTADO_REP":"={{ $json.body.REPRESENTANTE.ESTADO }}","EMAIL_REP":"={{ $json.body.REPRESENTANTE['E-MAIL'] }}","TELEFONE_REP":"={{ $json.body.REPRESENTANTE.TELEFONE }}","DATA E HORA":"={{ $now.setZone('America/Sao_Paulo').toFormat('dd/MM/yyyy HH:mm:ss') }}"},"matchingColumns":[],"schema":[{"id":"DATA E HORA","displayName":"DATA E HORA","required":false,"defaultMatch":false,"display":true,"type":"string","canBeUsedToMatch":true,"removed":false},{"id":"PESSOA","displayName":"PESSOA","required":false,"defaultMatch":false,"display":true,"type":"string","canBeUsedToMatch":true,"removed":false},{"id":"CNPJ","displayName":"CNPJ","required":false,"defaultMatch":false,"display":true,"type":"string","canBeUsedToMatch":true,"removed":false},{"id":"RAZAO_SOCIAL","displayName":"RAZAO_SOCIAL","required":false,"defaultMatch":false,"display":true,"type":"string","canBeUsedToMatch":true,"removed":false},{"id":"CEP","displayName":"CEP","required":false,"defaultMatch":false,"display":true,"type":"string","canBeUsedToMatch":true,"removed":false},{"id":"RUA","displayName":"RUA","required":false,"defaultMatch":false,"display":true,"type":"string","canBeUsedToMatch":true,"removed":false},{"id":"NUMERO","displayName":"NUMERO","required":false,"defaultMatch":false,"display":true,"type":"string","canBeUsedToMatch":true,"removed":false},{"id":"COMPLEMENTO","displayName":"COMPLEMENTO","required":false,"defaultMatch":false,"display":true,"type":"string","canBeUsedToMatch":true,"removed":false},{"id":"BAIRRO","displayName":"BAIRRO","required":false,"defaultMatch":false,"display":true,"type":"string","canBeUsedToMatch":true,"removed":false},{"id":"CIDADE","displayName":"CIDADE","required":false,"defaultMatch":false,"display":true,"type":"string","canBeUsedToMatch":true,"removed":false},{"id":"ESTADO","displayName":"ESTADO","required":false,"defaultMatch":false,"display":true,"type":"string","canBeUsedToMatch":true,"removed":false},{"id":"NOME_COMPLETO_REP","displayName":"NOME_COMPLETO_REP","required":false,"defaultMatch":false,"display":true,"type":"string","canBeUsedToMatch":true,"removed":false},{"id":"CPF_REP","displayName":"CPF_REP","required":false,"defaultMatch":false,"display":true,"type":"string","canBeUsedToMatch":true,"removed":false},{"id":"RG_REP","displayName":"RG_REP","required":false,"defaultMatch":false,"display":true,"type":"string","canBeUsedToMatch":true,"removed":false},{"id":"CEP_REP","displayName":"CEP_REP","required":false,"defaultMatch":false,"display":true,"type":"string","canBeUsedToMatch":true,"removed":false},{"id":"RUA_REP","displayName":"RUA_REP","required":false,"defaultMatch":false,"display":true,"type":"string","canBeUsedToMatch":true,"removed":false},{"id":"NUMERO_REP","displayName":"NUMERO_REP","required":false,"defaultMatch":false,"display":true,"type":"string","canBeUsedToMatch":true,"removed":false},{"id":"COMPLEMENTO_REP","displayName":"COMPLEMENTO_REP","required":false,"defaultMatch":false,"display":true,"type":"string","canBeUsedToMatch":true,"removed":false},{"id":"BAIRRO_REP","displayName":"BAIRRO_REP","required":false,"defaultMatch":false,"display":true,"type":"string","canBeUsedToMatch":true,"removed":false},{"id":"CIDADE_REP","displayName":"CIDADE_REP","required":false,"defaultMatch":false,"display":true,"type":"string","canBeUsedToMatch":true,"removed":false},{"id":"ESTADO_REP","displayName":"ESTADO_REP","required":false,"defaultMatch":false,"display":true,"type":"string","canBeUsedToMatch":true,"removed":false},{"id":"EMAIL_REP","displayName":"EMAIL_REP","required":false,"defaultMatch":false,"display":true,"type":"string","canBeUsedToMatch":true,"removed":false},{"id":"TELEFONE_REP","displayName":"TELEFONE_REP","required":false,"defaultMatch":false,"display":true,"type":"string","canBeUsedToMatch":true,"removed":false}],"attemptToConvertTypes":false,"convertFieldsToString":false},"options":{}},"type":"n8n-nodes-base.googleSheets","typeVersion":4.7,"position":[448,-240],"id":"e3789810-ec89-4b6a-a8cc-33d101deec82","name":"Append row in sheet","credentials":{"googleSheetsOAuth2Api":{"id":"6TVIGfPIghjLjfhr","name":"VRA - CADASTRO USUARIOS"}},"onError":"continueErrorOutput"},{"parameters":{"httpMethod":"POST","path":"5230b458-f2b1-4e7a-9216-c709fe28b9ff","options":{"rawBody":true,"responseData":"200 OK"}},"type":"n8n-nodes-base.webhook","typeVersion":2.1,"position":[240,-240],"id":"0526f2cc-0b40-41a5-9026-dd8436f695eb","name":"CADASTRO DE CLIENTES","webhookId":"5230b458-f2b1-4e7a-9216-c709fe28b9ff"},{"parameters":{"httpMethod":"POST","path":"a0e1aac5-c99d-495f-abd2-7a6da3784093","options":{"responseData":"200 OK"}},"type":"n8n-nodes-base.webhook","typeVersion":2.1,"position":[-96,176],"id":"21cda2fd-2c53-4525-8b4a-2107b349e5e7","name":"PLANILHA DE VENDAS","webhookId":"a0e1aac5-c99d-495f-abd2-7a6da3784093","onError":"continueRegularOutput"},{"parameters":{"operation":"append","documentId":{"__rl":true,"mode":"url","value":"https://docs.google.com/spreadsheets/d/1Y_H8f5_BZs0CoRbDLmvd5nvgmC7lrTg6KZt-zP3miYQ/edit?usp=sharing","__regex":"https:\\/\\/(?:drive|docs)\\.google\\.com(?:\\/.*|)\\/d\\/([0-9a-zA-Z\\-_]+)(?:\\/.*|)"},"sheetName":{"__rl":true,"value":46089070,"mode":"list","cachedResultName":"VENDAS","cachedResultUrl":"https://docs.google.com/spreadsheets/d/1Y_H8f5_BZs0CoRbDLmvd5nvgmC7lrTg6KZt-zP3miYQ/edit#gid=46089070"},"columns":{"mappingMode":"defineBelow","value":{"PESSOA":"={{ $json.body.PESSOA }}","CNPJ":"={{ $json.body.DADOS_DA_EMPRESA.CNPJ }}","RAZAO_SOCIAL":"={{ $json.body.DADOS_DA_EMPRESA.RAZAO_SOCIAL }}","CEP":"={{ $json.body.DADOS_DA_EMPRESA.CEP }}","RUA":"={{ $json.body.DADOS_DA_EMPRESA.RUA }}","NUMERO":"={{ $json.body.DADOS_DA_EMPRESA.NUMERO }}","COMPLEMENTO":"={{ $json.body.DADOS_DA_EMPRESA.COMPLEMENTO }}","BAIRRO":"={{ $json.body.DADOS_DA_EMPRESA.BAIRRO }}","CIDADE":"={{ $json.body.DADOS_DA_EMPRESA.CIDADE }}","ESTADO":"={{ $json.body.DADOS_DA_EMPRESA.ESTADO }}","NOME_COMPLETO_REP":"={{ $json.body.REPRESENTANTE.NOME_COMPLETO }}","CPF_REP":"={{ $json.body.REPRESENTANTE.CPF }}","RG_REP":"={{ $json.body.REPRESENTANTE.RG }}","CEP_REP":"={{ $json.body.REPRESENTANTE.CEP }}","RUA_REP":"={{ $json.body.REPRESENTANTE.RUA }}","NUMERO_REP":"={{ $json.body.REPRESENTANTE.NUMERO }}","COMPLEMENTO_REP":"={{ $json.body.REPRESENTANTE.COMPLEMENTO }}","BAIRRO_REP":"={{ $json.body.REPRESENTANTE.BAIRRO }}","CIDADE_REP":"={{ $json.body.REPRESENTANTE.CIDADE }}","ESTADO_REP":"={{ $json.body.REPRESENTANTE.ESTADO }}","EMAIL_REP":"={{ $json.body.REPRESENTANTE['E-MAIL'] }}","TELEFONE_REP":"={{ $json.body.REPRESENTANTE.TELEFONE }}","DATA E HORA":"={{ $now.setZone('America/Sao_Paulo').toFormat('dd/MM/yyyy HH:mm:ss') }}","SOFTWARE":"={{ $json.body.DADOS_VENDA.SOFTWARE }}","TOTAL DE CRÉDITO":"={{ $json.body.DADOS_VENDA.TOTAL_DE_CREDITO }}","TIPO DE CRÉDITO":"={{ $json.body.DADOS_VENDA.TIPO_DE_DE_CREDITO }}","VENDEDOR":"={{ $json.body.DADOS_VENDA.VENDEDOR }}","PREÇO":"={{ $json.body.DADOS_VENDA['PREÇO'] }}"},"matchingColumns":[],"schema":[{"id":"PESSOA","displayName":"PESSOA","required":false,"defaultMatch":false,"display":true,"type":"string","canBeUsedToMatch":true,"removed":false},{"id":"CNPJ","displayName":"CNPJ","required":false,"defaultMatch":false,"display":true,"type":"string","canBeUsedToMatch":true,"removed":false},{"id":"RAZAO_SOCIAL","displayName":"RAZAO_SOCIAL","required":false,"defaultMatch":false,"display":true,"type":"string","canBeUsedToMatch":true,"removed":false},{"id":"CEP","displayName":"CEP","required":false,"defaultMatch":false,"display":true,"type":"string","canBeUsedToMatch":true,"removed":false},{"id":"RUA","displayName":"RUA","required":false,"defaultMatch":false,"display":true,"type":"string","canBeUsedToMatch":true,"removed":false},{"id":"NUMERO","displayName":"NUMERO","required":false,"defaultMatch":false,"display":true,"type":"string","canBeUsedToMatch":true,"removed":false},{"id":"COMPLEMENTO","displayName":"COMPLEMENTO","required":false,"defaultMatch":false,"display":true,"type":"string","canBeUsedToMatch":true,"removed":false},{"id":"BAIRRO","displayName":"BAIRRO","required":false,"defaultMatch":false,"display":true,"type":"string","canBeUsedToMatch":true,"removed":false},{"id":"CIDADE","displayName":"CIDADE","required":false,"defaultMatch":false,"display":true,"type":"string","canBeUsedToMatch":true,"removed":false},{"id":"ESTADO","displayName":"ESTADO","required":false,"defaultMatch":false,"display":true,"type":"string","canBeUsedToMatch":true,"removed":false},{"id":"NOME_COMPLETO_REP","displayName":"NOME_COMPLETO_REP","required":false,"defaultMatch":false,"display":true,"type":"string","canBeUsedToMatch":true,"removed":false},{"id":"CPF_REP","displayName":"CPF_REP","required":false,"defaultMatch":false,"display":true,"type":"string","canBeUsedToMatch":true,"removed":false},{"id":"RG_REP","displayName":"RG_REP","required":false,"defaultMatch":false,"display":true,"type":"string","canBeUsedToMatch":true,"removed":false},{"id":"CEP_REP","displayName":"CEP_REP","required":false,"defaultMatch":false,"display":true,"type":"string","canBeUsedToMatch":true,"removed":false},{"id":"RUA_REP","displayName":"RUA_REP","required":false,"defaultMatch":false,"display":true,"type":"string","canBeUsedToMatch":true,"removed":false},{"id":"NUMERO_REP","displayName":"NUMERO_REP","required":false,"defaultMatch":false,"display":true,"type":"string","canBeUsedToMatch":true,"removed":false},{"id":"COMPLEMENTO_REP","displayName":"COMPLEMENTO_REP","required":false,"defaultMatch":false,"display":true,"type":"string","canBeUsedToMatch":true,"removed":false},{"id":"BAIRRO_REP","displayName":"BAIRRO_REP","required":false,"defaultMatch":false,"display":true,"type":"string","canBeUsedToMatch":true,"removed":false},{"id":"CIDADE_REP","displayName":"CIDADE_REP","required":false,"defaultMatch":false,"display":true,"type":"string","canBeUsedToMatch":true,"removed":false},{"id":"ESTADO_REP","displayName":"ESTADO_REP","required":false,"defaultMatch":false,"display":true,"type":"string","canBeUsedToMatch":true,"removed":false},{"id":"EMAIL_REP","displayName":"EMAIL_REP","required":false,"defaultMatch":false,"display":true,"type":"string","canBeUsedToMatch":true,"removed":false},{"id":"TELEFONE_REP","displayName":"TELEFONE_REP","required":false,"defaultMatch":false,"display":true,"type":"string","canBeUsedToMatch":true,"removed":false},{"id":"DATA E HORA","displayName":"DATA E HORA","required":false,"defaultMatch":false,"display":true,"type":"string","canBeUsedToMatch":true,"removed":false},{"id":"SOFTWARE","displayName":"SOFTWARE","required":false,"defaultMatch":false,"display":true,"type":"string","canBeUsedToMatch":true,"removed":false},{"id":"TOTAL DE CRÉDITO","displayName":"TOTAL DE CRÉDITO","required":false,"defaultMatch":false,"display":true,"type":"string","canBeUsedToMatch":true,"removed":false},{"id":"TIPO DE CRÉDITO","displayName":"TIPO DE CRÉDITO","required":false,"defaultMatch":false,"display":true,"type":"string","canBeUsedToMatch":true,"removed":false},{"id":"VENDEDOR","displayName":"VENDEDOR","required":false,"defaultMatch":false,"display":true,"type":"string","canBeUsedToMatch":true,"removed":false},{"id":"PREÇO","displayName":"PREÇO","required":false,"defaultMatch":false,"display":true,"type":"string","canBeUsedToMatch":true,"removed":false}],"attemptToConvertTypes":false,"convertFieldsToString":false},"options":{}},"type":"n8n-nodes-base.googleSheets","typeVersion":4.7,"position":[80,352],"id":"9b2432ea-d0f9-4084-b12d-da970785bb14","name":"Append row in sheet1","credentials":{"googleSheetsOAuth2Api":{"id":"6TVIGfPIghjLjfhr","name":"VRA - CADASTRO USUARIOS"}},"onError":"continueErrorOutput"},{"parameters":{"rules":{"values":[{"conditions":{"options":{"caseSensitive":true,"leftValue":"","typeValidation":"strict","version":2},"conditions":[{"leftValue":"={{ $json.Software }}","rightValue":"CLOUD PHOTORF","operator":{"type":"string","operation":"equals"},"id":"c294f0dd-0180-45f3-bfdc-a6162149d3d4"}],"combinator":"and"}},{"conditions":{"options":{"caseSensitive":true,"leftValue":"","typeValidation":"strict","version":2},"conditions":[{"id":"46d44a44-44d8-4b93-9a97-f00a46205b02","leftValue":"={{ $json.Software }}","rightValue":"FASTALBUM","operator":{"type":"string","operation":"equals","name":"filter.operator.equals"}}],"combinator":"and"}},{"conditions":{"options":{"caseSensitive":true,"leftValue":"","typeValidation":"strict","version":2},"conditions":[{"id":"920fc7f9-33e8-45b6-a402-6695fb99d7ec","leftValue":"={{ $json.Software }}","rightValue":"PHOTO DRIVE","operator":{"type":"string","operation":"equals","name":"filter.operator.equals"}}],"combinator":"and"}},{"conditions":{"options":{"caseSensitive":true,"leftValue":"","typeValidation":"strict","version":2},"conditions":[{"id":"18cd5db1-f789-46e2-a7e8-f583f705cd48","leftValue":"={{ $json.Software }}","rightValue":"E-PHOTORF","operator":{"type":"string","operation":"equals","name":"filter.operator.equals"}}],"combinator":"and"}},{"conditions":{"options":{"caseSensitive":true,"leftValue":"","typeValidation":"strict","version":2},"conditions":[{"id":"4b25dc63-d7e5-4001-b3d4-5fb24e46609f","leftValue":"={{ $json.Software }}","rightValue":"CHECKOUT PHOTORF","operator":{"type":"string","operation":"equals","name":"filter.operator.equals"}}],"combinator":"and"}}]},"options":{}},"type":"n8n-nodes-base.switch","typeVersion":3.3,"position":[704,176],"id":"ba14b4f0-8b71-4023-8458-1d49cfe9c99b","name":"Switch"},{"parameters":{"method":"POST","url":"https://services.leadconnectorhq.com/hooks/W7PGxpfbsFaEEUoQOtUb/webhook-trigger/67173ce7-5b85-41a7-be6b-6fd23450fe0f","sendBody":true,"specifyBody":"json","jsonBody":"={\n \"firstName\": \"{{ $json.Nome.split(' ')[0] }}\",\n \"lastName\": \"{{ $json.Nome.split(' ').slice(1).join(' ') }}\",\n \"email\": \"{{ $json.Email }}\",\n \"phone\": \"{{ $json.Telefon.replace(/[^0-9]/g, '').length === 11 ? '+55' + $json.Telefon.replace(/[^0-9]/g, '') : $json.Telefon }}\",\n \"companyName\": \"{{ $json.Empresa }}\",\n \"software\": \"{{ $json.Software }}\",\n \"tipoCredito\": \"{{ $json['Tipo de crédito'] }}\",\n \"tag\": \"{{ $json.tag }}\"\n}","options":{}},"type":"n8n-nodes-base.httpRequest","typeVersion":4.3,"position":[1312,-208],"id":"145d91b7-d217-4352-b7ab-ec4ab2cf1913","name":"Cloud PhotoRf"},{"parameters":{"method":"POST","url":"https://services.leadconnectorhq.com/hooks/W7PGxpfbsFaEEUoQOtUb/webhook-trigger/jZLaAHiYuQfYRlWnvm02","sendBody":true,"specifyBody":"json","jsonBody":"={\n \"firstName\": \"{{ $json.Nome.split(' ')[0] }}\",\n \"lastName\": \"{{ $json.Nome.split(' ').slice(1).join(' ') }}\",\n \"email\": \"{{ $json.Email }}\",\n \"phone\": \"{{ $json.Telefon.replace(/[^0-9]/g, '').length === 11 ? '+55' + $json.Telefon.replace(/[^0-9]/g, '') : $json.Telefon }}\",\n \"companyName\": \"{{ $json.Empresa }}\",\n \"software\": \"{{ $json.Software }}\",\n \"tipoCredito\": \"{{ $json['Tipo de crédito'] }}\",\n \"tag\": \"{{ $json.tag }}\"\n}","options":{}},"type":"n8n-nodes-base.httpRequest","typeVersion":4.3,"position":[1312,144],"id":"a1a598a7-c121-47ef-9694-4b4986ade720","name":"Fast Album"},{"parameters":{"method":"POST","url":"https://services.leadconnectorhq.com/hooks/W7PGxpfbsFaEEUoQOtUb/webhook-trigger/L3hnryrDfkGV4Qad7TmX","sendBody":true,"specifyBody":"json","jsonBody":"={\n \"firstName\": \"{{ $json.Nome.split(' ')[0] }}\",\n \"lastName\": \"{{ $json.Nome.split(' ').slice(1).join(' ') }}\",\n \"email\": \"{{ $json.Email }}\",\n \"phone\": \"{{ $json.Telefon.replace(/[^0-9]/g, '').length === 11 ? '+55' + $json.Telefon.replace(/[^0-9]/g, '') : $json.Telefon }}\",\n \"companyName\": \"{{ $json.Empresa }}\",\n \"software\": \"{{ $json.Software }}\",\n \"tipoCredito\": \"{{ $json['Tipo de crédito'] }}\",\n \"tag\": \"{{ $json.tag }}\"\n}","options":{}},"type":"n8n-nodes-base.httpRequest","typeVersion":4.3,"position":[1312,432],"id":"df176781-5767-4431-aead-257e185600e6","name":"Photo Drive"},{"parameters":{"method":"POST","url":"https://services.leadconnectorhq.com/hooks/W7PGxpfbsFaEEUoQOtUb/webhook-trigger/CArJ6aJnMyWMqoEfafEY","sendBody":true,"specifyBody":"json","jsonBody":"={\n \"firstName\": \"{{ $json.Nome.split(' ')[0] }}\",\n \"lastName\": \"{{ $json.Nome.split(' ').slice(1).join(' ') }}\",\n \"email\": \"{{ $json.Email }}\",\n \"phone\": \"{{ $json.Telefon.replace(/[^0-9]/g, '').length === 11 ? '+55' + $json.Telefon.replace(/[^0-9]/g, '') : $json.Telefon }}\",\n \"companyName\": \"{{ $json.Empresa }}\",\n \"software\": \"{{ $json.Software }}\",\n \"tipoCredito\": \"{{ $json['Tipo de crédito'] }}\",\n \"tag\": \"{{ $json.tag }}\"\n}","options":{}},"type":"n8n-nodes-base.httpRequest","typeVersion":4.3,"position":[1328,752],"id":"e94f3fac-ca8b-4cd4-aa57-b0f52232945a","name":"E-PhotoRf"},{"parameters":{"method":"POST","url":"https://services.leadconnectorhq.com/hooks/W7PGxpfbsFaEEUoQOtUb/webhook-trigger/olggbUnO2yz5sTksXgwY","sendBody":true,"specifyBody":"json","jsonBody":"={\n \"firstName\": \"{{ $json.Nome.split(' ')[0] }}\",\n \"lastName\": \"{{ $json.Nome.split(' ').slice(1).join(' ') }}\",\n \"email\": \"{{ $json.Email }}\",\n \"phone\": \"{{ $json.Telefon.replace(/[^0-9]/g, '').length === 11 ? '+55' + $json.Telefon.replace(/[^0-9]/g, '') : $json.Telefon }}\",\n \"companyName\": \"{{ $json.Empresa }}\",\n \"software\": \"{{ $json.Software }}\",\n \"tipoCredito\": \"{{ $json['Tipo de crédito'] }}\",\n \"tag\": \"{{ $json.tag }}\"\n}","options":{}},"type":"n8n-nodes-base.httpRequest","typeVersion":4.3,"position":[1072,976],"id":"f0bb4f07-184d-4b3c-9a10-2d501a08ef7a","name":"Checkout PhotoRf"},{"parameters":{"assignments":{"assignments":[{"id":"dfc306b1-e212-4e17-b8ff-7aff85085655","name":"Tag","value":"={{ $json['Tipo de crédito'] === 'PERÍODO DE TESTE' ? 'trial' : 'comprou' }}","type":"string"}]},"includeOtherFields":true,"options":{}},"type":"n8n-nodes-base.set","typeVersion":3.4,"position":[528,336],"id":"bd755522-5d50-4b8b-855e-63fb43ff5da5","name":"Set tag"},{"parameters":{"assignments":{"assignments":[{"id":"50079c22-fd07-4b72-9e5e-5aa64abcff64","name":"Nome","value":"={{ $json.NOME_COMPLETO_REP }}","type":"string"},{"id":"13bbc0d6-9231-4374-b238-a3d18f1f0823","name":"Telefon","value":"={{ $json.TELEFONE_REP }}","type":"string"},{"id":"cf57c9a2-e404-48e2-abd3-923ef925bcb9","name":"Email","value":"={{ $json.EMAIL_REP }}","type":"string"},{"id":"d447094f-5632-46e3-8c88-3e37ecdd5406","name":"Software","value":"={{ $json.SOFTWARE }}","type":"string"},{"id":"9c65620a-aefd-4441-a40e-39a62f7db02d","name":"Tipo de crédito","value":"={{ $json['TIPO DE CRÉDITO'] }}","type":"string"},{"id":"0fd3e205-9e07-4186-b796-850a13770c76","name":"Empresa","value":"={{ $json.RAZAO_SOCIAL }}","type":"string"}]},"options":{}},"type":"n8n-nodes-base.set","typeVersion":3.4,"position":[352,176],"id":"b3f9bcf4-55a6-4e9b-9c1c-35a41464a536","name":"Dados"},{"parameters":{"conditions":{"options":{"caseSensitive":true,"leftValue":"","typeValidation":"strict","version":2},"conditions":[{"id":"42280267-fad4-44cf-8e29-1b26e5ca2577","leftValue":"tag","rightValue":"trial","operator":{"type":"string","operation":"equals","name":"filter.operator.equals"}}],"combinator":"and"},"options":{}},"type":"n8n-nodes-base.if","typeVersion":2.2,"position":[1040,-288],"id":"cdd2a370-b7a6-4e23-a59e-39cfb0a5468f","name":"trial?"},{"parameters":{"conditions":{"options":{"caseSensitive":true,"leftValue":"","typeValidation":"strict","version":2},"conditions":[{"id":"42280267-fad4-44cf-8e29-1b26e5ca2577","leftValue":"tag","rightValue":"trial","operator":{"type":"string","operation":"equals","name":"filter.operator.equals"}}],"combinator":"and"},"options":{}},"type":"n8n-nodes-base.if","typeVersion":2.2,"position":[1024,0],"id":"53f61e0a-d275-4922-82d8-be4ca9833dc8","name":"trial?1"},{"parameters":{"conditions":{"options":{"caseSensitive":true,"leftValue":"","typeValidation":"strict","version":2},"conditions":[{"id":"42280267-fad4-44cf-8e29-1b26e5ca2577","leftValue":"tag","rightValue":"trial","operator":{"type":"string","operation":"equals","name":"filter.operator.equals"}}],"combinator":"and"},"options":{}},"type":"n8n-nodes-base.if","typeVersion":2.2,"position":[1024,288],"id":"880255e0-e553-410b-8f02-ee79907a4f52","name":"trial?2"},{"parameters":{"conditions":{"options":{"caseSensitive":true,"leftValue":"","typeValidation":"strict","version":2},"conditions":[{"id":"42280267-fad4-44cf-8e29-1b26e5ca2577","leftValue":"tag","rightValue":"trial","operator":{"type":"string","operation":"equals","name":"filter.operator.equals"}}],"combinator":"and"},"options":{}},"type":"n8n-nodes-base.if","typeVersion":2.2,"position":[1024,544],"id":"ecf162fd-1ab9-4d5b-b6ca-9feb28d62c6c","name":"trial?3"},{"parameters":{"conditions":{"options":{"caseSensitive":true,"leftValue":"","typeValidation":"strict","version":2},"conditions":[{"id":"42280267-fad4-44cf-8e29-1b26e5ca2577","leftValue":"tag","rightValue":"trial","operator":{"type":"string","operation":"equals","name":"filter.operator.equals"}}],"combinator":"and"},"options":{}},"type":"n8n-nodes-base.if","typeVersion":2.2,"position":[896,752],"id":"511b9756-c120-47cc-8e31-555e3cf09ddb","name":"trial?4"},{"id":"8716138f-57ee-4233-87e6-5a4d29c30034","name":"Linkia Tag Cloud","type":"n8n-nodes-base.httpRequest","typeVersion":4.2,"position":[1520,-128],"parameters":{"method":"POST","url":"https://services.leadconnectorhq.com/contacts/upsert","sendHeaders":true,"headerParameters":{"parameters":[{"name":"Authorization","value":"Bearer [REDACTED_GHL_PIT]"},{"name":"Version","value":"2021-07-28"},{"name":"Content-Type","value":"application/json"}]},"sendBody":true,"specifyBody":"json","jsonBody":"={\n \"locationId\": \"W7PGxpfbsFaEEUoQOtUb\",\n \"email\": \"{{ $json.Email }}\",\n \"phone\": \"{{ $json.Telefon.replace(/[^0-9]/g, '').length === 11 ? '+55' + $json.Telefon.replace(/[^0-9]/g, '') : $json.Telefon }}\",\n \"firstName\": \"{{ $json.Nome.split(' ')[0] }}\",\n \"lastName\": \"{{ $json.Nome.split(' ').slice(1).join(' ') }}\",\n \"tags\": [\"comprou-claud-photorf\"],\n \"customFields\": [\n { \"key\": \"software_comprado\", \"field_value\": \"{{ $json.Software }}\" }\n ]\n}","options":{}},"onError":"continueRegularOutput"},{"id":"e6900008-f9b0-41fd-b761-4691e57bd1f6","name":"CAPI Cloud","type":"n8n-nodes-base.httpRequest","typeVersion":4.2,"position":[1760,-128],"parameters":{"method":"POST","url":"https://track-capi-px3.agentesclimb.us/purchase","sendHeaders":true,"headerParameters":{"parameters":[{"name":"Content-Type","value":"application/json"}]},"sendBody":true,"specifyBody":"json","jsonBody":"={\n \"email\": \"{{ $json.Email }}\",\n \"phone\": \"{{ $json.Telefon.replace(/[^0-9]/g, '') }}\",\n \"first_name\": \"{{ $json.Nome.split(' ')[0] }}\",\n \"last_name\": \"{{ $json.Nome.split(' ').slice(1).join(' ') }}\",\n \"city\": \"{{ $('PLANILHA DE VENDAS').item.json.body.REPRESENTANTE.CIDADE }}\",\n \"state\": \"{{ $('PLANILHA DE VENDAS').item.json.body.REPRESENTANTE.ESTADO }}\",\n \"zip\": \"{{ $('PLANILHA DE VENDAS').item.json.body.REPRESENTANTE.CEP }}\",\n \"country\": \"BR\",\n \"value\": {{ Number($('PLANILHA DE VENDAS').item.json.body.DADOS_VENDA['PREÇO']) * Number($('PLANILHA DE VENDAS').item.json.body.DADOS_VENDA.TOTAL_DE_CREDITO) }},\n \"currency\": \"BRL\",\n \"content_name\": \"{{ $json.Software }}\",\n \"content_ids\": [\"{{ $json.Software }}\"],\n \"num_items\": {{ Number($('PLANILHA DE VENDAS').item.json.body.DADOS_VENDA.TOTAL_DE_CREDITO) }},\n \"event_id\": \"vra-{{ $execution.id }}\"\n}","options":{}},"onError":"continueRegularOutput"},{"id":"ba151b24-db54-4e43-a7af-8e7ffdfbdd98","name":"Linkia Tag Fast","type":"n8n-nodes-base.httpRequest","typeVersion":4.2,"position":[1504,160],"parameters":{"method":"POST","url":"https://services.leadconnectorhq.com/contacts/upsert","sendHeaders":true,"headerParameters":{"parameters":[{"name":"Authorization","value":"Bearer [REDACTED_GHL_PIT]"},{"name":"Version","value":"2021-07-28"},{"name":"Content-Type","value":"application/json"}]},"sendBody":true,"specifyBody":"json","jsonBody":"={\n \"locationId\": \"W7PGxpfbsFaEEUoQOtUb\",\n \"email\": \"{{ $json.Email }}\",\n \"phone\": \"{{ $json.Telefon.replace(/[^0-9]/g, '').length === 11 ? '+55' + $json.Telefon.replace(/[^0-9]/g, '') : $json.Telefon }}\",\n \"firstName\": \"{{ $json.Nome.split(' ')[0] }}\",\n \"lastName\": \"{{ $json.Nome.split(' ').slice(1).join(' ') }}\",\n \"tags\": [\"comprou-fast-album\"],\n \"customFields\": [\n { \"key\": \"software_comprado\", \"field_value\": \"{{ $json.Software }}\" }\n ]\n}","options":{}},"onError":"continueRegularOutput"},{"id":"5108f0f7-a89c-43b4-a13f-eb93167d9e44","name":"CAPI Fast","type":"n8n-nodes-base.httpRequest","typeVersion":4.2,"position":[1744,160],"parameters":{"method":"POST","url":"https://track-capi-px3.agentesclimb.us/purchase","sendHeaders":true,"headerParameters":{"parameters":[{"name":"Content-Type","value":"application/json"}]},"sendBody":true,"specifyBody":"json","jsonBody":"={\n \"email\": \"{{ $json.Email }}\",\n \"phone\": \"{{ $json.Telefon.replace(/[^0-9]/g, '') }}\",\n \"first_name\": \"{{ $json.Nome.split(' ')[0] }}\",\n \"last_name\": \"{{ $json.Nome.split(' ').slice(1).join(' ') }}\",\n \"city\": \"{{ $('PLANILHA DE VENDAS').item.json.body.REPRESENTANTE.CIDADE }}\",\n \"state\": \"{{ $('PLANILHA DE VENDAS').item.json.body.REPRESENTANTE.ESTADO }}\",\n \"zip\": \"{{ $('PLANILHA DE VENDAS').item.json.body.REPRESENTANTE.CEP }}\",\n \"country\": \"BR\",\n \"value\": {{ Number($('PLANILHA DE VENDAS').item.json.body.DADOS_VENDA['PREÇO']) * Number($('PLANILHA DE VENDAS').item.json.body.DADOS_VENDA.TOTAL_DE_CREDITO) }},\n \"currency\": \"BRL\",\n \"content_name\": \"{{ $json.Software }}\",\n \"content_ids\": [\"{{ $json.Software }}\"],\n \"num_items\": {{ Number($('PLANILHA DE VENDAS').item.json.body.DADOS_VENDA.TOTAL_DE_CREDITO) }},\n \"event_id\": \"vra-{{ $execution.id }}\"\n}","options":{}},"onError":"continueRegularOutput"},{"id":"2368e16f-93dc-481f-b543-a5cbadf62602","name":"Linkia Tag Drive","type":"n8n-nodes-base.httpRequest","typeVersion":4.2,"position":[1504,448],"parameters":{"method":"POST","url":"https://services.leadconnectorhq.com/contacts/upsert","sendHeaders":true,"headerParameters":{"parameters":[{"name":"Authorization","value":"Bearer [REDACTED_GHL_PIT]"},{"name":"Version","value":"2021-07-28"},{"name":"Content-Type","value":"application/json"}]},"sendBody":true,"specifyBody":"json","jsonBody":"={\n \"locationId\": \"W7PGxpfbsFaEEUoQOtUb\",\n \"email\": \"{{ $json.Email }}\",\n \"phone\": \"{{ $json.Telefon.replace(/[^0-9]/g, '').length === 11 ? '+55' + $json.Telefon.replace(/[^0-9]/g, '') : $json.Telefon }}\",\n \"firstName\": \"{{ $json.Nome.split(' ')[0] }}\",\n \"lastName\": \"{{ $json.Nome.split(' ').slice(1).join(' ') }}\",\n \"tags\": [\"comprou-photo-drive\"],\n \"customFields\": [\n { \"key\": \"software_comprado\", \"field_value\": \"{{ $json.Software }}\" }\n ]\n}","options":{}},"onError":"continueRegularOutput"},{"id":"b72d622e-12f9-41bd-8299-a0aea8abb882","name":"CAPI Drive","type":"n8n-nodes-base.httpRequest","typeVersion":4.2,"position":[1744,448],"parameters":{"method":"POST","url":"https://track-capi-px3.agentesclimb.us/purchase","sendHeaders":true,"headerParameters":{"parameters":[{"name":"Content-Type","value":"application/json"}]},"sendBody":true,"specifyBody":"json","jsonBody":"={\n \"email\": \"{{ $json.Email }}\",\n \"phone\": \"{{ $json.Telefon.replace(/[^0-9]/g, '') }}\",\n \"first_name\": \"{{ $json.Nome.split(' ')[0] }}\",\n \"last_name\": \"{{ $json.Nome.split(' ').slice(1).join(' ') }}\",\n \"city\": \"{{ $('PLANILHA DE VENDAS').item.json.body.REPRESENTANTE.CIDADE }}\",\n \"state\": \"{{ $('PLANILHA DE VENDAS').item.json.body.REPRESENTANTE.ESTADO }}\",\n \"zip\": \"{{ $('PLANILHA DE VENDAS').item.json.body.REPRESENTANTE.CEP }}\",\n \"country\": \"BR\",\n \"value\": {{ Number($('PLANILHA DE VENDAS').item.json.body.DADOS_VENDA['PREÇO']) * Number($('PLANILHA DE VENDAS').item.json.body.DADOS_VENDA.TOTAL_DE_CREDITO) }},\n \"currency\": \"BRL\",\n \"content_name\": \"{{ $json.Software }}\",\n \"content_ids\": [\"{{ $json.Software }}\"],\n \"num_items\": {{ Number($('PLANILHA DE VENDAS').item.json.body.DADOS_VENDA.TOTAL_DE_CREDITO) }},\n \"event_id\": \"vra-{{ $execution.id }}\"\n}","options":{}},"onError":"continueRegularOutput"},{"id":"717f3077-1cc9-41c0-bd8b-aeb16a2447e3","name":"Linkia Tag EPhoto","type":"n8n-nodes-base.httpRequest","typeVersion":4.2,"position":[1504,704],"parameters":{"method":"POST","url":"https://services.leadconnectorhq.com/contacts/upsert","sendHeaders":true,"headerParameters":{"parameters":[{"name":"Authorization","value":"Bearer [REDACTED_GHL_PIT]"},{"name":"Version","value":"2021-07-28"},{"name":"Content-Type","value":"application/json"}]},"sendBody":true,"specifyBody":"json","jsonBody":"={\n \"locationId\": \"W7PGxpfbsFaEEUoQOtUb\",\n \"email\": \"{{ $json.Email }}\",\n \"phone\": \"{{ $json.Telefon.replace(/[^0-9]/g, '').length === 11 ? '+55' + $json.Telefon.replace(/[^0-9]/g, '') : $json.Telefon }}\",\n \"firstName\": \"{{ $json.Nome.split(' ')[0] }}\",\n \"lastName\": \"{{ $json.Nome.split(' ').slice(1).join(' ') }}\",\n \"tags\": [\"comprou-e-photorf\"],\n \"customFields\": [\n { \"key\": \"software_comprado\", \"field_value\": \"{{ $json.Software }}\" }\n ]\n}","options":{}},"onError":"continueRegularOutput"},{"id":"08634f82-e9c6-4fa6-b01f-fdea84f2a531","name":"CAPI EPhoto","type":"n8n-nodes-base.httpRequest","typeVersion":4.2,"position":[1744,704],"parameters":{"method":"POST","url":"https://track-capi-px3.agentesclimb.us/purchase","sendHeaders":true,"headerParameters":{"parameters":[{"name":"Content-Type","value":"application/json"}]},"sendBody":true,"specifyBody":"json","jsonBody":"={\n \"email\": \"{{ $json.Email }}\",\n \"phone\": \"{{ $json.Telefon.replace(/[^0-9]/g, '') }}\",\n \"first_name\": \"{{ $json.Nome.split(' ')[0] }}\",\n \"last_name\": \"{{ $json.Nome.split(' ').slice(1).join(' ') }}\",\n \"city\": \"{{ $('PLANILHA DE VENDAS').item.json.body.REPRESENTANTE.CIDADE }}\",\n \"state\": \"{{ $('PLANILHA DE VENDAS').item.json.body.REPRESENTANTE.ESTADO }}\",\n \"zip\": \"{{ $('PLANILHA DE VENDAS').item.json.body.REPRESENTANTE.CEP }}\",\n \"country\": \"BR\",\n \"value\": {{ Number($('PLANILHA DE VENDAS').item.json.body.DADOS_VENDA['PREÇO']) * Number($('PLANILHA DE VENDAS').item.json.body.DADOS_VENDA.TOTAL_DE_CREDITO) }},\n \"currency\": \"BRL\",\n \"content_name\": \"{{ $json.Software }}\",\n \"content_ids\": [\"{{ $json.Software }}\"],\n \"num_items\": {{ Number($('PLANILHA DE VENDAS').item.json.body.DADOS_VENDA.TOTAL_DE_CREDITO) }},\n \"event_id\": \"vra-{{ $execution.id }}\"\n}","options":{}},"onError":"continueRegularOutput"},{"id":"8c22418f-0338-4357-ad2a-69381e0ad454","name":"Linkia Tag Checkout","type":"n8n-nodes-base.httpRequest","typeVersion":4.2,"position":[1376,912],"parameters":{"method":"POST","url":"https://services.leadconnectorhq.com/contacts/upsert","sendHeaders":true,"headerParameters":{"parameters":[{"name":"Authorization","value":"Bearer [REDACTED_GHL_PIT]"},{"name":"Version","value":"2021-07-28"},{"name":"Content-Type","value":"application/json"}]},"sendBody":true,"specifyBody":"json","jsonBody":"={\n \"locationId\": \"W7PGxpfbsFaEEUoQOtUb\",\n \"email\": \"{{ $json.Email }}\",\n \"phone\": \"{{ $json.Telefon.replace(/[^0-9]/g, '').length === 11 ? '+55' + $json.Telefon.replace(/[^0-9]/g, '') : $json.Telefon }}\",\n \"firstName\": \"{{ $json.Nome.split(' ')[0] }}\",\n \"lastName\": \"{{ $json.Nome.split(' ').slice(1).join(' ') }}\",\n \"tags\": [\"comprou-checkout-photorf\"],\n \"customFields\": [\n { \"key\": \"software_comprado\", \"field_value\": \"{{ $json.Software }}\" }\n ]\n}","options":{}},"onError":"continueRegularOutput"},{"id":"d090004e-7111-466e-9639-1462fcfa276d","name":"CAPI Checkout","type":"n8n-nodes-base.httpRequest","typeVersion":4.2,"position":[1616,912],"parameters":{"method":"POST","url":"https://track-capi-px3.agentesclimb.us/purchase","sendHeaders":true,"headerParameters":{"parameters":[{"name":"Content-Type","value":"application/json"}]},"sendBody":true,"specifyBody":"json","jsonBody":"={\n \"email\": \"{{ $json.Email }}\",\n \"phone\": \"{{ $json.Telefon.replace(/[^0-9]/g, '') }}\",\n \"first_name\": \"{{ $json.Nome.split(' ')[0] }}\",\n \"last_name\": \"{{ $json.Nome.split(' ').slice(1).join(' ') }}\",\n \"city\": \"{{ $('PLANILHA DE VENDAS').item.json.body.REPRESENTANTE.CIDADE }}\",\n \"state\": \"{{ $('PLANILHA DE VENDAS').item.json.body.REPRESENTANTE.ESTADO }}\",\n \"zip\": \"{{ $('PLANILHA DE VENDAS').item.json.body.REPRESENTANTE.CEP }}\",\n \"country\": \"BR\",\n \"value\": {{ Number($('PLANILHA DE VENDAS').item.json.body.DADOS_VENDA['PREÇO']) * Number($('PLANILHA DE VENDAS').item.json.body.DADOS_VENDA.TOTAL_DE_CREDITO) }},\n \"currency\": \"BRL\",\n \"content_name\": \"{{ $json.Software }}\",\n \"content_ids\": [\"{{ $json.Software }}\"],\n \"num_items\": {{ Number($('PLANILHA DE VENDAS').item.json.body.DADOS_VENDA.TOTAL_DE_CREDITO) }},\n \"event_id\": \"vra-{{ $execution.id }}\"\n}","options":{}},"onError":"continueRegularOutput"}],"connections":{"CADASTRO DE CLIENTES":{"main":[[{"node":"Append row in sheet","type":"main","index":0}]]},"PLANILHA DE VENDAS":{"main":[[{"node":"Append row in sheet1","type":"main","index":0}]]},"Append row in sheet":{"main":[[]]},"Append row in sheet1":{"main":[[{"node":"Dados","type":"main","index":0}]]},"Switch":{"main":[[{"node":"trial?","type":"main","index":0}],[{"node":"trial?1","type":"main","index":0}],[{"node":"trial?2","type":"main","index":0}],[{"node":"trial?3","type":"main","index":0}],[{"node":"trial?4","type":"main","index":0}]]},"Set tag":{"main":[[{"node":"Switch","type":"main","index":0}]]},"Dados":{"main":[[{"node":"Set tag","type":"main","index":0}]]},"trial?":{"main":[[],[{"node":"Cloud PhotoRf","type":"main","index":0},{"node":"Linkia Tag Cloud","type":"main","index":0}]]},"trial?1":{"main":[[],[{"node":"Fast Album","type":"main","index":0},{"node":"Linkia Tag Fast","type":"main","index":0}]]},"trial?2":{"main":[[],[{"node":"Photo Drive","type":"main","index":0},{"node":"Linkia Tag Drive","type":"main","index":0}]]},"trial?3":{"main":[[],[{"node":"E-PhotoRf","type":"main","index":0},{"node":"Linkia Tag EPhoto","type":"main","index":0}]]},"trial?4":{"main":[[],[{"node":"Checkout PhotoRf","type":"main","index":0},{"node":"Linkia Tag Checkout","type":"main","index":0}]]},"Linkia Tag Cloud":{"main":[[{"node":"CAPI Cloud","type":"main","index":0}]]},"CAPI Cloud":{"main":[[]]},"Linkia Tag Fast":{"main":[[{"node":"CAPI Fast","type":"main","index":0}]]},"CAPI Fast":{"main":[[]]},"Linkia Tag Drive":{"main":[[{"node":"CAPI Drive","type":"main","index":0}]]},"CAPI Drive":{"main":[[]]},"Linkia Tag EPhoto":{"main":[[{"node":"CAPI EPhoto","type":"main","index":0}]]},"CAPI EPhoto":{"main":[[]]},"Linkia Tag Checkout":{"main":[[{"node":"CAPI Checkout","type":"main","index":0}]]},"CAPI Checkout":{"main":[[]]}},"nodeGroups":[],"authors":"Vinicius Amaral","name":null,"description":null,"autosaved":false,"workflowPublishHistory":[{"createdAt":"2026-08-24T17:50:02.143Z","id":34,"workflowId":"QcJuvqhV98vIYtA6","versionId":"ea99f622-a817-4748-804a-5546cabe8f95","event":"deactivated","userId":"ba006ce7-0d34-471b-addf-5e747ca68eaf"},{"createdAt":"2026-08-24T17:50:02.220Z","id":35,"workflowId":"QcJuvqhV98vIYtA6","versionId":"ea99f622-a817-4748-804a-5546cabe8f95","event":"activated","userId":"ba006ce7-0d34-471b-addf-5e747ca68eaf"}]}} /opt/mia/workspace/clientes/px3lab/imports/fix_conafor_smart.py:15:TOKEN = "[REDACTED_GHL_PIT]" /opt/mia/workspace/clientes/px3lab/imports/import_conafor_smart.py:18:TOKEN = "[REDACTED_GHL_PIT]" /opt/mia/workspace/clientes/px3lab/imports/audit_conafor_20260827.py:19:TOKEN = "[REDACTED_GHL_PIT]" /opt/mia/workspace/clientes/px3lab/imports/conafor_smart_opcao3_fix.py:24:TOKEN = "[REDACTED_GHL_PIT]" /opt/mia/workspace/clientes/borrello/kit_tratamento/warmup_dia2_tagger.py:14:TOKEN = "[REDACTED_GHL_PIT]" /opt/mia/workspace/clientes/borrello/quiz_feng_shui/api.py:49: "[REDACTED_GHL_PIT]", /opt/mia-bot/sent/1786132006661662533.json:1:{"text": "Dá certo SE essa instância estiver apontando pra Location CLIMB DIGITAL. Pelo nome ('TESTE GRUPO PX3 - RENATO') parece que tá conectada na Location PX3, não Climb - se for isso, quando você mandar msg pelo WhatsApp dela vai cair no CRM PX3 e a automação do TESTE RAFA (que tá na Climb) NÃO vai disparar.\n\n🔍 Confere assim: clica em 'Open' nessa instância no painel Dinastia. Deve ter um campo tipo 'GHL Location ID' ou 'API Key'. Se estiver:\n\n• Location ID = W7PGxpfbsFaEEUoQOtUb → tá apontando PX3 (não serve pro TESTE RAFA)\n• Location ID = ztCw0x5ghGgkA7kH3RQ2 → tá apontando Climb Digital ✅ pode usar\n\nSE tiver apontando PX3, você tem 2 opções:\n1. RECONFIGURAR essa mesma instância pra apontar pra Climb (trocar Location ID + API Key [REDACTED_GHL_PIT])\n2. CRIAR UMA INSTÂNCIA NOVA na Dinastia dedicada pro TORQ apontando pra Climb\n\nRecomendo a 2 (nova) pra não bagunçar a instância PX3 que já roda outras coisas.\n\nMe confirma qual Location aparece que a gente vai adiante."} /opt/mia-bot/sent/1786283295830457344.json:1:{"text": "Update(/opt/mia/workspace/clientes/px3lab/dinastia_webhook/instancias.json)\n31 \"ghl_token\": \"[REDACTED_GHL_PIT]\",\n32 \"ghl_location\": \"W7PGxpfbsFaEEUoQOtUb\",\n33 \"descricao\": \"Vinicius - Px3 Lab\"\n34 + },\n35 + \"torq_teste\": {\n36 + \"dinastia_token\": \"KSDFJKSFJSLFJSF\",\n37 + \"ghl_token\": \"[REDACTED_GHL_PIT]\",\n38 + \"ghl_location\": \"ztCw0x5ghGgkA7kH3RQ2\",\n39 + \"descricao\": \"TORQ Bruno Teste - Climb Digital\",\n40 + \"numeros_equipe\": []\n41 }\n42 }\n43 No newline at end of file\n\nAdicionei \"torq_teste\" no instancias.json apontando pra Climb Digital. Passei os 3 passos que dependem dele (trocar webhook na Dinastia pra /torq_teste, ativar evento message, criar workflow no Linkia Climb com Send\nWebhook pro Bruno). Assim que mandar \"pronto\", disparo teste ao vivo."} ``` ## AWS_KEY — 6 ocorrência(s) ``` /opt/mia-bot/docs/1782173735613418.json:173: "raw": "// 📝 Create a new DinastiAPI user account\n// 🔗 POST /admin/users\n// 💡 All optional fields included for complete reference\n\n{\n \"name\": \"John Doe\",\n \"token\": \"1234ABCD\",\n \"webhook\": \"https://webhook.site/1234567890\",\n \"events\": \"All\",\n \"echoApiMessages\": false,\n \"skipMedia\": false,\n \"skipGroups\": false,\n \"skipNewsletters\": false,\n \"skipBroadcasts\": false,\n \"skipOwnMessages\": false,\n \"skipCalls\": false,\n \"callRejectMessage\": \"Sorry, I cannot take calls at the moment.\",\n \"callRejectType\": \"busy\",\n \"globalTransportSkips\": {\n \"skipGlobalWebhook\": false,\n \"skipGlobalRabbitMQ\": false,\n \"skipGlobalSQS\": false,\n \"skipGlobalRedis\": false,\n \"skipGlobalWebSocket\": false,\n \"skipGlobalS3\": false\n },\n \"proxyConfig\": {\n \"enabled\": true,\n \"proxyURL\": \"https://serverproxy.com:9080\"\n },\n \"s3Config\": {\n \"enabled\": true,\n \"endpoint\": \"https://s3.amazonaws.com\",\n \"region\": \"us-east-1\",\n \"bucket\": \"my-whatsapp-media\",\n \"access_key\": \"[REDACTED_AWS_KEY]\",\n \"secret_key\": \"wJalrXUtnFEMI/K7MDENG/bPxRfiCYEXAMPLE\",\n \"path_style\": false,\n \"public_url\": \"https://cdn.example.com\",\n \"media_delivery\": \"both\",\n \"retention_days\": 30,\n \"disable_acl\": true\n },\n \"rabbitmqConfig\": {\n \"enabled\": true,\n \"url\": \"amqp://guest:guest@localhost:5672/\",\n \"exchange\": \"whatsapp.events\",\n \"exchange_type\": \"topic\",\n \"queue\": \"whatsapp.user.{user_id}\",\n \"queue_type\": \"classic\",\n \"routing_key\": \"whatsapp.{event_type}\",\n \"events\": \"All\",\n \"durable\": true,\n \"auto_delete\": false,\n \"exclusive\": false,\n \"no_wait\": false,\n \"delivery_mode\": 2\n },\n \"whatsappConfig\": {\n \"waVersion\": \"2.3000.1027949008\",\n \"waPlatform\": \"WEB\",\n \"waReleaseChannel\": \"RELEASE\",\n \"waWebSubPlatform\": \"WEB_BROWSER\",\n \"waOSName\": \"Mac OS 10\",\n \"waOSVersion\": \"10.15.7\",\n \"waDeviceName\": \"Desktop\",\n \"waManufacturer\": \"Apple\",\n \"waDeviceBoard\": \"Mac-123456\",\n \"waLocaleLanguage\": \"en\",\n \"waLocaleCountry\": \"US\",\n \"waMCC\": \"000\",\n \"waMNC\": \"000\",\n \"waConnectType\": \"WIFI_UNKNOWN\",\n \"waPlatformType\": \"DESKTOP\"\n }\n}", /opt/mia-bot/docs/1782173735613418.json:212: "raw": "// 📝 Create a new DinastiAPI user account\n// 🔗 POST /admin/users\n// 💡 All optional fields included for complete reference\n\n{\n \"name\": \"John Doe\",\n \"token\": \"1234ABCD\",\n \"webhook\": \"https://webhook.site/1234567890\",\n \"events\": \"All\",\n \"echoApiMessages\": false,\n \"skipMedia\": false,\n \"skipGroups\": false,\n \"skipNewsletters\": false,\n \"skipBroadcasts\": false,\n \"skipOwnMessages\": false,\n \"skipCalls\": false,\n \"callRejectMessage\": \"Sorry, I cannot take calls at the moment.\",\n \"callRejectType\": \"busy\",\n \"globalTransportSkips\": {\n \"skipGlobalWebhook\": false,\n \"skipGlobalRabbitMQ\": false,\n \"skipGlobalSQS\": false,\n \"skipGlobalRedis\": false,\n \"skipGlobalWebSocket\": false,\n \"skipGlobalS3\": false\n },\n \"proxyConfig\": {\n \"enabled\": true,\n \"proxyURL\": \"https://serverproxy.com:9080\"\n },\n \"s3Config\": {\n \"enabled\": true,\n \"endpoint\": \"https://s3.amazonaws.com\",\n \"region\": \"us-east-1\",\n \"bucket\": \"my-whatsapp-media\",\n \"access_key\": \"[REDACTED_AWS_KEY]\",\n \"secret_key\": \"wJalrXUtnFEMI/K7MDENG/bPxRfiCYEXAMPLE\",\n \"path_style\": false,\n \"public_url\": \"https://cdn.example.com\",\n \"media_delivery\": \"both\",\n \"retention_days\": 30,\n \"disable_acl\": true\n },\n \"rabbitmqConfig\": {\n \"enabled\": true,\n \"url\": \"amqp://guest:guest@localhost:5672/\",\n \"exchange\": \"whatsapp.events\",\n \"exchange_type\": \"topic\",\n \"queue\": \"whatsapp.user.{user_id}\",\n \"queue_type\": \"classic\",\n \"routing_key\": \"whatsapp.{event_type}\",\n \"events\": \"All\",\n \"durable\": true,\n \"auto_delete\": false,\n \"exclusive\": false,\n \"no_wait\": false,\n \"delivery_mode\": 2\n },\n \"whatsappConfig\": {\n \"waVersion\": \"2.3000.1027949008\",\n \"waPlatform\": \"WEB\",\n \"waReleaseChannel\": \"RELEASE\",\n \"waWebSubPlatform\": \"WEB_BROWSER\",\n \"waOSName\": \"Mac OS 10\",\n \"waOSVersion\": \"10.15.7\",\n \"waDeviceName\": \"Desktop\",\n \"waManufacturer\": \"Apple\",\n \"waDeviceBoard\": \"Mac-123456\",\n \"waLocaleLanguage\": \"en\",\n \"waLocaleCountry\": \"US\",\n \"waMCC\": \"000\",\n \"waMNC\": \"000\",\n \"waConnectType\": \"WIFI_UNKNOWN\",\n \"waPlatformType\": \"DESKTOP\"\n }\n}", /opt/mia-bot/docs/1782173735613418.json:1807: "raw": "// 📝 Configure S3 Storage\n// 🔗 POST /session/s3/config\n// 💡 All optional fields included for complete reference\n\n{\n \"enabled\": true,\n \"endpoint\": \"https://s3.amazonaws.com\",\n \"region\": \"us-east-1\",\n \"bucket\": \"my-whatsapp-media\",\n \"access_key\": \"[REDACTED_AWS_KEY]\",\n \"secret_key\": \"wJalrXUtnFEMI/K7MDENG/bPxRfiCYEXAMPLEKEY\",\n \"path_style\": false,\n \"public_url\": \"https://cdn.example.com\",\n \"media_delivery\": \"both\",\n \"retention_days\": 1,\n \"disable_acl\": true\n}", /opt/mia-bot/docs/1781895813383263.json:173: "raw": "// 📝 Create a new DinastiAPI user account\n// 🔗 POST /admin/users\n// 💡 All optional fields included for complete reference\n\n{\n \"name\": \"John Doe\",\n \"token\": \"1234ABCD\",\n \"webhook\": \"https://webhook.site/1234567890\",\n \"events\": \"All\",\n \"echoApiMessages\": false,\n \"skipMedia\": false,\n \"skipGroups\": false,\n \"skipNewsletters\": false,\n \"skipBroadcasts\": false,\n \"skipOwnMessages\": false,\n \"skipCalls\": false,\n \"callRejectMessage\": \"Sorry, I cannot take calls at the moment.\",\n \"callRejectType\": \"busy\",\n \"globalTransportSkips\": {\n \"skipGlobalWebhook\": false,\n \"skipGlobalRabbitMQ\": false,\n \"skipGlobalSQS\": false,\n \"skipGlobalRedis\": false,\n \"skipGlobalWebSocket\": false,\n \"skipGlobalS3\": false\n },\n \"proxyConfig\": {\n \"enabled\": true,\n \"proxyURL\": \"https://serverproxy.com:9080\"\n },\n \"s3Config\": {\n \"enabled\": true,\n \"endpoint\": \"https://s3.amazonaws.com\",\n \"region\": \"us-east-1\",\n \"bucket\": \"my-whatsapp-media\",\n \"access_key\": \"[REDACTED_AWS_KEY]\",\n \"secret_key\": \"wJalrXUtnFEMI/K7MDENG/bPxRfiCYEXAMPLE\",\n \"path_style\": false,\n \"public_url\": \"https://cdn.example.com\",\n \"media_delivery\": \"both\",\n \"retention_days\": 30,\n \"disable_acl\": true\n },\n \"rabbitmqConfig\": {\n \"enabled\": true,\n \"url\": \"amqp://guest:guest@localhost:5672/\",\n \"exchange\": \"whatsapp.events\",\n \"exchange_type\": \"topic\",\n \"queue\": \"whatsapp.user.{user_id}\",\n \"queue_type\": \"classic\",\n \"routing_key\": \"whatsapp.{event_type}\",\n \"events\": \"All\",\n \"durable\": true,\n \"auto_delete\": false,\n \"exclusive\": false,\n \"no_wait\": false,\n \"delivery_mode\": 2\n },\n \"whatsappConfig\": {\n \"waVersion\": \"2.3000.1027949008\",\n \"waPlatform\": \"WEB\",\n \"waReleaseChannel\": \"RELEASE\",\n \"waWebSubPlatform\": \"WEB_BROWSER\",\n \"waOSName\": \"Mac OS 10\",\n \"waOSVersion\": \"10.15.7\",\n \"waDeviceName\": \"Desktop\",\n \"waManufacturer\": \"Apple\",\n \"waDeviceBoard\": \"Mac-123456\",\n \"waLocaleLanguage\": \"en\",\n \"waLocaleCountry\": \"US\",\n \"waMCC\": \"000\",\n \"waMNC\": \"000\",\n \"waConnectType\": \"WIFI_UNKNOWN\",\n \"waPlatformType\": \"DESKTOP\"\n }\n}", /opt/mia-bot/docs/1781895813383263.json:212: "raw": "// 📝 Create a new DinastiAPI user account\n// 🔗 POST /admin/users\n// 💡 All optional fields included for complete reference\n\n{\n \"name\": \"John Doe\",\n \"token\": \"1234ABCD\",\n \"webhook\": \"https://webhook.site/1234567890\",\n \"events\": \"All\",\n \"echoApiMessages\": false,\n \"skipMedia\": false,\n \"skipGroups\": false,\n \"skipNewsletters\": false,\n \"skipBroadcasts\": false,\n \"skipOwnMessages\": false,\n \"skipCalls\": false,\n \"callRejectMessage\": \"Sorry, I cannot take calls at the moment.\",\n \"callRejectType\": \"busy\",\n \"globalTransportSkips\": {\n \"skipGlobalWebhook\": false,\n \"skipGlobalRabbitMQ\": false,\n \"skipGlobalSQS\": false,\n \"skipGlobalRedis\": false,\n \"skipGlobalWebSocket\": false,\n \"skipGlobalS3\": false\n },\n \"proxyConfig\": {\n \"enabled\": true,\n \"proxyURL\": \"https://serverproxy.com:9080\"\n },\n \"s3Config\": {\n \"enabled\": true,\n \"endpoint\": \"https://s3.amazonaws.com\",\n \"region\": \"us-east-1\",\n \"bucket\": \"my-whatsapp-media\",\n \"access_key\": \"[REDACTED_AWS_KEY]\",\n \"secret_key\": \"wJalrXUtnFEMI/K7MDENG/bPxRfiCYEXAMPLE\",\n \"path_style\": false,\n \"public_url\": \"https://cdn.example.com\",\n \"media_delivery\": \"both\",\n \"retention_days\": 30,\n \"disable_acl\": true\n },\n \"rabbitmqConfig\": {\n \"enabled\": true,\n \"url\": \"amqp://guest:guest@localhost:5672/\",\n \"exchange\": \"whatsapp.events\",\n \"exchange_type\": \"topic\",\n \"queue\": \"whatsapp.user.{user_id}\",\n \"queue_type\": \"classic\",\n \"routing_key\": \"whatsapp.{event_type}\",\n \"events\": \"All\",\n \"durable\": true,\n \"auto_delete\": false,\n \"exclusive\": false,\n \"no_wait\": false,\n \"delivery_mode\": 2\n },\n \"whatsappConfig\": {\n \"waVersion\": \"2.3000.1027949008\",\n \"waPlatform\": \"WEB\",\n \"waReleaseChannel\": \"RELEASE\",\n \"waWebSubPlatform\": \"WEB_BROWSER\",\n \"waOSName\": \"Mac OS 10\",\n \"waOSVersion\": \"10.15.7\",\n \"waDeviceName\": \"Desktop\",\n \"waManufacturer\": \"Apple\",\n \"waDeviceBoard\": \"Mac-123456\",\n \"waLocaleLanguage\": \"en\",\n \"waLocaleCountry\": \"US\",\n \"waMCC\": \"000\",\n \"waMNC\": \"000\",\n \"waConnectType\": \"WIFI_UNKNOWN\",\n \"waPlatformType\": \"DESKTOP\"\n }\n}", /opt/mia-bot/docs/1781895813383263.json:1807: "raw": "// 📝 Configure S3 Storage\n// 🔗 POST /session/s3/config\n// 💡 All optional fields included for complete reference\n\n{\n \"enabled\": true,\n \"endpoint\": \"https://s3.amazonaws.com\",\n \"region\": \"us-east-1\",\n \"bucket\": \"my-whatsapp-media\",\n \"access_key\": \"[REDACTED_AWS_KEY]\",\n \"secret_key\": \"wJalrXUtnFEMI/K7MDENG/bPxRfiCYEXAMPLEKEY\",\n \"path_style\": false,\n \"public_url\": \"https://cdn.example.com\",\n \"media_delivery\": \"both\",\n \"retention_days\": 1,\n \"disable_acl\": true\n}", ``` ## META_TOKEN — 1 ocorrência(s) ``` /opt/mia-bot/sent/1785261426518381568.json:1:{"text": "❌ Erro no hotmart_to_meta_audience: 400 Client Error: Bad Request for url: https://graph.facebook.com/v21.0/120249797003050103/users?access_token=[REDACTED_META_TOKEN]"} ``` ## RESUMO | Tipo | Ocorrências | |------|------------| | HOTMART_HOT | 0 | | ELEVENLABS | 0 | | SLACK_BOT | 0 | | GOOGLE_API | 0 | | GOOGLE_OAUTH | 0 | | STRIPE_PUB | 0 | | SENDGRID | 0 | | EVOLUTION_KEY | 0 | | STRIPE_SECRET | 0 | | GHL_PIT | 24 | | OPENAI | 0 | | AWS_KEY | 6 | | ANTHROPIC | 0 | | ASAAS | 0 | | GITHUB | 0 | | META_TOKEN | 1 | **Total geral: 31 ocorrências**