Google Sheetsからの新規リードメールをOutlook経由で定期のに送信
中級
これは自動化ワークフローで、9個のノードを含みます。主にFilter, GoogleSheets, ScheduleTrigger, MicrosoftOutlookなどのノードを使用。 Google シートからの新規リードをOutlook経由で定時送信
前提条件
- •Google Sheets API認証情報
カテゴリー
-
ワークフロープレビュー
ノード接続関係を可視化、ズームとパンをサポート
ワークフローをエクスポート
以下のJSON設定をn8nにインポートして、このワークフローを使用できます
{
"meta": {
"instanceId": "ad0113c344ee237399e44e9f11798b05baeb83a6196d514a9ae9d2ad71c3b5c9",
"templateCredsSetupCompleted": true
},
"nodes": [
{
"id": "425810c5-874c-41db-8fdd-59450e7f280e",
"name": "メッセージを送信",
"type": "n8n-nodes-base.microsoftOutlook",
"position": [
-784,
9472
],
"webhookId": "028da3bf-3bd3-4c4f-883a-4e0f18c67f81",
"parameters": {
"subject": "Build AI Agents & Automations with n8n",
"bodyContent": "Hi There,\n\nI help people learn how to build AI agents and create powerful AI automations using n8n. If you’re exploring ways to save time or scale your workflows, I’d love to share what’s possible.\n\nYou can check out my n8n Creator profile here with 70+ ready-to-use automations:\n👉 https://n8n.io/creators/rbreen\n\nIf you’d like help getting started or want to see what AI + n8n can do for your business, just reply to this email.\n\nBest,\nRobert Breen\n📞 +1 814-882-1293\n🔗 https://www.linkedin.com/in/robert-breen-29429625/",
"toRecipients": "={{ $json.Email }}",
"additionalFields": {}
},
"credentials": {
"microsoftOutlookOAuth2Api": {
"id": "9z1nG9ReKLXU309r",
"name": "Microsoft Outlook account 4"
}
},
"typeVersion": 2,
"alwaysOutputData": true
},
{
"id": "e84f0281-eb13-4afa-b831-eae6f1a5cf54",
"name": "スケジュールトリガー",
"type": "n8n-nodes-base.scheduleTrigger",
"position": [
-2416,
9072
],
"parameters": {
"rule": {
"interval": [
{
"triggerAtHour": 9
}
]
}
},
"typeVersion": 1.2
},
{
"id": "1d3ef656-0288-45c2-8b82-a9aa7b57e2b0",
"name": "sheet3で行を取得",
"type": "n8n-nodes-base.googleSheets",
"position": [
-2080,
9232
],
"parameters": {
"options": {},
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1sXXVbl2kKdYTzCmZDe7QyeMp1N9wZg9K63oGK2UIaeU/edit#gid=0",
"cachedResultName": "Sheet1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1sXXVbl2kKdYTzCmZDe7QyeMp1N9wZg9K63oGK2UIaeU",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1sXXVbl2kKdYTzCmZDe7QyeMp1N9wZg9K63oGK2UIaeU/edit?usp=drivesdk",
"cachedResultName": "New Leads"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "HlBW2puZbuCCq8jJ",
"name": "Google Sheets account 3"
}
},
"typeVersion": 4.7
},
{
"id": "7fa47640-1e65-491d-9457-ef32d0b7f600",
"name": "フィルター1",
"type": "n8n-nodes-base.filter",
"position": [
-1744,
9088
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "914418a9-8c96-4959-abb7-ad3bb52f420d",
"operator": {
"type": "string",
"operation": "empty",
"singleValue": true
},
"leftValue": "={{ $json.Contacted }}",
"rightValue": ""
}
]
}
},
"typeVersion": 2.2
},
{
"id": "3b4a33f6-c810-4dcb-9b19-3abc6b982e9f",
"name": "sheet1に行を追加または更新",
"type": "n8n-nodes-base.googleSheets",
"position": [
-1312,
8736
],
"parameters": {
"columns": {
"value": {
"Email": "={{ $json.Email }}",
"Contacted": "Yes"
},
"schema": [
{
"id": "Email",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Email",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Contacted",
"type": "string",
"display": true,
"required": false,
"displayName": "Contacted",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Created",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "Created",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"Email"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "appendOrUpdate",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/14T6rilaOl1LBTwNnu7ILE3T1equWOz0noI-OIUaI3zU/edit#gid=0",
"cachedResultName": "leads"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "14T6rilaOl1LBTwNnu7ILE3T1equWOz0noI-OIUaI3zU",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/14T6rilaOl1LBTwNnu7ILE3T1equWOz0noI-OIUaI3zU/edit?usp=drivesdk",
"cachedResultName": "New Leads - Real"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "HlBW2puZbuCCq8jJ",
"name": "Google Sheets account 3"
}
},
"typeVersion": 4.7
},
{
"id": "65e19508-beb8-4b3d-8ec8-55093f437fd5",
"name": "付箋58",
"type": "n8n-nodes-base.stickyNote",
"position": [
-2688,
8576
],
"parameters": {
"color": 7,
"width": 2144,
"height": 1056,
"content": "## Email new leads from Google Sheets via Outlook on a schedule\n\nSend a templated outreach email to **new leads** in a Google Sheet on a **daily schedule**, then **mark each lead as contacted** so they won’t be emailed twice. Built with: **Schedule Trigger → Google Sheets → Filter → Outlook Send Email → Google Sheets (append/update)**.\n\n"
},
"typeVersion": 1
},
{
"id": "6736dbfa-79fc-4aa6-9890-5b60b3b98cd1",
"name": "付箋6",
"type": "n8n-nodes-base.stickyNote",
"position": [
-3120,
8576
],
"parameters": {
"width": 400,
"height": 1056,
"content": "## How to set up\n### 1) Google Sheets (OAuth2)\n- In **n8n → Credentials → New → Google Sheets (OAuth2)**, sign in and grant access. \n- In **Get rows**: select your **Lead Source** sheet (e.g., “New Leads”). \n- In **Append/Update**: select the sheet you want to mark as contacted (can be the same sheet or a CRM sheet). \n- Make sure your sheet has at least: `Email`, `Contacted` (blank for new).\n\n### 2) Outlook (Microsoft Graph) OAuth2\n- **n8n Cloud (quick connect):** \n - In **Credentials → New → Microsoft Outlook OAuth2**, choose **Connect**, sign in with your Microsoft account, and accept permissions.\n- **Self-hosted (Azure App Registration):** \n 1) Azure Portal → **App registrations** → **New registration**. \n 2) Add redirect URL: `https://YOUR_N8N_URL/rest/oauth2-credential/callback`. \n 3) **API permissions (Delegated):** `offline_access`, `Mail.Send`, `User.Read`. Grant admin consent if required. \n 4) Create a **Client secret**; copy **Application (client) ID** and **Directory (tenant) ID**. \n 5) In n8n, create **Microsoft Outlook OAuth2** credential with those values and scopes: `offline_access Mail.Send openid email profile`. \n- In the **Send a message** node, select that credential and keep `To` mapped to `{{$json.Email}}`. \n- Customize **Subject** and **Body** to your brand (default provided).\n\n---\n\n\n- 📧 **rbreen@ynteractive.com** \n- 🔗 **Robert Breen** — https://www.linkedin.com/in/robert-breen-29429625/ \n- 🌐 **ynteractive.com** — https://ynteractive.com\n\n"
},
"typeVersion": 1
},
{
"id": "79a41cd6-d72f-4cd5-81a2-3341a21ceeb8",
"name": "付箋70",
"type": "n8n-nodes-base.stickyNote",
"position": [
-2144,
8784
],
"parameters": {
"color": 3,
"width": 224,
"height": 656,
"content": "### 1) Connect Google Sheets (OAuth2)\n1. In **n8n → Credentials → New → Google Sheets (OAuth2)** \n2. Sign in with your Google account and grant access \n3. In each Google Sheets node, select your **Spreadsheet** and the appropriate **Worksheet**: \n\n\nhttps://docs.google.com/spreadsheets/d/1sXXVbl2kKdYTzCmZDe7QyeMp1N9wZg9K63oGK2UIaeU/edit#gid=0"
},
"typeVersion": 1
},
{
"id": "49825745-adc3-4a5e-ba1c-0a65e31fd177",
"name": "付箋7",
"type": "n8n-nodes-base.stickyNote",
"position": [
-848,
8608
],
"parameters": {
"color": 3,
"height": 992,
"content": "### 2) Outlook (Microsoft Graph) OAuth2\n- **n8n Cloud (quick connect):** \n - In **Credentials → New → Microsoft Outlook OAuth2**, choose **Connect**, sign in with your Microsoft account, and accept permissions.\n- **Self-hosted (Azure App Registration):** \n 1) Azure Portal → **App registrations** → **New registration**. \n 2) Add redirect URL: `https://YOUR_N8N_URL/rest/oauth2-credential/callback`. \n 3) **API permissions (Delegated):** `offline_access`, `Mail.Send`, `User.Read`. Grant admin consent if required. \n 4) Create a **Client secret**; copy **Application (client) ID** and **Directory (tenant) ID**. \n 5) In n8n, create **Microsoft Outlook OAuth2** credential with those values and scopes: `offline_access Mail.Send openid email profile`. \n- In the **Send a message** node, select that credential and keep `To` mapped to `{{$json.Email}}`. \n- Customize **Subject** and **Body** to your brand (default provided).\n"
},
"typeVersion": 1
}
],
"pinData": {},
"connections": {
"7fa47640-1e65-491d-9457-ef32d0b7f600": {
"main": [
[
{
"node": "3b4a33f6-c810-4dcb-9b19-3abc6b982e9f",
"type": "main",
"index": 0
},
{
"node": "425810c5-874c-41db-8fdd-59450e7f280e",
"type": "main",
"index": 0
}
]
]
},
"e84f0281-eb13-4afa-b831-eae6f1a5cf54": {
"main": [
[
{
"node": "1d3ef656-0288-45c2-8b82-a9aa7b57e2b0",
"type": "main",
"index": 0
}
]
]
},
"1d3ef656-0288-45c2-8b82-a9aa7b57e2b0": {
"main": [
[
{
"node": "7fa47640-1e65-491d-9457-ef32d0b7f600",
"type": "main",
"index": 0
}
]
]
}
}
}よくある質問
このワークフローの使い方は？
上記のJSON設定コードをコピーし、n8nインスタンスで新しいワークフローを作成して「JSONからインポート」を選択、設定を貼り付けて認証情報を必要に応じて変更してください。
このワークフローはどんな場面に適していますか？
中級
有料ですか？
このワークフローは完全無料です。ただし、ワークフローで使用するサードパーティサービス（OpenAI APIなど）は別途料金が発生する場合があります。
関連ワークフロー
AI生成LinkedIn投稿（人間による承認付き）
GPT-4、GoToHuman、Blotatoを使用したAI生成LinkedIn投稿（人間による承認付き）
Code
Merge
Filter
+
Code
Merge
Filter
19 ノードRobert Breen
ソーシャルメディア
自動メール削除処理：OutlookとBigQueryの統合
自動メール購読キャンセル処理：OutlookとBigQueryの統合
Set
Code
Merge
+
Set
Code
Merge
15 ノードRobert Breen
ソーシャルメディア
マーケティング業績メールレポートの自動化
Google Sheets と Outlook を使ってマーケティングパフォーマンスのメールレポートを自動生成する
Merge
Summarize
Google Sheets
+
Merge
Summarize
Google Sheets
13 ノードRobert Breen
文書抽出
初学者データ分析：GPT-4oを使ってGoogleシートで結合・フィルタリング・サマリー
初心者のデータ分析：GPT-4o を使用して Google スプレッドシートで結合、フィルタリング、集計
If
Set
Code
+
If
Set
Code
21 ノードRobert Breen
文書抽出
ブログ作成・エディタ
Google Sheetsに基づくブログライティング＆エディタ(GPT-4)
If
Code
Filter
+
If
Code
Filter
18 ノードRobert Breen
コンテンツ作成
アイスのリエンゲージングメールジェネレーター：GPT-4o-mini、OutlookとSheets
冷録客の再参画像メールジェネレータ：GPT-4o-mini、OutlookとSheets
Code
Aggregate
Google Sheets
+
Code
Aggregate
Google Sheets
15 ノードRobert Breen
リードナーチャリング
ワークフロー情報
難易度
中級
ノード数9
カテゴリー-
ノードタイプ5
作成者
Robert Breen
@rbreenProfessional services consultant with over 10 years of experience solving complex business problems across industries. I specialize in n8n and process automation—designing custom workflows that integrate tools like Google Calendar, Airtable, GPT, and internal systems. Whether you need to automate scheduling, sync data, or streamline operations, I build solutions that save time and drive results.
外部リンク
n8n.ioで表示 →
このワークフローを共有