通过AI潜在客户生成的智能房地产电子邮件和电话营销
高级
这是一个Lead Nurturing, Multimodal AI领域的自动化工作流，包含 23 个节点。主要使用 Code, Wait, Gmail, Webhook, HttpRequest 等节点。 使用Llama AI、VAPI呼叫和Gmail营销活动自动化房地产营销
前置要求
- •Google 账号和 Gmail API 凭证
- •HTTP Webhook 端点（n8n 会自动生成）
- •可能需要目标 API 的认证凭证
- •Google Sheets API 凭证
使用的节点 (23)
工作流预览
可视化展示节点连接关系，支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
"id": "winYQ758rQnKUEwz",
"meta": {
"instanceId": "dd69efaf8212c74ad206700d104739d3329588a6f3f8381a46a481f34c9cc281",
"templateCredsSetupCompleted": true
},
"name": "通过 AI 潜在客户生成的智能房地产电子邮件和电话营销",
"tags": [],
"nodes": [
{
"id": "c41e4b49-9c64-44c7-941f-b855d1c156b9",
"name": "Llama 3.2 - 推广内容模型",
"type": "@n8n/n8n-nodes-langchain.lmChatOllama",
"position": [
768,
640
],
"parameters": {
"model": "llama3.2-16000:latest",
"options": {}
},
"credentials": {
"ollamaApi": {
"id": "vDhjHnEfhHheDgd6",
"name": "Ollama-vrushti"
}
},
"typeVersion": 1
},
{
"id": "360ef908-8473-420f-ad04-288a804cd56d",
"name": "查看房地产报价单",
"type": "n8n-nodes-base.googleSheetsTrigger",
"position": [
240,
370
],
"parameters": {
"options": {},
"pollTimes": {
"item": [
{
"mode": "everyMinute"
}
]
},
"sheetName": {
"__rl": true,
"mode": "id",
"value": 1574728929
},
"documentId": {
"__rl": true,
"mode": "id",
"value": "1kRRDSoJNzVQAUbunYzAk-KUBcMjhuUw0PydGjLbbEVg"
}
},
"credentials": {
"googleSheetsTriggerOAuth2Api": {
"id": "BoDTTv5L67GVL3Fi",
"name": "Google Sheets - test"
}
},
"typeVersion": 1
},
{
"id": "7459aa86-67c4-417b-b20f-4693e564884d",
"name": "获取客户联系人列表",
"type": "n8n-nodes-base.googleSheets",
"position": [
460,
370
],
"parameters": {
"options": {},
"sheetName": {
"__rl": true,
"mode": "id",
"value": "gid=0"
},
"documentId": {
"__rl": true,
"mode": "id",
"value": "1kRRDSoJNzVQAUbunYzAk-KUBcMjhuUw0PydGjLbbEVg"
},
"authentication": "serviceAccount"
},
"credentials": {
"googleApi": {
"id": "ScSS2KxGQULuPtdy",
"name": "Google Sheets- test"
}
},
"typeVersion": 4.6
},
{
"id": "70fe474a-74fd-44c4-88e2-37d40805fe1d",
"name": "通过 VAPI 触发语音营销活动",
"type": "n8n-nodes-base.httpRequest",
"position": [
720,
-20
],
"parameters": {
"url": "https://api.vapi.ai/call",
"method": "POST",
"options": {},
"jsonBody": "={\n \"assistantId\": \"add_id_here\",\n \"phoneNumberId\": \"add_phone_number_id_here\",\n \"customers\": [\n {\n \"number\": \"add_vapi_agent_phonenumber_here\"\n }\n ]\n}",
"sendBody": true,
"sendHeaders": true,
"specifyBody": "json",
"headerParameters": {
"parameters": [
{
"name": "Authorization",
"value": "add_authorization_token_here"
}
]
}
},
"typeVersion": 4.2
},
{
"id": "05c2d036-974b-4d8d-a1d3-de241e0ad2c8",
"name": "使用 Llama 生成推广内容",
"type": "@n8n/n8n-nodes-langchain.agent",
"position": [
680,
420
],
"parameters": {
"text": "=You are an expert real estate sales copywriter. Based on the provided property offer, craft a persuasive and emotionally engaging promotional message for WhatsApp or Email that drives immediate action and lead generation through calls or clicks.\n\n🎯 Objective:\nDrive lead inquiries and bookings by showcasing value, urgency, and exclusivity in an impactful, action-focused message.\n\n📌 Format Guidelines:\n\nMax 150 words\n\nShort, crisp lines (WhatsApp/email friendly)\n\nAdd 3–5 real-estate-relevant emojis for appeal\n\nUse a warm, enthusiastic, benefit-driven tone\n\nBold hooks, emotional appeal, urgency & CTA\n\nUse <ul> lists for features and benefits\n\n📋 Offer Data:\n\nProject Name: {{ $json.title }}\n\nLocation: {{ $json.location }}\n\nDiscount: {{ $json.discount }}\n\nValid Till: {{ $json.validity }}\n\nInclusions: {{ $json.products_included }}\n\nOriginal Price: {{ $json.original_price }}\n\nOffer Price: {{ $json.discounted_price }}\n\nFreebie/Bonus: {{ $json.bonus }}\n\nContact Action: {{ $json.cta }}\n\n📢 Message Structure:\n\nCatchy Headline with 1–2 emojis + {{ $json.title }} or location hook\n\nEmotional intro (e.g., “Your dream home awaits” / “Invest smart, live better”)\n\nMention original price vs offer price + discount clearly\n\nFeature list in <ul> – highlight rooms, view, amenities\n\nBenefit list in <ul> – ROI, lifestyle, security, location perks\n\nHighlight {{ $json.bonus }} as exclusive gift 🎁\n\nCreate urgency – {{ $json.validity }} + “limited units” with ⏳\n\nEnd with high-energy CTA + contact/call prompt: {{ $json.cta }}\n\n🧾 Sample Output Format:\n\n🏡 LIMITED DEAL IN {{ $json.location }}! 🌇\n\nLooking for your dream property? This is the sign you've been waiting for!\n\n💰 Just {{ $json.discounted_price }} ({{ $json.discount }} OFF {{ $json.original_price }})!\n\n✨ What You Get:\n\n<ul> <li>3BHK Spacious Apartment with Balcony View</li> <li>Modern Kitchen, Smart Layout, Prime Location</li> </ul>\n🔑 Why It's Perfect:\n\n<ul> <li>✔️ Excellent ROI & Growing Area</li> <li>✔️ Secure Gated Community with Top Amenities</li> <li>✔️ Ideal for Families or Investors</li> </ul>\n🎁 Bonus: {{ $json.bonus }} included exclusively!\n\n⏳ Hurry! Offer valid till {{ $json.validity }}. Limited units available!\n\n📞 {{ $json.cta }} now to book your site visit or get full details!",
"options": {},
"promptType": "define"
},
"typeVersion": 2
},
{
"id": "c60a67d2-c2e9-4cda-99a3-998acaeefaf7",
"name": "延迟以同步数据",
"type": "n8n-nodes-base.wait",
"position": [
1056,
520
],
"webhookId": "76321858-c2b9-4c53-bc5f-90b4e32e2693",
"parameters": {},
"typeVersion": 1.1
},
{
"id": "33e6da41-1d90-448b-99bf-6e504799951c",
"name": "创建个性化邮件模板",
"type": "n8n-nodes-base.code",
"position": [
1276,
520
],
"parameters": {
"jsCode": "const emails = items.map(item => item.json.Emial);\nreturn [\n {\n json: {\n allEmails: emails.join(\", \"),\n output : $('Generate Promo Content with Llama').first().json.output\n }\n }\n];\n"
},
"typeVersion": 2
},
{
"id": "3f4f7f36-dfc0-4dd0-aae6-629aa036811f",
"name": "向客户发送推广邮件 (Gmail)",
"type": "n8n-nodes-base.gmail",
"position": [
1496,
520
],
"webhookId": "012ca109-03f0-445c-826c-45b4e85d21fe",
"parameters": {
"sendTo": "={{ $json.allEmails }}",
"message": "={{ $json.output }}",
"options": {},
"subject": "Offer",
"emailType": "text"
},
"credentials": {
"gmailOAuth2": {
"id": "PcTqvGU9uCunfltE",
"name": "Gmail account - test"
}
},
"typeVersion": 2.1
},
{
"id": "683c5242-cd5b-4797-a260-f7be9aad0c2f",
"name": "从 VAPI 接收潜在客户数据",
"type": "n8n-nodes-base.webhook",
"position": [
240,
1100
],
"webhookId": "60d5fdeb-b5d8-4e71-90d0-182acc695404",
"parameters": {
"path": "60d5fdeb-b5d8-4e71-90d0-182acc695404",
"options": {},
"httpMethod": "POST",
"responseMode": "responseNode"
},
"typeVersion": 2
},
{
"id": "6bee22d4-c599-42ca-a98e-c80e6a3e3283",
"name": "潜在客户解析延迟",
"type": "n8n-nodes-base.wait",
"position": [
500,
1100
],
"webhookId": "7d356500-7ff6-4133-805f-5aa5cd5b2310",
"parameters": {},
"typeVersion": 1.1
},
{
"id": "37dceb9f-374d-43d6-8f4d-46ff4040e43d",
"name": "将潜在客户保存到 CRM 表格",
"type": "n8n-nodes-base.googleSheets",
"position": [
760,
1100
],
"parameters": {
"columns": {
"value": {
"Name ": "={{ $json.body.message.toolCallList[0].function.arguments.name }}",
"Company name": "={{ $json.body.message.toolCallList[0].function.arguments.company_name }}",
"Company size": "={{ $json.body.message.toolCallList[0].function.arguments.company_size }}"
},
"schema": [
{
"id": "Name ",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Name ",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Company name",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Company name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Company size",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Company size",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "autoMapInputData",
"matchingColumns": [
"Name "
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "appendOrUpdate",
"sheetName": {
"__rl": true,
"mode": "id",
"value": "gid=0"
},
"documentId": {
"__rl": true,
"mode": "id",
"value": "1DCq5a_I2KyD0Tt5Z_TqluZOM1sq6KI05PaxmVVI7J4o"
},
"authentication": "serviceAccount"
},
"credentials": {
"googleApi": {
"id": "ScSS2KxGQULuPtdy",
"name": "Google Sheets- test"
}
},
"typeVersion": 4.5
},
{
"id": "b1e6b857-f0b2-4e6f-a8fb-23e7d8ef4f81",
"name": "向 VAPI 发送确认",
"type": "n8n-nodes-base.respondToWebhook",
"position": [
1000,
1100
],
"parameters": {
"options": {}
},
"typeVersion": 1.2
},
{
"id": "0f0056d4-5d72-4b41-bf9d-5b4b3522fde0",
"name": "便签",
"type": "n8n-nodes-base.stickyNote",
"position": [
200,
220
],
"parameters": {
"color": 3,
"width": 160,
"height": 340,
"content": "当表格 1 中添加/更新新报价时触发。启动营销活动。"
},
"typeVersion": 1
},
{
"id": "aeb5d09d-bca4-404c-9bd0-df7546f93fbd",
"name": "便签1",
"type": "n8n-nodes-base.stickyNote",
"position": [
960,
920
],
"parameters": {
"color": 4,
"width": 160,
"height": 340,
"content": "向 VAPI 发送成功响应，确认潜在客户已保存。"
},
"typeVersion": 1
},
{
"id": "3082042c-8524-4637-b708-ed3395776d6e",
"name": "便签2",
"type": "n8n-nodes-base.stickyNote",
"position": [
720,
920
],
"parameters": {
"width": 160,
"height": 340,
"content": "将合格的潜在客户添加到 Google Sheets CRM 以供后续跟进。"
},
"typeVersion": 1
},
{
"id": "9bba9391-3b55-4dd1-b992-d85b2fa2afa5",
"name": "便签3",
"type": "n8n-nodes-base.stickyNote",
"position": [
460,
920
],
"parameters": {
"color": 3,
"width": 160,
"height": 340,
"content": "短暂等待以确保 VAPI 潜在客户负载被完全捕获和解析。"
},
"typeVersion": 1
},
{
"id": "a6dc7a3e-a3d3-4e03-969f-279416c03683",
"name": "便签4",
"type": "n8n-nodes-base.stickyNote",
"position": [
220,
920
],
"parameters": {
"color": 5,
"width": 160,
"height": 340,
"content": "从 VAPI 语音呼叫表单捕获潜在客户信息（姓名、联系方式、兴趣等）。"
},
"typeVersion": 1
},
{
"id": "1be66d0b-e30b-48fb-834c-77581862fdc9",
"name": "便签5",
"type": "n8n-nodes-base.stickyNote",
"position": [
680,
-220
],
"parameters": {
"width": 180,
"height": 340,
"content": "使用 VAPI API 启动向客户的自动语音呼叫，包含关键报价详情。"
},
"typeVersion": 1
},
{
"id": "60edd47d-5e4e-4118-aa61-36c25957b2bb",
"name": "便签6",
"type": "n8n-nodes-base.stickyNote",
"position": [
1020,
360
],
"parameters": {
"color": 2,
"width": 160,
"height": 340,
"content": "添加暂停以确保所有先前操作（API、表格、AI）完成。"
},
"typeVersion": 1
},
{
"id": "93662cd4-dac8-407a-b43f-0ef436030660",
"name": "便签7",
"type": "n8n-nodes-base.stickyNote",
"position": [
1240,
360
],
"parameters": {
"color": 5,
"width": 160,
"height": 340,
"content": "将 AI 输出格式化为准备发送给客户的 HTML/文本邮件。"
},
"typeVersion": 1
},
{
"id": "b8e0d638-0f9b-4110-aae7-38c138ca92b0",
"name": "便签8",
"type": "n8n-nodes-base.stickyNote",
"position": [
1480,
380
],
"parameters": {
"color": 4,
"width": 160,
"height": 340,
"content": "使用 Gmail 或 SMTP 向每个客户发送个性化报价营销活动。"
},
"typeVersion": 1
},
{
"id": "491498cf-4b34-4952-8030-0efd609fa112",
"name": "便签9",
"type": "n8n-nodes-base.stickyNote",
"position": [
680,
240
],
"parameters": {
"color": 6,
"width": 300,
"height": 340,
"content": "使用 AI 根据更新的报价创建个性化营销内容。"
},
"typeVersion": 1
},
{
"id": "12b91ddf-12b4-4933-a75d-f31b64c0a977",
"name": "便签10",
"type": "n8n-nodes-base.stickyNote",
"position": [
420,
220
],
"parameters": {
"color": 4,
"width": 160,
"height": 340,
"content": "从表格 2 获取电子邮件/电话信息，以针对此报价的客户。"
},
"typeVersion": 1
}
],
"active": false,
"pinData": {},
"settings": {
"executionOrder": "v1"
},
"versionId": "1f7cc259-cf7c-4710-99f6-881706d55882",
"connections": {
"Delay to Sync Data": {
"main": [
[
{
"node": "Create Personalized Email Template",
"type": "main",
"index": 0
}
]
]
},
"Delay for Lead Parsing": {
"main": [
[
{
"node": "Save Lead to CRM Sheet",
"type": "main",
"index": 0
}
]
]
},
"Save Lead to CRM Sheet": {
"main": [
[
{
"node": "Send Acknowledgement to VAPI",
"type": "main",
"index": 0
}
]
]
},
"Get Client Contact List": {
"main": [
[
{
"node": "Trigger Voice Campaign via VAPI",
"type": "main",
"index": 0
},
{
"node": "Generate Promo Content with Llama",
"type": "main",
"index": 0
}
]
]
},
"Receive Lead Data from VAPI": {
"main": [
[
{
"node": "Delay for Lead Parsing",
"type": "main",
"index": 0
}
]
]
},
"Watch Real Estate Offer Sheet": {
"main": [
[
{
"node": "Get Client Contact List",
"type": "main",
"index": 0
}
]
]
},
"Llama 3.2 - Promo Content Model": {
"ai_languageModel": [
[
{
"node": "Generate Promo Content with Llama",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"Generate Promo Content with Llama": {
"main": [
[
{
"node": "Delay to Sync Data",
"type": "main",
"index": 0
}
]
]
},
"Create Personalized Email Template": {
"main": [
[
{
"node": "Email Promo to Clients (Gmail)",
"type": "main",
"index": 0
}
]
]
}
}
}常见问题
如何使用这个工作流？
复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景？
高级 - 客户培育, 多模态 AI
需要付费吗？
本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。
相关工作流推荐
智能活动跟进与社交助手
使用 GPT-4、LinkedIn 和 HubSpot 多渠道触达实现活动跟进自动化
Code
Filter
Hubspot
+8
25 节点Oneclick AI Squad
客户培育
09 - 潜在客户档案增强器
自动化潜在客户信息丰富与个性化外联：HubSpot、Phantombuster和GPT
If
Set
Code
+11
30 节点Avkash Kakdiya
客户培育
通过Excel和VAPI语音助手实现餐厅营销与预订自动化
使用Excel、VAPI语音助手和日历自动化餐厅营销与预订
Set
Code
Webhook
+7
11 节点Oneclick AI Squad
客户培育
放射学图像转详细报告转换器
使用GPT-4 Vision和PDF邮件将放射学图像转换为患者友好报告
Code
Wait
Gmail
+4
12 节点Oneclick AI Squad
文档提取
通过Excel + AI的智能邮件营销生成器（表格到收件箱）
基于Google Sheets使用Llama AI生成个性化营销邮件
Code
Gmail
Google Sheets
+4
7 节点Oneclick AI Squad
社交媒体
AI症状检查与医生推荐
使用Ollama AI和WhatsApp的医疗症状分析与医生推荐
If
Code
Webhook
+6
15 节点Oneclick AI Squad
客服机器人
工作流信息
难度等级
高级
节点数量23
分类2
节点类型11
作者
Oneclick AI Squad
@oneclick-aiThe AI Squad Initiative is a pioneering effort to build, automate and scale AI-powered workflows using n8n.io. Our mission is to help individuals and businesses integrate AI agents seamlessly into their daily operations from automating tasks and enhancing productivity to creating innovative, intelligent solutions. We design modular, reusable AI workflow templates that empower creators, developers and teams to supercharge their automation with minimal effort and maximum impact.
外部链接
在 n8n.io 查看 →
分享此工作流