YouTube Comment Analysis Automation with n8n & OpenAI

What This Workflow Does

This workflow takes a YouTube video ID and an API key. It collects the video details and up to 100 comments. Then it studies comment feelings and topics using OpenAI. Finally, it makes a clear report with suggestions. The report is sent by email and saved on Google Drive.

This saves lots of time. It helps video makers see what viewers think without reading all comments by hand. It shows if people like or dislike the video. It also shows what viewers talk about the most. This helps make better videos next time.

Who Should Use This Workflow

People who make YouTube videos and want to know viewer opinions fast. Anyone who finds reading many comments slow and hard. Users who want clear advice for improving videos. It is also good for those who want automatic reports sent by email.

Tools and Services Needed

• Google API Key: Access YouTube Data API.
• Gmail Account: To send report emails.
• Google Drive: To save report files.
• OpenAI API Key: For comment analysis.
• n8n Automation Platform: To run the workflow.

If using self hosting n8n, see self-host n8n. This helps full control without cloud service limits.

Beginner Step-by-Step: How to Use This Workflow in n8n

Download and Import

1. Download the workflow using the Download button on this page.
2. Open the n8n editor (assumed already open).
3. Use the Import from File option and select the downloaded workflow file.

Configure Credentials and Variables

1. Open the Workflow Variables node.
2. Add your Google API Key under GOOGLE_API_KEY.
3. Set the YouTube Video ID under VIDEO_ID.
4. Check and update email addresses for sending the report in the Gmail Report node.
5. Confirm connected Google Drive folder where reports will be saved.
6. Verify OpenAI API details are set in the AI nodes.

Test and Activate

1. Run the workflow manually to check it works. Watch for errors.
2. Look at the generated report email you receive and the saved file.
3. If all is good, activate the workflow to run automatically or on schedule.

Workflow Inputs, Processing, and Outputs

Input

• Google API Key used to call YouTube Data API.
• YouTube Video ID to identify which video to analyze.

Processing Steps

• Build YouTube API URLs using the video ID and API key.
• Retrieve video details (title, views, likes, topics).
• Fetch up to 100 comments using pagination to get all pages.
• Merge all data into one JSON object.
• Send combined data to OpenAI GPT model for analysis.
• Generate a detailed Markdown report covering sentiment, themes, recommendations.
• Convert Markdown to HTML for nice formatting.
• Email report via Gmail.
• Save report copy to Google Drive.

Output

• A structured report with video insights and viewer feedback.
• Email sent to configured addresses.
• Report file saved as archive on Google Drive.

Key Code Examples in Workflow

Below is the JavaScript code snippet that builds the YouTube API URL dynamically using input variables. You can copy it into the Create YouTube API URL code node.

// Sample JS from node
const BASE_URL = 'https://www.googleapis.com/youtube/v3/videos';
const VIDEO_ID = item.json.VIDEO_ID;
const GOOGLE_API_KEY = item.json.GOOGLE_API_KEY;
const youtubeUrl = `${BASE_URL}?part=snippet,contentDetails,status,statistics,player,topicDetails&id=${VIDEO_ID}&key=${GOOGLE_API_KEY}`;
return [{ json: { youtubeUrl } }];

This code makes the URL for fetching video details. The variables must match what you set in Workflow Variables.

Another important snippet handles comment pagination. It requests each page of comments until reaching around 100 total. Use in the Get Video Comments with Pagination code node.

async function buildQueryString(params) {
  return Object.entries(params).map(([key, value]) => `${key}=${encodeURIComponent(value)}`).join('&');
}

const BASE_URL = "https://www.googleapis.com/youtube/v3/commentThreads";
const videoId = item.json.VIDEO_ID;
const apiKey = item.json.GOOGLE_API_KEY;

let comments = [];
let nextPageToken = undefined;

while (true) {
  let params = {
    part: 'snippet',
    videoId: videoId,
    maxResults: 100,
    key: apiKey
  };
  if(nextPageToken) {
    params.pageToken = nextPageToken;
  }
  const url = `${BASE_URL}?${await buildQueryString(params)}`;
  const response = await this.helpers.httpRequest({ url, method: 'GET' });
  comments.push(...response.items);
  if (!response.nextPageToken || comments.length >= 100) break;
  nextPageToken = response.nextPageToken;
}

return [{ json: { comments } }];

This ensures all wanted comments load fully before analysis.

Customizations

• Change VIDEO_ID in Workflow Variables to analyze other videos.
• Modify maxResults in comment fetch code to get fewer or more comments.
• Update email addresses in Gmail Report node to send to different receivers.
• Use other OpenAI models like GPT-4 by switching in YouTube Video Report Agent node.
• Add more YouTube API parts, for example, liveStreamingDetails for live stats.

Troubleshooting

• Video ID missing error: Add a valid VIDEO_ID in Workflow Variables.
• Google API Key missing error: Make sure the GOOGLE_API_KEY is correct and set.
• Comments incomplete: Use full pagination code to fetch all pages.
• Report incomplete or off: Check data merge nodes to confirm full details and comments go to AI.

Pre-Production Checklist

• Google API Key works and has YouTube Data API enabled.
• Gmail OAuth2 credentials can send test emails.
• Test video ID fetches details and comments correctly.
• OpenAI credentials work and give expected responses.
• Output report looks good after Markdown to HTML conversion.

Deployment Guide

Activate the workflow in n8n by setting it to active. Run manually first to test each part. Schedule with cron or connect to other triggers if needed. Watch workflow logs for errors. Reports will then be sent via email and saved automatically.

Summary ✓

✓ Saves hours by automating YouTube comment reading and analysis.

✓ Gives clear, easy-to-understand reports about video and viewer feedback.

✓ Sends reports automatically by email and keeps copies safe on Google Drive.

→ Helps creators understand viewers better to make improved content.