使用KlickTipp和自定义私信将Instagram评论转化为潜在客户
中级
这是一个Lead Nurturing, AI Chatbot领域的自动化工作流,包含 12 个节点。主要使用 If, Switch, Webhook, HttpRequest, GoogleSheets 等节点。 使用KlickTipp和自定义私信将Instagram评论转化为潜在客户
前置要求
- •HTTP Webhook 端点(n8n 会自动生成)
- •可能需要目标 API 的认证凭证
- •Google Sheets API 凭证
工作流预览
可视化展示节点连接关系,支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入,即可使用此工作流
{
"meta": {
"instanceId": "95b3ab5a70ab1c8c1906357a367f1b236ef12a1409406fd992f60255f0f95f85",
"templateCredsSetupCompleted": true
},
"nodes": [
{
"id": "17b4422b-47fc-4d28-9906-762cb3f71049",
"name": "监听新的 Instagram 评论",
"type": "n8n-nodes-base.webhook",
"position": [
-304,
0
],
"webhookId": "7dc782c9-e042-4b43-9b59-f0b7705d8cc8",
"parameters": {
"path": "7dc782c9-e042-4b43-9b59-f0b7705d8cc8",
"options": {},
"responseMode": "responseNode"
},
"typeVersion": 2.1
},
{
"id": "2152d1c1-f620-4478-bb57-94c42743cbaa",
"name": "检查首次验证",
"type": "n8n-nodes-base.switch",
"notes": "This node checks whether there is a first validation challenge that needs to be responded to.",
"position": [
-96,
0
],
"parameters": {
"rules": {
"values": [
{
"outputKey": "Initial Webhook verification",
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "d6bafaef-109a-46b8-8053-86a3e3ed04fa",
"operator": {
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $json.query['hub.verify_token'] }}",
"rightValue": "KlickTipp"
}
]
},
"renameOutput": true
},
{
"outputKey": "Processing branch after setup",
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "7c17fb98-6811-49b7-b423-59c329f222d1",
"operator": {
"name": "filter.operator.equals",
"type": "string",
"operation": "equals"
},
"leftValue": "",
"rightValue": ""
}
]
},
"renameOutput": true
}
]
},
"options": {}
},
"notesInFlow": true,
"typeVersion": 3.2
},
{
"id": "5c2c6595-0057-4921-abc8-ef1d57ebc8bf",
"name": "验证挑战",
"type": "n8n-nodes-base.respondToWebhook",
"notes": "This node responds to the webhook when you setup the subscription inside the meta app and sends back the value for the challenge.",
"position": [
128,
-144
],
"parameters": {
"options": {},
"respondWith": "text",
"responseBody": "={{ $json.query['hub.challenge'] }}"
},
"notesInFlow": true,
"typeVersion": 1.4
},
{
"id": "07b31569-056b-4ac1-afdf-fde4bf07bf82",
"name": "便签",
"type": "n8n-nodes-base.stickyNote",
"position": [
-400,
-272
],
"parameters": {
"color": 7,
"width": 704,
"height": 544,
"content": "## 1. 数据接收"
},
"typeVersion": 1
},
{
"id": "e843796f-20d8-4f56-9d84-7ade490a0c5f",
"name": "向用户发送私信表单",
"type": "n8n-nodes-base.httpRequest",
"notes": "This node sends out a DM to a user in Instagram in order to prompt a form submission.",
"position": [
624,
0
],
"parameters": {
"url": "https://graph.instagram.com/v21.0/me/messages",
"method": "POST",
"options": {},
"sendBody": true,
"sendHeaders": true,
"authentication": "genericCredentialType",
"bodyParameters": {
"parameters": [
{
"name": "message",
"value": "={\"text\":\"Hallo {{ $json.body.entry[0].changes[0].value.from.username }} 👋*, danke für deinen Kommentar! 🎉 Damit wir dir dein kostenloses Freebie zuschicken können, musst Du Dich einmal kurz über folgendes Formular einmal eintragen:\\n\\nhttps://form.jotform.com/252682338805059?instagram_username={{ $json.body.entry[0].changes[0].value.from.username }}\\n\\nMit der Angabe erklärst du dich einverstanden, dass wir dich per E-Mail zu Werbezwecken kontaktieren dürfen (z. B. Tipps, Angebote und Infos rund um [Thema]). \\nDeine Daten behandeln wir natürlich vertraulich und du kannst dich jederzeit über einen Link in der E-Mail abmelden.\"}"
},
{
"name": "recipient",
"value": "={\"id\":\"{{ $json.body.entry[0].changes[0].value.from.id }}\"}"
}
]
},
"genericAuthType": "httpHeaderAuth"
},
"credentials": {
"httpHeaderAuth": {
"id": "GkguVYubbVGSDPut",
"name": "Instagram"
}
},
"notesInFlow": true,
"typeVersion": 4.2
},
{
"id": "e0217fec-a444-4c64-8ab4-93b7ef90fa6d",
"name": "便签1",
"type": "n8n-nodes-base.stickyNote",
"position": [
320,
-272
],
"parameters": {
"color": 7,
"width": 480,
"height": 544,
"content": "## 2. 验证并发送消息"
},
"typeVersion": 1
},
{
"id": "85cc1544-caf3-4e47-b01c-9f282d0b8a8d",
"name": "便签2",
"type": "n8n-nodes-base.stickyNote",
"position": [
80,
304
],
"parameters": {
"width": 1072,
"height": 1360,
"content": "## **社区节点免责声明**"
},
"typeVersion": 1
},
{
"id": "7c5ffb38-938a-4067-9a88-54a8ba021905",
"name": "评论是否包含关键词?",
"type": "n8n-nodes-base.if",
"notes": "This node checks if the comment included the intended keyword.",
"position": [
384,
16
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "bf80e26f-bfe8-4c1f-8fad-1ef649e458a9",
"operator": {
"type": "string",
"operation": "contains"
},
"leftValue": "={{ $json.body.entry[0].changes[0].value.text }}",
"rightValue": "keyword"
}
]
}
},
"notesInFlow": true,
"typeVersion": 2.2
},
{
"id": "7d26c483-faf2-4f09-af42-497aadb35ef4",
"name": "便签3",
"type": "n8n-nodes-base.stickyNote",
"position": [
816,
-272
],
"parameters": {
"color": 7,
"width": 656,
"height": 544,
"content": "## 3. 保存数据"
},
"typeVersion": 1
},
{
"id": "6f5b0980-f3b6-42e0-9b25-a4475656d2a2",
"name": "在匹配表中查找条目",
"type": "n8n-nodes-base.googleSheets",
"notes": "This node checks if there is an entry in the matching table for this username.",
"position": [
864,
0
],
"parameters": {
"options": {},
"filtersUI": {
"values": [
{
"lookupValue": "={{ $('Listen to new Instagram comments').item.json.body.entry[0].changes[0].value.from.username }}",
"lookupColumn": "Instagram username"
}
]
},
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1Ou94mTx0gHHdHKr6UQ3Kf01VyIKCNXdlUMhKykTD1Cs/edit#gid=0",
"cachedResultName": "Sheet1"
},
"documentId": {
"__rl": true,
"mode": "url",
"value": "https://docs.google.com/spreadsheets/d/1Ou94mTx0gHHdHKr6UQ3Kf01VyIKCNXdlUMhKykTD1Cs/edit?gid=0#gid=0"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "9lfEu8fQ2DymUZeD",
"name": "MW account"
}
},
"notesInFlow": true,
"typeVersion": 4.7
},
{
"id": "a0ff0eac-81ee-45de-9a42-a287af2b2161",
"name": "条目是否存在?",
"type": "n8n-nodes-base.if",
"notes": "This node checks whether the entry already exists in the matching table.",
"position": [
1056,
0
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "21c3a512-9c5e-4b69-9747-b071c3a0f93d",
"operator": {
"type": "number",
"operation": "exists",
"singleValue": true
},
"leftValue": "={{ $json.row_number }}",
"rightValue": ""
}
]
}
},
"notesInFlow": true,
"typeVersion": 2.2
},
{
"id": "184ab01a-d072-41cb-88d2-72147b41539a",
"name": "将条目添加到匹配表",
"type": "n8n-nodes-base.googleSheets",
"notes": "This node adds an entry to the matching table.",
"position": [
1280,
96
],
"parameters": {
"columns": {
"value": {
"Instagram username": "={{ $('Listen to new Instagram comments').item.json.body.entry[0].changes[0].value.from.username }}",
"Instagram ID comment payload": "={{ $('Listen to new Instagram comments').item.json.body.entry[0].changes[0].value.from.id }}"
},
"schema": [
{
"id": "Instagram username",
"type": "string",
"display": true,
"required": false,
"displayName": "Instagram username",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Instagram ID comment payload",
"type": "string",
"display": true,
"required": false,
"displayName": "Instagram ID comment payload",
"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/1Ou94mTx0gHHdHKr6UQ3Kf01VyIKCNXdlUMhKykTD1Cs/edit#gid=0",
"cachedResultName": "Sheet1"
},
"documentId": {
"__rl": true,
"mode": "url",
"value": "https://docs.google.com/spreadsheets/d/1Ou94mTx0gHHdHKr6UQ3Kf01VyIKCNXdlUMhKykTD1Cs/edit?gid=0#gid=0"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "9lfEu8fQ2DymUZeD",
"name": "MW account"
}
},
"notesInFlow": true,
"typeVersion": 4.7
}
],
"pinData": {
"Listen to new Instagram comments": [
{
"body": {
"entry": [
{
"id": "0",
"time": 1758907014,
"changes": [
{
"field": "comments",
"value": {
"id": "17865799348123123",
"from": {
"id": "2213136375123123",
"username": "username"
},
"text": "This is an example - keyword.",
"media": {
"id": "123123123",
"media_product_type": "FEED"
},
"parent_id": "1231231234"
}
}
]
}
],
"object": "instagram"
},
"query": {},
"params": {},
"headers": {
"host": "n8n-test-u24934.vm.elestio.app",
"accept": "*/*",
"x-real-ip": "31.13.115.2",
"connection": "close",
"user-agent": "Webhooks/1.0 (https://fb.me/webhooks)",
"content-type": "application/json",
"content-length": "308",
"x-forwarded-for": "31.13.115.2",
"x-hub-signature": "sha1=145d5d032cb43396fbf6644642fa5fc8757fa4b0",
"x-forwarded-port": "443",
"x-forwarded-proto": "https",
"x-hub-signature-256": "sha256=0af8f7d1656dd2403a1aa0eb27179078cbf60e4ac8c3c111e2fd993791221c79"
},
"webhookUrl": "https://n8n-test-u24934.vm.elestio.app/webhook-test/7dc782c9-e042-4b43-9b59-f0b7705d8cc8",
"executionMode": "test"
}
]
},
"connections": {
"DM form to user": {
"main": [
[
{
"node": "Look for entry in matching table",
"type": "main",
"index": 0
}
]
]
},
"Does entry exist?": {
"main": [
[],
[
{
"node": "Add entry to matching table",
"type": "main",
"index": 0
}
]
]
},
"Challenge to validate": {
"main": [
[]
]
},
"Check first validation": {
"main": [
[
{
"node": "Challenge to validate",
"type": "main",
"index": 0
}
],
[
{
"node": "Does comment contain keyword?",
"type": "main",
"index": 0
}
]
]
},
"Does comment contain keyword?": {
"main": [
[
{
"node": "DM form to user",
"type": "main",
"index": 0
}
]
]
},
"Listen to new Instagram comments": {
"main": [
[
{
"node": "Check first validation",
"type": "main",
"index": 0
}
]
]
},
"Look for entry in matching table": {
"main": [
[
{
"node": "Does entry exist?",
"type": "main",
"index": 0
}
]
]
}
}
}常见问题
如何使用这个工作流?
复制上方的 JSON 配置代码,在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」,粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景?
中级 - 客户培育, AI 聊天机器人
需要付费吗?
本工作流完全免费,您可以直接导入使用。但请注意,工作流中使用的第三方服务(如 OpenAI API)可能需要您自行付费。
相关工作流推荐
AI驱动的食品订单处理系统,集成Facebook Messenger、Google表格和日历
AI驱动的食品订单处理系统,集成Facebook Messenger、Google表格和日历
If
Code
Webhook
+8
26 节点Hans Wilhelm Radam
客户培育
基于参与度自动化Zoom参会者分群到KlickTipp
基于参与度自动化Zoom参会者分群到KlickTipp
Klicktipp
If
Set
+10
22 节点KlickTipp
内容创作
Zoom网络研讨会自动化出席标记系统(集成KlickTipp)
Zoom网络研讨会自动化出席标记系统(集成KlickTipp)
Klicktipp
If
Set
+10
29 节点KlickTipp
社交媒体
通过Excel和VAPI语音助手实现餐厅营销与预订自动化
使用Excel、VAPI语音助手和日历自动化餐厅营销与预订
Set
Code
Webhook
+7
11 节点Oneclick AI Squad
客户培育
使用Google表格和Puppeteer自动化Instagram私信与互动
使用Google表格和Puppeteer自动化Instagram私信与互动
If
Code
Wait
+9
43 节点Nitesh
客户培育
基于Airtable CRM、Gmail和网络研究的AI销售助手
基于Airtable CRM、Gmail和网络研究的AI销售助手
If
Gmail
Switch
+13
40 节点LeeWei
客户培育
工作流信息
难度等级
中级
节点数量12
分类2
节点类型7
作者
KlickTipp
@KlickTippReach more people. 100% GDPR compliant. Quickly create automated email campaigns, SMS and marketing automations. Market your knowledge independently of Google & Co., sell lucrative products and activate your customers.
外部链接
在 n8n.io 查看 →
分享此工作流