Gmail、SMTP、Google Sheetsを使用した自動ビルドバルクメール送信
中級
これはLead Nurturing分野の自動化ワークフローで、12個のノードを含みます。主にIf, Wait, Gmail, Limit, EmailSendなどのノードを使用。 Gmail、SMTP、Google Sheetsを使用した自動大規模なランダムな送信元メール送信
前提条件
- •Googleアカウント + Gmail API認証情報
- •Google Sheets API認証情報
カテゴリー
ワークフロープレビュー
ノード接続関係を可視化、ズームとパンをサポート
ワークフローをエクスポート
以下のJSON設定をn8nにインポートして、このワークフローを使用できます
{
"meta": {
"instanceId": "28099d2544433ae0f39c65315a4d4c531947fcb0f060a94d6047d7be5df31063",
"templateCredsSetupCompleted": true
},
"nodes": [
{
"id": "6afb72ca-c815-4fca-9125-f77d78bc46aa",
"name": "アイテムをループ処理",
"type": "n8n-nodes-base.splitInBatches",
"position": [
-560,
160
],
"parameters": {
"options": {},
"batchSize": "=1"
},
"typeVersion": 3
},
{
"id": "c147dbb2-b8fd-4ff5-bd76-7940b1f8ddb2",
"name": "リミット",
"type": "n8n-nodes-base.limit",
"position": [
-760,
360
],
"parameters": {},
"typeVersion": 1
},
{
"id": "630c46c1-bf9a-4634-8ce2-a5bd054d1813",
"name": "条件分岐",
"type": "n8n-nodes-base.if",
"position": [
-380,
260
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "8dc5b028-6f5d-4d76-8852-99180bfb4591",
"operator": {
"type": "string",
"operation": "exists",
"singleValue": true
},
"leftValue": "={{ $json['Email Address '] }}",
"rightValue": ""
}
]
}
},
"typeVersion": 2.2
},
{
"id": "f6834735-f169-4ba4-86de-9ed5c7221628",
"name": "レコードを更新",
"type": "n8n-nodes-base.googleSheets",
"position": [
60,
260
],
"parameters": {
"columns": {
"value": {
"Sent on": "={{ $now }}",
"Message Id": "={{ $json.id }}",
"Email Sent ": "Yes",
"Email Address ": "={{ $('If').first().json['Email Address '] }}"
},
"schema": [
{
"id": "Name",
"type": "string",
"display": true,
"required": false,
"displayName": "Name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Email Address ",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Email Address ",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Sender Email",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Sender Email",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Email Subject",
"type": "string",
"display": true,
"required": false,
"displayName": "Email Subject",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Email Body",
"type": "string",
"display": true,
"required": false,
"displayName": "Email Body",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Email Sent ",
"type": "string",
"display": true,
"required": false,
"displayName": "Email Sent ",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Sent on",
"type": "string",
"display": true,
"required": false,
"displayName": "Sent on",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Message Id",
"type": "string",
"display": true,
"required": false,
"displayName": "Message Id",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"Email Address "
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "appendOrUpdate",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1Tq1WP6qf-YHx5odZWHFit1nFvMLSRmxM0-Fkf8mx8zk/edit#gid=0",
"cachedResultName": "Sheet1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1Tq1WP6qf-YHx5odZWHFit1nFvMLSRmxM0-Fkf8mx8zk",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1Tq1WP6qf-YHx5odZWHFit1nFvMLSRmxM0-Fkf8mx8zk/edit?usp=drivesdk",
"cachedResultName": "Bulk Sender Template"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "NdBpgqV7UHdZ3CZc",
"name": "Google Sheets account"
}
},
"typeVersion": 4.6
},
{
"id": "6dd38853-6493-4677-8db2-0df6497aee42",
"name": "メールを送信",
"type": "n8n-nodes-base.gmail",
"position": [
-140,
260
],
"webhookId": "2add08f1-0af8-4951-af47-721d2c4302ec",
"parameters": {
"sendTo": "={{ $json['Email Address '] }}",
"message": "={{ $json['Email Body'] }}",
"options": {},
"subject": "={{ $json['Email Subject'] }}",
"emailType": "text"
},
"credentials": {
"gmailOAuth2": {
"id": "Fd6oTce3HQiRi3dG",
"name": "electrabot.info@gmail.com"
}
},
"typeVersion": 2.1
},
{
"id": "6f4402a7-7519-444f-81a6-fc2600f936cd",
"name": "メールを取得",
"type": "n8n-nodes-base.googleSheets",
"position": [
-940,
360
],
"parameters": {
"options": {},
"filtersUI": {
"values": [
{
"lookupValue": "No",
"lookupColumn": "Email Sent "
}
]
},
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1Tq1WP6qf-YHx5odZWHFit1nFvMLSRmxM0-Fkf8mx8zk/edit#gid=0",
"cachedResultName": "Sheet1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1Tq1WP6qf-YHx5odZWHFit1nFvMLSRmxM0-Fkf8mx8zk",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1Tq1WP6qf-YHx5odZWHFit1nFvMLSRmxM0-Fkf8mx8zk/edit?usp=drivesdk",
"cachedResultName": "Bulk Sender Template"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "NdBpgqV7UHdZ3CZc",
"name": "Google Sheets account"
}
},
"typeVersion": 4.5
},
{
"id": "bdf30635-0665-40cd-bfee-b507c3a67f49",
"name": "タイマーを設定",
"type": "n8n-nodes-base.scheduleTrigger",
"position": [
-1120,
360
],
"parameters": {
"rule": {
"interval": [
{
"field": "hours",
"hoursInterval": 6
}
]
}
},
"typeVersion": 1.2
},
{
"id": "ea3e124e-7a38-4c67-b8a5-e61ec51b3ac6",
"name": "待機",
"type": "n8n-nodes-base.wait",
"position": [
280,
340
],
"webhookId": "c4cf719a-d47f-4761-8a16-aff92b8e9a19",
"parameters": {
"amount": 10
},
"typeVersion": 1.1
},
{
"id": "e69107b7-6e00-4854-81cf-17da9b09b5af",
"name": "接続",
"type": "n8n-nodes-base.emailSend",
"position": [
-1120,
160
],
"webhookId": "49772db0-f2ab-4f5a-9b20-5b4f097f301c",
"parameters": {
"text": "={{ $json['Email body'] }}",
"options": {
"appendAttribution": false
},
"subject": "={{ $json['Email subject'] }}",
"toEmail": "={{ $json['Email Address '] }}",
"fromEmail": "={{ $json['Sender email '] }}",
"emailFormat": "text"
},
"credentials": {
"smtp": {
"id": "PnCWFLAx6sFw8ynW",
"name": "team@electrabot.space"
}
},
"typeVersion": 2.1
},
{
"id": "960aca19-606e-409b-b187-b1269bfdc907",
"name": "付箋",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1180,
-40
],
"parameters": {
"width": 1660,
"height": 620,
"content": "# Email Sender"
},
"typeVersion": 1
},
{
"id": "85ac89d1-f0b8-4899-98d0-495db2f0018c",
"name": "付箋1",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1480,
-40
],
"parameters": {
"width": 300,
"height": 620,
"content": "## 1. Setup Guide\n* ### Configure the timer node to your desired execution frequency.\n* ### Duplicate the provided [Google Sheet Template](https://docs.google.com/spreadsheets/d/1TjXelyGPg5G8lbPDI9_XOReTzmU1o52z2R3v8dYaoQM/edit?usp=sharing).\n* ### Link the duplicated sheet within both the \"Get Emails\" and \"Update Record\" nodes.\n* ### Select your preferred email sending node and use the \"Limit\" node to manage the volume of emails dispatched.\n\n## 2. Help\n* ### For detailed instructions, please refer to our [Detailed Setup Guide](https://drive.google.com/file/d/1o95RjqpwH_FZc28ajgxJJj5j3u6IyO0w/view?usp=sharing).\n* ### If you require further assistance, contact us via Email at [info.gainflow@gmail.com](mailto:info.gainflow@gmail.com).\n* ### Discover additional practical workflows by clicking [HERE](https://docs.google.com/document/d/1RACo90h-QwKA4hEZSlOQZsyw4iB5-43JM2l0s4lpuoY/edit?usp=sharing)."
},
"typeVersion": 1
},
{
"id": "e6679e6b-cb5f-4b31-a05d-87b31dfe018e",
"name": "付箋4",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1160,
60
],
"parameters": {
"color": 3,
"width": 320,
"height": 260,
"content": "## Utilize this node for non-Google email services."
},
"typeVersion": 1
}
],
"pinData": {},
"connections": {
"630c46c1-bf9a-4634-8ce2-a5bd054d1813": {
"main": [
[
{
"node": "6dd38853-6493-4677-8db2-0df6497aee42",
"type": "main",
"index": 0
}
]
]
},
"ea3e124e-7a38-4c67-b8a5-e61ec51b3ac6": {
"main": [
[
{
"node": "6afb72ca-c815-4fca-9125-f77d78bc46aa",
"type": "main",
"index": 0
}
]
]
},
"c147dbb2-b8fd-4ff5-bd76-7940b1f8ddb2": {
"main": [
[
{
"node": "6afb72ca-c815-4fca-9125-f77d78bc46aa",
"type": "main",
"index": 0
}
]
]
},
"bdf30635-0665-40cd-bfee-b507c3a67f49": {
"main": [
[
{
"node": "6f4402a7-7519-444f-81a6-fc2600f936cd",
"type": "main",
"index": 0
}
]
]
},
"6f4402a7-7519-444f-81a6-fc2600f936cd": {
"main": [
[
{
"node": "c147dbb2-b8fd-4ff5-bd76-7940b1f8ddb2",
"type": "main",
"index": 0
}
]
]
},
"6dd38853-6493-4677-8db2-0df6497aee42": {
"main": [
[
{
"node": "f6834735-f169-4ba4-86de-9ed5c7221628",
"type": "main",
"index": 0
}
]
]
},
"f6834735-f169-4ba4-86de-9ed5c7221628": {
"main": [
[
{
"node": "ea3e124e-7a38-4c67-b8a5-e61ec51b3ac6",
"type": "main",
"index": 0
}
]
]
},
"6afb72ca-c815-4fca-9125-f77d78bc46aa": {
"main": [
[],
[
{
"node": "630c46c1-bf9a-4634-8ce2-a5bd054d1813",
"type": "main",
"index": 0
}
]
]
}
}
}よくある質問
このワークフローの使い方は？
上記のJSON設定コードをコピーし、n8nインスタンスで新しいワークフローを作成して「JSONからインポート」を選択、設定を貼り付けて認証情報を必要に応じて変更してください。
このワークフローはどんな場面に適していますか？
中級 - リードナーチャリング
有料ですか？
このワークフローは完全無料です。ただし、ワークフローで使用するサードパーティサービス（OpenAI APIなど）は別途料金が発生する場合があります。
関連ワークフロー
メール外報自動化
Google SheetsとGmailを使った無料メールフォロー sequense
If
Set
Html
+
If
Set
Html
18 ノードGerald Denor
リードナーチャリング
Google テーブルから Rapiwa API を使用して WhatsApp ウェルカムメッセージを自動送信
GoogleテーブルとRapiwaを使用したセールスリード向けWhatsApp歓迎メッセージの自動送信
If
Code
Wait
+
If
Code
Wait
17 ノードSpaGreen Creative
リードナーチャリング
潜在顧客開掘とメールワーキングフロー
Google Maps、SendGrid、AIを使用してB2Bリード獲得とメールマーケティングを自動化
If
Set
Code
+
If
Set
Code
141 ノードEzema Kingsley Chibuzo
リード獲得
コールドメール生成
Apollo、Apify、GPTを使用してB2Bリード獲得とパーソナライズされたクールドメールを自動化
If
Wait
Gmail
+
If
Wait
Gmail
24 ノードMirai
Apollo データスクレイピングとタッチアウトフロー 1 ✅
Apollo、AI による解析と計画されたメール.follow-up によるリード生成の自動化
If
Code
Wait
+
If
Code
Wait
39 ノードDeniz
コンテンツ作成
GPT-4o、WordPress、LinkedInを使ってRSSから自動でブログ記事を投稿
GPT-4o、WordPress、LinkedInを使ってRSSコンテンツを自動のにブログ記事へ公開
If
Set
Code
+
If
Set
Code
40 ノードImmanuel
人工知能
ワークフロー情報
難易度
中級
ノード数12
カテゴリー1
ノードタイプ9
作成者
Gain FLow AI
@gain-flowGainFlow AI is your go-to AI automation agency, specializing in Python and no-code solutions to eliminate repetitive tasks for individuals and businesses. Free up your time and boost efficiency. For inquiries, Fill this form - https://docs.google.com/forms/d/e/1FAIpQLSfIiXdw4HMcI2HM-Obng13j_RFiKv7X-mjOVm_mcy2ucRA8EA/viewform or reach out to us at info.gainflow@gmail.com.
外部リンク
n8n.ioで表示 →
このワークフローを共有