太阳能线索重新激活
高级
这是一个Lead Nurturing, AI Summarization领域的自动化工作流，包含 28 个节点。主要使用 Code, Wait, OpenAi, Twilio, Webhook 等节点。 AI驱动的短信、邮件和Google表格自动化重新激活太阳能线索
前置要求
- •OpenAI API Key
- •HTTP Webhook 端点（n8n 会自动生成）
- •Google Sheets API 凭证
工作流预览
可视化展示节点连接关系，支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
"id": "FcYSrOOmvhHNunFy",
"meta": {
"instanceId": "2000c64071c20843606b95c63795bb0797c41036047055a6586498e855b96efc",
"templateCredsSetupCompleted": true
},
"name": "太阳能线索重新激活",
"tags": [],
"nodes": [
{
"id": "b0c58e82-6c8c-4eb6-b43f-b7e7f8cf4541",
"name": "📋 工作流概述",
"type": "n8n-nodes-base.stickyNote",
"position": [
-4020,
-780
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "a1148985-cdc2-4418-ba2f-dd68cdf99513",
"name": "📊 Google 表格指南",
"type": "n8n-nodes-base.stickyNote",
"position": [
-4020,
-40
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "6c978b0a-a2fd-4055-8a71-dcd10f681d4a",
"name": "📅 序列策略",
"type": "n8n-nodes-base.stickyNote",
"position": [
-2820,
60
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "bdffcefe-1fdb-4e62-87c8-6d7fc5da6789",
"name": "🤖 AI 响应指南",
"type": "n8n-nodes-base.stickyNote",
"position": [
-2540,
-860
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "439691b2-5432-4084-9771-002f98ca6e23",
"name": "⚙️ 设置说明",
"type": "n8n-nodes-base.stickyNote",
"position": [
-3460,
20
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "534718b3-76c2-4ac1-a38a-420d9b23906e",
"name": "📈 性能指南",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1380,
20
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "59729b30-c802-459b-ba7f-e93cb89713e6",
"name": "筛选准备就绪的线索",
"type": "n8n-nodes-base.code",
"position": [
-3140,
-200
],
"parameters": {},
"typeVersion": 2
},
{
"id": "201e24e6-c323-4c0e-9e1d-33b22025bf79",
"name": "一次处理一个线索",
"type": "n8n-nodes-base.splitInBatches",
"position": [
-2920,
-200
],
"parameters": {},
"typeVersion": 3
},
{
"id": "1a87c08d-7255-467a-8db3-efe20fabb560",
"name": "标记序列为活跃",
"type": "n8n-nodes-base.googleSheets",
"position": [
-2680,
-180
],
"parameters": {},
"typeVersion": 4
},
{
"id": "deb0608e-20b1-487d-b1d8-5553a2782b5b",
"name": "第 1 周短信",
"type": "n8n-nodes-base.twilio",
"position": [
-2480,
-200
],
"parameters": {},
"typeVersion": 1
},
{
"id": "fd8af3c2-def5-4930-9aa9-74ef58e20e73",
"name": "等待 1 周",
"type": "n8n-nodes-base.wait",
"position": [
-2260,
-200
],
"webhookId": "8dbcc0c3-7c8f-4379-8de8-620e384ad734",
"parameters": {},
"typeVersion": 1
},
{
"id": "5f82ebd0-3542-4593-abe1-77e1f53541f9",
"name": "第 2 周短信",
"type": "n8n-nodes-base.twilio",
"position": [
-2040,
-200
],
"parameters": {},
"typeVersion": 1
},
{
"id": "6251747b-d48f-430c-b83b-4e55da14d1e7",
"name": "等待 2 周",
"type": "n8n-nodes-base.wait",
"position": [
-1820,
-200
],
"webhookId": "ebd029b7-f494-4a71-a0db-55d54d92ee19",
"parameters": {},
"typeVersion": 1
},
{
"id": "0b30cc3a-1cb0-48a4-a189-4693d16553b1",
"name": "第 3 周电子邮件",
"type": "n8n-nodes-base.emailSend",
"position": [
-1600,
-200
],
"webhookId": "1b6d26cb-a6d9-4209-8c15-b61963e954c7",
"parameters": {},
"typeVersion": 2
},
{
"id": "47feb955-2114-4dca-b8bb-b85772ea6762",
"name": "等待 3 周",
"type": "n8n-nodes-base.wait",
"position": [
-1380,
-200
],
"webhookId": "760109bb-d6cb-4b39-b8bb-ebbe5594c561",
"parameters": {},
"typeVersion": 1
},
{
"id": "8f1f5bff-9b9e-4719-937e-4ae368835628",
"name": "第 4 周短信",
"type": "n8n-nodes-base.twilio",
"position": [
-1160,
-200
],
"parameters": {},
"typeVersion": 1
},
{
"id": "9e0efcd8-55bc-436c-8ba8-93b79153d271",
"name": "等待 4 周",
"type": "n8n-nodes-base.wait",
"position": [
-940,
-200
],
"webhookId": "a7a4c962-f708-4f85-962b-8ad6833cbe91",
"parameters": {},
"typeVersion": 1
},
{
"id": "b989f278-a414-4c85-b4c2-9889b50e1edd",
"name": "最终短信",
"type": "n8n-nodes-base.twilio",
"position": [
-720,
-200
],
"parameters": {},
"typeVersion": 1
},
{
"id": "e0f29e52-59de-412e-82ce-d31c814b1330",
"name": "标记序列完成",
"type": "n8n-nodes-base.googleSheets",
"position": [
-500,
-200
],
"parameters": {},
"typeVersion": 4
},
{
"id": "83b2ca04-9208-4cae-a7f5-dff7591d675b",
"name": "短信回复 Webhook",
"type": "n8n-nodes-base.webhook",
"position": [
-3460,
-380
],
"webhookId": "d81bb540-23ad-49fe-9ed9-f843cf72ffe9",
"parameters": {},
"typeVersion": 2
},
{
"id": "77dead87-4773-454d-b350-2bc691e558fb",
"name": "解析回复",
"type": "n8n-nodes-base.code",
"position": [
-3240,
-380
],
"parameters": {},
"typeVersion": 2
},
{
"id": "42c46794-317f-40bd-b484-6131863807d3",
"name": "查找线索数据",
"type": "n8n-nodes-base.googleSheets",
"position": [
-3020,
-380
],
"parameters": {},
"typeVersion": 4
},
{
"id": "619280ca-c23c-4375-a1db-4aab8eaa4e56",
"name": "AI 生成响应",
"type": "n8n-nodes-base.openAi",
"position": [
-2800,
-380
],
"parameters": {},
"typeVersion": 1
},
{
"id": "42bab90b-ca10-460c-ae68-91933166a875",
"name": "发送 AI 回复",
"type": "n8n-nodes-base.twilio",
"position": [
-2580,
-380
],
"parameters": {},
"typeVersion": 1
},
{
"id": "3615cce3-9a70-4a39-ae48-21b007759cd5",
"name": "分析响应意图",
"type": "n8n-nodes-base.code",
"position": [
-2360,
-380
],
"parameters": {},
"typeVersion": 2
},
{
"id": "ed6fc588-55f4-418a-aba7-0f3d4a85a92a",
"name": "更新响应状态",
"type": "n8n-nodes-base.googleSheets",
"position": [
-2140,
-380
],
"parameters": {},
"typeVersion": 4
},
{
"id": "ff293413-c2dc-463b-937e-01212e432ce7",
"name": "计划触发器",
"type": "n8n-nodes-base.scheduleTrigger",
"position": [
-3580,
-200
],
"parameters": {},
"typeVersion": 1.2
},
{
"id": "9940fab1-ef0f-4bdf-bd31-5e1c1db32554",
"name": "获取表格中的行",
"type": "n8n-nodes-base.googleSheets",
"position": [
-3360,
-200
],
"parameters": {},
"typeVersion": 4.6
}
],
"active": false,
"pinData": {},
"settings": {
"executionOrder": "v1"
},
"versionId": "a05dd95b-ec73-4398-8d02-a4e08d8e0b9c",
"connections": {
"Final SMS": {
"main": [
[
{
"node": "Mark Sequence Complete",
"type": "main",
"index": 0
}
]
]
},
"Week 1 SMS": {
"main": [
[
{
"node": "Wait 1 Week",
"type": "main",
"index": 0
}
]
]
},
"Week 2 SMS": {
"main": [
[
{
"node": "Wait 2 Weeks",
"type": "main",
"index": 0
}
]
]
},
"Week 4 SMS": {
"main": [
[
{
"node": "Wait 4 Weeks",
"type": "main",
"index": 0
}
]
]
},
"Parse Reply": {
"main": [
[
{
"node": "Find Lead Data",
"type": "main",
"index": 0
}
]
]
},
"Wait 1 Week": {
"main": [
[
{
"node": "Week 2 SMS",
"type": "main",
"index": 0
}
]
]
},
"Wait 2 Weeks": {
"main": [
[
{
"node": "Week 3 Email",
"type": "main",
"index": 0
}
]
]
},
"Wait 3 Weeks": {
"main": [
[
{
"node": "Week 4 SMS",
"type": "main",
"index": 0
}
]
]
},
"Wait 4 Weeks": {
"main": [
[
{
"node": "Final SMS",
"type": "main",
"index": 0
}
]
]
},
"Week 3 Email": {
"main": [
[
{
"node": "Wait 3 Weeks",
"type": "main",
"index": 0
}
]
]
},
"Send AI Reply": {
"main": [
[
{
"node": "Analyze Response Intent",
"type": "main",
"index": 0
}
]
]
},
"Find Lead Data": {
"main": [
[
{
"node": "AI Generate Response",
"type": "main",
"index": 0
}
]
]
},
"Schedule Trigger": {
"main": [
[
{
"node": "Get row(s) in sheet",
"type": "main",
"index": 0
}
]
]
},
"SMS Reply Webhook": {
"main": [
[
{
"node": "Parse Reply",
"type": "main",
"index": 0
}
]
]
},
"Filter Ready Leads": {
"main": [
[
{
"node": "Process One Lead at a Time",
"type": "main",
"index": 0
}
]
]
},
"Get row(s) in sheet": {
"main": [
[
{
"node": "Filter Ready Leads",
"type": "main",
"index": 0
}
]
]
},
"AI Generate Response": {
"main": [
[
{
"node": "Send AI Reply",
"type": "main",
"index": 0
}
]
]
},
"Mark Sequence Active": {
"main": [
[
{
"node": "Week 1 SMS",
"type": "main",
"index": 0
}
]
]
},
"Analyze Response Intent": {
"main": [
[
{
"node": "Update Response Status",
"type": "main",
"index": 0
}
]
]
},
"Process One Lead at a Time": {
"main": [
[],
[
{
"node": "Mark Sequence Active",
"type": "main",
"index": 0
}
]
]
}
}
}常见问题
如何使用这个工作流？
复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景？
高级 - 客户培育, AI 摘要总结
需要付费吗？
本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。
相关工作流推荐
通过邮件和短信发送自动患者预约提醒，支持多数据库
通过邮件和短信发送自动患者预约提醒，支持多数据库
Set
Code
Wait
+7
23 节点David Olusola
客服机器人
潜在客户开发与邮件工作流
使用Google Maps、SendGrid和AI自动化B2B潜在客户开发与邮件营销
If
Set
Code
+21
141 节点Ezema Kingsley Chibuzo
潜在客户开发
使用Google套件、PDF和邮件自动化商业保险提交
通过Google套件、PDF和邮件自动化商业保险提交流程
If
Set
Code
+10
37 节点David Olusola
文档提取
使用Apollo.io和Google表格的自动化LinkedIn潜在客户丰富管道
使用Apollo.io和Google表格的自动化LinkedIn潜在客户丰富管道
If
Code
Wait
+10
33 节点Rahi Uppal
潜在客户开发
每日 WhatsApp 群组智能分析：GPT-4.1 分析与语音消息转录
每日 WhatsApp 群组智能分析：GPT-4.1 分析与语音消息转录
If
Set
Code
+20
52 节点Daniel Lianes
杂项
使用GPT-4自动总结Zoom录制并发送到Slack和邮件
使用GPT-4自动总结Zoom录制并发送到Slack和邮件
Code
Gmail
Slack
+3
6 节点David Olusola
AI 摘要总结
工作流信息
难度等级
高级
节点数量28
分类2
节点类型10
作者
David Olusola
@dae221I help ambitious businesses eliminate operational bottlenecks and scale faster with AI automation. My clients typically see 40-60% efficiency gains within 90 days. Currently accepting 3 new projects this quarter - david@daexai.com
外部链接
在 n8n.io 查看 →
分享此工作流