基于本地商业搜索的冷邮件开场白：GPT-4和Dumpling AI
中级
这是一个Lead Generation, Multimodal AI领域的自动化工作流，包含 10 个节点。主要使用 Filter, SplitOut, FormTrigger, HttpRequest, GoogleSheets 等节点。 基于本地商业搜索的冷邮件开场白：GPT-4和Dumpling AI
前置要求
- •可能需要目标 API 的认证凭证
- •Google Sheets API 凭证
- •OpenAI API Key
工作流预览
可视化展示节点连接关系，支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
"id": "0qDhUTSyRmBi8kf1",
"meta": {
"instanceId": "a1ae5c8dc6c65e674f9c3947d083abcc749ef2546dff9f4ff01de4d6a36ebfe6",
"templateCredsSetupCompleted": true
},
"name": "Cold Email Icebreakers from Local Business Search with GPT-4 and Dumpling AI",
"tags": [],
"nodes": [
{
"id": "5d586469-2b68-4eca-9d1b-123382c7df53",
"name": "Form: Submit Search Keyword",
"type": "n8n-nodes-base.formTrigger",
"position": [
-360,
-20
],
"webhookId": "db2ca5f4-62f3-412a-b052-3292212ca865",
"parameters": {
"options": {},
"formTitle": "Keyword",
"formFields": {
"values": [
{
"fieldLabel": "Keyword"
}
]
}
},
"typeVersion": 2.2
},
{
"id": "25aa6db4-b732-488b-aa62-17512b364e6b",
"name": "Dumpling AI: Search Google Maps for Businesses",
"type": "n8n-nodes-base.httpRequest",
"position": [
-140,
-20
],
"parameters": {
"url": "https://app.dumplingai.com/api/v1/search-maps",
"method": "POST",
"options": {},
"jsonBody": "={\n \"query\": \"{{$json.Keyword}}\",\n \"page\": \"\"\n}\n",
"sendBody": true,
"specifyBody": "json",
"authentication": "genericCredentialType",
"genericAuthType": "httpHeaderAuth"
},
"credentials": {
"httpHeaderAuth": {
"id": "RLFzAcGRepr5eXZB",
"name": "Dumpling AI-n8n"
}
},
"typeVersion": 4.2
},
{
"id": "f1f7cb08-4b00-4552-b7bc-7bd1d74f8268",
"name": "🧮 Split: Extract Individual Places",
"type": "n8n-nodes-base.splitOut",
"position": [
80,
-20
],
"parameters": {
"options": {},
"fieldToSplitOut": "places"
},
"typeVersion": 1
},
{
"id": "944774ac-686d-40d5-b0f1-8d075367347f",
"name": "🔁 Loop: Process Each Business",
"type": "n8n-nodes-base.splitInBatches",
"position": [
300,
-20
],
"parameters": {
"options": {},
"batchSize": 2
},
"typeVersion": 3
},
{
"id": "d6a3f852-bd40-4c31-92c5-c580cc9338be",
"name": "🧠 Dumpling AI: Extract Email + Website Summary",
"type": "n8n-nodes-base.httpRequest",
"onError": "continueRegularOutput",
"position": [
480,
100
],
"parameters": {
"url": "https://app.dumplingai.com/api/v1/extract",
"method": "POST",
"options": {},
"jsonBody": "={\n \"url\": \"{{ $json.website }}\",\n \"schema\": {\n \"email\": \"string\",\n \"websiteSummary\": \"string\"\n }\n}\n",
"sendBody": true,
"specifyBody": "json",
"authentication": "genericCredentialType",
"genericAuthType": "httpHeaderAuth"
},
"credentials": {
"httpHeaderAuth": {
"id": "RLFzAcGRepr5eXZB",
"name": "Dumpling AI-n8n"
}
},
"typeVersion": 4.2
},
{
"id": "bebe9509-1162-418c-8a04-1f4ec9bee0de",
"name": "✍️ GPT-4: Write Personalized Icebreaker Email",
"type": "@n8n/n8n-nodes-langchain.openAi",
"position": [
720,
100
],
"parameters": {
"modelId": {
"__rl": true,
"mode": "list",
"value": "gpt-4o",
"cachedResultName": "GPT-4O"
},
"options": {},
"messages": {
"values": [
{
"role": "system",
"content": "=Prompt:\n\nYou are a Digital Marketing Specialist writing personalized ice breaker outreach emails.\n\nUsing the information provided below, write a short, friendly, and professional ice breaker message that shows genuine interest in the business and naturally opens the conversation to offer digital marketing help without sounding salesy or generic. The tone should be warm and customized to each business based on what they do.\n\nYour goal is to:\n\nMention something specific about the business using the website summary or keywords\n\nMake it sound like a real person wrote it, not a copy-paste email\n\nGently introduce your digital marketing agency as a potential support partner\n\n\nOutput:\nA short, 4-6 sentence email that:\n\nStarts with a warm ice breaker referencing something specific about the business\n\nExpresses genuine curiosity or admiration for what they do\n\nIntroduces you as someone who runs a digital marketing agency\n\nOpens the door for a conversation without being pushy\n\nExample Format:\n\nHi [First Name or Business Name],\n\nI came across [Business Name] while researching businesses that [reference from keywords or summary], and I was genuinely impressed by [insert insight from website summary]. It’s clear you're doing something meaningful in your space.\n\nI run a digital marketing agency that helps businesses like yours get even more visibility and drive consistent leads online. I’d love to explore how we might support your growth goals.\n\nWould it be okay if I shared a few ideas?"
},
{
"content": "=Input:\n\nBusiness Name: {{ $('🧮 Split: Extract Individual Places').item.json.title }}\n\nKeywords:{{ $('🧮 Split: Extract Individual Places').item.json.types[1] }} \n{{ $('🧮 Split: Extract Individual Places').item.json.types[0] }}\n\nWebsite Summary: {{ $json.results.websiteSummary }}"
}
]
}
},
"credentials": {
"openAiApi": {
"id": "dd8NvMC6rvx8RITo",
"name": "OpenAi account 2"
}
},
"executeOnce": true,
"typeVersion": 1.8
},
{
"id": "7ba29bb7-c99e-4e3e-98c8-ba4bef80fc64",
"name": "✅ IF: Email Exists",
"type": "n8n-nodes-base.filter",
"position": [
1100,
100
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "1cc31bf9-2bc4-4fc3-932e-44d08697cd7a",
"operator": {
"type": "string",
"operation": "exists",
"singleValue": true
},
"leftValue": "={{ $('🧠 Dumpling AI: Extract Email + Website Summary').item.json.results.email }}",
"rightValue": ""
}
]
}
},
"typeVersion": 2.2
},
{
"id": "d299e441-4a1b-491e-880b-b13c78942e46",
"name": "📄 Log to Google Sheets",
"type": "n8n-nodes-base.googleSheets",
"position": [
1320,
100
],
"parameters": {
"columns": {
"value": {
"Email": "={{ $('🧠 Dumpling AI: Extract Email + Website Summary').item.json.results.email }}",
"Phone": "={{ $('🧮 Split: Extract Individual Places').item.json.phoneNumber }}",
"Title": "={{ $('🧮 Split: Extract Individual Places').item.json.title }}",
"Ice Breaker": "={{ $json.message.content }}",
"Website URL": "={{ $('🧮 Split: Extract Individual Places').item.json.website }}",
"Website Summary": "={{ $('🧠 Dumpling AI: Extract Email + Website Summary').item.json.results.websiteSummary }}"
},
"schema": [
{
"id": "Title",
"type": "string",
"display": true,
"required": false,
"displayName": "Title",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Email",
"type": "string",
"display": true,
"required": false,
"displayName": "Email",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Phone",
"type": "string",
"display": true,
"required": false,
"displayName": "Phone",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Ice Breaker",
"type": "string",
"display": true,
"required": false,
"displayName": "Ice Breaker",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Website URL",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Website URL",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Website Summary",
"type": "string",
"display": true,
"required": false,
"displayName": "Website Summary",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"Website URL"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "appendOrUpdate",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1GDIewE5xJMdRWlLJH_b8TnaoahTfRMBgc774VEl95wU/edit#gid=0",
"cachedResultName": "Sheet1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1GDIewE5xJMdRWlLJH_b8TnaoahTfRMBgc774VEl95wU/edit?usp=drivesdk",
"cachedResultName": "Cold email outreach"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "GaJqJHuS5mQxap7q",
"name": "Google Sheets account"
}
},
"typeVersion": 4.6
},
{
"id": "9dcf2513-c329-445f-9cdc-cdbceb8b25a5",
"name": "📤 Instantly API: Add to Campaign",
"type": "n8n-nodes-base.httpRequest",
"position": [
640,
-140
],
"parameters": {
"url": "https://api.instantly.ai/api/v1/lead/add",
"method": "POST",
"options": {},
"sendBody": true,
"authentication": "genericCredentialType",
"bodyParameters": {
"parameters": [
{
"name": "campaign_id",
"value": "CampaignID"
},
{
"name": "email",
"value": "={{ $json.title }}"
},
{
"name": "personalization",
"value": "={{ $('✍️ GPT-4: Write Personalized Icebreaker Email').first().json.message.content }}"
},
{
"name": "phone",
"value": "={{ $('Dumpling AI: Search Google Maps for Businesses').first().json.places[1].phoneNumber }}"
},
{
"name": "website",
"value": "={{ $('Dumpling AI: Search Google Maps for Businesses').first().json.places[1].website }}"
}
]
},
"genericAuthType": "httpHeaderAuth"
},
"credentials": {
"httpHeaderAuth": {
"id": "Db4bdaRp3JlzPR3a",
"name": "Instantly"
}
},
"typeVersion": 4.2
},
{
"id": "9a7f63ba-c5fd-4406-8819-c13331ab025f",
"name": "Sticky Note",
"type": "n8n-nodes-base.stickyNote",
"position": [
-340,
-360
],
"parameters": {
"width": 740,
"height": 440,
"content": "### ✉️ Cold Email Icebreaker Generator\n\nThis workflow:\n- Accepts a keyword (e.g. \"dentist in New York\")\n- Searches local businesses using Dumpling AI\n- Extracts website summaries and emails\n- Uses GPT-4 to write short, friendly icebreaker emails\n- Logs results to Google Sheets\n- Optionally adds leads to Instantly.ai campaigns\n\n✅ Tools Used:\n- Dumpling AI\n- GPT-4\n- Google Sheets\n- Instantly.ai (optional)\n"
},
"typeVersion": 1
}
],
"active": false,
"pinData": {
"Form: Submit Search Keyword": [
{
"json": {
"Keyword": "Dentist in New york",
"formMode": "test",
"submittedAt": "2025-07-18T10:33:34.824+10:00"
}
}
],
"🧠 Dumpling AI: Extract Email + Website Summary": [
{
"json": {
"results": {
"email": "info@209nycdental.com",
"websiteSummary": "209 NYC Dental is a dental practice in New York City offering a variety of services, including general dentistry, cosmetic dentistry, implant dentistry, and periodontics. They have been in practice since 1887 and have a team of experienced dentists and staff. They offer a free consultation and financing options are available."
},
"screenshotUrl": "https://pub-1ff5a17124b34b658b5b75065b3a03e8.r2.dev/temp-bbc74f5f-750b-4af9-b8bf-3355f6bd9c92.png"
}
},
{
"json": {
"results": {
"email": null,
"websiteSummary": "We are committed to providing quality healthcare to families located in the New York area and treat patients of all ages. We provide comprehensive solutions for our patients' oral health needs. Believing in the importance of listening to our patients, we take the time to truly understand each person's needs, goals, and lifestyle. By understanding our patients' objectives we can provide solutions that will improve their health while transforming their smile into something bright and beautiful.\n\nNew York Dental Office is located at 245 E 63rd St #110, New York, NY. We are currently accepting new patients, and you can schedule an appointment by calling 212-548-3261."
},
"screenshotUrl": "https://pub-1ff5a17124b34b658b5b75065b3a03e8.r2.dev/temp-6550bf47-d201-47e2-9278-fec56c2f9901.png"
}
}
]
},
"settings": {
"executionOrder": "v1"
},
"versionId": "82424895-4ea4-4891-a151-6bfa542fdc2d",
"connections": {
"✅ IF: Email Exists": {
"main": [
[
{
"node": "📄 Log to Google Sheets",
"type": "main",
"index": 0
}
]
]
},
"📄 Log to Google Sheets": {
"main": [
[
{
"node": "🔁 Loop: Process Each Business",
"type": "main",
"index": 0
}
]
]
},
"Form: Submit Search Keyword": {
"main": [
[
{
"node": "Dumpling AI: Search Google Maps for Businesses",
"type": "main",
"index": 0
}
]
]
},
"🔁 Loop: Process Each Business": {
"main": [
[
{
"node": "📤 Instantly API: Add to Campaign",
"type": "main",
"index": 0
}
],
[
{
"node": "🧠 Dumpling AI: Extract Email + Website Summary",
"type": "main",
"index": 0
}
]
]
},
"🧮 Split: Extract Individual Places": {
"main": [
[
{
"node": "🔁 Loop: Process Each Business",
"type": "main",
"index": 0
}
]
]
},
"Dumpling AI: Search Google Maps for Businesses": {
"main": [
[
{
"node": "🧮 Split: Extract Individual Places",
"type": "main",
"index": 0
}
]
]
},
"✍️ GPT-4: Write Personalized Icebreaker Email": {
"main": [
[
{
"node": "✅ IF: Email Exists",
"type": "main",
"index": 0
}
]
]
},
"🧠 Dumpling AI: Extract Email + Website Summary": {
"main": [
[
{
"node": "✍️ GPT-4: Write Personalized Icebreaker Email",
"type": "main",
"index": 0
}
]
]
}
}
}常见问题
如何使用这个工作流？
复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景？
中级 - 潜在客户开发, 多模态 AI
需要付费吗？
本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。
相关工作流推荐
使用GPT-4、Dumpling AI和Google Drive生成广告图片变体
使用GPT-4、Dumpling AI和Google Drive生成广告图片变体
Split Out
Form Trigger
Google Drive
+8
14 节点Yang
内容创作
基于AI的潜在客户生成系统（邮件个性化和LinkedIn）
基于AI的潜在客户生成系统：包含邮件个性化和LinkedIn功能
If
Code
Limit
+11
51 节点Matthieu
潜在客户开发
基于AI的潜在客户生成（Apollo、LinkedIn研究和4步个性化邮件）
基于AI的潜在客户生成：使用Apollo、LinkedIn研究和4步个性化邮件
If
Set
Code
+8
30 节点Gain FLow AI
潜在客户开发
使用 Dumpling AI 和 Google 文档的表单转博客自动化
使用 Dumpling AI、OpenAI 和 Google 文档从关键词自动化博客创建
Code
Wait
Limit
+8
17 节点Yang
内容创作
使用 Dumpling AI 从表单自动生成电影级动物视频和声音
使用GPT-4、Dumpling AI和ElevenLabs音频将表单输入转换为电影级视频
Set
Code
Wait
+9
23 节点Yang
内容创作
使用LinkedIn、OpenAI和Sales Navigator创建合格线索和冷呼叫脚本
通过LinkedIn、OpenAI和Sales Navigator创建合格线索和冷呼叫脚本
If
Code
Limit
+11
47 节点Matthieu
潜在客户开发
