自動メール送信にフォローアップと返信追跡を付与
中級
これはSocial Media, Multimodal AI分野の自動化ワークフローで、11個のノードを含みます。主にIf, Gmail, Switch, GoogleSheets, EmailReadImapなどのノードを使用。 フォローアップと返信追跡を備えた自動メールブロードキャスト
前提条件
- •Googleアカウント + Gmail API認証情報
- •Google Sheets API認証情報
ワークフロープレビュー
ノード接続関係を可視化、ズームとパンをサポート
ワークフローをエクスポート
以下のJSON設定をn8nにインポートして、このワークフローを使用できます
{
"id": "8urb5ud9FW5of1Ct",
"meta": {
"instanceId": "dd69efaf8212c74ad206700d104739d3329588a6f3f8381a46a481f34c9cc281",
"templateCredsSetupCompleted": true
},
"name": "Automated Email Blast with Follow-Ups & Response Tracking",
"tags": [],
"nodes": [
{
"id": "263d7a2a-0185-47b5-a58b-c00a0f756dcc",
"name": "Daily Trigger",
"type": "n8n-nodes-base.scheduleTrigger",
"position": [
-80,
-485
],
"parameters": {
"rule": {
"interval": [
{
"field": "cronExpression"
}
]
}
},
"typeVersion": 1.2
},
{
"id": "d5b54189-9981-4b23-afa1-d8c2007ce94d",
"name": "Fetch Contact Data",
"type": "n8n-nodes-base.googleSheets",
"position": [
140,
-485
],
"parameters": {
"options": {},
"sheetName": {
"__rl": true,
"mode": "list",
"value": 686562196,
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1eO0pcfO3SFEofhUXjRy8Ps_XqfNpVnu5W8fwVSAy4Ds/edit#gid=686562196",
"cachedResultName": "Sheet3"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1eO0pcfO3SFEofhUXjRy8Ps_XqfNpVnu5W8fwVSAy4Ds",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1eO0pcfO3SFEofhUXjRy8Ps_XqfNpVnu5W8fwVSAy4Ds/edit?usp=drivesdk",
"cachedResultName": "PageRankChecker"
},
"authentication": "serviceAccount"
},
"credentials": {
"googleApi": {
"id": "ScSS2KxGQULuPtdy",
"name": "Google Sheets- test"
}
},
"typeVersion": 4.6
},
{
"id": "f2525c0e-4f9b-4430-a4f1-d21c18977095",
"name": "Iterate Contacts",
"type": "n8n-nodes-base.splitInBatches",
"position": [
360,
-485
],
"parameters": {
"options": {}
},
"typeVersion": 3
},
{
"id": "55ff15d6-15ed-4197-b2b4-98df8695f98c",
"name": "Determine Follow-Up Stage",
"type": "n8n-nodes-base.if",
"onError": "continueErrorOutput",
"position": [
580,
-560
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "8533f0cb-5664-4ba3-ac35-46587194560d",
"operator": {
"name": "filter.operator.equals",
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $json.Reply }}",
"rightValue": "no"
}
]
}
},
"typeVersion": 2.2,
"alwaysOutputData": true
},
{
"id": "11f2e1b6-0f21-4d5b-aced-a4c45e29f970",
"name": "Route by Follow-Up Stage",
"type": "n8n-nodes-base.switch",
"position": [
800,
-560
],
"parameters": {
"rules": {
"values": [
{
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "bde52b5f-b028-4849-acd0-fd976bbae44d",
"operator": {
"type": "number",
"operation": "equals"
},
"leftValue": "={{ $json['Follow-up'] }}",
"rightValue": 6
}
]
}
},
{
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "1a69881c-21ce-4cb7-9c17-f5ed0e5dd6ac",
"operator": {
"type": "number",
"operation": "equals"
},
"leftValue": "={{ $json['Follow-up'] }}",
"rightValue": 7
}
]
}
}
]
},
"options": {}
},
"typeVersion": 3.2
},
{
"id": "2dbd64d3-ec48-4992-a25e-f665d4f04001",
"name": "Send Follow-Up メール 1",
"type": "n8n-nodes-base.gmail",
"position": [
1020,
-660
],
"webhookId": "3844e21b-95b7-4e7c-81ef-5e49a9e8a6f1",
"parameters": {
"sendTo": "={{ $json['User Email'] }}",
"message": "Testing-6",
"options": {
"appendAttribution": false
},
"subject": "Testing-6",
"emailType": "text",
"authentication": "serviceAccount"
},
"credentials": {
"googleApi": {
"id": "ScSS2KxGQULuPtdy",
"name": "Google Sheets- test"
}
},
"typeVersion": 2.1
},
{
"id": "c2ed8d92-11c0-49df-87c2-191917a18a9b",
"name": "Send Follow-Up メール 2",
"type": "n8n-nodes-base.gmail",
"position": [
1020,
-460
],
"webhookId": "0e770d89-aadf-4a63-a769-f142de4da2e2",
"parameters": {
"sendTo": "={{ $json['User Email'] }}",
"message": "Testing-7",
"options": {
"appendAttribution": false
},
"subject": "Testing-7",
"emailType": "text",
"authentication": "serviceAccount"
},
"credentials": {
"googleApi": {
"id": "ScSS2KxGQULuPtdy",
"name": "Google Sheets- test"
}
},
"typeVersion": 2.1
},
{
"id": "715c5558-6bdb-4b8b-afc1-ae62bbf175f0",
"name": "Update Sheet with Follow-Up Status",
"type": "n8n-nodes-base.googleSheets",
"position": [
1240,
-460
],
"parameters": {
"columns": {
"value": {
"Reply": "={{ $('Route by Follow-Up Stage').item.json.Reply }}",
"Follow-up": "={{ $('Route by Follow-Up Stage').item.json['Follow-up'] + 1}}",
"Send Mail": "=yes (Follow-up = {{ $('Route by Follow-Up Stage').item.json['Follow-up'] }}) ",
"User Name": "={{ $('Route by Follow-Up Stage').item.json['User Name'] }}",
"Inquiry ID": "={{ $('Route by Follow-Up Stage').item.json['Inquiry ID'] }}",
"User Email": "={{ $('Route by Follow-Up Stage').item.json['User Email'] }}",
"Follow-up Type": "Email",
"Submission Date": "={{ new Date($now).toISOString().split('T')[0] }}",
"Next Follow-up Date": "={{ new Date(Date.now() + 3 * 24 * 60 * 60 * 1000).toISOString().split('T')[0] }}"
},
"schema": [
{
"id": "User Name",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "User Name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "User Email",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "User Email",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Inquiry ID",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Inquiry ID",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Reply",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Reply",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Follow-up",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Follow-up",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Send Mail",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Send Mail",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Follow-up Type",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Follow-up Type",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Communication Mode",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Communication Mode",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Status",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Status",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Comment",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Comment",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Requirement Doc",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Requirement Doc",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Workflow Diagram",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Workflow Diagram",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Test Cases",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Test Cases",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Call Schedule",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Call Schedule",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Submission Date",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Submission Date",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Next Follow-up Date",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Next Follow-up Date",
"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": "autoMapInputData",
"matchingColumns": [
"User Name"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "update",
"sheetName": {
"__rl": true,
"mode": "list",
"value": 686562196,
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1eO0pcfO3SFEofhUXjRy8Ps_XqfNpVnu5W8fwVSAy4Ds/edit#gid=686562196",
"cachedResultName": "Sheet3"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1eO0pcfO3SFEofhUXjRy8Ps_XqfNpVnu5W8fwVSAy4Ds",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1eO0pcfO3SFEofhUXjRy8Ps_XqfNpVnu5W8fwVSAy4Ds/edit?usp=drivesdk",
"cachedResultName": "PageRankChecker"
},
"authentication": "serviceAccount"
},
"credentials": {
"googleApi": {
"id": "ScSS2KxGQULuPtdy",
"name": "Google Sheets- test"
}
},
"typeVersion": 4.6
},
{
"id": "009b187a-a8b6-4748-bc9a-2e7dcd69f233",
"name": "Check メール Responses",
"type": "n8n-nodes-base.emailReadImap",
"position": [
-80,
-200
],
"parameters": {
"options": {
"customEmailConfig": "[\"UNSEEN\", [\"SUBJECT\", \"Testing\"]]"
}
},
"credentials": {
"imap": {
"id": "D3nLrSlP1dHWcIDE",
"name": "IMAP account"
}
},
"typeVersion": 2
},
{
"id": "91e87156-bd84-4df5-ad9e-11089af50c02",
"name": "Update Sheet with Response",
"type": "n8n-nodes-base.googleSheets",
"position": [
140,
-200
],
"parameters": {
"columns": {
"value": {
"reply": "=yes",
"user email": "={{ $json.from }}"
},
"schema": [
{
"id": "user name",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "user name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "user email",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "user email",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "reply",
"type": "string",
"display": true,
"required": false,
"displayName": "reply",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "followup",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "followup",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Send mail",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Send mail",
"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": [
"user email"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "update",
"sheetName": {
"__rl": true,
"mode": "list",
"value": 686562196,
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1eO0pcfO3SFEofhUXjRy8Ps_XqfNpVnu5W8fwVSAy4Ds/edit#gid=686562196",
"cachedResultName": "Sheet3"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1eO0pcfO3SFEofhUXjRy8Ps_XqfNpVnu5W8fwVSAy4Ds",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1eO0pcfO3SFEofhUXjRy8Ps_XqfNpVnu5W8fwVSAy4Ds/edit?usp=drivesdk",
"cachedResultName": "PageRankChecker"
},
"authentication": "serviceAccount"
},
"credentials": {
"googleApi": {
"id": "ScSS2KxGQULuPtdy",
"name": "Google Sheets- test"
}
},
"typeVersion": 4.6
},
{
"id": "a599605e-e3a6-412c-a221-cc73d87d7d74",
"name": "付箋",
"type": "n8n-nodes-base.stickyNote",
"position": [
-100,
-960
],
"parameters": {
"color": 4,
"width": 920,
"height": 240,
"content": "## Node Details\n- **Daily Trigger - 9 AM**: Triggers the workflow daily at 9 AM using a Cron schedule.\n- **Read Contact Data from Google Sheet**: Reads contact data (name, email, stage) from a specified Google Sheet range.\n- **Loop Through Contacts**: Uses SplitInBatches to process each contact individually.\n- **Determine Follow-Up Stage**: Checks the contact’s stage (e.g., Initial, Follow-Up 1) using an If node.\n- **Send Main/Follow-Up Email**: Sends personalized emails via Gmail based on the stage.\n- **Update Sheet Status**: Appends or updates the Google Sheet with the new status (e.g., Sent, Replied).\n- **Check Gmail for Replies**: Periodically checks Gmail for responses using an IMAP node.\n- **Log Responses**: Writes response details (e.g., timestamp, content) to the Google Sheet."
},
"typeVersion": 1
}
],
"active": false,
"pinData": {},
"settings": {
"executionOrder": "v1"
},
"versionId": "437e7f2a-166b-487d-a269-7fc2dbebb917",
"connections": {
"263d7a2a-0185-47b5-a58b-c00a0f756dcc": {
"main": [
[
{
"node": "d5b54189-9981-4b23-afa1-d8c2007ce94d",
"type": "main",
"index": 0
}
]
]
},
"f2525c0e-4f9b-4430-a4f1-d21c18977095": {
"main": [
[],
[
{
"node": "55ff15d6-15ed-4197-b2b4-98df8695f98c",
"type": "main",
"index": 0
}
]
]
},
"d5b54189-9981-4b23-afa1-d8c2007ce94d": {
"main": [
[
{
"node": "f2525c0e-4f9b-4430-a4f1-d21c18977095",
"type": "main",
"index": 0
}
]
]
},
"Check Email Responses": {
"main": [
[
{
"node": "91e87156-bd84-4df5-ad9e-11089af50c02",
"type": "main",
"index": 0
}
]
]
},
"Send Follow-Up Email 2": {
"main": [
[
{
"node": "715c5558-6bdb-4b8b-afc1-ae62bbf175f0",
"type": "main",
"index": 0
}
]
]
},
"Send Follow-Up Email 1": {
"main": [
[
{
"node": "715c5558-6bdb-4b8b-afc1-ae62bbf175f0",
"type": "main",
"index": 0
}
]
]
},
"11f2e1b6-0f21-4d5b-aced-a4c45e29f970": {
"main": [
[
{
"node": "Send Follow-Up Email 1",
"type": "main",
"index": 0
}
],
[
{
"node": "Send Follow-Up Email 2",
"type": "main",
"index": 0
}
]
]
},
"55ff15d6-15ed-4197-b2b4-98df8695f98c": {
"main": [
[
{
"node": "11f2e1b6-0f21-4d5b-aced-a4c45e29f970",
"type": "main",
"index": 0
}
]
]
},
"Send a message for followup 6": {
"main": [
[
{
"node": "HRMS api for upadte inqiery data direclty in db",
"type": "main",
"index": 0
}
]
]
},
"Send a message for followup 7": {
"main": [
[
{
"node": "HRMS api for upadte inqiery data direclty in db",
"type": "main",
"index": 0
}
]
]
},
"715c5558-6bdb-4b8b-afc1-ae62bbf175f0": {
"main": [
[
{
"node": "f2525c0e-4f9b-4430-a4f1-d21c18977095",
"type": "main",
"index": 0
}
]
]
}
}
}よくある質問
このワークフローの使い方は？
上記のJSON設定コードをコピーし、n8nインスタンスで新しいワークフローを作成して「JSONからインポート」を選択、設定を貼り付けて認証情報を必要に応じて変更してください。
このワークフローはどんな場面に適していますか？
中級 - ソーシャルメディア, マルチモーダルAI
有料ですか？
このワークフローは完全無料です。ただし、ワークフローで使用するサードパーティサービス（OpenAI APIなど）は別途料金が発生する場合があります。
関連ワークフロー
WhatsApp、メール、Twilio SMS 経由の食品メニュー更新通知
料理メニュー更新通知器
If
Set
Code
+
If
Set
Code
22 ノードOneclick AI Squad
ソーシャルメディア
AI駆動のInstagramコメント自動返信
Instagramのコメント返信の自動化はOpenAIとRedisで追跡
If
Code
Merge
+
If
Code
Merge
27 ノードOneclick AI Squad
ソーシャルメディア
Excel + AIによるスマートメールマーケティングジェネレーター（シートからインボックス）
Googleスプレッドシートを使ってLlama AIを使ってパーソナライズされたマーケティングメールを生成する
Code
Gmail
Google Sheets
+
Code
Gmail
Google Sheets
7 ノードOneclick AI Squad
ソーシャルメディア
Instagramの悪質コメント審査と自動防衛ワークフロー
Perspective APIとSlackリマインダーを使ってInstagramのコメントを自動審査
If
Set
Cron
+
If
Set
Cron
15 ノードOneclick AI Squad
ソーシャルメディア
電子商取引での誕生日割引自動化
Google SheetとGmailを使用してECサイトの誕生日割引メールを自動化
If
Gmail
Function
+
If
Gmail
Function
7 ノードMarth
ソーシャルメディア
Instagram インフルエンサーの成果物および契約準拠性の自動化
Claude AI と Slack アラートを使って Instagram インフルエンサー契約の合従性を自動化
If
Set
Code
+
If
Set
Code
26 ノードOneclick AI Squad
ソーシャルメディア
ワークフロー情報
難易度
中級
ノード数11
カテゴリー2
ノードタイプ8
作成者
Oneclick AI Squad
@oneclick-aiThe AI Squad Initiative is a pioneering effort to build, automate and scale AI-powered workflows using n8n.io. Our mission is to help individuals and businesses integrate AI agents seamlessly into their daily operations from automating tasks and enhancing productivity to creating innovative, intelligent solutions. We design modular, reusable AI workflow templates that empower creators, developers and teams to supercharge their automation with minimal effort and maximum impact.
外部リンク
n8n.ioで表示 →
このワークフローを共有