Leadcapture - Relatório Diário

The workflow JSON

Copy or download the full n8n JSON below. Paste it into a new n8n workflow, add your credentials, activate. Full import guide →

{
  "name": "LeadCapture - Relat\u00f3rio Di\u00e1rio",
  "nodes": [
    {
      "parameters": {
        "rule": {
          "interval": [
            {
              "field": "cronExpression",
              "expression": "0 8 * * *"
            }
          ]
        }
      },
      "id": "cron-trigger",
      "name": "Todo dia 8h",
      "type": "n8n-nodes-base.scheduleTrigger",
      "typeVersion": 1.1,
      "position": [
        250,
        300
      ]
    },
    {
      "parameters": {
        "method": "GET",
        "url": "={{ $env.API_URL }}/api/leads/stats/daily",
        "sendQuery": true,
        "queryParameters": {
          "parameters": [
            {
              "name": "tenant_id",
              "value": "all"
            }
          ]
        }
      },
      "id": "get-stats",
      "name": "Buscar Estat\u00edsticas",
      "type": "n8n-nodes-base.httpRequest",
      "typeVersion": 4.1,
      "position": [
        500,
        300
      ]
    },
    {
      "parameters": {
        "jsCode": "const stats = $input.all()[0].json;\n\nconst report = {\n  date: new Date().toLocaleDateString('pt-BR'),\n  totalLeads: stats.total || 0,\n  hotLeads: stats.hot || 0,\n  warmLeads: stats.warm || 0,\n  coldLeads: stats.cold || 0,\n  totalCapital: stats.capital || 0,\n  conversions: stats.conversions || 0,\n  topConsultants: stats.topConsultants || []\n};\n\nconst message = `\ud83d\udcca *RELAT\u00d3RIO DI\u00c1RIO - LeadCapture Pro*\n\ud83d\udcc5 ${report.date}\n\n\ud83d\udcc8 *M\u00e9tricas do Dia:*\n\u2022 Total de Leads: ${report.totalLeads}\n\u2022 \ud83d\udd25 Hot: ${report.hotLeads}\n\u2022 \ud83c\udf24\ufe0f Warm: ${report.warmLeads}\n\u2022 \u2744\ufe0f Cold: ${report.coldLeads}\n\n\ud83d\udcb0 *Capital Total:* R$ ${report.totalCapital.toLocaleString('pt-BR')}\n\u2705 *Convers\u00f5es:* ${report.conversions}\n\n\ud83c\udfc6 *Top Consultores:*\n${report.topConsultants.map((c, i) => `${i + 1}. ${c.nome} - ${c.leads} leads`).join('\\n')}\n\n_Acesse o dashboard para mais detalhes._`;\n\nreturn { message, stats: report };"
      },
      "id": "format-report",
      "name": "Formatar Relat\u00f3rio",
      "type": "n8n-nodes-base.code",
      "typeVersion": 2,
      "position": [
        750,
        300
      ]
    },
    {
      "parameters": {
        "method": "POST",
        "url": "={{ $env.SLACK_WEBHOOK_URL }}",
        "sendBody": true,
        "bodyParameters": {
          "parameters": [
            {
              "name": "text",
              "value": "={{ $json.message }}"
            }
          ]
        }
      },
      "id": "send-slack",
      "name": "Enviar Slack",
      "type": "n8n-nodes-base.httpRequest",
      "typeVersion": 4.1,
      "position": [
        1000,
        200
      ]
    },
    {
      "parameters": {
        "method": "POST",
        "url": "={{ $env.EVOLUTION_API_URL }}/message/sendText/{{ $env.EVOLUTION_INSTANCE }}",
        "sendHeaders": true,
        "headerParameters": {
          "parameters": [
            {
              "name": "apikey",
              "value": "={{ $env.EVOLUTION_API_KEY }}"
            },
            {
              "name": "Content-Type",
              "value": "application/json"
            }
          ]
        },
        "sendBody": true,
        "bodyParameters": {
          "parameters": [
            {
              "name": "number",
              "value": "={{ $env.ADMIN_PHONE }}"
            },
            {
              "name": "textMessage",
              "value": "={ \"text\": \"{{ $json.message }}\" }"
            }
          ]
        }
      },
      "id": "send-whatsapp",
      "name": "Enviar WhatsApp Admin",
      "type": "n8n-nodes-base.httpRequest",
      "typeVersion": 4.1,
      "position": [
        1000,
        400
      ]
    }
  ],
  "connections": {
    "Todo dia 8h": {
      "main": [
        [
          {
            "node": "Buscar Estat\u00edsticas",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Buscar Estat\u00edsticas": {
      "main": [
        [
          {
            "node": "Formatar Relat\u00f3rio",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Formatar Relat\u00f3rio": {
      "main": [
        [
          {
            "node": "Enviar Slack",
            "type": "main",
            "index": 0
          },
          {
            "node": "Enviar WhatsApp Admin",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  },
  "settings": {
    "executionOrder": "v1"
  },
  "tags": [
    {
      "name": "leadcapture",
      "createdAt": "2024-01-01T00:00:00.000Z"
    },
    {
      "name": "scheduled",
      "createdAt": "2024-01-01T00:00:00.000Z"
    }
  ]
}

About this workflow

LeadCapture - Relatório Diário. Uses httpRequest. Scheduled trigger; 5 nodes.

Source: https://github.com/juzafalao/leadcapture-pro/blob/d243e1d06f3e3b1bdba757646dc47f960c05caba/n8n/daily-report.json — original creator credit. Request a take-down →

More Marketing & Ads workflows → · Browse all categories →

Related workflows

Workflows that share integrations, category, or trigger type with this one. All free to copy and import.