AutomationFlowsAI & RAG › Analyze Youtube Comments with Openai and Send Reports via Email and Chat

Analyze Youtube Comments with Openai and Send Reports via Email and Chat

BySpaGreen Creative @spagreen on n8n.io

This advanced n8n workflow is designed for YouTube content creators, social media managers, digital marketers, and agency owners who need a deep, automated understanding of their video performance. It acts as a virtual audience research analyst, automatically fetching video…

Event trigger★★★★☆ complexityAI-powered25 nodesGmailGoogle DriveTelegramTelegram TriggerN8N Nodes RapiwaAgentOpenAI Chat
AI & RAG Trigger: Event Nodes: 25 Complexity: ★★★★☆ AI nodes: yes Added:

This workflow corresponds to n8n.io template #15806 — we link there as the canonical source.

This workflow follows the Agent → Gmail recipe pattern — see all workflows that pair these two integrations.

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 →

Download .json
{
  "id": "FPFIxyzdAgTUt9iz",
  "meta": {
    "templateCredsSetupCompleted": true
  },
  "name": "Automated YouTube Comment Analysis & Reporting",
  "tags": [],
  "nodes": [
    {
      "id": "39171489-f6d3-41a0-a739-49479440213d",
      "name": "Sticky Note10",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -320,
        320
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "80d73b1d-c6a7-45a0-b936-de302ecd96cf",
      "name": "Gmail Report",
      "type": "n8n-nodes-base.gmail",
      "position": [
        1472,
        848
      ],
      "parameters": {},
      "executeOnce": true,
      "typeVersion": 2.1
    },
    {
      "id": "305e12c3-7565-4243-80ce-d4e57bdd2efc",
      "name": "Sticky Note",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        800,
        768
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "1ae78778-0d75-4446-bec7-36f94dc1ab2f",
      "name": "Save Report to Google Drive",
      "type": "n8n-nodes-base.googleDrive",
      "position": [
        1328,
        896
      ],
      "parameters": {},
      "executeOnce": true,
      "retryOnFail": false,
      "typeVersion": 3
    },
    {
      "id": "9bfbbab3-aa7e-40f3-a701-3871878e3f85",
      "name": "If",
      "type": "n8n-nodes-base.if",
      "position": [
        848,
        368
      ],
      "parameters": {},
      "typeVersion": 2.3
    },
    {
      "id": "0c0bf417-db09-4392-9fb2-f6d2edad3874",
      "name": "Code (Check Video ID & if exist then Separate it)",
      "type": "n8n-nodes-base.code",
      "position": [
        672,
        368
      ],
      "parameters": {},
      "typeVersion": 2
    },
    {
      "id": "23fa1029-0480-47a3-91d4-a9bf319012e1",
      "name": "No Operation, do nothing",
      "type": "n8n-nodes-base.noOp",
      "position": [
        160,
        384
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "eeacd1e9-4a13-44b2-8bcd-a09261159128",
      "name": "If (Check Admin)",
      "type": "n8n-nodes-base.if",
      "position": [
        -96,
        512
      ],
      "parameters": {},
      "typeVersion": 2.3
    },
    {
      "id": "455139de-e220-44f3-8d76-e7d4063a3c9a",
      "name": "If (Check Perfect Message for 'SEO Analysis')",
      "type": "n8n-nodes-base.if",
      "position": [
        464,
        384
      ],
      "parameters": {},
      "typeVersion": 2.3
    },
    {
      "id": "e2f048b0-f813-493b-bfc5-7fcac93c47ec",
      "name": "If (Check User Message)",
      "type": "n8n-nodes-base.if",
      "position": [
        160,
        592
      ],
      "parameters": {},
      "typeVersion": 2.3
    },
    {
      "id": "45429ad2-c640-454e-872d-8b8dd8f92f87",
      "name": "Send a alert message to Admin",
      "type": "n8n-nodes-base.telegram",
      "position": [
        320,
        480
      ],
      "parameters": {},
      "typeVersion": 1.2
    },
    {
      "id": "9d69b730-c303-47d7-840c-c4c054406074",
      "name": "Telegram Trigger1",
      "type": "n8n-nodes-base.telegramTrigger",
      "position": [
        -288,
        512
      ],
      "parameters": {},
      "typeVersion": 1.2
    },
    {
      "id": "d63d951a-392d-43cd-b268-f6580adf887c",
      "name": "Sticky Note15",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -112,
        832
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "27e1a240-2356-4ade-9dd9-7c6e737dd847",
      "name": "Split Out Comments",
      "type": "n8n-nodes-base.splitOut",
      "position": [
        176,
        848
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "db414175-45bf-4ae0-8b3e-bcf17d6e9fcd",
      "name": "Combine Comments",
      "type": "n8n-nodes-base.summarize",
      "position": [
        368,
        848
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "947fc31f-fa03-4ea3-9470-d6a0e0ee36ce",
      "name": "Create One JSON Object",
      "type": "n8n-nodes-base.aggregate",
      "position": [
        608,
        848
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "3317a6c2-122c-45a1-8d6a-93add8b80a8a",
      "name": "Sticky Note1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -320,
        768
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "bcae189d-8e76-4c66-8236-7a7182f14393",
      "name": "Send a text message",
      "type": "n8n-nodes-base.telegram",
      "position": [
        1488,
        992
      ],
      "parameters": {},
      "executeOnce": true,
      "typeVersion": 1.2
    },
    {
      "id": "04fc28d3-a755-4ad7-8458-6e0b8c952206",
      "name": "Rapiwa",
      "type": "n8n-nodes-rapiwa.rapiwa",
      "position": [
        1328,
        1072
      ],
      "parameters": {},
      "executeOnce": true,
      "typeVersion": 1
    },
    {
      "id": "8df8ad18-1b46-4f56-a787-c08552f57f8e",
      "name": "Edit Fields (Set API key)",
      "type": "n8n-nodes-base.set",
      "position": [
        -256,
        848
      ],
      "parameters": {},
      "typeVersion": 3.4
    },
    {
      "id": "b9c66935-39e3-4bf4-b5d1-e4aa5db0ae52",
      "name": "Code (Make Video Comments Pagination)",
      "type": "n8n-nodes-base.code",
      "position": [
        -32,
        848
      ],
      "parameters": {},
      "typeVersion": 2
    },
    {
      "id": "7ac1eef5-48d6-46c1-a8d7-cf97c312f271",
      "name": "YouTube Video Report AI",
      "type": "@n8n/n8n-nodes-langchain.agent",
      "position": [
        832,
        848
      ],
      "parameters": {},
      "typeVersion": 1.7
    },
    {
      "id": "eeecada8-dd32-44f4-8c7f-4bae684d360c",
      "name": "Markdown to HTML Format",
      "type": "n8n-nodes-base.markdown",
      "position": [
        1136,
        848
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "d62ae7ed-24e5-4272-982e-509f607f739d",
      "name": "OpenAI",
      "type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
      "position": [
        832,
        1008
      ],
      "parameters": {},
      "typeVersion": 1.3
    },
    {
      "id": "84bb1c5e-dd04-49c0-8ba6-77d1aa00c458",
      "name": "Sticky Note3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -816,
        320
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    }
  ],
  "active": false,
  "settings": {
    "availableInMCP": false,
    "executionOrder": "v1"
  },
  "versionId": "b090b066-8e05-4c41-9a76-4d81c6e259ed",
  "connections": {
    "If": {
      "main": [
        [
          {
            "node": "Edit Fields (Set API key)",
            "type": "main",
            "index": 0
          }
        ],
        []
      ]
    },
    "OpenAI": {
      "ai_languageModel": [
        [
          {
            "node": "YouTube Video Report AI",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "Combine Comments": {
      "main": [
        [
          {
            "node": "Create One JSON Object",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "If (Check Admin)": {
      "main": [
        [
          {
            "node": "No Operation, do nothing",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "If (Check User Message)",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Telegram Trigger1": {
      "main": [
        [
          {
            "node": "If (Check Admin)",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Split Out Comments": {
      "main": [
        [
          {
            "node": "Combine Comments",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Create One JSON Object": {
      "main": [
        [
          {
            "node": "YouTube Video Report AI",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "If (Check User Message)": {
      "main": [
        [
          {
            "node": "Send a alert message to Admin",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Markdown to HTML Format": {
      "main": [
        [
          {
            "node": "Gmail Report",
            "type": "main",
            "index": 0
          },
          {
            "node": "Save Report to Google Drive",
            "type": "main",
            "index": 0
          },
          {
            "node": "Send a text message",
            "type": "main",
            "index": 0
          },
          {
            "node": "Rapiwa",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "YouTube Video Report AI": {
      "main": [
        [
          {
            "node": "Markdown to HTML Format",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "No Operation, do nothing": {
      "main": [
        [
          {
            "node": "If (Check Perfect Message for 'SEO Analysis')",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Edit Fields (Set API key)": {
      "main": [
        [
          {
            "node": "Code (Make Video Comments Pagination)",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Code (Make Video Comments Pagination)": {
      "main": [
        [
          {
            "node": "Split Out Comments",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "If (Check Perfect Message for 'SEO Analysis')": {
      "main": [
        [
          {
            "node": "Code (Check Video ID & if exist then Separate it)",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Code (Check Video ID & if exist then Separate it)": {
      "main": [
        [
          {
            "node": "If",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}
Pro

For the full experience including quality scoring and batch install features for each workflow upgrade to Pro

About this workflow

This advanced n8n workflow is designed for YouTube content creators, social media managers, digital marketers, and agency owners who need a deep, automated understanding of their video performance. It acts as a virtual audience research analyst, automatically fetching video…

Source: https://n8n.io/workflows/15806/ — original creator credit. Request a take-down →

More AI & RAG workflows → · Browse all categories →

Related workflows

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

AI & RAG

Inbox Guardian. Uses gmailTrigger, lmChatOpenAi, agent, textClassifier. Event-driven trigger; 66 nodes.

Gmail Trigger, OpenAI Chat, Agent +12
AI & RAG

This workflow helps Customer Success Managers brain dump their client knowledge via voice notes and kickstart business review preparation by auto-generating a structured Google Slides draft in their o

Google Drive, Gmail, Telegram Trigger +7
AI & RAG

Generate AI viral videos with NanoBanana & VEO3, shared on socials via Blotato 2. Uses @blotato/n8n-nodes-blotato, googleSheets, lmChatOpenAi, toolThink. Event-driven trigger; 94 nodes.

@Blotato/N8N Nodes Blotato, Google Sheets, OpenAI Chat +9
AI & RAG

Arvifund - Supabase. Uses httpRequest, telegram, googleSheets, telegramTrigger. Event-driven trigger; 90 nodes.

HTTP Request, Telegram, Google Sheets +8
AI & RAG

Arvifund - Supabase (Fixed v2). Uses httpRequest, telegram, googleSheets, telegramTrigger. Event-driven trigger; 90 nodes.

HTTP Request, Telegram, Google Sheets +9