January 22, 2026

YouTube to Gmail, comment insights sent ready to share

Lisa Granqvist Partner Workflow Automation Expert

Get a free AI assessment → ⬇️ Use template

You open YouTube Studio to “quickly” check comments, and suddenly it’s been an hour. You scroll, you spot a few patterns, then you lose them again because there’s no clean way to summarize what people are actually saying.

This YouTube comment insights automation hits content creators first, honestly. But a marketing manager reporting on campaigns and an agency lead juggling client channels feel the same pain: too much raw feedback, not enough clarity. The outcome is simple. You get a share-ready email summary with sentiment, themes, questions, and next actions.

You’ll learn what the workflow does, what you need to run it, and how to adapt it so your team gets insights without living in the comments tab.

How This Automation Works

Here’s the complete workflow you’ll be setting up:

n8n Workflow Template: YouTube to Gmail, comment insights sent ready to share

Click to explore

flowchart LR

    subgraph sg0["Pick Video Ids from Google sheet Flow"]
        direction LR
        n0@{ icon: "mdi:cog", form: "rounded", label: "Limit", pos: "b", h: 48 }
        n1@{ icon: "mdi:robot", form: "rounded", label: "AI Agent", pos: "b", h: 48 }
        n2@{ icon: "mdi:brain", form: "rounded", label: "OpenAI Chat Model", pos: "b", h: 48 }
        n3@{ icon: "mdi:swap-horizontal", form: "rounded", label: "If", pos: "b", h: 48 }
        n4@{ icon: "mdi:swap-vertical", form: "rounded", label: "Set Video Details", pos: "b", h: 48 }
        n5@{ icon: "mdi:cog", form: "rounded", label: "Get Youtube Video Details", pos: "b", h: 48 }
        n6["<div style='background:#f5f5f5;padding:10px;border-radius:8px;display:inline-block;border:1px solid #e0e0e0'><img src='https://flowpast.com/wp-content/uploads/n8n-workflow-icons/httprequest.dark.svg' width='40' height='40' /></div><br/>Get Youtube Video Comments"]
        n7["<div style='background:#f5f5f5;padding:10px;border-radius:8px;display:inline-block;border:1px solid #e0e0e0'><img src='https://flowpast.com/wp-content/uploads/n8n-workflow-icons/code.svg' width='40' height='40' /></div><br/>Prepare Comments Data"]
        n8["<div style='background:#f5f5f5;padding:10px;border-radius:8px;display:inline-block;border:1px solid #e0e0e0'><img src='https://flowpast.com/wp-content/uploads/n8n-workflow-icons/code.svg' width='40' height='40' /></div><br/>Prepare HTML for Email"]
        n9@{ icon: "mdi:message-outline", form: "rounded", label: "Gmail Account Configuration", pos: "b", h: 48 }
        n10@{ icon: "mdi:database", form: "rounded", label: "Update Status on Google Sheet", pos: "b", h: 48 }
        n11@{ icon: "mdi:play-circle", form: "rounded", label: "Pick Video Ids from Google s..", pos: "b", h: 48 }
        n3 --> n0
        n0 --> n4
        n1 --> n8
        n2 -.-> n1
        n4 --> n5
        n7 --> n1
        n8 --> n9
        n5 --> n6
        n6 --> n7
        n9 --> n10
        n11 --> n3
    end

    %% Styling
    classDef trigger fill:#e8f5e9,stroke:#388e3c,stroke-width:2px
    classDef ai fill:#e3f2fd,stroke:#1976d2,stroke-width:2px
    classDef aiModel fill:#e8eaf6,stroke:#3f51b5,stroke-width:2px
    classDef decision fill:#fff8e1,stroke:#f9a825,stroke-width:2px
    classDef database fill:#fce4ec,stroke:#c2185b,stroke-width:2px
    classDef api fill:#fff3e0,stroke:#e65100,stroke-width:2px
    classDef code fill:#f3e5f5,stroke:#7b1fa2,stroke-width:2px
    classDef disabled stroke-dasharray: 5 5,opacity: 0.5
    class n11 trigger
    class n1 ai
    class n2 aiModel
    class n3 decision
    class n10 database
    class n6 api
    class n7,n8 code
    classDef customIcon fill:none,stroke:none
    class n6,n7,n8 customIcon

