视频转录搜索与问答，集成VLM Run、GPT-4和Google Workspace
中级
这是一个Content Creation, Multimodal AI领域的自动化工作流，包含 14 个节点。主要使用 Webhook, GoogleDrive, GoogleSheets, Agent, GoogleSheetsTool 等节点。 视频转录搜索与问答，集成VLM Run、GPT-4和Google Workspace
前置要求
- •HTTP Webhook 端点（n8n 会自动生成）
- •Google Drive API 凭证
- •Google Sheets API 凭证
- •OpenAI API Key
使用的节点 (14)
工作流预览
可视化展示节点连接关系，支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
"meta": {
"instanceId": "96d35e452e0d9a182973416b7532cfc5643239aaaa764a5bf74d52ca84f4a35c",
"templateCredsSetupCompleted": true
},
"nodes": [
{
"id": "a85ebcf0-5f2a-4ee7-8c68-b00197810f4d",
"name": "Google Drive 触发器",
"type": "n8n-nodes-base.googleDriveTrigger",
"position": [
0,
0
],
"parameters": {
"event": "fileCreated",
"options": {},
"pollTimes": {
"item": [
{
"mode": "everyMinute"
}
]
},
"triggerOn": "specificFolder",
"folderToWatch": {
"__rl": true,
"mode": "list",
"value": "1E8rvLEWKguorMT36yCD1jY78G0u8g6g7",
"cachedResultUrl": "https://drive.google.com/drive/folders/1E8rvLEWKguorMT36yCD1jY78G0u8g6g7",
"cachedResultName": "test_data"
}
},
"credentials": {
"googleDriveOAuth2Api": {
"id": "oCzY5bzObKMMfjpu",
"name": "Google Drive account 3"
}
},
"typeVersion": 1
},
{
"id": "a87e6ce7-081c-4482-9372-33dad10d5b3b",
"name": "下载文件",
"type": "n8n-nodes-base.googleDrive",
"position": [
208,
0
],
"parameters": {
"fileId": {
"__rl": true,
"mode": "id",
"value": "={{ $json.id }}"
},
"options": {
"binaryPropertyName": "data"
},
"operation": "download"
},
"credentials": {
"googleDriveOAuth2Api": {
"id": "oCzY5bzObKMMfjpu",
"name": "Google Drive account 3"
}
},
"typeVersion": 3
},
{
"id": "56911f23-a3e2-4e86-94ab-8e373d6676be",
"name": "当收到聊天消息时",
"type": "@n8n/n8n-nodes-langchain.chatTrigger",
"position": [
656,
304
],
"webhookId": "5a5e6401-bb33-4801-9019-8c996a6bb293",
"parameters": {
"mode": "webhook",
"public": true,
"options": {}
},
"typeVersion": 1.1
},
{
"id": "e15b3d90-09be-4abd-90f9-2bdf68d93481",
"name": "AI Agent",
"type": "@n8n/n8n-nodes-langchain.agent",
"position": [
944,
304
],
"parameters": {
"options": {
"systemMessage": "You are a video‑QA assistant. Use the Getrows tool to fetch the relevant transcript segments for the user’s question, then answer based only on those segments, check the sheets before replying\n"
}
},
"typeVersion": 2
},
{
"id": "390f8b2f-2fa6-40f4-8e99-31bb8ab339d4",
"name": "OpenAI 聊天模型",
"type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
"position": [
928,
512
],
"parameters": {
"model": {
"__rl": true,
"mode": "list",
"value": "gpt-4.1",
"cachedResultName": "gpt-4.1"
},
"options": {}
},
"credentials": {
"openAiApi": {
"id": "WqqkexJ7QGbexoAz",
"name": "OpenAi account 4"
}
},
"typeVersion": 1.2
},
{
"id": "cff805f1-caaa-46c3-9f11-21fa534baa9b",
"name": "在表格中追加行",
"type": "n8n-nodes-base.googleSheets",
"position": [
1040,
0
],
"parameters": {
"columns": {
"value": {
"Data": "={{ $json.body[0].body.response }}",
"Video Namae": "={{ $json.body[0].body.id }}"
},
"schema": [
{
"id": "Video Namae",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Video Namae",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Data",
"type": "string",
"display": true,
"required": false,
"displayName": "Data",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "append",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1N8T3rF6DvDKQnRA93Hk-bvjhIu-nu89YveqEBLY9Lp4/edit#gid=0",
"cachedResultName": "Sheet1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1N8T3rF6DvDKQnRA93Hk-bvjhIu-nu89YveqEBLY9Lp4",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1N8T3rF6DvDKQnRA93Hk-bvjhIu-nu89YveqEBLY9Lp4/edit?usp=drivesdk",
"cachedResultName": "video storing"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "lxV2oXYXJq9hllrs",
"name": "Google Sheets account 5"
}
},
"typeVersion": 4.7
},
{
"id": "a4a451fd-d3c3-4f5b-bd26-b318e488b802",
"name": "在 Google Sheets 中获取行",
"type": "n8n-nodes-base.googleSheetsTool",
"position": [
1104,
496
],
"parameters": {
"options": {},
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1N8T3rF6DvDKQnRA93Hk-bvjhIu-nu89YveqEBLY9Lp4/edit#gid=0",
"cachedResultName": "Sheet1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1N8T3rF6DvDKQnRA93Hk-bvjhIu-nu89YveqEBLY9Lp4",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1N8T3rF6DvDKQnRA93Hk-bvjhIu-nu89YveqEBLY9Lp4/edit?usp=drivesdk",
"cachedResultName": "video storing"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "lxV2oXYXJq9hllrs",
"name": "Google Sheets account 5"
}
},
"typeVersion": 4.7
},
{
"id": "2a17a22e-a9d3-4068-8f41-e8861e5e4a8e",
"name": "便签",
"type": "n8n-nodes-base.stickyNote",
"position": [
-528,
-384
],
"parameters": {
"color": 7,
"width": 432,
"height": 1072,
"content": "## 🎥 视频转录 + Q&A 管道"
},
"typeVersion": 1
},
{
"id": "aed461ed-fca9-4058-90cf-a76ca12909ae",
"name": "便签1",
"type": "n8n-nodes-base.stickyNote",
"position": [
-64,
-384
],
"parameters": {
"color": 7,
"width": 432,
"height": 560,
"content": "## 📁 输入处理"
},
"typeVersion": 1
},
{
"id": "c08cc4c2-4a38-403b-aa15-aac669f5a765",
"name": "便签2",
"type": "n8n-nodes-base.stickyNote",
"position": [
400,
-384
],
"parameters": {
"width": 432,
"height": 560,
"content": "## 🤖 VLM Run 执行 Agent"
},
"typeVersion": 1
},
{
"id": "26167bc6-779a-4ad3-91e0-ed511a4b1a11",
"name": "VLM Run 用于视频处理",
"type": "@vlm-run/n8n-nodes-vlmrun.vlmRun",
"position": [
448,
0
],
"parameters": {
"domain": "video.transcription",
"operation": "video",
"callbackUrl": "https://playground.attensys.ai/webhook/transcript-video",
"processAsynchronously": true
},
"credentials": {
"vlmRunApi": {
"id": "7JF2kdNzjhKZsHGg",
"name": "VLM Run account 2"
}
},
"typeVersion": 1
},
{
"id": "bc679495-9f40-4453-9552-6d4cb54bfa5b",
"name": "接收 JSON 数据",
"type": "n8n-nodes-base.webhook",
"position": [
688,
0
],
"webhookId": "91fda1ba-ebe7-4bca-af29-3315bdc6fe77",
"parameters": {
"path": "transcript-video",
"options": {},
"httpMethod": "POST"
},
"typeVersion": 2
},
{
"id": "834078ed-48c5-42b2-8d40-24e60b8c0ce9",
"name": "便签3",
"type": "n8n-nodes-base.stickyNote",
"position": [
864,
-384
],
"parameters": {
"color": 7,
"width": 432,
"height": 560,
"content": "## 📊 数据存储"
},
"typeVersion": 1
},
{
"id": "18281c54-6103-4060-a3f4-17d1afa7ded0",
"name": "便签4",
"type": "n8n-nodes-base.stickyNote",
"position": [
-64,
208
],
"parameters": {
"color": 7,
"width": 1360,
"height": 480,
"content": ""
},
"typeVersion": 1
}
],
"pinData": {},
"connections": {
"Download file": {
"main": [
[
{
"node": "VLM Run for Video Processing",
"type": "main",
"index": 0
}
]
]
},
"OpenAI Chat Model": {
"ai_languageModel": [
[
{
"node": "AI Agent",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"Receives JSON Data": {
"main": [
[
{
"node": "Append row in sheet",
"type": "main",
"index": 0
}
]
]
},
"Google Drive Trigger": {
"main": [
[
{
"node": "Download file",
"type": "main",
"index": 0
}
]
]
},
"When chat message received": {
"main": [
[
{
"node": "AI Agent",
"type": "main",
"index": 0
}
]
]
},
"Get row(s) in sheet in Google Sheets": {
"ai_tool": [
[
{
"node": "AI Agent",
"type": "ai_tool",
"index": 0
}
]
]
}
}
}常见问题
如何使用这个工作流？
复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景？
中级 - 内容创作, 多模态 AI
需要付费吗？
本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。
相关工作流推荐
AI驱动的文档处理与整理系统，集成Gemini、VLM Run和Google表格
AI驱动的文档处理与整理系统，集成Gemini、VLM Run和Google表格
Webhook
Google Drive
Agent
+7
14 节点Atik
内容创作
自动化财务文档处理
使用Google Gemini OCR的自动化财务文档处理
Set
Code
Merge
+13
76 节点Didac Fernandez
内容创作
重新排名 #1
通过网页爬取、GPT-4o和WhatsApp自动化电话营销
Set
Code
Webhook
+18
48 节点Khaisa Studio
客户培育
AI驱动的邮件分诊与自动回复系统，集成OpenAI代理和Gmail
AI驱动的邮件分诊与自动回复系统，集成OpenAI代理和Gmail
If
Set
Gmail
+20
68 节点Abdullahi Ahmed
内容创作
使用 Azure OpenAI 和 Google Workspace 自动化 DEI 资格筛选
使用Azure GPT-4o、Google云端硬盘和表格自动进行DEI资格筛选
If
Code
Gmail
+9
19 节点Rahul Joshi
内容创作
使用OpenAI、RunwayML和ElevenLabs自动化无脸短视频
使用OpenAI、RunwayML和ElevenLabs自动化无脸短视频：从脚本到社交媒体
Set
Code
Wait
+18
56 节点LeeWei
内容创作
工作流信息
难度等级
中级
节点数量14
分类2
节点类型10
作者
Atik
@atikAI and Automation engineer with 2 years of experience helping businesses streamline workflows using tools like n8n, Make, and Zapier. I also build custom Python solutions and AI integrations tailored to your needs. Use my link to book an initial consultation for automation and AI projects.
外部链接
在 n8n.io 查看 →
分享此工作流