YouTube评论情感分析器
高级
这是一个AI, Marketing领域的自动化工作流，包含 16 个节点。主要使用 If, Set, SplitOut, HttpRequest, GoogleSheets 等节点，结合人工智能技术实现智能自动化。 🚀 YouTube评论情感分析器（使用Google Sheets和OpenAI）
前置要求
- •可能需要目标 API 的认证凭证
- •Google Sheets API 凭证
- •OpenAI API Key
使用的节点 (16)
工作流预览
可视化展示节点连接关系，支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
"id": "xaC6zL4bWBo14xyJ",
"meta": {
"instanceId": "10f6e8a86649316fe7041c503c24e6d77b68a961a9f4f1f76d0100c435446092",
"templateCredsSetupCompleted": true
},
"name": "YouTube评论情感分析器",
"tags": [],
"nodes": [
{
"id": "0bacd739-7ea3-42f5-8986-2f7d47628ee9",
"name": "拆分输出",
"type": "n8n-nodes-base.splitOut",
"position": [
820,
-40
],
"parameters": {
"options": {},
"fieldToSplitOut": "body.items"
},
"typeVersion": 1
},
{
"id": "236aaaab-6a9a-42d7-8645-980bf8c3254d",
"name": "OpenAI 聊天模型",
"type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
"position": [
1080,
180
],
"parameters": {
"model": {
"__rl": true,
"mode": "list",
"value": "gpt-4o-mini"
},
"options": {}
},
"credentials": {
"openAiApi": {
"id": "4d73v7kxEDNu3n25",
"name": "OpenAi account"
}
},
"typeVersion": 1.2
},
{
"id": "c1eda3a6-9fbe-4150-8086-c3ffebaeb2e1",
"name": "无操作，不执行任何操作",
"type": "n8n-nodes-base.noOp",
"position": [
380,
140
],
"parameters": {},
"typeVersion": 1
},
{
"id": "d28f3fbf-6013-47af-ba84-3bdd9800fd3b",
"name": "从Google表格获取视频URL",
"type": "n8n-nodes-base.googleSheets",
"position": [
-200,
-40
],
"parameters": {
"options": {},
"sheetName": {
"__rl": true,
"mode": "list",
"value": 760258523,
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1xoCVr_mlwn4jFcnJENtrU-_K5nkIytZ8qBXzxMq55n4/edit#gid=760258523",
"cachedResultName": "Sheet2"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1xoCVr_mlwn4jFcnJENtrU-_K5nkIytZ8qBXzxMq55n4",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1xoCVr_mlwn4jFcnJENtrU-_K5nkIytZ8qBXzxMq55n4/edit?usp=drivesdk",
"cachedResultName": "Youtube Videos Comments"
},
"authentication": "serviceAccount"
},
"credentials": {
"googleApi": {
"id": "jPoTdPxgVL0vr9SQ",
"name": "Google Sheets account"
}
},
"typeVersion": 4.5
},
{
"id": "0ac06530-cfe7-4f1c-8c0a-8def2126df0f",
"name": "检查下一个获取时间是否可用",
"type": "n8n-nodes-base.if",
"position": [
-20,
-40
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "92084960-e023-4cd6-a5c0-ddd43275cc33",
"operator": {
"type": "string",
"operation": "empty",
"singleValue": true
},
"leftValue": "={{ $json.next_fetch_time }}",
"rightValue": "={{ $now.toISO() }}"
}
]
}
},
"typeVersion": 2.2
},
{
"id": "ba42f450-3b0c-41a3-8e72-d2a38b97cfc7",
"name": "检查下一个获取时间是否在当前时间之前",
"type": "n8n-nodes-base.if",
"position": [
160,
80
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "40c8d081-b298-46b1-850c-2322ed89d18d",
"operator": {
"type": "dateTime",
"operation": "before"
},
"leftValue": "={{ $json.next_fetch_time }}",
"rightValue": "={{ $now.toISO() }}"
}
]
}
},
"typeVersion": 2.2
},
{
"id": "aad11f42-b976-41d7-b771-151da60391d6",
"name": "获取视频URL的评论",
"type": "n8n-nodes-base.httpRequest",
"position": [
360,
-60
],
"parameters": {
"url": "https://www.googleapis.com/youtube/v3/commentThreads",
"options": {
"response": {
"response": {
"fullResponse": true,
"responseFormat": "json"
}
},
"pagination": {
"pagination": {
"parameters": {
"parameters": [
{
"name": "pageToken",
"value": "={{ $response.body.nextPageToken }}"
}
]
},
"completeExpression": "={{ !$response.body.nextPageToken}}",
"paginationCompleteWhen": "other"
}
}
},
"sendQuery": true,
"authentication": "genericCredentialType",
"genericAuthType": "httpQueryAuth",
"queryParameters": {
"parameters": [
{
"name": "part",
"value": "snippet"
},
{
"name": "videoId",
"value": "={{ $json[\"video_urls\"].match(/(?:v=|\\/)([0-9A-Za-z_-]{11})/)[1] || ''}}"
},
{
"name": "maxResults",
"value": "100"
}
]
}
},
"credentials": {
"httpQueryAuth": {
"id": "LmsYEaslJmA6CMdL",
"name": "Query Auth account 4"
}
},
"typeVersion": 4.2
},
{
"id": "4cf1ebd0-e260-4e53-bc26-be1db2f6e7f2",
"name": "分析每条评论的情感",
"type": "@n8n/n8n-nodes-langchain.sentimentAnalysis",
"position": [
1060,
-40
],
"parameters": {
"options": {
"categories": "Positive, Neutral, Negative",
"systemPromptTemplate": "You are highly intelligent and accurate sentiment analyzer. Analyze the sentiment of the provided text. Categorize it into one of the following: {categories}. Use the provided formatting instructions. Only output the JSON."
},
"inputText": "={{ $json.snippet.topLevelComment.snippet.textOriginal }}"
},
"typeVersion": 1
},
{
"id": "f306c5cd-6b6b-46fa-b7ef-f3ccef960931",
"name": "按要求格式化字段以保存到Google表格",
"type": "n8n-nodes-base.set",
"position": [
1500,
-40
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "25fb96a0-de38-4495-8473-0385a3fd5df9",
"name": "commentId",
"type": "string",
"value": "={{ $json.snippet.topLevelComment.id }}"
},
{
"id": "d824ecd0-89c0-4c07-992f-6a5d3421690e",
"name": "video_url",
"type": "string",
"value": "=https://www.youtube.com/watch?v={{ $json.snippet.videoId }}"
},
{
"id": "cdcbc3d9-ab3e-4d7d-80a7-bfe168b0ed27",
"name": "comment",
"type": "string",
"value": "={{ $json.snippet.topLevelComment.snippet.textOriginal }}"
},
{
"id": "20bcfe96-3904-44d2-b72a-9eb49d603c8d",
"name": "authorName",
"type": "string",
"value": "={{ $json.snippet.topLevelComment.snippet.authorDisplayName }}"
},
{
"id": "c92f56bf-8b37-4c4e-9ce7-b7a49d63deee",
"name": "likes",
"type": "string",
"value": "={{ $json.snippet.topLevelComment.snippet.likeCount }}"
},
{
"id": "7cc4fdb3-7c41-418a-bf4f-71081fe9df74",
"name": "reply",
"type": "string",
"value": "={{ $json.snippet.totalReplyCount }}"
},
{
"id": "9988ea66-7f31-4b2c-90ab-3cad8efabf95",
"name": "sentiment",
"type": "string",
"value": "={{ $json.sentimentAnalysis.category }}"
},
{
"id": "6552df27-6e04-4048-b3c2-1e1755ccac28",
"name": "published_at",
"type": "string",
"value": "={{ $json.snippet.topLevelComment.snippet.publishedAt }}"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "6cd20a6e-8bcc-44c7-a62d-e3c3c75e6d9a",
"name": "在Google表格中插入和更新评论",
"type": "n8n-nodes-base.googleSheets",
"position": [
1720,
-40
],
"parameters": {
"columns": {
"value": {},
"schema": [
{
"id": "commentId",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "commentId",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "video_url",
"type": "string",
"display": true,
"required": false,
"displayName": "video_url",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "comment",
"type": "string",
"display": true,
"required": false,
"displayName": "comment",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "authorName",
"type": "string",
"display": true,
"required": false,
"displayName": "authorName",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "likes",
"type": "string",
"display": true,
"required": false,
"displayName": "likes",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "reply",
"type": "string",
"display": true,
"required": false,
"displayName": "reply",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "sentiment",
"type": "string",
"display": true,
"required": false,
"displayName": "sentiment",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "published_at",
"type": "string",
"display": true,
"required": false,
"displayName": "published_at",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "autoMapInputData",
"matchingColumns": [
"commentId"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "appendOrUpdate",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1xoCVr_mlwn4jFcnJENtrU-_K5nkIytZ8qBXzxMq55n4/edit#gid=0",
"cachedResultName": "Sheet1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1xoCVr_mlwn4jFcnJENtrU-_K5nkIytZ8qBXzxMq55n4",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1xoCVr_mlwn4jFcnJENtrU-_K5nkIytZ8qBXzxMq55n4/edit?usp=drivesdk",
"cachedResultName": "Youtube Videos Comments"
},
"authentication": "serviceAccount"
},
"credentials": {
"googleApi": {
"id": "jPoTdPxgVL0vr9SQ",
"name": "Google Sheets account"
}
},
"typeVersion": 4.5
},
{
"id": "ea240f38-1462-402b-8db2-36b3e8664c2f",
"name": "更新最后获取时间和next_fetch_time",
"type": "n8n-nodes-base.googleSheets",
"position": [
1940,
-40
],
"parameters": {
"columns": {
"value": {
"video_urls": "={{ $('Get Video Urls from Google Sheet').item.json.video_urls }}",
"next_fetch_time": "={{ $now.plus(5, 'min').toISO() }}",
"last_fetched_time": "={{ $now.toISO() }}"
},
"schema": [
{
"id": "video_urls",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "video_urls",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "last_fetched_time",
"type": "string",
"display": true,
"required": false,
"displayName": "last_fetched_time",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "next_fetch_time",
"type": "string",
"display": true,
"required": false,
"displayName": "next_fetch_time",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"video_urls"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "appendOrUpdate",
"sheetName": {
"__rl": true,
"mode": "list",
"value": 760258523,
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1xoCVr_mlwn4jFcnJENtrU-_K5nkIytZ8qBXzxMq55n4/edit#gid=760258523",
"cachedResultName": "Sheet2"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1xoCVr_mlwn4jFcnJENtrU-_K5nkIytZ8qBXzxMq55n4",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1xoCVr_mlwn4jFcnJENtrU-_K5nkIytZ8qBXzxMq55n4/edit?usp=drivesdk",
"cachedResultName": "Youtube Videos Comments"
},
"authentication": "serviceAccount"
},
"credentials": {
"googleApi": {
"id": "jPoTdPxgVL0vr9SQ",
"name": "Google Sheets account"
}
},
"typeVersion": 4.5
},
{
"id": "610fa83c-a626-42c0-aa8b-1ebb1a6bcf44",
"name": "无操作，不执行任何操作1",
"type": "n8n-nodes-base.noOp",
"position": [
820,
140
],
"parameters": {},
"typeVersion": 1
},
{
"id": "30570a68-78b8-434e-bb20-ea85a0689a63",
"name": "点击“测试工作流”时",
"type": "n8n-nodes-base.manualTrigger",
"position": [
-380,
-40
],
"parameters": {},
"typeVersion": 1
},
{
"id": "4fe79a97-fc39-41c0-9d2f-f07865deef5e",
"name": "便签 1",
"type": "n8n-nodes-base.stickyNote",
"position": [
-440,
-160
],
"parameters": {
"color": 5,
"width": 2620,
"height": 480,
"content": ""
},
"typeVersion": 1
},
{
"id": "0ccb85d8-d29e-44a7-b644-49b3dcc6ce9b",
"name": "检查成功响应",
"type": "n8n-nodes-base.if",
"position": [
560,
-60
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "bce76f94-5904-4fdb-b172-adc1134855f9",
"operator": {
"type": "number",
"operation": "equals"
},
"leftValue": "={{ $json.statusCode }}",
"rightValue": 200
}
]
}
},
"typeVersion": 2.2
},
{
"id": "880f570f-6300-4659-9dcf-d47880140131",
"name": "便签 2",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1100,
-500
],
"parameters": {
"width": 640,
"height": 820,
"content": "### **如何使用此工作流：**"
},
"typeVersion": 1
}
],
"active": false,
"pinData": {},
"settings": {
"executionOrder": "v1"
},
"versionId": "70007187-7437-4053-b909-5057bf816906",
"connections": {
"Split Out": {
"main": [
[
{
"node": "Analyze sentiment of every comment",
"type": "main",
"index": 0
}
]
]
},
"OpenAI Chat Model": {
"ai_languageModel": [
[
{
"node": "Analyze sentiment of every comment",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"Check Success Response": {
"main": [
[
{
"node": "Split Out",
"type": "main",
"index": 0
}
],
[
{
"node": "No Operation, do nothing1",
"type": "main",
"index": 0
}
]
]
},
"Get Comments for video urls": {
"main": [
[
{
"node": "Check Success Response",
"type": "main",
"index": 0
}
]
]
},
"Get Video Urls from Google Sheet": {
"main": [
[
{
"node": "check next fetch time is available or not",
"type": "main",
"index": 0
}
]
]
},
"When clicking ‘Test workflow’": {
"main": [
[
{
"node": "Get Video Urls from Google Sheet",
"type": "main",
"index": 0
}
]
]
},
"Analyze sentiment of every comment": {
"main": [
[
{
"node": "Format fields as required to save in google sheet",
"type": "main",
"index": 0
}
],
[
{
"node": "Format fields as required to save in google sheet",
"type": "main",
"index": 0
}
],
[
{
"node": "Format fields as required to save in google sheet",
"type": "main",
"index": 0
}
]
]
},
"Insert and update comment in google sheet": {
"main": [
[
{
"node": "Update last fetched time and next_fetch_time",
"type": "main",
"index": 0
}
]
]
},
"check next fetch time is available or not": {
"main": [
[
{
"node": "Get Comments for video urls",
"type": "main",
"index": 0
}
],
[
{
"node": "check next fetch time is before the current time",
"type": "main",
"index": 0
}
]
]
},
"Update last fetched time and next_fetch_time": {
"main": [
[]
]
},
"check next fetch time is before the current time": {
"main": [
[
{
"node": "Get Comments for video urls",
"type": "main",
"index": 0
}
],
[
{
"node": "No Operation, do nothing",
"type": "main",
"index": 0
}
]
]
},
"Format fields as required to save in google sheet": {
"main": [
[
{
"node": "Insert and update comment in google sheet",
"type": "main",
"index": 0
}
]
]
}
}
}常见问题
如何使用这个工作流？
复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景？
高级 - 人工智能, 营销
需要付费吗？
本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。
相关工作流推荐
使用DeepSeek抓取Trustpilot评论，通过OpenAI分析情感
使用DeepSeek抓取Trustpilot评论，通过OpenAI分析情感
If
Set
Html
+9
20 节点Davide
产品
AI生成的WordPress文章摘要块
WordPress文章的AI生成摘要块
If
Set
Slack
+14
32 节点Dataki
人工智能
使用 Browserflow 和 Google Sheets 自动化 LinkedIn 请求与破冰消息
使用 Browserflow 和 Google Sheets 自动化 LinkedIn 请求与破冰消息
If
Set
Sort
+15
44 节点PollupAI
销售
（Duc）深度研究市场模板
集成PerplexityAI研究和OpenAI内容的多层级WordPress博客生成器
If
Set
Xml
+28
132 节点Daniel Ng
人工智能
使用AI分析YouTube评论自动检测情感倾向
使用 Google Gemini AI 和 Google Sheets 进行 YouTube 评论情感分析
If
Set
Code
+9
15 节点Davide
人工智能
Shopify产品列表AI博客生成器：使用GPT-4o和Google表格
Shopify产品列表AI博客生成器：使用GPT-4o和Google表格
If
Set
Shopify
+10
19 节点Kumar Shivam
人工智能
