冷え込み/ホットなメール自動化
上級
これはLead Nurturing分野の自動化ワークフローで、19個のノードを含みます。主にIf, Set, Hunter, EmailSend, GoogleSheetsなどのノードを使用。 Google Sheets、メール検証、SMTPを使った自動コールドメールマーケティングキャンペーン
前提条件
- •Google Sheets API認証情報
カテゴリー
ワークフロープレビュー
ノード接続関係を可視化、ズームとパンをサポート
ワークフローをエクスポート
以下のJSON設定をn8nにインポートして、このワークフローを使用できます
{
"id": "0NUf4DsJtFfnyxnp",
"meta": {
"instanceId": "b575ae39acc98e53d75e50d1b5147e8b0922704c4aeb3230092d8e2a78247bc3"
},
"name": "Cold/Warm Email Automation",
"tags": [],
"nodes": [
{
"id": "8df39dbf-a9c7-4de0-9582-8946a312a35f",
"name": "ワークフロー実行時（'Execute workflow'クリック時）",
"type": "n8n-nodes-base.manualTrigger",
"position": [
432,
1392
],
"parameters": {},
"typeVersion": 1
},
{
"id": "3adc0f15-d7a2-4b23-b36d-eb0361167446",
"name": "付箋2",
"type": "n8n-nodes-base.stickyNote",
"position": [
1824,
2096
],
"parameters": {
"color": 7,
"height": 256,
"content": "## **Find out SMTP info for your email service provider Link** \n\nhttps://docs.google.com/document/d/1UnAYprKmGWHQ7VDpzdMndV7-iPl1sVlIIke3GY5O8e0/edit?usp=sharing"
},
"typeVersion": 1
},
{
"id": "42a71dd2-654d-48ca-9e89-619402f9b65a",
"name": "付箋3",
"type": "n8n-nodes-base.stickyNote",
"position": [
80,
1584
],
"parameters": {
"color": 7,
"width": 272,
"height": 208,
"content": "## **Step-by-Step Tutorial YouTube Video Link** \n\n\nhttps://youtu.be/Dg68OaYPhYs?si=LVu9pdxt9JUuCrzM"
},
"typeVersion": 1
},
{
"id": "bb87b350-c396-4cd4-a266-1b58300cf261",
"name": "付箋4",
"type": "n8n-nodes-base.stickyNote",
"position": [
576,
1584
],
"parameters": {
"color": 7,
"width": 224,
"height": 224,
"content": "## **Sample Google Sheet for Leads I used.** \n\nhttps://docs.google.com/spreadsheets/d/1pWxsNGde3BHzIF7IMiRum4sGjVNRl9LfcJybmgkzuMM/edit?usp=sharing \n\n\n- "
},
"typeVersion": 1
},
{
"id": "5a7e7b8a-30ef-43fa-a290-23ccff275628",
"name": "スケジュールトリガー（午前9時）",
"type": "n8n-nodes-base.scheduleTrigger",
"position": [
176,
1392
],
"parameters": {
"rule": {
"interval": [
{
"triggerAtHour": 9
}
]
}
},
"typeVersion": 1.2
},
{
"id": "5c58d9d4-f19c-44f1-871c-a31dde73f8c3",
"name": "リードシート - シートから行を取得",
"type": "n8n-nodes-base.googleSheets",
"position": [
640,
1392
],
"parameters": {
"options": {},
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1pWxsNGde3BHzIF7IMiRum4sGjVNRl9LfcJybmgkzuMM/edit#gid=0",
"cachedResultName": "Sheet1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1pWxsNGde3BHzIF7IMiRum4sGjVNRl9LfcJybmgkzuMM",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1pWxsNGde3BHzIF7IMiRum4sGjVNRl9LfcJybmgkzuMM/edit?usp=drivesdk",
"cachedResultName": "Leads"
}
},
"typeVersion": 4.6
},
{
"id": "3a2a1244-2870-421b-a27b-ce9dba18eace",
"name": "GSheet更新（メールが「送信済み」の場合）",
"type": "n8n-nodes-base.googleSheets",
"position": [
2320,
1744
],
"parameters": {
"columns": {
"value": {
"Tool Name": "={{ $('Google Sheets').item.json['Tool Name'] }}",
"Email Sent": "={{ $json.accepted[0] }}"
},
"schema": [
{
"id": "Tool Name",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Tool Name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Country",
"type": "string",
"display": true,
"required": false,
"displayName": "Country",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Tool Link",
"type": "string",
"display": true,
"required": false,
"displayName": "Tool Link",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Link to Apply Affiliate",
"type": "string",
"display": true,
"required": false,
"displayName": "Link to Apply Affiliate",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "How to Work",
"type": "string",
"display": true,
"required": false,
"displayName": "How to Work",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Affiliate Link to Share",
"type": "string",
"display": true,
"required": false,
"displayName": "Affiliate Link to Share",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Coupon Code",
"type": "string",
"display": true,
"required": false,
"displayName": "Coupon Code",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Reach Out Mode",
"type": "string",
"display": true,
"required": false,
"displayName": "Reach Out Mode",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Email",
"type": "string",
"display": true,
"required": false,
"displayName": "Email",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "How did you find?",
"type": "string",
"display": true,
"required": false,
"displayName": "How did you find?",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Status",
"type": "string",
"display": true,
"required": false,
"displayName": "Status",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Reach Out Platform",
"type": "string",
"display": true,
"required": false,
"displayName": "Reach Out Platform",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Incoming",
"type": "string",
"display": true,
"required": false,
"displayName": "Incoming",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Script",
"type": "string",
"display": true,
"required": false,
"displayName": "Script",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Email Sent",
"type": "string",
"display": true,
"required": false,
"displayName": "Email Sent",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Ideas",
"type": "string",
"display": true,
"required": false,
"displayName": "Ideas",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "row_number",
"type": "string",
"display": true,
"removed": false,
"readOnly": true,
"required": false,
"displayName": "row_number",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"Tool Name"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "update",
"sheetName": {
"__rl": true,
"mode": "list",
"value": 2051398108,
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1cMGVHzjsAKmjrNqS9Pi0HPAmq6uv8bl211LdzZNg1mY/edit#gid=2051398108",
"cachedResultName": "AI tool reachout"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1cMGVHzjsAKmjrNqS9Pi0HPAmq6uv8bl211LdzZNg1mY",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1cMGVHzjsAKmjrNqS9Pi0HPAmq6uv8bl211LdzZNg1mY/edit?usp=drivesdk",
"cachedResultName": "CF Calendar"
}
},
"executeOnce": true,
"typeVersion": 4.6
},
{
"id": "78f8130a-26ee-4e7b-b749-2c201eb6aca2",
"name": "チェッカー - メール検証済みか否か",
"type": "n8n-nodes-base.if",
"position": [
1568,
1584
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "d70305b4-4313-4b48-8e20-16a7d10acb81",
"operator": {
"type": "string",
"operation": "contains"
},
"leftValue": "={{ $json.result }}",
"rightValue": "undeliverable"
}
]
}
},
"typeVersion": 2.2
},
{
"id": "935d4058-b2e9-43f1-a887-defb038948c3",
"name": "付箋5",
"type": "n8n-nodes-base.stickyNote",
"position": [
1264,
1760
],
"parameters": {
"width": 208,
"height": 192,
"content": "## **Add Email Verification API** \n\nI use hunter, https://hunter.io/api-keys\n\nYou can use any other tools"
},
"typeVersion": 1
},
{
"id": "4b8ae9a2-346c-424f-ba77-fb0aa42c4e58",
"name": "G Sheet1に「送信済み」更新用フィールド作成",
"type": "n8n-nodes-base.set",
"position": [
2096,
1744
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "05814c14-4365-4c37-af55-f28bf2ee5819",
"name": "accepted[0]",
"type": "string",
"value": "Sent"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "4f251ddb-b669-4b14-8255-ab47ab062516",
"name": "操作なし（何もしない5）",
"type": "n8n-nodes-base.noOp",
"position": [
1872,
1424
],
"parameters": {},
"typeVersion": 1
},
{
"id": "d8fd0b18-6907-4466-b2f5-d5bd19293da8",
"name": "Hunterを使用したメール検証",
"type": "n8n-nodes-base.hunter",
"position": [
1312,
1584
],
"parameters": {
"email": "={{ $json.Email }}",
"operation": "emailVerifier"
},
"typeVersion": 1
},
{
"id": "de42e271-8e99-4a09-b189-a0af7b2bbcb2",
"name": "チェッカー - 既に「送信済み」か否か",
"type": "n8n-nodes-base.if",
"position": [
864,
1392
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "c72a013e-7b22-4bc7-a6c6-d51e9804ece7",
"operator": {
"type": "string",
"operation": "contains"
},
"leftValue": "={{ $json['Email Sent'] }}",
"rightValue": "Sent"
}
]
}
},
"typeVersion": 2.2
},
{
"id": "6a1c602a-489b-4c83-b2b8-da27bc80718f",
"name": "チェッカー - リードの「メール」フィールドが空か",
"type": "n8n-nodes-base.if",
"position": [
1088,
1488
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "d70305b4-4313-4b48-8e20-16a7d10acb81",
"operator": {
"type": "string",
"operation": "empty",
"singleValue": true
},
"leftValue": "={{ $json.Email }}",
"rightValue": ""
}
]
}
},
"typeVersion": 2.2
},
{
"id": "3234922f-6bc2-4127-aa64-743d2ba2faa2",
"name": "操作なし",
"type": "n8n-nodes-base.noOp",
"position": [
1040,
1296
],
"parameters": {},
"typeVersion": 1
},
{
"id": "808e5a15-f0ca-4c9a-8361-2dad2ef51849",
"name": "操作なし1",
"type": "n8n-nodes-base.noOp",
"position": [
1312,
1392
],
"parameters": {},
"typeVersion": 1
},
{
"id": "d98f7325-01c6-4e62-acc9-ca6bee188d39",
"name": "付箋",
"type": "n8n-nodes-base.stickyNote",
"position": [
576,
1232
],
"parameters": {
"width": 224,
"height": 128,
"content": "## **Connect with Google Sheet or CRM** "
},
"typeVersion": 1
},
{
"id": "ecfd047b-fcb8-4e7b-a150-537cc96be2f2",
"name": "SMTPを使用したメール送信",
"type": "n8n-nodes-base.emailSend",
"position": [
1872,
1744
],
"webhookId": "3a2cb249-8183-4481-8df7-5fcdd2c52881",
"parameters": {
"text": "=Hello {{ $('Lead Sheet - Get Rows from the sheet').item.json['Tool Name'] }} team, \n\nWe can collborate on multiple features. Can we have a quick meet over the meet?\n\nBest regards,\nJanak",
"options": {},
"subject": "Let's collaborate!",
"toEmail": "={{ $('Lead Sheet - Get Rows from the sheet').item.json.Email }}",
"fromEmail": "support@dolphy.io",
"emailFormat": "text"
},
"executeOnce": false,
"typeVersion": 2.1
},
{
"id": "2188bf86-d2d8-48c2-9783-954d3c879089",
"name": "付箋1",
"type": "n8n-nodes-base.stickyNote",
"position": [
1824,
1920
],
"parameters": {
"width": 224,
"height": 128,
"content": "## **Send email using SMTP- Any Email Provider works** "
},
"typeVersion": 1
}
],
"active": false,
"pinData": {},
"settings": {
"executionOrder": "v1"
},
"versionId": "d5347202-25e6-43fd-aca3-2e53eef114c0",
"connections": {
"ecfd047b-fcb8-4e7b-a150-537cc96be2f2": {
"main": [
[
{
"node": "4b8ae9a2-346c-424f-ba77-fb0aa42c4e58",
"type": "main",
"index": 0
}
]
]
},
"d8fd0b18-6907-4466-b2f5-d5bd19293da8": {
"main": [
[
{
"node": "78f8130a-26ee-4e7b-b749-2c201eb6aca2",
"type": "main",
"index": 0
}
]
]
},
"de42e271-8e99-4a09-b189-a0af7b2bbcb2": {
"main": [
[
{
"node": "3234922f-6bc2-4127-aa64-743d2ba2faa2",
"type": "main",
"index": 0
}
],
[
{
"node": "6a1c602a-489b-4c83-b2b8-da27bc80718f",
"type": "main",
"index": 0
}
]
]
},
"5c58d9d4-f19c-44f1-871c-a31dde73f8c3": {
"main": [
[
{
"node": "de42e271-8e99-4a09-b189-a0af7b2bbcb2",
"type": "main",
"index": 0
}
]
]
},
"8df39dbf-a9c7-4de0-9582-8946a312a35f": {
"main": [
[
{
"node": "5c58d9d4-f19c-44f1-871c-a31dde73f8c3",
"type": "main",
"index": 0
}
]
]
},
"78f8130a-26ee-4e7b-b749-2c201eb6aca2": {
"main": [
[
{
"node": "4f251ddb-b669-4b14-8255-ab47ab062516",
"type": "main",
"index": 0
}
],
[
{
"node": "ecfd047b-fcb8-4e7b-a150-537cc96be2f2",
"type": "main",
"index": 0
}
]
]
},
"6a1c602a-489b-4c83-b2b8-da27bc80718f": {
"main": [
[
{
"node": "808e5a15-f0ca-4c9a-8361-2dad2ef51849",
"type": "main",
"index": 0
}
],
[
{
"node": "d8fd0b18-6907-4466-b2f5-d5bd19293da8",
"type": "main",
"index": 0
}
]
]
},
"4b8ae9a2-346c-424f-ba77-fb0aa42c4e58": {
"main": [
[
{
"node": "3a2a1244-2870-421b-a27b-ce9dba18eace",
"type": "main",
"index": 0
}
]
]
}
}
}よくある質問
このワークフローの使い方は？
上記のJSON設定コードをコピーし、n8nインスタンスで新しいワークフローを作成して「JSONからインポート」を選択、設定を貼り付けて認証情報を必要に応じて変更してください。
このワークフローはどんな場面に適していますか？
上級 - リードナーチャリング
有料ですか？
このワークフローは完全無料です。ただし、ワークフローで使用するサードパーティサービス（OpenAI APIなど）は別途料金が発生する場合があります。
関連ワークフロー
Browserflow と Google Sheets で LinkedIn へのリクエストを自動追跡
Browserflow と Google Sheets を使って LinkedIn の自動招待を追跡
If
Set
Wait
+
If
Set
Wait
23 ノードStéphane Heckel
リードナーチャリング
Googleスプレッドシートによるランダムテンプレートと連動した自動のな冷え込みメールマーケティングキャンペーン
ランダムテンプレートとGoogle Sheetsによる自動コールドメールマーケティングキャンペーン
If
Set
Code
+
If
Set
Code
20 ノードAnir Agram
リードナーチャリング
YouTube SEOの自動化1
GPT-4oとRunwayを使って動画脚本からYouTube SEOコンテンツとサムネイルを生成する
If
Set
Code
+
If
Set
Code
19 ノードJanak Patel
コンテンツ作成
AI生成WordPress記事要約ブロック
WordPress記事のAI生成要約ブロック
If
Set
Slack
+
If
Set
Slack
32 ノードDataki
人工知能
NocoボードとAIによる優先順位付け
AIを使ってリクエストを割り当てし、NocoDBのカンバンステータスからリマインダーを送信する
If
Set
Slack
+
If
Set
Slack
27 ノードŁukasz
サポート
Gmail、OpenAI、そしてGoogleスプレッドシートを使った敏捷開発の細化準備の自動化
Gmail、OpenAI、そしてGoogleシートを使った敏捷な振り返り準備の自動化
If
Set
Gmail
+
If
Set
Gmail
51 ノードWillemijn
プロダクト
