潜在客户磁铁生成
中级
这是一个Content Creation, Multimodal AI领域的自动化工作流，包含 15 个节点。主要使用 If, Wait, HttpRequest, GoogleSheets, SplitInBatches 等节点。 使用RapidAPI AI从谷歌表格生成潜在客户磁铁创意
前置要求
- •可能需要目标 API 的认证凭证
- •Google Sheets API 凭证
- •Google Drive API 凭证
工作流预览
可视化展示节点连接关系，支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
"id": "XbA6Q2NrTmh3RvvK",
"meta": {
"instanceId": "60c025075753afcab9f803964b4caaca9402f435deb4efafbb8e3b93b54d8752",
"templateCredsSetupCompleted": true
},
"name": "潜在客户磁铁生成",
"tags": [],
"nodes": [
{
"id": "0e3082c1-cb3d-4b6e-9367-c3da75a02da5",
"name": "HTTP 请求",
"type": "n8n-nodes-base.httpRequest",
"position": [
1060,
160
],
"parameters": {
"url": "https://lead-magnet-idea-generator-ai.p.rapidapi.com/index.php",
"method": "POST",
"options": {},
"sendBody": true,
"contentType": "multipart-form-data",
"sendHeaders": true,
"bodyParameters": {
"parameters": [
{
"name": "topic",
"value": "={{ $json.Topic }}"
},
{
"name": "website",
"value": "={{ $json['Website Url'] }}"
}
]
},
"headerParameters": {
"parameters": [
{
"name": "x-rapidapi-host",
"value": "lead-magnet-idea-generator-ai.p.rapidapi.com"
},
{
"name": "x-rapidapi-key"
}
]
}
},
"typeVersion": 4.2
},
{
"id": "5dd91b00-0670-430f-aeed-365cee02225b",
"name": "遍历项目",
"type": "n8n-nodes-base.splitInBatches",
"position": [
480,
0
],
"parameters": {
"options": {
"reset": false
}
},
"typeVersion": 3
},
{
"id": "2e99095a-b29f-428c-990d-b6fffd40adcb",
"name": "等待",
"type": "n8n-nodes-base.wait",
"position": [
1640,
140
],
"webhookId": "74ac1ccb-f843-41b8-97c4-b8d32892a5ea",
"parameters": {
"amount": 10
},
"typeVersion": 1.1
},
{
"id": "952b9061-9f2c-41b4-9f0a-1567160f3540",
"name": "如果",
"type": "n8n-nodes-base.if",
"position": [
800,
20
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "e0b7b7c8-3a7a-466d-bae7-269282b49d34",
"operator": {
"type": "string",
"operation": "notEmpty",
"singleValue": true
},
"leftValue": "={{ $json.Topic }}",
"rightValue": ""
},
{
"id": "64dde394-0e49-4306-a24a-de2bf448fc95",
"operator": {
"type": "string",
"operation": "empty",
"singleValue": true
},
"leftValue": "={{ $json.Content }}",
"rightValue": ""
}
]
}
},
"typeVersion": 2.2
},
{
"id": "9a000b36-5933-4891-9b1d-e31ef6092ed8",
"name": "Google Sheets1",
"type": "n8n-nodes-base.googleSheets",
"position": [
180,
0
],
"parameters": {
"options": {},
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "",
"cachedResultName": "Sheet1"
},
"documentId": {
"__rl": true,
"mode": "url",
"value": ""
},
"authentication": "serviceAccount"
},
"credentials": {
"googleApi": {
"id": "qUtlCnYpk7bXXaYp",
"name": "Google Sheets account 3"
}
},
"typeVersion": 4.6
},
{
"id": "64b72bb3-a25a-4cc7-843a-79f25486afd8",
"name": "Google Drive 触发器",
"type": "n8n-nodes-base.googleDriveTrigger",
"position": [
-80,
0
],
"parameters": {
"pollTimes": {
"item": [
{
"mode": "everyMinute"
}
]
},
"triggerOn": "specificFile",
"fileToWatch": {
"__rl": true,
"mode": "url",
"value": ""
},
"authentication": "serviceAccount"
},
"credentials": {
"googleApi": {
"id": "qUtlCnYpk7bXXaYp",
"name": "Google Sheets account 3"
}
},
"typeVersion": 1
},
{
"id": "2d1d2710-ea6a-4953-bdd7-8f6341177066",
"name": "Google Sheets2",
"type": "n8n-nodes-base.googleSheets",
"position": [
1360,
140
],
"parameters": {
"columns": {
"value": {
"Topic": "={{ $('If').item.json.Topic }}",
"Content": "={{ $json.data }}",
"Website Url": "={{ $('If').item.json['Website Url'] }}",
"Generated Date": "={{ new Date().toLocaleString() }}"
},
"schema": [
{
"id": "Topic",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Topic",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Website Url",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Website Url",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Content",
"type": "string",
"display": true,
"required": false,
"displayName": "Content",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Generated Date",
"type": "string",
"display": true,
"required": false,
"displayName": "Generated Date",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"Topic"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "appendOrUpdate",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "",
"cachedResultName": "Sheet1"
},
"documentId": {
"__rl": true,
"mode": "url",
"value": ""
},
"authentication": "serviceAccount"
},
"credentials": {
"googleApi": {
"id": "qUtlCnYpk7bXXaYp",
"name": "Google Sheets account 3"
}
},
"typeVersion": 4.6
},
{
"id": "831e52d3-07f3-4f33-b820-9e33b13d5506",
"name": "便签",
"type": "n8n-nodes-base.stickyNote",
"position": [
-880,
-480
],
"parameters": {
"width": 660,
"height": 940,
"content": "# 🚀 潜在客户磁铁创意生成工作流"
},
"typeVersion": 1
},
{
"id": "0c29124c-3409-4682-8dda-a4319e8844a8",
"name": "便签1",
"type": "n8n-nodes-base.stickyNote",
"position": [
-160,
-420
],
"parameters": {
"height": 640,
"content": "### 📌 节点：Google Drive触发器"
},
"typeVersion": 1
},
{
"id": "731e5f13-05c1-43bb-9810-a41955f2ecf5",
"name": "便签2",
"type": "n8n-nodes-base.stickyNote",
"position": [
120,
-420
],
"parameters": {
"height": 640,
"content": "### 📌 节点：Google Sheets1"
},
"typeVersion": 1
},
{
"id": "9fbf2aed-8272-47b0-8a89-5b0abcf02e79",
"name": "便签3",
"type": "n8n-nodes-base.stickyNote",
"position": [
420,
-420
],
"parameters": {
"height": 640,
"content": "### 📌 节点：循环遍历项目"
},
"typeVersion": 1
},
{
"id": "52a1ecbe-9942-4f6f-9d32-a44a0e3e3a1f",
"name": "便签4",
"type": "n8n-nodes-base.stickyNote",
"position": [
700,
-420
],
"parameters": {
"height": 640,
"content": "### 📌 节点：条件判断"
},
"typeVersion": 1
},
{
"id": "86e47d98-d052-4203-b056-9442f20b0fa4",
"name": "便签5",
"type": "n8n-nodes-base.stickyNote",
"position": [
980,
-420
],
"parameters": {
"width": 280,
"height": 820,
"content": "### 📌 节点：HTTP请求"
},
"typeVersion": 1
},
{
"id": "866680d1-8d17-45ab-81eb-b7a1cb9448d0",
"name": "便签6",
"type": "n8n-nodes-base.stickyNote",
"position": [
1280,
-420
],
"parameters": {
"height": 700,
"content": "### 📌 节点：Google Sheets2"
},
"typeVersion": 1
},
{
"id": "0d382187-48dc-45cc-bc27-cba36049bd6b",
"name": "便签7",
"type": "n8n-nodes-base.stickyNote",
"position": [
1560,
-420
],
"parameters": {
"height": 680,
"content": "### 📌 节点：等待"
},
"typeVersion": 1
}
],
"active": false,
"pinData": {},
"settings": {
"executionOrder": "v1"
},
"versionId": "4caf167f-472a-4c9e-aef3-4b77c3fa4b93",
"connections": {
"If": {
"main": [
[
{
"node": "HTTP Request",
"type": "main",
"index": 0
}
],
[
{
"node": "Loop Over Items",
"type": "main",
"index": 0
}
]
]
},
"Wait": {
"main": [
[
{
"node": "Loop Over Items",
"type": "main",
"index": 0
}
]
]
},
"HTTP Request": {
"main": [
[
{
"node": "Google Sheets2",
"type": "main",
"index": 0
}
]
]
},
"Google Sheets1": {
"main": [
[
{
"node": "Loop Over Items",
"type": "main",
"index": 0
}
]
]
},
"Google Sheets2": {
"main": [
[
{
"node": "Wait",
"type": "main",
"index": 0
}
]
]
},
"Loop Over Items": {
"main": [
[],
[
{
"node": "If",
"type": "main",
"index": 0
}
]
]
},
"Google Drive Trigger": {
"main": [
[
{
"node": "Google Sheets1",
"type": "main",
"index": 0
}
]
]
}
}
}常见问题
如何使用这个工作流？
复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景？
中级 - 内容创作, 多模态 AI
需要付费吗？
本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。
相关工作流推荐
TikTok转录文本
使用RapidAPI和Google Sheets自动化TikTok视频转录
If
Code
Wait
+5
21 节点Evoort Solutions
内容创作
使用图像转图像GPT、Google Sheets和Drive生成并上传图片
使用图像转图像GPT、Google Sheets和Drive生成并上传图片
If
Code
Wait
+6
23 节点Evoort Solutions
内容创作
Flux AI 文生图副本
使用 Flux AI 集成 Google Sheets 和 Drive 的文生图生成器
If
Code
Wait
+6
23 节点Evoort Solutions
内容创作
无水印TikTok视频下载至Google Drive并自动记录到表格
将无水印TikTok视频下载到Google Drive，并自动在表格中记录日志
If
Wait
Form Trigger
+4
19 节点Evoort Solutions
内容创作
使用背景移除AI处理图像并在Google表格中跟踪结果
使用背景移除AI处理图像并在Google表格中跟踪结果
If
Wait
Form Trigger
+4
17 节点Evoort Solutions
内容创作
使用 Job Search Global API 和 Google Sheets 自动化职位搜索
使用 Job Search Global API 和 Google Sheets 自动化职位搜索
If
Set
Code
+5
15 节点Evoort Solutions
内容创作
