GPT・Googleカレンダー・Supabaseを使用した自動メール管理システム
上級
これはTicket Management, AI RAG分野の自動化ワークフローで、42個のノードを含みます。主にIf, Code, Gmail, Switch, Telegramなどのノードを使用。 GPT、Googleカレンダー、Supabaseを使った自動メール管理システム
前提条件
- •Googleアカウント + Gmail API認証情報
- •Telegram Bot Token
- •OpenAI API Key
- •Supabase URL と API Key
使用ノード (42)
カテゴリー
ワークフロープレビュー
ノード接続関係を可視化、ズームとパンをサポート
ワークフローをエクスポート
以下のJSON設定をn8nにインポートして、このワークフローを使用できます
{
"meta": {
"instanceId": "a88d54d0dc140647df8f628579b3d5aae0dedb13c983a1f5c11ee14f54f18774",
"templateCredsSetupCompleted": true
},
"nodes": [
{
"id": "7959f62a-c7bd-4c30-ba81-73fa5f120d48",
"name": "Gmail Trigger",
"type": "n8n-nodes-base.gmailTrigger",
"position": [
500,
-140
],
"parameters": {
"filters": {
"labelIds": [
"INBOX"
],
"includeSpamTrash": false
},
"pollTimes": {
"item": [
{
"mode": "=everyMinute"
}
]
}
},
"credentials": {
"gmailOAuth2": {
"id": "C3I7lGaMkl8s8Uu6",
"name": "builtbyabdul"
}
},
"typeVersion": 1.2
},
{
"id": "cba3842f-57f3-43a5-a436-868c81712967",
"name": "テキスト分類器",
"type": "@n8n/n8n-nodes-langchain.textClassifier",
"position": [
780,
-140
],
"parameters": {
"options": {},
"inputText": "=From: {{ $json.From }}\nSubject: {{ $json.Subject }}\nEmail body: {{ $json.snippet }}",
"categories": {
"categories": [
{
"category": "Sales/Leads/Inquiries",
"description": "Any email about new inquiries, booking calls, interested leads. This is for sales/inquiries/leads"
},
{
"category": "Clients/Active Projects",
"description": "Any email that's active client communication. Can be project updates, feedback, deliverables etc.\n\n"
},
{
"category": "Reports/Results",
"description": "Any email about Performance updates (ads, analytics), Campaign reviews, KPIs, dashboards"
},
{
"category": "Billing/Admin",
"description": "Any emails about Invoices, contracts, payment confirmations, Tool subscriptions, platform updates etc."
},
{
"category": "Other/Low Priority",
"description": "Any emails that don't fit into any of the other categories. Can be Newsletters, cold emails, updates from tools etc. Anything that’s not urgent or important"
}
]
}
},
"typeVersion": 1.1
},
{
"id": "28dbe8df-9fa6-47fa-9891-48a88d703021",
"name": "OpenAI Chat Model",
"type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
"position": [
780,
40
],
"parameters": {
"model": {
"__rl": true,
"mode": "list",
"value": "gpt-4.1-mini",
"cachedResultName": "gpt-4.1-mini"
},
"options": {}
},
"credentials": {
"openAiApi": {
"id": "E9waf1c33TsN4RCh",
"name": "OpenAi account"
}
},
"typeVersion": 1.2
},
{
"id": "67aa2083-c8ef-4405-893e-53247b3ab6a2",
"name": "営業 / リード",
"type": "n8n-nodes-base.gmail",
"position": [
1220,
-500
],
"webhookId": "77607f79-b391-434a-9373-da44715d27c1",
"parameters": {
"labelIds": [
"Label_8604649380419238342",
"IMPORTANT"
],
"messageId": "={{ $('Gmail Trigger').item.json.id }}",
"operation": "addLabels"
},
"credentials": {
"gmailOAuth2": {
"id": "C3I7lGaMkl8s8Uu6",
"name": "builtbyabdul"
}
},
"typeVersion": 2.1
},
{
"id": "7b27e516-9515-45fe-aa4c-709c3f761b47",
"name": "クライアント連絡",
"type": "n8n-nodes-base.gmail",
"position": [
1220,
-320
],
"webhookId": "0fa6e86f-0318-46e0-9552-705c87f9e835",
"parameters": {
"labelIds": [
"Label_3864215407576145230",
"IMPORTANT"
],
"messageId": "={{ $('Gmail Trigger').item.json.id }}",
"operation": "addLabels"
},
"credentials": {
"gmailOAuth2": {
"id": "C3I7lGaMkl8s8Uu6",
"name": "builtbyabdul"
}
},
"typeVersion": 2.1
},
{
"id": "7d7f705b-e6ab-4b2a-aafd-0cd9ad4225fb",
"name": "レポート / 結果",
"type": "n8n-nodes-base.gmail",
"position": [
1220,
-140
],
"webhookId": "c501b3ac-780e-489f-a667-7ac7626b24b6",
"parameters": {
"labelIds": [
"Label_6284269275653839225"
],
"messageId": "={{ $('Gmail Trigger').item.json.id }}",
"operation": "addLabels"
},
"credentials": {
"gmailOAuth2": {
"id": "C3I7lGaMkl8s8Uu6",
"name": "builtbyabdul"
}
},
"typeVersion": 2.1
},
{
"id": "6a8339bb-3c7d-49ab-a03d-380d705d884b",
"name": "請求 / 管理",
"type": "n8n-nodes-base.gmail",
"position": [
1220,
40
],
"webhookId": "2b1362a9-2f33-45a6-b6d8-42b55fd66e6a",
"parameters": {
"labelIds": [
"Label_295304589470276513"
],
"messageId": "={{ $('Gmail Trigger').item.json.id }}",
"operation": "addLabels"
},
"credentials": {
"gmailOAuth2": {
"id": "C3I7lGaMkl8s8Uu6",
"name": "builtbyabdul"
}
},
"typeVersion": 2.1
},
{
"id": "efb203a1-f643-40c2-81d0-da388d9c34bd",
"name": "その他",
"type": "n8n-nodes-base.gmail",
"position": [
1220,
220
],
"webhookId": "217b3682-7d0e-451e-96f4-503770f204e1",
"parameters": {
"labelIds": [
"Label_8092655313303559301"
],
"messageId": "={{ $('Gmail Trigger').item.json.id }}",
"operation": "addLabels"
},
"credentials": {
"gmailOAuth2": {
"id": "C3I7lGaMkl8s8Uu6",
"name": "builtbyabdul"
}
},
"typeVersion": 2.1
},
{
"id": "30468c6d-1b64-4953-a207-3f358b9c4910",
"name": "既読マーク3",
"type": "n8n-nodes-base.gmail",
"position": [
1440,
220
],
"webhookId": "48d3f7f1-fef4-4ce0-930c-b5b6e64a8184",
"parameters": {
"messageId": "={{ $json.id }}",
"operation": "markAsRead"
},
"credentials": {
"gmailOAuth2": {
"id": "C3I7lGaMkl8s8Uu6",
"name": "builtbyabdul"
}
},
"typeVersion": 2.1
},
{
"id": "9c319421-1609-4d9b-875e-567ebc64f03d",
"name": "構造化出力パーサー2",
"type": "@n8n/n8n-nodes-langchain.outputParserStructured",
"position": [
3020,
-240
],
"parameters": {
"schemaType": "manual",
"inputSchema": "{\n \"type\": \"object\",\n \"properties\": {\n \"emailBody\": {\n \"type\": \"string\",\n \"description\": \"The HTML-formatted body content of the email reply to be sent to the prospect. Use <p>, <br>, and <a> tags for formatting. (If escalate is true, this is not required.)\"\n },\n \"reason\": {\n \"type\": \"string\",\n \"description\": \"Short explanation for why this email response was generated. E.g. what the user asked for, what info was found, and why this response was appropriate.\"\n },\n \"escalate\": {\n \"type\": \"boolean\",\n \"description\": \"True if you're unsure or can't confidently answer the question using available knowledge. False if you’re confident in your response and can proceed without human help.\"\n },\n \"knowledgeDatabase\": {\n \"type\": \"string\",\n \"description\": \"A summary of the facts retrieved from the Knowledge Database that were used to answer the email.\"\n }\n },\n \"required\": [\n \"emailBody\",\n \"reason\",\n \"escalate\"\n ]\n}\n"
},
"typeVersion": 1.2
},
{
"id": "9c150470-5d5a-4228-adc6-384ebce2c514",
"name": "付箋2",
"type": "n8n-nodes-base.stickyNote",
"position": [
2480,
-480
],
"parameters": {
"color": 5,
"width": 1120,
"height": 940,
"content": "# Check Knowledge Base + Draft Email"
},
"typeVersion": 1
},
{
"id": "7a1cdf33-7419-42cf-b8eb-05a29bf5512b",
"name": "イベント取得",
"type": "n8n-nodes-base.googleCalendarTool",
"position": [
2820,
-740
],
"parameters": {
"options": {},
"timeMax": "={{ /*n8n-auto-generated-fromAI-override*/ $fromAI('Before', `the day after the date the user requested`, 'string') }}",
"timeMin": "={{ /*n8n-auto-generated-fromAI-override*/ $fromAI('After', `the day before the date the user requested`, 'string') }}",
"calendar": {
"__rl": true,
"mode": "list",
"value": "builtbyabdul@gmail.com",
"cachedResultName": "builtbyabdul@gmail.com"
},
"operation": "getAll"
},
"credentials": {
"googleCalendarOAuth2Api": {
"id": "LBdhcTyZ27AfxId9",
"name": "Google Calendar account"
}
},
"typeVersion": 1.3
},
{
"id": "90fbe187-df56-45a5-b0ee-6fb68b1e0fba",
"name": "構造化出力パーサー",
"type": "@n8n/n8n-nodes-langchain.outputParserStructured",
"position": [
3060,
-860
],
"parameters": {
"schemaType": "manual",
"inputSchema": "{\n \"type\": \"object\",\n \"properties\": {\n \"emailBody\": {\n \"type\": \"string\",\n \"description\": \"The HTML-formatted body content of the email to be sent. Use <p>, <br>, and <a> tags for proper formatting.\"\n },\n \"eventName\": {\n \"type\": \"string\",\n \"description\": \"The name of the event. (If just sending availabilities, you can leave this empty.)\"\n },\n \"startTime\": {\n \"type\": \"string\",\n \"description\": \"The start time of the event, in ISO 8601 format. (If just sending availabilities, you can leave this empty.)\"\n },\n \"endTime\": {\n \"type\": \"string\",\n \"description\": \"The end time of the event, in ISO 8601 format. (If just sending availabilities, you can leave this empty.)\"\n },\n \"bookCall\": {\n \"type\": \"boolean\",\n \"description\": \"True if booking a call for a specific time slot. False if sending availabilities.\"\n },\n \"calendarAvailabilities\": {\n \"type\": \"string\",\n \"description\": \"Detailed calendar availabilities for the time as specified by manager. Optional.\"\n }\n },\n \"required\": [\n \"emailBody\",\n \"eventName\",\n \"startTime\",\n \"endTime\",\n \"bookCall\"\n ]\n}\n"
},
"typeVersion": 1.2
},
{
"id": "c634a163-41f4-4dba-81d9-d7b56e1252ca",
"name": "カレンダーエージェント",
"type": "@n8n/n8n-nodes-langchain.agent",
"position": [
2680,
-1060
],
"parameters": {
"text": "=Here's the email:\n{{ $('Gmail Trigger').item.json.snippet }}\n\nHere's the full thread for context:\n{{ $('Get Thread').item.json.messages.map((msg, index) => `Message ${index + 1}: ${msg.fullBody || msg.snippet}`).join('\\n\\n---\\n\\n') }}\n\n",
"options": {
"systemMessage": "=You are a sales agent at Marketing Ladder (a Marketing Agency). Your job is to handle calendar enquiries via email and reply with either available time slots or booking confirmations. Keep responses short, friendly, and conversational.\n\nTools\nget_events: Use this to check availability for a specific day or time\n\nthink_tool: Use this to decide next steps after getting calendar data\n\nResponse Logic\nIf the email includes a specific date only (no time):\nUse get_events to check availability that day\n\nIf there are open 30-minute slots, casually mention a time range (e.g., “I should be free 9–11AM”) instead of exact times\n\nInclude your calendar link in the messages\n\nExample phrasing:\n\n“How about we set something up for tomorrow? I should be free 9–11AM (Chicago Time).”\n\nIf the email includes both a date and time:\nUse get_events to check if that time is available\n\nIf available:\n\nAssume the meeting is 30 minutes\n\nConfirm the time in a casual tone (e.g., “Yup, I should be good then”)\n\nCreate the calendar event\n\nIf unavailable:\n\nSuggest 2 alternative slots in a natural way (e.g., “I'm tied up then — how about 9:30 or 10:15 instead?”)\n\nOffer your calendar link as well\n\nExtra Rules:\n-If they say “Monday” (or any weekday), treat it as the next upcoming one\n\n-Never mention what’s booked — just say “I'm already tied up then” or “I’m booked at that time”\n\n-Default meeting length is 30 minutes unless stated otherwise\n\n-Always mention the time zone: Chicago Time (CST/CDT)\n\n-Sign off every email as: Abdul\n\n-If they ask for your calendar link, always give: https://cal.com/builtbyabdul/freeconsultation\n\nToday is: {{ $now.format('EEEE') }}, {{ $now.format('yyyy-MM-dd') }}\n\nExample response:\n\n\"\"<p>Thanks for reaching out and your interest in our LinkedIn Growth services!</p>\n\n<p>I'm free for a call tomorrow (Sunday) between 11–11:45AM Chicago Time (CDT). Let me know if that works for you, or feel free to grab a slot that fits your schedule using my calendar here:<br>\n<a href=\"https://cal.com/builtbyabdul/freeconsultation\">https://cal.com/builtbyabdul/freeconsultation</a></p>\n\n<p>Looking forward to chatting!</p>\n\n<p>Best,<br>\nAbdul</p>\"\"\n"
},
"promptType": "define",
"hasOutputParser": true
},
"typeVersion": 1.9
},
{
"id": "4ae6b1e3-fc83-4bde-a9bc-49a18cf46b32",
"name": "思考ツール",
"type": "@n8n/n8n-nodes-langchain.toolThink",
"position": [
2940,
-800
],
"parameters": {},
"typeVersion": 1
},
{
"id": "fc68e100-043b-4fb7-8388-1db3e5c07a9b",
"name": "付箋1",
"type": "n8n-nodes-base.stickyNote",
"position": [
2480,
-1180
],
"parameters": {
"color": 5,
"width": 1120,
"height": 640,
"content": "# Check Calendar Availability + Draft Email"
},
"typeVersion": 1
},
{
"id": "fd8404b2-522e-480c-b882-8fc94239e88f",
"name": "OpenAI Chat Model5",
"type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
"position": [
2540,
-840
],
"parameters": {
"model": {
"__rl": true,
"mode": "list",
"value": "gpt-4.1",
"cachedResultName": "gpt-4.1"
},
"options": {}
},
"credentials": {
"openAiApi": {
"id": "E9waf1c33TsN4RCh",
"name": "OpenAi account"
}
},
"typeVersion": 1.2
},
{
"id": "0c5ec3ff-1ad1-4d26-9340-f4ed1ff0846a",
"name": "OpenAI Chat Model7",
"type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
"position": [
1840,
-280
],
"parameters": {
"model": {
"__rl": true,
"mode": "list",
"value": "gpt-4.1-mini",
"cachedResultName": "gpt-4.1-mini"
},
"options": {}
},
"credentials": {
"openAiApi": {
"id": "E9waf1c33TsN4RCh",
"name": "OpenAi account"
}
},
"typeVersion": 1.2
},
{
"id": "cf89e12e-6778-4c2f-8be1-6465a3afa9d7",
"name": "カレンダーまたはメール",
"type": "@n8n/n8n-nodes-langchain.chainLlm",
"position": [
1840,
-500
],
"parameters": {
"text": "=New email just came in. \n\nHere's the email: \n\n{{ $('Gmail Trigger').item.json.id }}\n\nHere's the thread for context:\n\n{{ $json.messages.map((msg, index) => `Message ${index + 1}: ${msg.fullBody || msg.snippet}`).join('\\n\\n---\\n\\n') }}\n\n\nClassify it. ",
"messages": {
"messageValues": [
{
"message": "=You're a sales inbox manager. \nThe emails coming in from clients are sales-related, either leads/inquiries reaching out to book a call or to get more info. \n\nYour job is to classify each email as a calendar or information email. \n\nCalendar emails are those where the prospect suggests being booked in for a call. \n\nInformation emails are those which require a reply from the sales team to progress further. This could be the prospect asking for information or making an enquiry. "
}
]
},
"promptType": "define",
"hasOutputParser": true
},
"typeVersion": 1.6
},
{
"id": "db6386bf-32a6-4e61-ab47-9710011f20c7",
"name": "Gmail",
"type": "n8n-nodes-base.gmail",
"position": [
1440,
-500
],
"webhookId": "58a6430a-c9f6-45a5-928b-0a8fc2da78b3",
"parameters": {
"simple": false,
"options": {},
"resource": "thread",
"threadId": "={{ $json.threadId }}",
"operation": "get"
},
"credentials": {
"gmailOAuth2": {
"id": "C3I7lGaMkl8s8Uu6",
"name": "builtbyabdul"
}
},
"typeVersion": 2.1
},
{
"id": "0e016ea3-bfa9-4f2b-a096-64a34e936e82",
"name": "スレッド取得",
"type": "n8n-nodes-base.code",
"position": [
1600,
-500
],
"parameters": {
"jsCode": "// Get the Gmail thread data from the previous node\nconst threadData = $input.all();\n\n// Array to store all messages\nconst allMessages = [];\n\n// Function to extract text from message payload\nfunction extractMessageBody(payload) {\n let body = '';\n \n if (payload.body && payload.body.data) {\n // Single part message\n body = Buffer.from(payload.body.data, 'base64').toString('utf-8');\n } else if (payload.parts) {\n // Multi-part message\n for (const part of payload.parts) {\n if (part.mimeType === 'text/plain' && part.body && part.body.data) {\n body += Buffer.from(part.body.data, 'base64').toString('utf-8');\n } else if (part.mimeType === 'text/html' && part.body && part.body.data && !body) {\n // Use HTML if no plain text found\n body = Buffer.from(part.body.data, 'base64').toString('utf-8');\n } else if (part.parts) {\n // Nested parts (recursive)\n body += extractMessageBody(part);\n }\n }\n }\n \n return body.trim();\n}\n\n// Loop through each item from the Gmail node\nfor (const item of threadData) {\n // Check if messages exist in the item\n if (item.json.messages && Array.isArray(item.json.messages)) {\n // Loop through each message in the thread\n for (let i = 0; i < item.json.messages.length; i++) {\n const message = item.json.messages[i];\n \n // Extract the full message body\n const fullBody = message.payload ? extractMessageBody(message.payload) : message.snippet || '';\n \n if (fullBody) {\n allMessages.push({\n messageIndex: i,\n threadId: item.json.id || 'unknown',\n snippet: message.snippet || '',\n fullBody: fullBody,\n messageId: message.id || 'unknown',\n subject: message.payload?.headers?.find(h => h.name === 'Subject')?.value || '',\n from: message.payload?.headers?.find(h => h.name === 'From')?.value || '',\n date: message.payload?.headers?.find(h => h.name === 'Date')?.value || ''\n });\n }\n }\n }\n}\n\n// Return all messages as a single item with an array\nreturn [{\n json: {\n threadId: threadData[0]?.json?.id || 'unknown',\n totalMessages: allMessages.length,\n messages: allMessages\n }\n}];"
},
"typeVersion": 2
},
{
"id": "49dc5b26-b1e0-4969-82d2-eb0c91a631fe",
"name": "構造化出力パーサー6",
"type": "@n8n/n8n-nodes-langchain.outputParserStructured",
"position": [
2020,
-280
],
"parameters": {
"schemaType": "manual",
"inputSchema": "{\n \"type\": \"object\",\n \"properties\": {\n \"calendar\": {\n \"type\": \"boolean\",\n \"description\": \"True if Calendar Email and False if Information Email\"\n }\n },\n \"required\": [\n \"newProspectEmail\"\n ]\n}"
},
"typeVersion": 1.2
},
{
"id": "85623967-3d14-49fe-ba1a-f0cd9b248d21",
"name": "スイッチ",
"type": "n8n-nodes-base.switch",
"position": [
2160,
-500
],
"parameters": {
"rules": {
"values": [
{
"outputKey": "Calendar",
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "925bd4a7-f8a4-4b93-8fb9-47f6a238c89d",
"operator": {
"type": "boolean",
"operation": "true",
"singleValue": true
},
"leftValue": "={{ $json.output.calendar }}",
"rightValue": "Calendar"
}
]
},
"renameOutput": true
},
{
"outputKey": "Email",
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "a2580899-2579-496c-9f96-ea14fb997c4f",
"operator": {
"type": "boolean",
"operation": "false",
"singleValue": true
},
"leftValue": "={{ $json.output.calendar }}",
"rightValue": "Email"
}
]
},
"renameOutput": true
}
]
},
"options": {}
},
"typeVersion": 3.2
},
{
"id": "1a05e73f-25d4-4689-8c67-78aebf86b2de",
"name": "Gmail2",
"type": "n8n-nodes-base.gmail",
"position": [
3180,
-1060
],
"webhookId": "4674a08e-4878-4a34-a4f1-bd5e3315ab4b",
"parameters": {
"message": "={{ $json.output.emailBody }}",
"options": {
"replyTo": "={{ $('Gmail Trigger').item.json.From.extractEmail() }}",
"threadId": "={{ $('Gmail Trigger').item.json.threadId }}"
},
"subject": "=re: {{ $('Gmail Trigger').item.json.Subject }}",
"resource": "draft",
"emailType": "html"
},
"credentials": {
"gmailOAuth2": {
"id": "C3I7lGaMkl8s8Uu6",
"name": "builtbyabdul"
}
},
"typeVersion": 2.1
},
{
"id": "b7176cee-5122-4c95-bf73-6aad17a2f643",
"name": "ウィンドウバッファメモリ",
"type": "@n8n/n8n-nodes-langchain.memoryBufferWindow",
"position": [
2680,
-140
],
"parameters": {
"sessionKey": "=123456",
"sessionIdType": "customKey"
},
"typeVersion": 1.3
},
{
"id": "2053b536-f8c1-4ab1-85ea-b2ec3532c401",
"name": "OpenAI Chat Model1",
"type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
"position": [
3020,
80
],
"parameters": {
"model": {
"__rl": true,
"mode": "list",
"value": "gpt-4.1-mini",
"cachedResultName": "gpt-4.1-mini"
},
"options": {}
},
"credentials": {
"openAiApi": {
"id": "E9waf1c33TsN4RCh",
"name": "OpenAi account"
}
},
"typeVersion": 1.2
},
{
"id": "cec9545a-4f17-455b-be75-a894563424f0",
"name": "Supabase Vector Store2",
"type": "@n8n/n8n-nodes-langchain.vectorStoreSupabase",
"position": [
2660,
100
],
"parameters": {
"options": {
"queryName": "match_documents"
},
"tableName": {
"__rl": true,
"mode": "list",
"value": "documents",
"cachedResultName": "documents"
}
},
"credentials": {
"supabaseApi": {
"id": "0xwwr9KuQRNxpYYg",
"name": "Marketing Ladder"
}
},
"typeVersion": 1
},
{
"id": "8908e09d-a7aa-48d8-a6fe-b85eec59233b",
"name": "Embeddings OpenAI2",
"type": "@n8n/n8n-nodes-langchain.embeddingsOpenAi",
"position": [
2680,
280
],
"parameters": {
"options": {}
},
"credentials": {
"openAiApi": {
"id": "E9waf1c33TsN4RCh",
"name": "OpenAi account"
}
},
"typeVersion": 1.2
},
{
"id": "45bf5a88-9986-45dd-a6f5-3d1aa58aa9ee",
"name": "OpenAI Chat Model2",
"type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
"position": [
2500,
-180
],
"parameters": {
"model": {
"__rl": true,
"mode": "list",
"value": "gpt-4.1-mini",
"cachedResultName": "gpt-4.1-mini"
},
"options": {}
},
"credentials": {
"openAiApi": {
"id": "E9waf1c33TsN4RCh",
"name": "OpenAi account"
}
},
"typeVersion": 1.2
},
{
"id": "07f2df75-ce13-425f-9fec-e8bf079975a0",
"name": "ナレッジデータベース",
"type": "@n8n/n8n-nodes-langchain.toolVectorStore",
"position": [
2800,
-80
],
"parameters": {
"name": "KnowledgeDatabase",
"topK": "=5",
"description": "A list of frequently asked questions and answers and services we provide."
},
"typeVersion": 1
},
{
"id": "a33d5b62-974b-492f-90da-647d657d51ba",
"name": "Gmail3",
"type": "n8n-nodes-base.gmail",
"position": [
3260,
-260
],
"webhookId": "fe550c66-938b-47b1-8e44-e3a8a4c81551",
"parameters": {
"message": "={{ $json.output.emailBody }}",
"options": {
"replyTo": "={{ $('Gmail Trigger').item.json.From.extractEmail() }}",
"threadId": "={{ $('Gmail Trigger').item.json.threadId }}"
},
"subject": "=re: {{ $('Gmail Trigger').item.json.Subject }}",
"resource": "draft",
"emailType": "html"
},
"credentials": {
"gmailOAuth2": {
"id": "C3I7lGaMkl8s8Uu6",
"name": "builtbyabdul"
}
},
"typeVersion": 2.1
},
{
"id": "acdac639-c864-46b3-8108-4fbbf917b738",
"name": "Telegram",
"type": "n8n-nodes-base.telegram",
"position": [
3460,
-260
],
"webhookId": "aaced721-6777-4eb1-bd9e-288c69abacd2",
"parameters": {
"text": "=📥 New lead: {{ $('Gmail Trigger').item.json.From.split('<')[0].trim() }} \nThey were asking a question. I searched the knowledge database and drafted a reply for you. \nCheck your email!",
"chatId": "7961813100",
"additionalFields": {
"appendAttribution": false
}
},
"credentials": {
"telegramApi": {
"id": "aZMZKjKKlDbla2uQ",
"name": "Inbox Manager"
}
},
"typeVersion": 1.2
},
{
"id": "f5cc67cf-5494-4779-ba92-b1f38f63314c",
"name": "Telegram2",
"type": "n8n-nodes-base.telegram",
"position": [
3240,
-440
],
"webhookId": "0ba8be42-8201-4494-b643-0a56586bfb07",
"parameters": {
"text": "=📥 New lead: {{ $('Gmail Trigger').item.json.From.split('<')[0].trim() }} \nThey were asking a question, I searched the knowledge database but I wasn't sure how to respond.\nCheck your email!",
"chatId": "7961813100",
"additionalFields": {
"appendAttribution": false
}
},
"credentials": {
"telegramApi": {
"id": "aZMZKjKKlDbla2uQ",
"name": "Inbox Manager"
}
},
"typeVersion": 1.2
},
{
"id": "90e8a7e7-e944-4225-808e-5f7246a2d3ef",
"name": "受信ボット",
"type": "n8n-nodes-base.telegram",
"position": [
3380,
-1060
],
"webhookId": "d00cec86-877d-4176-942a-654ccdf17819",
"parameters": {
"text": "=📥 New lead: {{ $('Gmail Trigger').item.json.From.split('<')[0].trim() }} \nThey want to book a call. I checked your calendar and drafted a reply for you. \nCheck your email!",
"chatId": "7961813100",
"additionalFields": {
"appendAttribution": false
}
},
"credentials": {
"telegramApi": {
"id": "aZMZKjKKlDbla2uQ",
"name": "Inbox Manager"
}
},
"typeVersion": 1.2
},
{
"id": "623dd1d3-c4e0-4974-ae5d-c413fdc7f08a",
"name": "エスカレーション？",
"type": "n8n-nodes-base.if",
"position": [
3040,
-400
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "8c816866-eec9-4c02-a7df-e37a4c1fc89f",
"operator": {
"type": "boolean",
"operation": "true",
"singleValue": true
},
"leftValue": "={{ $json.output.escalate }}",
"rightValue": "true"
}
]
}
},
"typeVersion": 2.2
},
{
"id": "7551ab07-435c-4245-b1d8-5de3225cd7ba",
"name": "付箋4",
"type": "n8n-nodes-base.stickyNote",
"position": [
460,
-540
],
"parameters": {
"color": 3,
"width": 1100,
"height": 940,
"content": "# Categorize incoming emails\n"
},
"typeVersion": 1
},
{
"id": "9457d233-f70d-4b4b-9fe2-6ca2469c8e21",
"name": "付箋5",
"type": "n8n-nodes-base.stickyNote",
"position": [
1580,
-600
],
"parameters": {
"color": 4,
"width": 880,
"height": 540,
"content": "# New lead? Send to calendar/knowledge agent"
},
"typeVersion": 1
},
{
"id": "149f284f-01ec-4910-9543-59766fc8c51e",
"name": "ナレッジエージェント",
"type": "@n8n/n8n-nodes-langchain.agent",
"position": [
2660,
-400
],
"parameters": {
"text": "=Here's the email:\n{{ $('Gmail Trigger').item.json.snippet }}\n\nHere's the full thread for context:\n{{ $('Get Thread').item.json.messages.map((msg, index) => `Message ${index + 1}: ${msg.fullBody || msg.snippet}`).join('\\n\\n---\\n\\n') }}\n",
"options": {
"systemMessage": "=You work in the sales team at Marketing Ladder, a Marketing Agency. Your job is to respond to outbound/inbound emails from prospects.\n\nEmails may include:\n- A reply to a cold email we sent\n- A new inquiry from a prospect\n- A general question about our services\n\nYour steps:\n1. Use the \"knowledge database\" tool (RAG database) to find accurate answers to their question.\n2. Write a clear, human reply that:\n - Answers their question\n - Encourages them to book a consultation **if** you see fit (include this link if relevant: https://cal.com/builtbyabdul/freeconsultation)\n\nRules:\n-Never hallucinate/make up stuff. If you don't know the answer or can't find relevant info in your knowledge database, set \"escalate\": true so a human can take over.\n-Sign off every email as Abdul.\n\nCurrent date/time in Chicago (CDT): {{ $now.weekdayLong }}, {{ $now.format('dd LLL yyyy') }} at {{ $now.format('t') }}\n\nExample email:\n\"\"Hey Abdul, I came across your LinkedIn. \nI'm very interested after I checked out your beautifully designed website.\nWhat services do you guys offer? Anything related to LinkedIn? I gotta say, mine is pretty trash\"\"\n\nExample response:\n\"<p>Hey — appreciate you checking out the site, and glad it resonated.</p>\n\n<p>Yes, we offer LinkedIn-focused services. Mainly building out high-converting profiles, content systems that attract leads, and automated outreach funnels. If your profile needs work, we can help fix both the look and the backend strategy.</p>\n\n<p>Happy to walk you through more details over a call if you want. When are you free? Feel free to check my calendar here: <br>\n<a href=\"https://cal.com/builtbyabdul/freeconsultation\">https://cal.com/builtbyabdul/freeconsultation</a></p>\n\n<p>Best,<br>Abdul</p>\"\n"
},
"promptType": "define",
"hasOutputParser": true
},
"typeVersion": 1.9
},
{
"id": "07d606ce-4624-4a30-a7c2-3b72fb2994b9",
"name": "付箋",
"type": "n8n-nodes-base.stickyNote",
"position": [
4520,
-1160
],
"parameters": {
"color": 5,
"width": 860,
"height": 840,
"content": "## Example Draft + Telegram Notification\n\n\n\n"
},
"typeVersion": 1
},
{
"id": "44ccb83b-6cdd-448e-b7ca-4a42bd6bc504",
"name": "付箋3",
"type": "n8n-nodes-base.stickyNote",
"position": [
3700,
-1160
],
"parameters": {
"color": 3,
"width": 800,
"height": 360,
"content": "## Example Customer Email\n"
},
"typeVersion": 1
},
{
"id": "ca2e568b-79af-48b6-8fff-f00daba40c84",
"name": "付箋6",
"type": "n8n-nodes-base.stickyNote",
"position": [
1820,
60
],
"parameters": {
"color": 5,
"width": 440,
"height": 240,
"content": "## Hey, I'm Abdul 👋\n### I build growth systems for consultants & agencies. If you want to work together or need help automating your business, check out my website: \n### **https://www.builtbyabdul.com/**\n### Or email me at **builtbyabdul@gmail.com**\n### Have a lovely day ;)`"
},
"typeVersion": 1
},
{
"id": "606d1ce2-c0e4-4512-87c6-9d26af0ca2fb",
"name": "付箋7",
"type": "n8n-nodes-base.stickyNote",
"position": [
-380,
-760
],
"parameters": {
"width": 780,
"height": 1380,
"content": "# AI Inbox Manager that categorizes emails, books calls, and replies automatically\n## Overview\nTurn your cluttered inbox into a smart, autonomous assistant that categorizes emails, replies to leads, checks your calendar, and notifies you on Telegram—all without lifting a finger.\n\nThis workflow is designed for a marketing agency, but can be adapted for any business. It classifies incoming emails into categories like Sales, Client Communication, Reports, Billing, and Other. If it detects a new lead or priority message, it routes the email to one of two agents:\n- The **Calendar Agent** checks your availability in Google Calendar and drafts a consultation reply \n- The **Knowledge Agent** answers FAQs using your business knowledge base (with Supabase embeddings) \n\nBoth agents create draft email responses and send a Telegram alert so you're always in the loop.\n\n### Who’s it for\n- Founders and agency owners buried in emails \n- Marketing teams handling lots of inbound leads \n- Customer support managers automating Tier 1 replies \n- Anyone who wants a cleaner, smarter inbox without hiring a VA \n\n### How it works\n- Gmail trigger watches for incoming emails \n- Email content is passed to an AI classifier to apply a label (Sales, Client, Billing, etc.) \n- If the message is a new inquiry or lead, it’s routed to:\n - **Calendar Agent** → checks Google Calendar and drafts a reply with available slots \n - **Knowledge Agent** → searches vector DB and drafts a helpful reply from documentation \n- Both agents create a Gmail draft response and send a Telegram notification with summary \n\n### Example use case\n> A lead emails you asking for a discovery call. \n> \n> ✅ Email is labeled \"Sales\" \n> ✅ AI Calendar Agent checks your Google Calendar \n> ✅ A reply is drafted offering free time slots \n> ✅ You get a Telegram ping: \n> _\"New lead: Abdul Mir. I checked your calendar and drafted a reply. Check your email!\"_ \n\n### How to set up\n1. Connect your Gmail and set up a trigger for new messages \n2. Train the AI classifier with example categories and emails \n3. Connect Google Calendar API for availability checks \n4. Upload your internal docs and sync to Supabase vector store \n5. Connect Telegram for alerts \n6. Customize AI prompts and escalation logic as needed \n\n### Requirements\n- Gmail integration \n- OpenAI or Claude API (for classification + chat agents) \n- Google Calendar API \n- Supabase (or Pinecone, Weaviate) for RAG vector DB \n- Telegram bot API key\n\n### How to customize\n- Add custom labels like “Recruiting,” “Investor,” or “Support” \n- Replace Telegram with Slack or SMS alerts \n- Add CRM sync to update lead status \n- Escalate complicated replies to a human via task creation \n- Add auto-send (instead of drafts) after review or based on confidence score\n"
},
"typeVersion": 1
}
],
"pinData": {},
"connections": {
"db6386bf-32a6-4e61-ab47-9710011f20c7": {
"main": [
[
{
"node": "0e016ea3-bfa9-4f2b-a096-64a34e936e82",
"type": "main",
"index": 0
}
]
]
},
"efb203a1-f643-40c2-81d0-da388d9c34bd": {
"main": [
[
{
"node": "30468c6d-1b64-4953-a207-3f358b9c4910",
"type": "main",
"index": 0
}
]
]
},
"1a05e73f-25d4-4689-8c67-78aebf86b2de": {
"main": [
[
{
"node": "90e8a7e7-e944-4225-808e-5f7246a2d3ef",
"type": "main",
"index": 0
}
]
]
},
"a33d5b62-974b-492f-90da-647d657d51ba": {
"main": [
[
{
"node": "acdac639-c864-46b3-8108-4fbbf917b738",
"type": "main",
"index": 0
}
]
]
},
"85623967-3d14-49fe-ba1a-f0cd9b248d21": {
"main": [
[
{
"node": "c634a163-41f4-4dba-81d9-d7b56e1252ca",
"type": "main",
"index": 0
}
],
[
{
"node": "149f284f-01ec-4910-9543-59766fc8c51e",
"type": "main",
"index": 0
}
]
]
},
"623dd1d3-c4e0-4974-ae5d-c413fdc7f08a": {
"main": [
[
{
"node": "f5cc67cf-5494-4779-ba92-b1f38f63314c",
"type": "main",
"index": 0
}
],
[
{
"node": "a33d5b62-974b-492f-90da-647d657d51ba",
"type": "main",
"index": 0
}
]
]
},
"0e016ea3-bfa9-4f2b-a096-64a34e936e82": {
"main": [
[
{
"node": "cf89e12e-6778-4c2f-8be1-6465a3afa9d7",
"type": "main",
"index": 0
}
]
]
},
"7a1cdf33-7419-42cf-b8eb-05a29bf5512b": {
"ai_tool": [
[
{
"node": "c634a163-41f4-4dba-81d9-d7b56e1252ca",
"type": "ai_tool",
"index": 0
}
]
]
},
"4ae6b1e3-fc83-4bde-a9bc-49a18cf46b32": {
"ai_tool": [
[
{
"node": "c634a163-41f4-4dba-81d9-d7b56e1252ca",
"type": "ai_tool",
"index": 0
}
]
]
},
"7959f62a-c7bd-4c30-ba81-73fa5f120d48": {
"main": [
[
{
"node": "cba3842f-57f3-43a5-a436-868c81712967",
"type": "main",
"index": 0
}
]
]
},
"67aa2083-c8ef-4405-893e-53247b3ab6a2": {
"main": [
[
{
"node": "db6386bf-32a6-4e61-ab47-9710011f20c7",
"type": "main",
"index": 0
}
]
]
},
"c634a163-41f4-4dba-81d9-d7b56e1252ca": {
"main": [
[
{
"node": "1a05e73f-25d4-4689-8c67-78aebf86b2de",
"type": "main",
"index": 0
}
]
]
},
"149f284f-01ec-4910-9543-59766fc8c51e": {
"main": [
[
{
"node": "623dd1d3-c4e0-4974-ae5d-c413fdc7f08a",
"type": "main",
"index": 0
}
]
]
},
"cba3842f-57f3-43a5-a436-868c81712967": {
"main": [
[
{
"node": "67aa2083-c8ef-4405-893e-53247b3ab6a2",
"type": "main",
"index": 0
}
],
[
{
"node": "7b27e516-9515-45fe-aa4c-709c3f761b47",
"type": "main",
"index": 0
}
],
[
{
"node": "7d7f705b-e6ab-4b2a-aafd-0cd9ad4225fb",
"type": "main",
"index": 0
}
],
[
{
"node": "6a8339bb-3c7d-49ab-a03d-380d705d884b",
"type": "main",
"index": 0
}
],
[
{
"node": "efb203a1-f643-40c2-81d0-da388d9c34bd",
"type": "main",
"index": 0
}
]
]
},
"cf89e12e-6778-4c2f-8be1-6465a3afa9d7": {
"main": [
[
{
"node": "85623967-3d14-49fe-ba1a-f0cd9b248d21",
"type": "main",
"index": 0
}
]
]
},
"28dbe8df-9fa6-47fa-9891-48a88d703021": {
"ai_languageModel": [
[
{
"node": "cba3842f-57f3-43a5-a436-868c81712967",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"8908e09d-a7aa-48d8-a6fe-b85eec59233b": {
"ai_embedding": [
[
{
"node": "cec9545a-4f17-455b-be75-a894563424f0",
"type": "ai_embedding",
"index": 0
}
]
]
},
"07f2df75-ce13-425f-9fec-e8bf079975a0": {
"ai_tool": [
[
{
"node": "149f284f-01ec-4910-9543-59766fc8c51e",
"type": "ai_tool",
"index": 0
}
]
]
},
"2053b536-f8c1-4ab1-85ea-b2ec3532c401": {
"ai_languageModel": [
[
{
"node": "07f2df75-ce13-425f-9fec-e8bf079975a0",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"45bf5a88-9986-45dd-a6f5-3d1aa58aa9ee": {
"ai_languageModel": [
[
{
"node": "149f284f-01ec-4910-9543-59766fc8c51e",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"fd8404b2-522e-480c-b882-8fc94239e88f": {
"ai_languageModel": [
[
{
"node": "c634a163-41f4-4dba-81d9-d7b56e1252ca",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"0c5ec3ff-1ad1-4d26-9340-f4ed1ff0846a": {
"ai_languageModel": [
[
{
"node": "cf89e12e-6778-4c2f-8be1-6465a3afa9d7",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"cec9545a-4f17-455b-be75-a894563424f0": {
"ai_vectorStore": [
[
{
"node": "07f2df75-ce13-425f-9fec-e8bf079975a0",
"type": "ai_vectorStore",
"index": 0
}
]
]
},
"90fbe187-df56-45a5-b0ee-6fb68b1e0fba": {
"ai_outputParser": [
[
{
"node": "c634a163-41f4-4dba-81d9-d7b56e1252ca",
"type": "ai_outputParser",
"index": 0
}
]
]
},
"9c319421-1609-4d9b-875e-567ebc64f03d": {
"ai_outputParser": [
[
{
"node": "149f284f-01ec-4910-9543-59766fc8c51e",
"type": "ai_outputParser",
"index": 0
}
]
]
},
"49dc5b26-b1e0-4969-82d2-eb0c91a631fe": {
"ai_outputParser": [
[
{
"node": "cf89e12e-6778-4c2f-8be1-6465a3afa9d7",
"type": "ai_outputParser",
"index": 0
}
]
]
}
}
}よくある質問
このワークフローの使い方は？
上記のJSON設定コードをコピーし、n8nインスタンスで新しいワークフローを作成して「JSONからインポート」を選択、設定を貼り付けて認証情報を必要に応じて変更してください。
このワークフローはどんな場面に適していますか？
上級 - チケット管理, AI RAG検索拡張
有料ですか？
このワークフローは完全無料です。ただし、ワークフローで使用するサードパーティサービス（OpenAI APIなど）は別途料金が発生する場合があります。
関連ワークフロー
n8nノードの探索（可視化リファレンスライブラリ内）
n8nノードを可視化リファレンスライブラリで探索
If
Ftp
Set
+
If
Ftp
Set
113 ノードI versus AI
その他
AI知識ベースアシスタントとOpenAI、Supabase、Google Driveドキュメントの同期
AI知識ベースアシスタントとOpenAI、Supabase、Google Driveドキュメントの同期
Set
Limit
Switch
+
Set
Limit
Switch
49 ノードAbdul Mir
内部Wiki
🛃 インボックスマネージャー
GPT-5、マルチエージェントAI、Pineconeデータベースを使った自動メール管理システム
If
Gmail
Switch
+
If
Gmail
Switch
41 ノードZawanah
チケット管理
正式Gmailの下書きが更新されました
GPT-4.1、Pinecone RAG、Gmail を使った自動製品コンタクトメール対応
If
Gmail
Gmail Trigger
+
If
Gmail
Gmail Trigger
18 ノードFayzul Noor
チケット管理
ペットショップ 4
ペットショップ予約AIエージェント
If
Set
Code
+
If
Set
Code
187 ノードBruno Dias
人工知能
コンテキスト・ハイブリッドRAG AIコピー
RAGアプリケーション向けのGoogle DriveからSupabaseコンテキストベクトルデータベースへの同期
If
Set
Code
+
If
Set
Code
76 ノードMichael Taleb
AI RAG検索拡張
ワークフロー情報
難易度
上級
ノード数42
カテゴリー2
ノードタイプ18
作成者
Abdul Mir
@abdulmirHey 👋 I'm Abdul. I build AI-powered systems for marketing agencies and consultants who want to move fast and automate the boring stuff. Think lead gen agents, proposal generators, and content creation systems. I specialize in growth-focused automations and share workflows that save time and land clients.
外部リンク
n8n.ioで表示 →
このワークフローを共有