カスタマイズされたメール
中級
これはLead Nurturing, Multimodal AI分野の自動化ワークフローで、8個のノードを含みます。主にIf, Set, GoogleSheets, ScheduleTrigger, ChainLlmなどのノードを使用。 Gemini AIとGoogleスプレッドシートを使ってパーソナライズされた営業アウトリーチメール作成
前提条件
- •Google Sheets API認証情報
- •Google Gemini API Key
カテゴリー
ワークフロープレビュー
ノード接続関係を可視化、ズームとパンをサポート
ワークフローをエクスポート
以下のJSON設定をn8nにインポートして、このワークフローを使用できます
{
"name": "Personalised Mail",
"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": "If",
"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": {
"cbca8f8d-959d-45b9-a801-20386034a844": {
"main": [
[
{
"node": "9120c44a-92a4-4f06-83a5-045bd7e17a07",
"type": "main",
"index": 0
}
]
]
},
"9120c44a-92a4-4f06-83a5-045bd7e17a07": {
"main": [
[
{
"node": "23b2b8e8-e26c-4586-9ec1-dba83ab0069c",
"type": "main",
"index": 0
}
]
]
},
"323a2628-a30a-4b20-8a56-2d0677c6c5af": {
"main": [
[
{
"node": "c3a221a2-d3e3-47f3-a897-6781a29857a4",
"type": "main",
"index": 0
}
]
]
},
"c3a221a2-d3e3-47f3-a897-6781a29857a4": {
"main": [
[
{
"node": "cbca8f8d-959d-45b9-a801-20386034a844",
"type": "main",
"index": 0
}
]
]
},
"23b2b8e8-e26c-4586-9ec1-dba83ab0069c": {
"main": [
[
{
"node": "7e937d3d-3483-442e-b89c-57ce699609ed",
"type": "main",
"index": 0
}
]
]
},
"7e937d3d-3483-442e-b89c-57ce699609ed": {
"main": [
[]
]
},
"3434b60b-85ea-4221-94c4-3abf64f8ff17": {
"ai_languageModel": [
[
{
"node": "9120c44a-92a4-4f06-83a5-045bd7e17a07",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"e62f603b-d063-4f90-9d13-ce599b536bed": {
"ai_outputParser": [
[
{
"node": "9120c44a-92a4-4f06-83a5-045bd7e17a07",
"type": "ai_outputParser",
"index": 0
}
]
]
}
}
}よくある質問
このワークフローの使い方は？
上記のJSON設定コードをコピーし、n8nインスタンスで新しいワークフローを作成して「JSONからインポート」を選択、設定を貼り付けて認証情報を必要に応じて変更してください。
このワークフローはどんな場面に適していますか？
中級 - リードナーチャリング, マルチモーダルAI
有料ですか？
このワークフローは完全無料です。ただし、ワークフローで使用するサードパーティサービス（OpenAI APIなど）は別途料金が発生する場合があります。
関連ワークフロー
Apify、Google Gemini、Sheetsを使ってUpworkの提案生成をリアルタイムで自動化
Upwork提案生成をAIで自動化するにはApify、Google Gemini、Sheetsを活用しましょう
If
Set
Gmail
+
If
Set
Gmail
25 ノードIntuz
リード獲得
リアルタイムでLinkedInプロフィールを自動調査し、AIを活用したリード発信（Apify、Gemini、Sheetsを使用）
Apify、Gemini、 Sheets を使って LinkedIn プロフィール調査とメールアウトレッチを自動化
If
Limit
Google Sheets
+
If
Limit
Google Sheets
20 ノードIntuz
リード獲得
Apify、Apollo.io、Google Geminiを使ったLinkedIn求人情報のAI駆動リード生成の自動化
LinkedIn求人検索からの自動化リード生成：Apify、Apollo.io、Google Gemini
If
Code
Limit
+
If
Code
Limit
47 ノードIntuz
リード獲得
開発完了 - FAXコンテンツ抽出
ファクスと PDF のデータ抽出ワークフロー：Google Gemini と Google Sheets を使用
Set
Code
Form Trigger
+
Set
Code
Form Trigger
18 ノードIntuz
コンテンツ作成
LinkedInおよびXウイルスのなコンテンツ自動エンジン
AIを使ってLinkedInとXにウイルスのなコンテンツを自動生成して公開する
If
Set
Wait
+
If
Set
Wait
156 ノードDiptamoy Barman
コンテンツ作成
Gemini、Tavily および人間の審査を使用して SEO 最適化された WordPress ブログを生成
Gemini、Tavily、そして人間の審査を使ってSEO最適化されたWordPressブログを生成する
If
Set
Code
+
If
Set
Code
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で表示 →
このワークフローを共有