{
"meta": {
"instanceId": "7350ad64699d4a716bb17e2ac4a1abdc5dd751423501ba26d218b248995d24d7"
},
"nodes": [
{
"parameters": {},
"id": "a91519bb-c58f-4dda-a056-84a9768ff149",
"name": "Start",
"type": "n8n-nodes-base.start",
"typeVersion": 1,
"position": [
220,
980
]
},
{
"parameters": {
"sheetId": "1K3Due-xPhv0s6_k7mv7FFKM79gyR3tTwtAVu0hK95y8",
"options": {}
},
"id": "a3fe0f38-5564-4dc3-b1ff-bd7afea8559e",
"name": "Google Sheets1",
"type": "n8n-nodes-base.googleSheets",
"typeVersion": 2,
"position": [
480,
980
],
"credentials": {
"googleSheetsOAuth2Api": {
"id": "2",
"name": "Jean - BotConversa"
}
}
},
{
"parameters": {
"batchSize": 1,
"options": {}
},
"id": "c4432761-a670-4d73-a8ea-ef1b3bdc4a43",
"name": "SplitInBatches1",
"type": "n8n-nodes-base.splitInBatches",
"typeVersion": 1,
"position": [
760,
980
]
},
{
"parameters": {
"values": {
"string": [
{
"name": "Data atual",
"value": "={{$now}}"
},
{
"name": "Data aniversário",
"value": "={{ $json[\"Data nascimento\"] }}"
}
]
},
"options": {}
},
"id": "6d602d60-3cea-44a6-aba4-bc9dd7a19f93",
"name": "Datas",
"type": "n8n-nodes-base.set",
"typeVersion": 1,
"position": [
980,
980
]
},
{
"parameters": {
"conditions": {
"string": [
{
"value1": "={{ $json[\"Data atual\"].split('T')[0].split('-').reverse().join('/').slice(0,5)}}",
"value2": "={{ $json[\"Data aniversário\"].slice(0,5)}}"
}
]
}
},
"id": "73fad30f-15fb-48c9-a511-678926a37fca",
"name": "IF1",
"type": "n8n-nodes-base.if",
"typeVersion": 1,
"position": [
1200,
980
]
},
{
"parameters": {},
"id": "d9d19882-caa9-46ec-825a-40792d975ea0",
"name": "Falso",
"type": "n8n-nodes-base.noOp",
"typeVersion": 1,
"position": [
1440,
1120
]
},
{
"parameters": {},
"id": "4d6146a1-5781-473b-8124-88b7cfae60fe",
"name": "Verdadeiro",
"type": "n8n-nodes-base.noOp",
"typeVersion": 1,
"position": [
1360,
720
]
},
{
"parameters": {
"functionCode": "var telefone = items[0].json.telefone.replace(' ','').replace('(','').replace(')','').replace(' ','').replace(' ','').replace('-','').replace(' ','');
var ddd = telefone.slice(2,4);
var ddi = telefone.charAt(0);
var ddx = telefone.slice(0,2);
var length = telefone.length;
if (length >= 12){
if (ddi == '+'){
ddi = telefone.slice(0,3);
telefone = parseInt(telefone.slice(3)).toString();
} else {
if (ddx == '55'){
telefone = parseInt(telefone.slice(2)).toString();
ddi = \"+55\";
} else {
telefone = parseInt(telefone).toString();
ddi = 'não informado';
}
}
} else {
telefone = parseInt(telefone).toString();
ddi = 'não informado';
}

ddd = telefone.slice(0,2);
telefone = telefone.slice(2);
if (ddd > 28){
telefone = telefone.slice(-8);
} else {
telefone = '9'+telefone.slice(-8);
}
var whatsapp_formatado = '+55'+ddd+telefone;

return [
{
json: {
ddi,
ddd,
telefone,
whatsapp_formatado,
}
}
];"
},
"name": "Validar Telefone",
"type": "n8n-nodes-base.function",
"position": [
1780,
720
],
"typeVersion": 1,
"id": "ecb2d4ae-aa38-42ce-8fc3-46ddfc859c84"
},
{
"parameters": {
"values": {
"string": [
{
"name": "telefone",
"value": "=+{{ $node[\"SplitInBatches1\"].json[\"Telefone\"].toString()}}"
}
]
},
"options": {}
},
"id": "41a4d15f-16a9-4280-9bd4-3ee179eb53ca",
"name": "Telefone",
"type": "n8n-nodes-base.set",
"typeVersion": 1,
"position": [
1580,
720
]
},
{
"parameters": {
"authentication": "genericCredentialType",
"genericAuthType": "httpHeaderAuth",
"requestMethod": "POST",
"url": "=https://backend.botconversa.com.br/api/v1/webhook/subscriber/",
"options": {},
"bodyParametersUi": {
"parameter": [
{
"name": "phone",
"value": "={{ $json[\"whatsapp_formatado\"] }}"
},
{
"name": "first_name",
"value": "={{ $node[\"SplitInBatches1\"].json[\"Nome\"].split(' ')[0]}}"
},
{
"name": "last_name",
"value": "={{ $node[\"SplitInBatches1\"].json[\"Nome\"].split(' ')[1]}} {{ $node[\"SplitInBatches1\"].json[\"Nome\"].split(' ')[2]}} {{ $node[\"SplitInBatches1\"].json[\"Nome\"].split(' ')[3]}}"
}
]
}
},
"id": "64feb937-57e7-45f1-8876-5b5204e5c3dc",
"name": "Cadastrar na audiência",
"type": "n8n-nodes-base.httpRequest",
"typeVersion": 2,
"position": [
2000,
720
],
"credentials": {
"httpHeaderAuth": {
"id": "29",
"name": "Chave API AULA AVANCADA"
}
},
"continueOnFail": true
},
{
"parameters": {
"authentication": "genericCredentialType",
"genericAuthType": "httpHeaderAuth",
"url": "=https://backend.botconversa.com.br/api/v1/webhook/subscriber/{{$node[\"Validar Telefone\"].json[\"whatsapp_formatado\"]}}/",
"options": {}
},
"id": "e29cd653-f228-4753-b8b9-bfae00c248a1",
"name": "Buscar ID audiência",
"type": "n8n-nodes-base.httpRequest",
"typeVersion": 2,
"position": [
2240,
720
],
"credentials": {
"httpHeaderAuth": {
"id": "29",
"name": "Chave API AULA AVANCADA"
}
},
"continueOnFail": true
},
{
"parameters": {
"authentication": "genericCredentialType",
"genericAuthType": "httpHeaderAuth",
"requestMethod": "POST",
"url": "=https://backend.botconversa.com.br/api/v1/webhook/subscriber/{{$node[\"Buscar ID audiência\"].json[\"id\"]}}/send_flow/",
"options": {},
"bodyParametersUi": {
"parameter": [
{
"name": "flow",
"value": "513439"
}
]
}
},
"id": "fa966ac6-6b2d-490c-a156-73e645d23f2c",
"name": "Enviar fluxo",
"type": "n8n-nodes-base.httpRequest",
"typeVersion": 2,
"position": [
2460,
720
],
"credentials": {
"httpHeaderAuth": {
"id": "29",
"name": "Chave API AULA AVANCADA"
}
},
"continueOnFail": true
},
{
"parameters": {
"amount": 10,
"unit": "seconds"
},
"id": "c6d61939-b019-4e79-9709-faea653358c6",
"name": "Wait",
"type": "n8n-nodes-base.wait",
"typeVersion": 1,
"position": [
2680,
720
],
"webhookId": "e35786b3-63cf-41d5-a5c4-ba631345ad81"
},
{
"parameters": {
"triggerTimes": {
"item": [
{
"hour": 8
}
]
}
},
"id": "ebb80a39-c028-48b8-b2a7-a947fd816317",
"name": "Cron",
"type": "n8n-nodes-base.cron",
"typeVersion": 1,
"position": [
220,
1160
]
}
],
"connections": {
"Start": {
"main": [
[
{
"node": "Google Sheets1",
"type": "main",
"index": 0
}
]
]
},
"Google Sheets1": {
"main": [
[
{
"node": "SplitInBatches1",
"type": "main",
"index": 0
}
]
]
},
"SplitInBatches1": {
"main": [
[
{
"node": "Datas",
"type": "main",
"index": 0
}
]
]
},
"Datas": {
"main": [
[
{
"node": "IF1",
"type": "main",
"index": 0
}
]
]
},
"IF1": {
"main": [
[
{
"node": "Verdadeiro",
"type": "main",
"index": 0
}
],
[
{
"node": "Falso",
"type": "main",
"index": 0
}
]
]
},
"Falso": {
"main": [
[
{
"node": "SplitInBatches1",
"type": "main",
"index": 0
}
]
]
},
"Verdadeiro": {
"main": [
[
{
"node": "Telefone",
"type": "main",
"index": 0
}
]
]
},
"Validar Telefone": {
"main": [
[
{
"node": "Cadastrar na audiência",
"type": "main",
"index": 0
}
]
]
},
"Telefone": {
"main": [
[
{
"node": "Validar Telefone",
"type": "main",
"index": 0
}
]
]
},
"Cadastrar na audiência": {
"main": [
[
{
"node": "Buscar ID audiência",
"type": "main",
"index": 0
}
]
]
},
"Buscar ID audiência": {
"main": [
[
{
"node": "Enviar fluxo",
"type": "main",
"index": 0
}
]
]
},
"Enviar fluxo": {
"main": [
[
{
"node": "Wait",
"type": "main",
"index": 0
}
]
]
},
"Wait": {
"main": [
[
{
"node": "SplitInBatches1",
"type": "main",
"index": 0
}
]
]
},
"Cron": {
"main": [
[
{
"node": "Google Sheets1",
"type": "main",
"index": 0
}
]
]
}
}
}