Why This Matters: Turning Comment Noise Into Decisions

Comments are one of the best “free” research streams you have, but they’re messy. The useful bits are scattered between compliments, inside jokes, and random arguments, and it’s on you to turn all that into something you can act on. Most people try to skim a few dozen comments and call it done. Then a week later you realize viewers asked the same question 50 times, or a negative theme kept repeating, and you missed it because it didn’t jump out in one sitting.

The friction compounds. Not because any single step is hard, but because you repeat it for every video, every week, forever.

Reading 100 comments per video is manageable once, but it becomes a recurring time sink when you publish consistently.
Important feedback gets buried, so you end up making content decisions based on hunches instead of patterns.
Sharing insights with a client or team turns into copy-pasting screenshots and trying to explain “the vibe.”
Without status tracking, you re-check the same videos and still miss new ones that should be reviewed.

What You’ll Build: Google Sheets → AI Analysis → Gmail Report

This workflow turns a simple spreadsheet into a lightweight YouTube research pipeline. You log a YouTube video ID in Google Sheets and mark it as “Pending.” From there, n8n pulls the video’s metadata, fetches up to 100 top comments via the YouTube API (ordered by relevance), and calculates basic engagement metrics from what it collected. Then an AI Agent powered by the OpenAI Chat Model (GPT-4) reads a curated set of comments and produces a structured analysis: sentiment, recurring themes, common questions, and practical recommendations. Finally, the workflow builds a polished HTML email and sends it to you in Gmail, then updates the sheet to “Mail Sent” so it won’t process the same row again.

The flow starts in Google Sheets. It moves through comment collection and AI summarization, then ends with a formatted email you can forward to a client or drop into a weekly report. No extra dashboards to babysit.

What You’re Building

What Gets Automated

What You’ll Achieve

Watching Google Sheets for new rows marked “Pending” and pulling the YouTube Video ID.
Fetching YouTube metadata and up to 100 top comments automatically using the YouTube API.
Calculating comment counts, likes, and reply signals so the AI isn’t guessing.
Generating an HTML email report and sending it via Gmail, then marking the row as “Mail Sent.”

Get an analysis email in about 10–20 minutes instead of reading comments manually.
Spot recurring themes and “video sequel” ideas without hunting for them.
Answer viewer questions faster because they are grouped and summarized.
Make content decisions with evidence, not vague impressions.
Keep a clean processing trail in Sheets so nothing gets double-handled.

Expected Results

Say you publish 3 videos a week and you want real insight from the top 100 comments on each. Manually skimming, sorting, and summarizing usually takes about 45 minutes per video, so you’re spending around 2–3 hours a week just to produce a “best guess” summary. With this workflow, adding the ID to Google Sheets takes a minute, and the rest runs in the background. You typically get the Gmail report after a short wait while comments are fetched and analyzed, and you’re done for the week.

Before You Start

n8n instance (try n8n Cloud free)
Self-hosting option if you prefer (Hostinger works well)
Google Sheets for logging video IDs and status.
Gmail to send the formatted report email.
YouTube API credentials (get them from Google Cloud Console APIs & Services).
OpenAI API key (get it from the OpenAI dashboard).

Skill level: Intermediate. You’ll connect accounts, add API keys, and slightly adjust prompts and email recipients.

Want someone to build this for you? Talk to an automation expert (free 15-minute consultation).

Step by Step

A Google Sheet row is marked “Pending.” The workflow watches your spreadsheet for new or updated rows and only proceeds when the Status column is set correctly.

The workflow fetches YouTube details and comments. Using the YouTube Video ID, it pulls basic metadata, then collects up to 100 top comments via an HTTP request to the YouTube API.

