25 - 自动化每日注册摘要

• •Slack Bot Token 或 Webhook URL
• •PostgreSQL 数据库连接信息
• •Telegram Bot Token

{
  "name": "25 - 自动化每日注册摘要",
  "nodes": [
    {
      "id": "9bcb46ca-0694-41ee-b700-1dfa22bdb478",
      "name": "数据库配置说明",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -180,
        200
      ],
      "parameters": {
        "color": 4,
        "width": 440,
        "height": 580,
        "content": "## 1️⃣ 触发器与数据获取"
      },
      "typeVersion": 1
    },
    {
      "id": "bf6257e2-a159-42d2-9826-68bf692337b0",
      "name": "消息配置说明",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        280,
        120
      ],
      "parameters": {
        "color": 5,
        "width": 260,
        "height": 660,
        "content": "## 2️⃣ 报告准备"
      },
      "typeVersion": 1
    },
    {
      "id": "1a8bf7d7-18e7-4b08-947e-6bc189d5a2f5",
      "name": "⏰ 每日报告触发器",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        -120,
        420
      ],
      "parameters": {
        "rule": {
          "interval": [
            {
              "triggerAtHour": 9
            }
          ]
        }
      },
      "typeVersion": 1.2
    },
    {
      "id": "bf7c0220-7aa2-40b0-b12d-3e4756f07130",
      "name": "🗄️ 获取注册数量",
      "type": "n8n-nodes-base.postgres",
      "position": [
        100,
        420
      ],
      "parameters": {
        "query": "-- EDIT: Replace 'users' with your table name and 'created_at' with your timestamp column\nSELECT COUNT(*) as signup_count \nFROM customers \nWHERE created_at >= NOW() - INTERVAL '24 HOURS';",
        "options": {},
        "operation": "executeQuery"
      },
      "typeVersion": 2.4
    },
    {
      "id": "998a13b4-e761-47e2-bfac-8b65a3a47dfa",
      "name": "📝 准备报告消息",
      "type": "n8n-nodes-base.set",
      "position": [
        360,
        420
      ],
      "parameters": {
        "values": {
          "string": [
            {
              "name": "signup_count",
              "value": "={{ $json.signup_count || 0 }}"
            },
            {
              "name": "report_date",
              "value": "={{ new Date().toLocaleDateString('en-US', { timeZone: 'UTC', year: 'numeric', month: 'long', day: 'numeric' }) }}"
            },
            {
              "name": "message_text",
              "value": "=📊 Daily Signup Report\nNew signups in the last 24h: {{ $json.signup_count || 0 }}"
            }
          ]
        },
        "options": {}
      },
      "typeVersion": 2
    },
    {
      "id": "8f165983-aa33-489d-bc3c-827b626cd531",
      "name": "💬 发布到Slack",
      "type": "n8n-nodes-base.slack",
      "position": [
        660,
        220
      ],
      "parameters": {
        "text": "={{ $node['📝 Prepare Report Message'].json.message_text }}",
        "channel": "#general",
        "attachments": [],
        "otherOptions": {}
      },
      "typeVersion": 1
    },
    {
      "id": "f4130a5a-0473-4e7e-b5cc-00dc33c8775d",
      "name": "📢 发送到Teams",
      "type": "n8n-nodes-base.microsoftTeams",
      "position": [
        660,
        420
      ],
      "parameters": {
        "name": "YOUR_CHANNEL_NAME",
        "teamId": "YOUR_TEAM_ID",
        "options": {}
      },
      "typeVersion": 1
    },
    {
      "id": "13930dd0-dd61-4fb9-857b-f2ca484a1c8e",
      "name": "📲 发送到Telegram",
      "type": "n8n-nodes-base.telegram",
      "position": [
        660,
        620
      ],
      "parameters": {
        "text": "={{ $node['📝 Prepare Report Message'].json.message_text }}",
        "chatId": "YOUR_TELEGRAM_CHAT_ID",
        "additionalFields": {
          "appendAttribution": false
        }
      },
      "typeVersion": 1.1
    },
    {
      "id": "7447cbfd-709d-4acc-9f66-68f2914edd21",
      "name": "消息配置说明1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        560,
        -40
      ],
      "parameters": {
        "color": 3,
        "width": 360,
        "height": 820,
        "content": "## 3️⃣ 多渠道通知发送"
      },
      "typeVersion": 1
    }
  ],
  "active": false,
  "pinData": {},
  "settings": {
    "executionOrder": "v1"
  },
  "connections": {
    "1a8bf7d7-18e7-4b08-947e-6bc189d5a2f5": {
      "main": [
        [
          {
            "node": "bf7c0220-7aa2-40b0-b12d-3e4756f07130",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "bf7c0220-7aa2-40b0-b12d-3e4756f07130": {
      "main": [
        [
          {
            "node": "998a13b4-e761-47e2-bfac-8b65a3a47dfa",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "998a13b4-e761-47e2-bfac-8b65a3a47dfa": {
      "main": [
        [
          {
            "node": "8f165983-aa33-489d-bc3c-827b626cd531",
            "type": "main",
            "index": 0
          },
          {
            "node": "f4130a5a-0473-4e7e-b5cc-00dc33c8775d",
            "type": "main",
            "index": 0
          },
          {
            "node": "13930dd0-dd61-4fb9-857b-f2ca484a1c8e",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}