{
  "name": "Automate daily signup stats from PostgreSQL to Slack, Teams & Telegram",
  "nodes": [
    {
      "id": "9bcb46ca-0694-41ee-b700-1dfa22bdb478",
      "name": "Database Config Instructions",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -180,
        200
      ],
      "parameters": {
        "width": 440,
        "height": 580,
        "content": "## 1️⃣ Trigger & Data Fetching\n\n⏰ Daily Report Trigger runs every day at 9:00 AM.\n\n*It triggers 🗄️ Fetch Signup Count, which queries the customers table in PostgreSQL to count the number of new signup"
      }
    },
    {
      "id": "bf6257e2-a159-42d2-9826-68bf692337b0",
      "name": "Messaging Config Instructions",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        280,
        120
      ],
      "parameters": {
        "width": 260,
        "height": 660,
        "content": "## 2️⃣ Report Preparation\n\n📝 Prepare Report Message formats the results into a ready-to-send message.\n\n*It includes the signup count, report date, and a summary message:\n📊 Daily Signup Report – New si"
      }
    },
    {
      "id": "1a8bf7d7-18e7-4b08-947e-6bc189d5a2f5",
      "name": "⏰ Daily Report Trigger",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        -120,
        420
      ]
    },
    {
      "id": "bf7c0220-7aa2-40b0-b12d-3e4756f07130",
      "name": "🗄️ Fetch Signup Count",
      "type": "n8n-nodes-base.postgres",
      "position": [
        100,
        420
      ]
    },
    {
      "id": "998a13b4-e761-47e2-bfac-8b65a3a47dfa",
      "name": "📝 Prepare Report Message",
      "type": "n8n-nodes-base.set",
      "position": [
        360,
        420
      ]
    },
    {
      "id": "8f165983-aa33-489d-bc3c-827b626cd531",
      "name": "💬 Post to Slack",
      "type": "n8n-nodes-base.slack",
      "position": [
        660,
        220
      ]
    },
    {
      "id": "f4130a5a-0473-4e7e-b5cc-00dc33c8775d",
      "name": "📢 Send to Teams",
      "type": "n8n-nodes-base.microsoftTeams",
      "position": [
        660,
        420
      ]
    },
    {
      "id": "13930dd0-dd61-4fb9-857b-f2ca484a1c8e",
      "name": "📲 Send to Telegram",
      "type": "n8n-nodes-base.telegram",
      "position": [
        660,
        620
      ]
    },
    {
      "id": "7447cbfd-709d-4acc-9f66-68f2914edd21",
      "name": "Messaging Config Instructions1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        560,
        -40
      ],
      "parameters": {
        "width": 360,
        "height": 820,
        "content": "## 3️⃣ Multi-Channel Notification Delivery\n\n*The prepared message is sent to multiple platforms in parallel:\n\n💬 Post to Slack\n📢 Send to Teams\n📲 Send to Telegram"
      }
    }
  ],
  "connections": {
    "⏰ Daily Report Trigger": {
      "main": [
        [
          {
            "node": "🗄️ Fetch Signup Count",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "🗄️ Fetch Signup Count": {
      "main": [
        [
          {
            "node": "📝 Prepare Report Message",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "📝 Prepare Report Message": {
      "main": [
        [
          {
            "node": "💬 Post to Slack",
            "type": "main",
            "index": 0
          },
          {
            "node": "📢 Send to Teams",
            "type": "main",
            "index": 0
          },
          {
            "node": "📲 Send to Telegram",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}