Metrics are calculated and the AI generates insights. A code step prepares comment stats and a trimmed comment set, then the AI Agent (GPT-4 via the OpenAI Chat Model) produces sentiment, themes, viewer questions, and clear recommendations.

A formatted Gmail report is sent and the sheet is updated. Another code step builds the HTML email, Gmail sends it, and the workflow marks the row as “Mail Sent” so you don’t get duplicates.

You can easily modify the analysis prompt to focus on brand mentions, product feedback, or content ideas based on your needs. See the full implementation guide below for customization options.

Step-by-Step Implementation Guide

Step 1: Configure the Google Sheets Trigger

This workflow starts when new or updated rows are detected in your Google Sheet via Retrieve Sheet Video IDs.

Add Retrieve Sheet Video IDs and set Document to [YOUR_ID] and Sheet to Youtube_Video.
Set the polling schedule to Every Minute (already configured in pollTimes).
Credential Required: Connect your Google Sheets credentials.

Step 2: Connect Google Sheets

Use the incoming row data to filter pending items and prepare your video parameters.

In Check Pending Status, confirm the condition compares Status to Pending using {{ $json.Status }}.
In Throttle Items, keep the default limit or set a custom item cap if you want to control throughput.
In Map Video Parameters, set videoId to {{ $json['Youtube video id'] }} and maxComments to 100.

Keep your Google Sheet column names consistent with Youtube video id and Status to avoid missing data when Map Video Parameters runs.

Step 3: Set Up YouTube Data Retrieval

Fetch metadata and comments for the target video ID, then compute summary statistics.

In Fetch YouTube Metadata, set Video ID to {{ $json.videoId }}, Resource to video, and Operation to get.
Credential Required: Connect your YouTube OAuth2 credentials.
In Retrieve YouTube Comments, set URL to https://www.googleapis.com/youtube/v3/commentThreads and keep Authentication as predefinedCredentialType with nodeCredentialType set to youTubeOAuth2Api.
Confirm the query parameters include part snippet, videoId {{ $('Map Video Parameters').item.json.videoId }}, maxResults 100, and order relevance.
In Process Comment Metrics, keep the existing JavaScript to calculate totals, averages, top comments, and sentiment counts.

Credential Required: Connect your YouTube OAuth2 credentials to both Fetch YouTube Metadata and Retrieve YouTube Comments.

Step 4: Set Up AI Analysis

The AI layer analyzes comment text and produces a structured JSON response used in the email report.

In Analyze Comments with AI, keep the Text field as Analyze these comments from the video "{{ $json.videoTitle }}": ... {{ $json.commentTexts }} to pass metrics and comment text into the prompt.
Set or confirm the System Message requires JSON output with keys: overall_sentiment_breakdown, main_themes, common_questions, key_feedback_points, actionable_insights.
In OpenAI Chat Engine, select the model gpt-4o-mini and set Response Format to json_object.
Credential Required: Connect your OpenAI credentials in OpenAI Chat Engine (the AI tool for Analyze Comments with AI).

If the AI response isn't valid JSON, update the system prompt in Analyze Comments with AI to emphasize strict JSON output.

Step 5: Configure Output Actions

Build an HTML email report and send it, then mark the original row as completed.

In Build Email HTML, keep the JavaScript that parses $json.output and generates emailHTML and subject.
In Send Email Report, set Send To to [YOUR_EMAIL], Message to {{ $json.emailHTML }}, and Subject to {{ $json.subject }}.
Credential Required: Connect your Gmail credentials in Send Email Report.
In Mark Sheet as Sent, set Operation to update, match on Id, and update Status to Mail Sent using {{ $('Retrieve Sheet Video IDs').item.json.Id }}.
Credential Required: Connect your Google Sheets credentials in Mark Sheet as Sent.

⚠️ Common Pitfall: If the email content appears blank, confirm Analyze Comments with AI returns valid JSON and Build Email HTML uses JSON.parse($json.output) successfully.

Step 6: Test and Activate Your Workflow

