使用Claude 3.5、Channable和Relevance AI自动生成谷歌广告文案
高级
这是一个Content Creation, Multimodal AI领域的自动化工作流，包含 19 个节点。主要使用 If, Set, Code, Slack, Aggregate 等节点。 通过Claude 3.5、Channable和Relevance AI自动生成谷歌广告文案
前置要求
- •Slack Bot Token 或 Webhook URL
- •可能需要目标 API 的认证凭证
- •Google Sheets API 凭证
工作流预览
可视化展示节点连接关系，支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
"meta": {
"instanceId": "04fd795d32aabb18b913b4a3350b5cd0e9313a422ea0e7bdac0da2fb76cac9f7"
},
"nodes": [
{
"id": "b07b40c1-4c8c-4c35-aa07-be7025ed68b2",
"name": "获取产品源",
"type": "n8n-nodes-base.httpRequest",
"notes": "CORRECTED: Uses v1 API if available, or replace with your e-commerce platform feed endpoint",
"position": [
-1380,
820
],
"parameters": {
"url": "={{$env.CHANNABLE_API_URL}}/v1/projects/{{$env.PROJECT_ID}}/items",
"options": {},
"authentication": "genericCredentialType",
"genericAuthType": "httpHeaderAuth"
},
"credentials": {
"httpHeaderAuth": {
"id": "luTyM3gZSgwhM8i0",
"name": "Header Auth account"
}
},
"typeVersion": 4.2
},
{
"id": "4b90a3bc-da44-44bc-b19a-d81427545f26",
"name": "格式化为 CSV",
"type": "n8n-nodes-base.set",
"notes": "Formats compliant ads into CSV structure",
"position": [
560,
700
],
"parameters": {
"options": {}
},
"typeVersion": 3.3
},
{
"id": "bea6c2f0-4a95-4848-85a1-780cc048b26d",
"name": "警报 - 不合规",
"type": "n8n-nodes-base.slack",
"notes": "Sends Slack alert for non-compliant ads. Can replace with Email node.",
"position": [
560,
900
],
"webhookId": "50d6fb83-2c83-4b57-80f9-5bb46d6b9fdf",
"parameters": {
"text": "=⚠️ Non-Compliant Ad Flagged\n\n*Product ID:* {{$json.product_id}}\n*Product Title:* {{$json.product_title}}\n*Category:* {{$json.category}}\n\n*Generated Headline:* {{$json.validated_headline}}\n*Generated Description:* {{$json.validated_description}}\n\n*Compliance Issues:* Check agent output\n\n*Timestamp:* {{$json.validation_timestamp}}",
"otherOptions": {}
},
"typeVersion": 2.1
},
{
"id": "95f53395-e93d-4309-8f98-d2b2378cbb13",
"name": "聚合批次",
"type": "n8n-nodes-base.aggregate",
"notes": "Combines all processed batches into single dataset",
"position": [
760,
700
],
"parameters": {
"options": {},
"aggregate": "aggregateAllItemData"
},
"typeVersion": 1
},
{
"id": "56492a38-1188-4b35-999f-14017ac76484",
"name": "保存到 Google Sheets",
"type": "n8n-nodes-base.googleSheets",
"notes": "CORRECTED: Saves CSV data to Google Sheets instead of Channable API upload (which doesn't exist). You can then: 1) Import manually to Google Ads, 2) Use Channable scheduled import, or 3) Build Google Ads API direct upload",
"position": [
1160,
700
],
"parameters": {
"options": {},
"sheetName": {
"__rl": true,
"mode": "name",
"value": "Generated Ads"
},
"documentId": {
"__rl": true,
"mode": "id",
"value": "={{$env.GOOGLE_SHEET_ID}}"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "0xHwEMloLvs9YH5S",
"name": "Google Sheets account"
}
},
"typeVersion": 4.4
},
{
"id": "f25d680c-28ad-43f5-96c8-0f022cf1a710",
"name": "计划触发器 - 每日1",
"type": "n8n-nodes-base.scheduleTrigger",
"notes": "Triggers workflow daily at midnight. Can also be triggered manually.",
"position": [
-1600,
820
],
"parameters": {
"rule": {
"interval": [
{
"field": "cronExpression",
"expression": "0 0 * * *"
}
]
}
},
"typeVersion": 1
},
{
"id": "01a193ae-a04f-4a04-9c3e-0a40c8e197c5",
"name": "分批处理1",
"type": "n8n-nodes-base.splitInBatches",
"notes": "Processes 50 products at a time to avoid API rate limits",
"position": [
-1140,
820
],
"parameters": {
"options": {},
"batchSize": 50
},
"typeVersion": 3
},
{
"id": "50792985-2a29-4aeb-8191-2a1ef3d7ec97",
"name": "生成广告文案 - Relevance AI1",
"type": "n8n-nodes-base.httpRequest",
"notes": "CORRECTED: Uses /trigger endpoint with tool ID from environment variable. Get your actual tool ID after creating in Relevance AI.",
"position": [
-880,
800
],
"parameters": {
"url": "={{$env.RELEVANCE_AI_API_URL}}/tools/google_text_ad_copy_generator/run",
"method": "POST",
"options": {
"timeout": 60000
},
"jsonBody": "={\n \"params\": {\n \"product_title\": \"{{$json.title}}\",\n \"product_description\": \"{{$json.description}}\",\n \"price\": \"{{$json.price}}\",\n \"category\": \"{{$json.category}}\",\n \"brand\": \"{{$json.brand}}\"\n }\n}",
"sendBody": true,
"specifyBody": "json",
"authentication": "genericCredentialType",
"genericAuthType": "httpHeaderAuth"
},
"credentials": {
"httpHeaderAuth": {
"id": "luTyM3gZSgwhM8i0",
"name": "Header Auth account"
}
},
"typeVersion": 4.2
},
{
"id": "17d67f83-8300-41c5-a3ac-9b7ea4bc25c2",
"name": "验证字符限制1",
"type": "n8n-nodes-base.code",
"notes": "Validates headline ≤30 chars and description ≤90 chars. This is the fix from the YouTube video for accurate character counting.",
"position": [
-560,
800
],
"parameters": {
"jsCode": "// Character limit validation with accurate counting\n\nconst headline = $input.item.json.headline || '';\nconst description = $input.item.json.description || '';\n\n// Function to accurately count displayed characters\nfunction getCharacterCount(str) {\n str = str.trim();\n return str.length;\n}\n\n// Validate headline (max 30 characters)\nlet headlineResult = {};\nconst headlineCount = getCharacterCount(headline);\n\nif (headlineCount > 30) {\n let truncated = headline.substring(0, 27).trim();\n truncated = truncated.replace(/[,.\\-:]$/, '');\n headlineResult = {\n headline: truncated + '...',\n char_count: truncated.length + 3,\n truncated: true,\n original: headline\n };\n} else {\n headlineResult = {\n headline: headline,\n char_count: headlineCount,\n truncated: false,\n original: headline\n };\n}\n\n// Validate description (max 90 characters)\nlet descriptionResult = {};\nconst descriptionCount = getCharacterCount(description);\n\nif (descriptionCount > 90) {\n let truncated = description.substring(0, 87).trim();\n truncated = truncated.replace(/[,.\\-:]$/, '');\n descriptionResult = {\n description: truncated + '...',\n char_count: truncated.length + 3,\n truncated: true,\n original: description\n };\n} else {\n descriptionResult = {\n description: description,\n char_count: descriptionCount,\n truncated: false,\n original: description\n };\n}\n\n// Return validated data with original product info\nreturn {\n product_id: $input.item.json.product_id || $input.item.json.id,\n product_title: $input.item.json.product_title || $input.item.json.title,\n validated_headline: headlineResult.headline,\n headline_char_count: headlineResult.char_count,\n headline_truncated: headlineResult.truncated,\n validated_description: descriptionResult.description,\n description_char_count: descriptionResult.char_count,\n description_truncated: descriptionResult.truncated,\n category: $input.item.json.category,\n final_url: $input.item.json.product_url || $input.item.json.link,\n validation_timestamp: new Date().toISOString()\n};"
},
"typeVersion": 2
},
{
"id": "534ea658-ea94-4d4c-a4e3-5d5fa1c699b6",
"name": "合规检查代理1",
"type": "n8n-nodes-base.httpRequest",
"notes": "CORRECTED: Uses /agents/trigger with agent_id in body. Get your actual agent ID from Relevance AI.",
"position": [
-160,
800
],
"parameters": {
"url": "={{$env.RELEVANCE_AI_API_URL}}/agents/google_ads_compliance_checker/run",
"method": "POST",
"options": {
"timeout": 60000
},
"jsonBody": "={\n \"message\": {\n \"role\": \"user\",\n \"content\": \"Check compliance for this ad: Headline: {{$json.validated_headline}}, Description: {{$json.validated_description}}, Category: {{$json.category}}\"\n },\n \"agent_id\": \"{{$env.RELEVANCE_AGENT_COMPLIANCE_ID}}\"\n}",
"sendBody": true,
"specifyBody": "json",
"authentication": "genericCredentialType",
"genericAuthType": "httpHeaderAuth"
},
"credentials": {
"httpHeaderAuth": {
"id": "luTyM3gZSgwhM8i0",
"name": "Header Auth account"
}
},
"typeVersion": 4.2
},
{
"id": "c9bfe847-7215-4ae5-a61e-4eb24ae1da0c",
"name": "如果合规1",
"type": "n8n-nodes-base.if",
"notes": "Routes ads based on compliance status. APPROVED ads go to formatting, others trigger alert.",
"position": [
160,
800
],
"parameters": {
"options": {},
"conditions": {
"string": [
{
"value1": "={{$json.compliance_status || $json.output}}",
"value2": "APPROVED",
"operation": "contains"
}
]
}
},
"typeVersion": 2
},
{
"id": "5a27e0f1-d4e7-4a81-9700-dd1c368fbb0b",
"name": "生成 CSV 文件1",
"type": "n8n-nodes-base.code",
"notes": "Converts JSON to properly escaped CSV format",
"position": [
960,
700
],
"parameters": {
"jsCode": "// Generate CSV from aggregated data\n\nconst items = $input.all();\n\n// CSV headers\nconst headers = ['product_id', 'headline', 'description', 'final_url', 'display_url'];\n\n// Create CSV rows\nconst rows = items.map(item => {\n const json = item.json;\n return [\n json.product_id || '',\n json.headline || '',\n json.description || '',\n json.final_url || '',\n json.display_url || ''\n ];\n});\n\n// Convert to CSV string\nconst csvRows = [headers, ...rows];\nconst csvString = csvRows\n .map(row => row.map(cell => `\"${String(cell).replace(/\"/g, '\"\"')}\"`).join(','))\n .join('\\n');\n\n// Return CSV data\nreturn {\n csv_data: csvString,\n total_ads: rows.length,\n generated_at: new Date().toISOString(),\n filename: `google_ads_${new Date().toISOString().split('T')[0]}.csv`\n};"
},
"typeVersion": 2
},
{
"id": "55d4429b-b4a9-4a19-bb34-2f58d7881a5c",
"name": "成功通知1",
"type": "n8n-nodes-base.slack",
"notes": "Sends success notification with summary",
"position": [
1360,
700
],
"webhookId": "04afb760-a7e8-4d2d-9827-1ed01108405d",
"parameters": {
"text": "=✅ *Google Ads Generation Complete*\n\n📊 *Summary:*\n• Total Ads Generated: {{$node['Generate CSV File1'].json.total_ads}}\n• Saved to Google Sheets: {{$env.GOOGLE_SHEET_ID}}\n• Timestamp: {{$node['Generate CSV File1'].json.generated_at}}\n\n🎯 *Next Steps:*\n• Review ads in Google Sheet\n• Import to Google Ads (manual or scheduled)\n• Monitor for disapprovals in 24 hours\n\n💡 CSV filename: {{$node['Generate CSV File1'].json.filename}}",
"otherOptions": {}
},
"typeVersion": 2.1
},
{
"id": "9af47779-8ca3-4e7c-9d3d-76f419c45361",
"name": "便签",
"type": "n8n-nodes-base.stickyNote",
"position": [
-2060,
760
],
"parameters": {
"width": 360,
"height": 220,
"content": "## 🟦 计划触发器 - 每日"
},
"typeVersion": 1
},
{
"id": "d563b4b9-7239-4bb1-ab62-73b924643715",
"name": "便签1",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1500,
400
],
"parameters": {
"width": 340,
"height": 320,
"content": "## 🟦 获取产品源 (Channable)"
},
"typeVersion": 1
},
{
"id": "538ff6d6-5496-42db-90c4-2f22a1f228f4",
"name": "便签2",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1240,
980
],
"parameters": {
"width": 320,
"height": 240,
"content": "## 🟦 分批处理"
},
"typeVersion": 1
},
{
"id": "bb106886-79a8-437c-8f74-50939befe720",
"name": "便签4",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1020,
400
],
"parameters": {
"width": 340,
"height": 320,
"content": "## 🟦 生成广告文案 - Relevance AI"
},
"typeVersion": 1
},
{
"id": "eabe3ce0-d216-426d-8cc3-e1411f36c385",
"name": "便签3",
"type": "n8n-nodes-base.stickyNote",
"position": [
-680,
980
],
"parameters": {
"width": 320,
"height": 300,
"content": "## 🟦 验证字符限制"
},
"typeVersion": 1
},
{
"id": "adb78971-8b7e-4eaf-9d9a-c47439b35c12",
"name": "便签5",
"type": "n8n-nodes-base.stickyNote",
"position": [
-320,
400
],
"parameters": {
"width": 340,
"height": 320,
"content": "## 🟦 合规检查代理"
},
"typeVersion": 1
}
],
"pinData": {},
"connections": {
"IF Compliant1": {
"main": [
[
{
"node": "Format for CSV",
"type": "main",
"index": 0
}
],
[
{
"node": "Alert - Non-Compliant",
"type": "main",
"index": 0
}
]
]
},
"Format for CSV": {
"main": [
[
{
"node": "Aggregate Batches",
"type": "main",
"index": 0
}
]
]
},
"Get Product Feed": {
"main": [
[
{
"node": "Split Into Batches1",
"type": "main",
"index": 0
}
]
]
},
"Aggregate Batches": {
"main": [
[
{
"node": "Generate CSV File1",
"type": "main",
"index": 0
}
]
]
},
"Generate CSV File1": {
"main": [
[
{
"node": "Save to Google Sheets",
"type": "main",
"index": 0
}
]
]
},
"Split Into Batches1": {
"main": [
[
{
"node": "Generate Ad Copy - Relevance AI1",
"type": "main",
"index": 0
}
]
]
},
"Save to Google Sheets": {
"main": [
[
{
"node": "Success Notification1",
"type": "main",
"index": 0
}
]
]
},
"Compliance Check Agent1": {
"main": [
[
{
"node": "IF Compliant1",
"type": "main",
"index": 0
}
]
]
},
"Schedule Trigger - Daily1": {
"main": [
[
{
"node": "Get Product Feed",
"type": "main",
"index": 0
}
]
]
},
"Validate Character Limits1": {
"main": [
[
{
"node": "Compliance Check Agent1",
"type": "main",
"index": 0
}
]
]
},
"Generate Ad Copy - Relevance AI1": {
"main": [
[
{
"node": "Validate Character Limits1",
"type": "main",
"index": 0
}
]
]
}
}
}常见问题
如何使用这个工作流？
复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景？
高级 - 内容创作, 多模态 AI
需要付费吗？
本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。
相关工作流推荐
使用Channable Feed和Relevance AI自动化Google广告文案优化
使用Channable Feed和Relevance AI自动化Google广告文案优化
Code
Slack
Http Request
+4
16 节点Nikan Noorafkan
内容创作
🛍️ 使用 Channable、Relevance AI 和 Merchant API 优化 Google Shopping Feed
🛍️ 使用 Channable、Relevance AI 和 Merchant API 优化 Google Shopping Feed
If
Code
Slack
+5
19 节点Nikan Noorafkan
内容创作
WordPress博客自动化专业版（深度研究）v2.1市场
使用GPT-4o、Perplexity AI和多语言支持自动化SEO优化的博客创建
If
Set
Xml
+27
125 节点Daniel Ng
内容创作
使用AI和Freepik将Reddit商业痛点转换为病毒式LinkedIn内容
使用AI和Freepik将Reddit商业痛点转换为病毒式LinkedIn内容
If
Set
Code
+16
48 节点Daniel Lianes
内容创作
使用 OpenAI、QuickChart 和 Google Drive 将电子表格数据转换为智能图表
使用 OpenAI、QuickChart 和 Google Drive 将电子表格数据转换为智能图表
If
Set
Code
+18
82 节点LeeWei
内容创作
内容生成器 v3
AI驱动博客自动化：使用GPT-4生成并发布SEO文章至WordPress和Twitter
If
Set
Code
+25
144 节点Jay Emp0
内容创作
工作流信息
难度等级
高级
节点数量19
分类2
节点类型10
作者
Nikan Noorafkan
@nikkannooraHey, I’m Nikan Noorafkan — a creator passionate about building smart, automated workflows that drive business outcomes. With a background in performance marketing, user acquisition, and retention strategies, I use n8n to connect data, automate repetitive tasks, and scale growth across the funnel.
外部链接
在 n8n.io 查看 →
分享此工作流