{
  "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(' ','');\nvar ddd = telefone.slice(2,4);\nvar ddi = telefone.charAt(0);\nvar ddx = telefone.slice(0,2);\nvar length = telefone.length;\nif (length >= 12){\n  if (ddi == '+'){\n    ddi = telefone.slice(0,3);\n    telefone = parseInt(telefone.slice(3)).toString();\n  } else {\n    if (ddx == '55'){\n      telefone = parseInt(telefone.slice(2)).toString();\n      ddi = \"+55\";\n    } else {\n      telefone = parseInt(telefone).toString();\n      ddi = 'não informado';\n    }\n  }\n} else {\n  telefone = parseInt(telefone).toString();\n  ddi = 'não informado';\n}\n\nddd = telefone.slice(0,2);\ntelefone = telefone.slice(2);\nif (ddd > 28){\n  telefone = telefone.slice(-8);\n} else {\n  telefone = '9'+telefone.slice(-8);\n}\nvar whatsapp_formatado = '+55'+ddd+telefone;\n\nreturn [\n  {\n    json: {\n      ddi,\n      ddd,\n      telefone,\n      whatsapp_formatado,   \n    }\n  }\n];"
      },
      "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
          }
        ]
      ]
    }
  }
}