个性化邮件
中级
这是一个Lead Nurturing, Multimodal AI领域的自动化工作流，包含 8 个节点。主要使用 If, Set, GoogleSheets, ScheduleTrigger, ChainLlm 等节点。 使用Gemini AI和Google表格创建个性化销售外联邮件
前置要求
- •Google Sheets API 凭证
- •Google Gemini API Key
工作流预览
可视化展示节点连接关系，支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入，即可使用此工作流
{
"name": "个性化邮件",
"nodes": [
{
"id": "c3a221a2-d3e3-47f3-a897-6781a29857a4",
"name": "从表格读取潜在客户",
"type": "n8n-nodes-base.googleSheets",
"position": [
-400,
0
],
"parameters": {
"options": {},
"sheetName": {
"__rl": true,
"mode": "list",
"value": "Your_Sheet_GID",
"cachedResultUrl": "Your_Sheet_URL",
"cachedResultName": "Your_Sheet_Name"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "YOUR_SPREADSHEET_ID_HERE",
"cachedResultUrl": "Your_Spreadsheet_URL",
"cachedResultName": "Your_Spreadsheet_Name"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "Your_Credentials_Id",
"name": "Google Sheets account"
}
},
"typeVersion": 4
},
{
"id": "23b2b8e8-e26c-4586-9ec1-dba83ab0069c",
"name": "为表格准备数据",
"type": "n8n-nodes-base.set",
"position": [
400,
0
],
"parameters": {
"values": {
"string": [
{
"name": "updated_email",
"value": "={{ $input.item.json.text }}"
}
]
},
"options": {}
},
"typeVersion": 2
},
{
"id": "7e937d3d-3483-442e-b89c-57ce699609ed",
"name": "用邮件更新表格",
"type": "n8n-nodes-base.googleSheets",
"position": [
620,
0
],
"parameters": {
"columns": {
"value": {
"Email": "={{ $('Read Leads from Sheet').item.json.Email }}",
"subject": "= {{ $json.output.subject }}",
"email_body": "={{ $json.output.email_body }}"
},
"schema": [
{
"id": "Name",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Title",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Title",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Company",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Company",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Location",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Location",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Education",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Education",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "LinkedIn_Connections",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "LinkedIn_Connections",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Industry_Focus",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Industry_Focus",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Key_Expertise",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Key_Expertise",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "LinkedIn_URL",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "LinkedIn_URL",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Email",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Email",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Company_Type",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Company_Type",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Focus_Areas",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Focus_Areas",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Growth_Stage",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Growth_Stage",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Pain_Points",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Pain_Points",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Location_Opportunities",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Location_Opportunities",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Email_Template",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Email_Template",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "LinkedIn_DM_Template",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "LinkedIn_DM_Template",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Company_Website",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Company_Website",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "email_body",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "email_body",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "subject",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "subject",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "row_number",
"type": "string",
"display": true,
"removed": true,
"readOnly": true,
"required": false,
"displayName": "row_number",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"Email"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "update",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "Your_Sheet_GID",
"cachedResultUrl": "Your_Sheet_URL",
"cachedResultName": "Your_Sheet_Name"
},
"documentId": {
"__rl": true,
"mode": "id",
"value": "=1p6vuSjRfTiSUrPa3CR4wQA8c9NyuS18K2UMhP_bWx08"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "Your_Credentials_Id",
"name": "Google Sheets account"
}
},
"typeVersion": 4
},
{
"id": "9120c44a-92a4-4f06-83a5-045bd7e17a07",
"name": "基础LLM链",
"type": "@n8n/n8n-nodes-langchain.chainLlm",
"position": [
40,
0
],
"parameters": {
"text": "=You are an expert email copywriter for Intuz, a company offering AI Engineering and AI Service solutions.\n\nYour task is to generate the components for a single, concise, professional, and conversational email outreach (100-120 words).\n\n---\n**CONTEXT & DATA**\n* Prospect Name: {{ $('Read Leads from Sheet').item.json.Name }}\n* Company Name: {{ $('Read Leads from Sheet').item.json.Company }}\n* Persona / Title: {{ $('Read Leads from Sheet').item.json.Title }}\n* CTA Link: [https://calendly.com/YOUR_LINK]\n\n---\n**INSTRUCTIONS**\n* **Pain Point:** Focus on one of these: slow AI feature rollouts, difficulty integrating AI, scaling challenges, or security concerns.\n* **Value Proposition:** Highlight how Intuz's AI Engineering services solve that specific pain point (e.g., rapid development, seamless integration, scalable workflows).\n* **Structure:** The email body must start with a question addressing the pain point, briefly explain the solution, and end with a CTA for a 15-minute call using the provided link.\n* **Tone:** Conversational, empathetic, and professional.\n* **Subject Line:** Generate a catchy, question-based subject line (under 8 words) tied to the pain point.\n* **Personalization:** Use the prospect's data to tailor the message.\n* **CRITICAL FORMATTING:** Structure the `email_body` into 3 distinct paragraphs. Use the markdown newline character `\\n\\n` to separate each paragraph for clean spacing and readability.\n* **Constraints:** Keep the body 100-120 words. No salutation (e.g., \"Hi Tobias,\") or sign-off (e.g., \"Best,\") should be included in the email body.\n\n---\n**REQUIRED OUTPUT**\nYou MUST format your response as a valid JSON object containing two keys: \"subject\" and \"email_body\".",
"batching": {},
"promptType": "define",
"hasOutputParser": true
},
"typeVersion": 1.7
},
{
"id": "3434b60b-85ea-4221-94c4-3abf64f8ff17",
"name": "Google Gemini聊天模型",
"type": "@n8n/n8n-nodes-langchain.lmChatGoogleGemini",
"position": [
60,
220
],
"parameters": {
"options": {},
"modelName": "models/gemini-2.5-flash"
},
"credentials": {
"googlePalmApi": {
"id": "Your_Gemini_API",
"name": "Your Google Gemini API"
}
},
"typeVersion": 1
},
{
"id": "e62f603b-d063-4f90-9d13-ce599b536bed",
"name": "结构化输出解析器",
"type": "@n8n/n8n-nodes-langchain.outputParserStructured",
"position": [
180,
220
],
"parameters": {
"jsonSchemaExample": "{\n \"subject\": \"A short, catchy, question-based subject line\",\n \"email_body\": \"The full email body, 100-120 words, without any salutation or sign-off.\"\n}"
},
"typeVersion": 1.3
},
{
"id": "323a2628-a30a-4b20-8a56-2d0677c6c5af",
"name": "计划触发器",
"type": "n8n-nodes-base.scheduleTrigger",
"position": [
-620,
0
],
"parameters": {
"rule": {
"interval": [
{
"field": "minutes",
"minutesInterval": 30
}
]
}
},
"typeVersion": 1.2
},
{
"id": "cbca8f8d-959d-45b9-a801-20386034a844",
"name": "条件判断",
"type": "n8n-nodes-base.if",
"position": [
-180,
0
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "0640b75d-662e-4625-a038-92c099b79f25",
"operator": {
"type": "string",
"operation": "empty",
"singleValue": true
},
"leftValue": "={{ $json.email_body }}",
"rightValue": ""
},
{
"id": "6d30f170-03fd-4e89-9a56-ab87e8c7c01a",
"operator": {
"type": "string",
"operation": "empty",
"singleValue": true
},
"leftValue": "={{ $json.subject }}",
"rightValue": ""
}
]
}
},
"typeVersion": 2.2
}
],
"active": true,
"pinData": {},
"settings": {
"executionOrder": "v1"
},
"connections": {
"If": {
"main": [
[
{
"node": "Basic LLM Chain",
"type": "main",
"index": 0
}
]
]
},
"Basic LLM Chain": {
"main": [
[
{
"node": "Prepare Data for Sheet",
"type": "main",
"index": 0
}
]
]
},
"Schedule Trigger": {
"main": [
[
{
"node": "Read Leads from Sheet",
"type": "main",
"index": 0
}
]
]
},
"Read Leads from Sheet": {
"main": [
[
{
"node": "If",
"type": "main",
"index": 0
}
]
]
},
"Prepare Data for Sheet": {
"main": [
[
{
"node": "Update Sheet with Email",
"type": "main",
"index": 0
}
]
]
},
"Update Sheet with Email": {
"main": [
[]
]
},
"Google Gemini Chat Model": {
"ai_languageModel": [
[
{
"node": "Basic LLM Chain",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"Structured Output Parser": {
"ai_outputParser": [
[
{
"node": "Basic LLM Chain",
"type": "ai_outputParser",
"index": 0
}
]
]
}
}
}常见问题
如何使用这个工作流？
复制上方的 JSON 配置代码，在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」，粘贴配置后根据需要修改凭证设置即可。
这个工作流适合什么场景？
中级 - 客户培育, 多模态 AI
需要付费吗？
本工作流完全免费，您可以直接导入使用。但请注意，工作流中使用的第三方服务（如 OpenAI API）可能需要您自行付费。
相关工作流推荐
使用Apify、Google Gemini和Sheets实时自动化Upwork提案生成
使用Apify、Google Gemini和Sheets自动化AI Upwork提案生成
If
Set
Gmail
+8
25 节点Intuz
潜在客户开发
实时自动化 LinkedIn 档案研究与 AI 外联（使用 Apify、Gemini 和 Sheets）
使用 Apify、Gemini 和 Sheets 自动化 LinkedIn 档案研究与邮件外联
If
Limit
Google Sheets
+6
20 节点Intuz
潜在客户开发
使用Apify、Apollo.io和Google Gemini自动化LinkedIn职位AI驱动潜在客户生成
自动化LinkedIn职位潜在客户生成：Apify、Apollo.io和Google Gemini
If
Code
Limit
+11
47 节点Intuz
潜在客户开发
开发完成 - FAX 内容提取
传真和 PDF 数据提取工作流：使用 Google Gemini 和 Google Sheets
Set
Code
Form Trigger
+8
18 节点Intuz
内容创作
LinkedIn和X病毒内容自动引擎
使用AI生成和发布自动创建LinkedIn和X的病毒内容
If
Set
Wait
+26
156 节点Diptamoy Barman
内容创作
使用 Gemini、Tavily 和人工审核生成 SEO 优化 WordPress 博客
使用 Gemini、Tavily 和人工审核生成 SEO 优化 WordPress 博客
If
Set
Code
+12
38 节点Aryan Shinde
内容创作
工作流信息
难度等级
中级
节点数量8
分类2
节点类型7
作者
Intuz
@intuzA boutique tech consulting company, helping businesses with custom AI/ML, Workflow Automations, and software development.
外部链接
在 n8n.io 查看 →
分享此工作流