Run a manual test with a “Pending” row to confirm the data pipeline, AI response, and email report.

In your sheet, add a row with a valid Youtube video id and set Status to Pending.
Click Execute Workflow and verify the execution flow: Retrieve Sheet Video IDs → Check Pending Status → Throttle Items → Map Video Parameters → Fetch YouTube Metadata → Retrieve YouTube Comments → Process Comment Metrics → Analyze Comments with AI → Build Email HTML → Send Email Report → Mark Sheet as Sent.
Confirm the email arrives with a subject like YouTube Analysis: [Video Title] - [#] comments analyzed.
Verify the sheet row is updated to Mail Sent in the Status column.
Turn the workflow Active to enable continuous monitoring.

🔒

Unlock Full Step-by-Step Guide

Get the complete implementation guide + downloadable template

Troubleshooting Tips

YouTube API credentials can expire or lack the right scopes. If fetching comments fails, check your Google Cloud Console project, enabled APIs, and quota first.
If you’re using Wait nodes or external processing, timing can be unpredictable. Increase the wait duration if the AI step runs before comments or metrics are fully available.
Default AI prompts are generic. Add your brand voice, what “good feedback” looks like, and the format you prefer early, because otherwise you will keep rewriting the email summary.

Quick Answers

What’s the setup time for this YouTube comment insights automation?

About 30 minutes if you already have your API keys.

Is coding required for this comment insights automation?

No. You’ll mostly connect Google Sheets, Gmail, and paste in API keys, then tweak the AI prompt.

Is n8n free to use for this YouTube comment insights workflow?

Yes. n8n has a free self-hosted option and a free trial on n8n Cloud. Cloud plans start at $20/month for higher volume. You’ll also need to factor in OpenAI API usage (often a few cents per report) and YouTube API quota limits.

Where can I host n8n to run this automation?

Two options: n8n Cloud (managed, easiest setup) or self-hosting on a VPS. For self-hosting, Hostinger VPS is affordable and handles n8n well. Self-hosting gives you unlimited executions but requires basic server management.

Can I modify this YouTube comment insights workflow for different use cases?

Yes, and you should. Most teams start by editing the AI Agent prompt to focus on brand mentions, product feedback, or content ideas, and by changing who receives the Gmail report. You can also adjust the “Retrieve YouTube Comments” step to pull fewer comments for faster runs, or expand it when you’re doing deeper research. If you want the results stored instead of emailed, swap the “Send Email Report” output for a Google Sheets update that writes the summary back into new columns.

Why is my Google Sheets connection failing in this workflow?

Usually it’s permissions or an expired OAuth connection. Reconnect your Google account in n8n, confirm the workflow has access to the exact spreadsheet, and double-check the column names match what the workflow expects (especially “YouTube Video ID” and “Status”).

What volume can this YouTube comment insights workflow process?

It’s designed to scale across many videos, but the practical limit is your n8n executions and API quotas. On n8n Cloud Starter, you can run thousands of executions per month, which is plenty for weekly reporting across a few channels. If you self-host, executions aren’t capped, so it mainly depends on your server and how many videos you queue as “Pending.” The workflow pulls up to 100 comments per video by default, so batching lots of videos at once can increase YouTube API usage and slow processing.

Is this YouTube comment insights automation better than using Zapier or Make?

Often, yes. This workflow benefits from n8n’s flexible logic (filters, code steps, and branching) and the ability to self-host when volume grows. Zapier or Make can work, but AI + API-heavy workflows tend to get expensive or awkward once you add “fetch comments, compute metrics, then format HTML.” If you only need a simple “new row in Sheets → send an email” flow, those tools can be faster to set up. If you’re unsure, Talk to an automation expert and explain your volume and reporting needs.

Once this is running, comment review becomes a repeatable system instead of a weekly rabbit hole. The workflow handles the scroll. You focus on what to change next.

Need Help Setting This Up?

Our automation experts can build and customize this workflow for your specific needs. Free 15-minute consultation—no commitment required.

Lisa Granqvist

Workflow Automation Expert

Expert in workflow automation and no-code tools.

{
"id": null,
"versionId": null,
"name": "Automated YouTube Comment Insight System",
"meta": {
"instanceId": "0096db40aa80a24a6258b084e892fd3dd39c60b6ba5bd3ee76df984c8849cbaa",
"templateCredsSetupCompleted": null,
"templateId": null
},
"nodes": [
{
"id": "flowpast-topbar-4459",
"name": "Flowpast Branding",
"type": "n8n-nodes-base.stickyNote",
"position": [
60,
75
],
"parameters": {
"color": 7,
"width": 995,
"height": 80,
"content": "## Flowpast.com | Automation Workflow Library\n**\ud83d\udcd6 Full tutorial & setup guide:** flowpast.com"
},
"typeVersion": 1
},
{
"id": "b62a4e3a-c843-4ed2-9ee4-cbfb1a218259",
"name": "Retrieve Sheet Video IDs",
"type": "n8n-nodes-base.googleSheetsTrigger",
"position": [
955,
175
],
"parameters": {
"options": [],
"pollTimes": {
"item": [
{
"mode": "everyMinute"
}
]
},
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "[YOUR_ID]",
"cachedResultName": "Youtube_Video "
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "[YOUR_ID]",
"cachedResultUrl": "[YOUR_ID]",
"cachedResultName": "Youtube_Video"
}
},
"typeVersion": 1
},
{
"id": "747fb13b-ee39-4dd7-8338-8db07e3b568e",
"name": "Check Pending Status",
"type": "n8n-nodes-base.if",
"position": [
650,
250
],
"parameters": {
"options": [],
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "5f1eae10-5270-4e99-8627-597e3451c82c",
"operator": {
"name": "filter.operator.equals",
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $json.Status }}",
"rightValue": "Pending"
}
]
}
},
"typeVersion": 2.2
},
{
"id": "d7edbd68-9213-426b-ae6b-71a13bb23690",
"name": "Throttle Items",
"type": "n8n-nodes-base.limit",
"position": [
465,
190
],
"parameters": [],
"typeVersion": 1
},
{
"id": "6895d6b4-4ae4-4092-9302-33b1c69167d6",
"name": "Map Video Parameters",
"type": "n8n-nodes-base.set",
"position": [
240,
265
],
"parameters": {
"options": [],
"assignments": {
"assignments": [
{
"id": "219795ef-daa4-4444-9865-c5d3856be63b",
"name": "videoId",
"type": "string",
"value": "={{ $json['Youtube video id'] }}"
},
{
"id": "cd4f519d-4c84-496c-8974-29ef69c890fc",
"name": "maxComments ",
"type": "number",
"value": 100
}
]
}
},
"typeVersion": 3.4
},
{
"id": "df200d75-d932-4bb4-9e57-16a940963db3",
"name": "Fetch YouTube Metadata",
"type": "n8n-nodes-base.youTube",
"position": [
60,
450
],
"parameters": {
"options": [],
"videoId": "={{ $json.videoId }}",
"resource": "video",
"operation": "get"
},
"typeVersion": 1
},
{
"id": "5346229d-9386-497b-99c7-192e75896bf2",
"name": "Retrieve YouTube Comments",
"type": "n8n-nodes-base.httpRequest",
"position": [
245,
450
],
"parameters": {
"url": "https://www.googleapis.com/youtube/v3/commentThreads",
"options": [],
"sendQuery": true,
"authentication": "predefinedCredentialType",
"queryParameters": {
"parameters": [
{
"name": "part",
"value": "snippet"
},
{
"name": "videoId",
"value": "={{ $('Map Video Parameters').item.json.videoId }}"
},
{
"name": "maxResults",
"value": "100"
},
{
"name": "order",
"value": "relevance"
}
]
},
"nodeCredentialType": "youTubeOAuth2Api"
},
"typeVersion": 4.2
},
{
"id": "ffee99ec-ad6d-4ac9-b0ad-e466a18ad7de",
"name": "Process Comment Metrics",
"type": "n8n-nodes-base.code",
"position": [
570,
465
],
"parameters": {
"jsCode": "// Get comments from HTTP Request node\nconst comments = $input.first().json.items\n//const comments = response.items || [];\n\n// Get video title from the YouTube node (step 5)\n//const videoData = ;\nconst videoTitle = $('Fetch YouTube Metadata').first().json.snippet.title;\n\n// Extract comment data\nconst processedComments = comments.map(item => {\n  const comment = item.snippet.topLevelComment.snippet;\n  return {\n    text: comment.textDisplay,\n    author: comment.authorDisplayName,\n    likes: comment.likeCount || 0,\n    publishedAt: comment.publishedAt,\n    replyCount: item.snippet.totalReplyCount || 0\n  };\n});\n\n// Calculate statistics\nconst totalComments = processedComments.length;\nconst totalLikes = processedComments.reduce((sum, c) => sum + c.likes, 0);\nconst avgLikes = totalComments > 0 ? (totalLikes / totalComments).toFixed(2) : 0;\nconst totalReplies = processedComments.reduce((sum, c) => sum + c.replyCount, 0);\n\n// Get top comments by likes\nconst topComments = processedComments\n  .sort((a, b) => b.likes - a.likes)\n  .slice(0, 5);\n\n// Prepare comment texts for AI analysis\nconst commentTexts = processedComments\n  .slice(0, 50) // Limit to 50 comments for AI analysis\n  .map(c => c.text)\n  .join('\\n---\\n');\n\n// Basic sentiment analysis (count positive/negative keywords)\nconst positiveWords = ['love', 'great', 'awesome', 'amazing', 'excellent', 'good', 'fantastic', 'helpful', 'thanks'];\nconst negativeWords = ['hate', 'terrible', 'awful', 'bad', 'worst', 'horrible', 'useless', 'waste'];\n\nlet positiveCount = 0;\nlet negativeCount = 0;\n\nprocessedComments.forEach(comment => {\n  const lowerText = comment.text.toLowerCase();\n  positiveWords.forEach(word => {\n    if (lowerText.includes(word)) positiveCount++;\n  });\n  negativeWords.forEach(word => {\n    if (lowerText.includes(word)) negativeCount++;\n  });\n});\n\nreturn [{\n  json: {\n    videoTitle,\n    totalComments,\n    avgLikes,\n    totalReplies,\n    topComments,\n    commentTexts,\n    processedComments,\n    sentimentCounts: {\n      positive: positiveCount,\n      negative: negativeCount,\n      neutral: totalComments - positiveCount - negativeCount\n    }\n  }\n}];\n\n"
},
"typeVersion": 2
},
{
"id": "42f0f581-57a0-438d-b1a1-29a89e984554",
"name": "Analyze Comments with AI",
"type": "@n8n/n8n-nodes-langchain.agent",
"position": [
755,
460
],
"parameters": {
"text": "=Analyze these comments from the video \"{{ $json.videoTitle }}\":\n\nTotal Comments: {{ $json.totalComments }}\nAverage Likes: {{ $json.avgLikes }}\n\nComments to analyze:\n{{ $json.commentTexts }}",
"options": {
"maxIterations": 100,
"systemMessage": "You are a YouTube comment analyst. Analyze the provided comments and return a structured analysis with:\n1. Overall sentiment breakdown (positive/negative/neutral percentages)\n2. Top 3-5 main themes or topics discussed\n3. Common questions from viewers\n4. Key feedback points and suggestions\n5. Actionable insights for content improvement\n\nFormat your response in clear sections with headers in json key value format and use underscore in the key name. Always use following keys for output json: \n1. overall_sentiment_breakdown\n2. main_themes\n3. common_questions\n4. key_feedback_points\n5. actionable_insights"
},
"promptType": "define"
},
"typeVersion": 1.9
},
{
"id": "35abbd58-e69a-4d86-963e-0a758aaff7b2",
"name": "OpenAI Chat Engine",
"type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
"position": [
900,
670
],
"parameters": {
"model": {
"__rl": true,
"mode": "list",
"value": "gpt-4o-mini"
},
"options": {
"responseFormat": "json_object"
}
},
"typeVersion": 1.2
},
{
"id": "7eab55e1-e9e2-4750-a07d-f02941c7a8c6",
"name": "Build Email HTML",
"type": "n8n-nodes-base.code",
"position": [
520,
760
],
"parameters": {
"mode": "runOnceForEachItem",
"jsCode": "const output = JSON.parse($json.output)\n //return output; \n//return output.overall_sentiment_breakdown.Positive;\n\nlet common_question = \"\";\n  \noutput.common_questions.map(rec => {\n  return common_question += \"<li>\"+rec.trim().replace(new RegExp(\".*,$\"), \"\")+\"</li>\"\n})\n\nlet key_feedback_points_and_suggestions = \"\";\n\noutput.key_feedback_points.map(rec => {\n  return key_feedback_points_and_suggestions += \"<li>\"+rec.trim().replace(new RegExp(\".*,$\"), \"\")+\"</li>\"\n})\n\n\nlet actionable_insights_for_content_improvement = \"\"\n\noutput.actionable_insights.map(rec => {\n  return actionable_insights_for_content_improvement += \"<li>\"+rec.trim().replace(new RegExp(\".*,$\"), \"\")+\"</li>\"\n})\n\n\n// return {common_question};\n\n\n     \n\n//return output; \n// Generate the email HTML\nconst emailHTML = `\n<!DOCTYPE html>\n<html>\n<head>\n  <style>\n    body { font-family: Arial, sans-serif; line-height: 1.6; color: #333; }\n    .header { background: #f4f4f4; padding: 20px; border-radius: 5px; }\n    .section { margin: 20px 0; }\n    .stats { background: #e9ecef; padding: 15px; border-radius: 5px; }\n    .analysis { background: #f8f9fa; padding: 20px; border-radius: 5px; }\n    h2 { color: #2c3e50; }\n    h3 { color: #34495e; }\n    h4 { color: #7f8c8d; }\n    .footer { margin-top: 30px; padding-top: 20px; border-top: 1px solid #ddd; color: #666; font-size: 0.9em; }\n  </style>\n<link rel="preload" as="image" href="https://flowpast.s3.eu-north-1.amazonaws.com/featured_blog_images/102316.webp"><link rel="preload" as="image" href="https://flowpast.s3.eu-north-1.amazonaws.com/featured_blog_images/102316.webp"></head>
\n<body>\n  <div class=\"header\">\n    <h2>YouTube Comments Analysis Report</h2>\n    <h3>Video: ${$(\"Process Comment Metrics\").item.json.videoTitle}</h3>\n  </div>\n\n  <div class=\"section stats\">\n    <h3> Quick Statistics</h3>\n    <ul>\n      <li><strong>Total Comments Analyzed:</strong> ${$('Process Comment Metrics').item.json.totalComments}</li>\n      <li><strong>Average Likes per Comment:</strong> ${$('Process Comment Metrics').item.json.avgLikes}</li>\n      <li><strong>Total Replies:</strong> ${$('Process Comment Metrics').item.json.totalReplies}</li>\n      <li><strong>Sentiment Summary:</strong> \n        Positive: ${output.overall_sentiment_breakdown.positive}, \n        Negative: ${output.overall_sentiment_breakdown.negative}, \n        Neutral: ${output.overall_sentiment_breakdown.neutral}\n      </li>\n    </ul>\n  </div>\n\n  <div class=\"section stats\">\n    <h3>Common Questions</h3>\n    <ul>\n      ${common_question}\n    </ul>\n  </div>\n\n    <div class=\"section stats\">\n    <h3>Key feedback points and suggestions</h3>\n    <ul>\n      ${key_feedback_points_and_suggestions}\n    </ul>\n  </div>\n\n\n  <div class=\"section stats\">\n    <h3>Actionable insights for content improvement</h3>\n    <ul>\n      ${actionable_insights_for_content_improvement}\n    </ul>\n  </div>\n\n\n\n\n  <div class=\"footer\">\n    <p><em>Report generated on ${new Date().toLocaleString()}</em></p>\n    \n  </div>\n</body>\n</html>`;\n\n\n// Return the formatted data\nreturn  {\n  json: {\n    emailHTML,\n    subject: `YouTube Analysis: ${$('Process Comment Metrics').item.json.videoTitle} - ${$('Process Comment Metrics').item.json.totalComments} comments analyzed`,\n    videoTitle: $('Process Comment Metrics').item.json.videoTitle\n  }\n};"
},
"typeVersion": 2
},
{
"id": "f789c4e0-813b-4f6d-9584-86a274fba969",
"name": "Send Email Report",
"type": "n8n-nodes-base.gmail",
"position": [
300,
730
],
"webhookId": "90b8f9ad-4226-42a0-971b-7fa9f5f190bd",
"parameters": {
"sendTo": "[YOUR_EMAIL]",
"message": "={{ $json.emailHTML }}",
"options": [],
"subject": "={{ $json.subject }}"
},
"typeVersion": 2.1
},
{
"id": "309d2e7d-2da0-439b-b2ac-87196d9f5733",
"name": "Mark Sheet as Sent",
"type": "n8n-nodes-base.googleSheets",
"position": [
80,
740
],
"parameters": {
"columns": {
"value": {
"Id": "={{ $('Retrieve Sheet Video IDs').item.json.Id }}",
"Status": "Mail Sent"
},
"schema": [
{
"id": "Id",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Id",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Youtube video id",
"type": "string",
"display": true,
"required": false,
"displayName": "Youtube video id",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Status",
"type": "string",
"display": true,
"required": false,
"displayName": "Status",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "row_number",
"type": "string",
"display": true,
"removed": true,
"readOnly": true,
"required": false,
"displayName": "row_number",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"Id"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": [],
"operation": "update",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "[YOUR_ID]",
"cachedResultName": "Youtube_Video "
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "[YOUR_ID]",
"cachedResultUrl": "[YOUR_ID]",
"cachedResultName": "Youtube_Video"
}
},
"typeVersion": 4.5
}
],
"pinData": [],
"connections": {
"Check Pending Status": {
"main": [
[
{
"node": "Throttle Items",
"type": "main",
"index": 0
}
]
]
},
"Throttle Items": {
"main": [
[
{
"node": "Map Video Parameters",
"type": "main",
"index": 0
}
]
]
},
"Analyze Comments with AI": {
"main": [
[
{
"node": "Build Email HTML",
"type": "main",
"index": 0
}
]
]
},
"OpenAI Chat Engine": {
"ai_languageModel": [
[
{
"node": "Analyze Comments with AI",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"Map Video Parameters": {
"main": [
[
{
"node": "Fetch YouTube Metadata",
"type": "main",
"index": 0
}
]
]
},
"Process Comment Metrics": {
"main": [
[
{
"node": "Analyze Comments with AI",
"type": "main",
"index": 0
}
]
]
},
"Build Email HTML": {
"main": [
[
{
"node": "Send Email Report",
"type": "main",
"index": 0
}
]
]
},
"Fetch YouTube Metadata": {
"main": [
[
{
"node": "Retrieve YouTube Comments",
"type": "main",
"index": 0
}
]
]
},
"Retrieve YouTube Comments": {
"main": [
[
{
"node": "Process Comment Metrics",
"type": "main",
"index": 0
}
]
]
},
"Send Email Report": {
"main": [
[
{
"node": "Mark Sheet as Sent",
"type": "main",
"index": 0
}
]
]
},
"Retrieve Sheet Video IDs": {
"main": [
[
{
"node": "Check Pending Status",
"type": "main",
"index": 0
}
]
]
}
}
}