使用 AI 自然语音和 Google Sheets 生成多发言人播客
中级
这是一个AI, Marketing领域的自动化工作流，包含 15 个节点。主要使用 If, Code, Wait, Aggregate, GoogleDrive 等节点，结合人工智能技术实现智能自动化。 使用 AI 自然语音 🤖🧠 和 Google Sheets 生成多发言人播客 🎙️
前置要求
- •Google Drive API 凭证
- •可能需要目标 API 的认证凭证
- •Google Sheets API 凭证
工作流预览
可视化展示节点连接关系，支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
"id": "o6fbolcbTTW2JOud",
"meta": {
"instanceId": "a4bfc93e975ca233ac45ed7c9227d84cf5a2329310525917adaf3312e10d5462",
"templateCredsSetupCompleted": true
},
"name": "使用 AI 自然语音和 Google Sheets 生成多发言人播客",
"tags": [],
"nodes": [
{
"id": "a1300e42-783b-4d2d-aa59-051cce93e902",
"name": "从视频和音频文件生成说话头像视频",
"type": "n8n-nodes-base.httpRequest",
"position": [
1300,
-160
],
"parameters": {},
"typeVersion": 4.2
},
{
"id": "fe7065f8-0154-4cfc-9329-8ed7d2fa99e2",
"name": "获取状态",
"type": "n8n-nodes-base.wait",
"position": [
1120,
-160
],
"webhookId": "66ea18d8-44ea-40c4-ad28-0085aa8edf5c",
"parameters": {},
"typeVersion": 1.1
},
{
"id": "94e86ce9-9364-42af-bad0-88c132725962",
"name": "# 从视频和音频文件生成说话头像视频",
"type": "n8n-nodes-base.if",
"position": [
1480,
-160
],
"parameters": {},
"typeVersion": 2.2
},
{
"id": "25c7ebe6-b3bc-41b1-a0e2-497aef244fc0",
"name": "当点击“测试工作流”时",
"type": "n8n-nodes-base.manualTrigger",
"position": [
-100,
-160
],
"parameters": {},
"typeVersion": 1
},
{
"id": "3e22cea1-531c-45dd-b515-677d7acf575e",
"name": "创建音频",
"type": "n8n-nodes-base.httpRequest",
"position": [
860,
-160
],
"parameters": {},
"typeVersion": 4.2
},
{
"id": "f08b6131-dbd6-495e-975d-8bb93413d763",
"name": "获取音频 URL",
"type": "n8n-nodes-base.httpRequest",
"position": [
140,
160
],
"parameters": {},
"typeVersion": 4.2
},
{
"id": "e90de1da-70d8-4f8a-a191-d1e062f46223",
"name": "获取音频文件",
"type": "n8n-nodes-base.httpRequest",
"position": [
380,
160
],
"parameters": {},
"typeVersion": 4.2
},
{
"id": "ce961c0b-63ea-46f7-aabe-76886aa2ac3b",
"name": "上传音频",
"type": "n8n-nodes-base.googleDrive",
"position": [
600,
160
],
"parameters": {},
"typeVersion": 3
},
{
"id": "1aa25ff1-12f0-4728-a05f-929e39ed647e",
"name": "便签3",
"type": "n8n-nodes-base.stickyNote",
"position": [
140,
-1100
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "245d9467-db91-427b-a04f-dca1763dfda3",
"name": "便签4",
"type": "n8n-nodes-base.stickyNote",
"position": [
140,
-800
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "04d34818-938e-430f-be49-620bed7dce21",
"name": "便利贴5",
"type": "n8n-nodes-base.stickyNote",
"position": [
140,
-340
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "4affe680-17b8-4bbd-a823-501c8a3f66bd",
"name": "便签 6",
"type": "n8n-nodes-base.stickyNote",
"position": [
140,
-580
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "d102629d-fae8-4dfa-852c-44a71725e956",
"name": "获取播客文本",
"type": "n8n-nodes-base.googleSheets",
"position": [
140,
-160
],
"parameters": {},
"typeVersion": 4.5
},
{
"id": "cad0e941-7dc8-46fb-9bd2-0df96377a4e1",
"name": "完整播客文本",
"type": "n8n-nodes-base.code",
"position": [
600,
-160
],
"parameters": {},
"typeVersion": 2
},
{
"id": "8c77039c-0cec-4502-a7f4-114b67a8a379",
"name": "获取所有行",
"type": "n8n-nodes-base.aggregate",
"position": [
380,
-160
],
"parameters": {},
"typeVersion": 1
}
],
"active": false,
"pinData": {},
"settings": {
"executionOrder": "v1"
},
"versionId": "3b9d83f1-e453-4afd-8690-0ccf71dc0465",
"connections": {
"Completed?": {
"main": [
[
{
"node": "Get Url Audio",
"type": "main",
"index": 0
}
],
[
{
"node": "Wait 60 sec.",
"type": "main",
"index": 0
}
]
]
},
"Get status": {
"main": [
[
{
"node": "Completed?",
"type": "main",
"index": 0
}
]
]
},
"Create Audio": {
"main": [
[
{
"node": "Wait 60 sec.",
"type": "main",
"index": 0
}
]
]
},
"Get all rows": {
"main": [
[
{
"node": "Full Podcast Text",
"type": "main",
"index": 0
}
]
]
},
"Upload Audio": {
"main": [
[]
]
},
"Wait 60 sec.": {
"main": [
[
{
"node": "Get status",
"type": "main",
"index": 0
}
]
]
},
"Get Url Audio": {
"main": [
[
{
"node": "Get File Audio",
"type": "main",
"index": 0
}
]
]
},
"Get File Audio": {
"main": [
[
{
"node": "Upload Audio",
"type": "main",
"index": 0
}
]
]
},
"Get Podcast text": {
"main": [
[
{
"node": "Get all rows",
"type": "main",
"index": 0
}
]
]
},
"Full Podcast Text": {
"main": [
[
{
"node": "Create Audio",
"type": "main",
"index": 0
}
]
]
},
"When clicking ‘Test workflow’": {
"main": [
[
{
"node": "Get Podcast text",
"type": "main",
"index": 0
}
]
]
}
}
}常见问题
如何使用这个工作流？
复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景？
中级 - 人工智能, 营销
需要付费吗？
本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。
相关工作流推荐
使用Google Veo3创建视频并上传到YouTube
使用Google Veo3生成AI视频，保存到Google云端硬盘并上传到YouTube
If
Set
Wait
+7
22 节点Davide
人工智能
使用 FLUX Kontext 生成 AI 情境化图像
使用 FLUX Kontext、Google Sheets 和 Drive 通过 AI 提示词变换图像
If
Wait
Google Drive
+5
17 节点Davide
设计
（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
人工智能
WooCommerce服装目录的AI虚拟试穿
WooCommerce服装目录的AI虚拟试穿自动生成
If
Set
Wait
+7
21 节点Davide
销售
在GIF上交换面孔
使用Fal.run AI和Google服务自动化GIF人脸交换
If
Set
Wait
+6
19 节点Davide
设计
工作流信息
难度等级
中级
节点数量15
分类2
节点类型9
作者
Davide
@n3witaliaFull-stack Web Developer based in Italy specialising in Marketing & AI-powered automations. For business enquiries, send me an email at info@n3w.it or add me on Linkedin.com/in/davideboizza
外部链接
在 n8n.io 查看 →
分享此工作流