AIベースのWhatsAppサポートボット（Googleスプレッドシートでのチケット作成）
上級
これはSupport Chatbot, Multimodal AI分野の自動化ワークフローで、35個のノードを含みます。主にSet, Xml, Code, Html, Waitなどのノードを使用。 AIベースのWhatsAppサポートボット（Google シートチケット作成）
前提条件
- •Googleアカウント + Gmail API認証情報
- •ターゲットAPIの認証情報が必要な場合あり
- •Google Sheets API認証情報
- •OpenAI API Key
- •Pinecone API Key
使用ノード (35)
カテゴリー
ワークフロープレビュー
ノード接続関係を可視化、ズームとパンをサポート
ワークフローをエクスポート
以下のJSON設定をn8nにインポートして、このワークフローを使用できます
{
"nodes": [
{
"id": "c5b15d1f-3f07-4075-83d6-e9b393a20a16",
"name": "チャットメッセージ受信時",
"type": "@n8n/n8n-nodes-langchain.chatTrigger",
"position": [
1344,
720
],
"webhookId": "5365fa15-96ef-4437-90f5-8faeb595b03a",
"parameters": {},
"typeVersion": 1.1
},
{
"id": "91546766-7a95-4b59-8d13-e4b970b28e88",
"name": "AIエージェント",
"type": "@n8n/n8n-nodes-langchain.agent",
"position": [
1776,
720
],
"parameters": {},
"typeVersion": 2.1
},
{
"id": "b4a7917b-a9e6-4076-9aad-efe7cc4d72c5",
"name": "フォーム送信時",
"type": "n8n-nodes-base.formTrigger",
"position": [
1104,
-368
],
"webhookId": "8e81bc08-6fc8-4a47-8e45-63fe28046b5b",
"parameters": {},
"typeVersion": 2.2
},
{
"id": "f8d14cc9-8eb6-4fc6-9ffc-9c916738b09d",
"name": "XML",
"type": "n8n-nodes-base.xml",
"position": [
1856,
-368
],
"parameters": {},
"typeVersion": 1
},
{
"id": "a0af59c0-9c5a-4e4a-8654-fd4546224646",
"name": "HTTP Request",
"type": "n8n-nodes-base.httpRequest",
"position": [
1696,
-368
],
"parameters": {},
"typeVersion": 4.2
},
{
"id": "5ebd8d66-9d86-400e-b601-7fa2e0eb40c0",
"name": "Code",
"type": "n8n-nodes-base.code",
"position": [
2000,
-368
],
"parameters": {},
"typeVersion": 2
},
{
"id": "7dd826d4-a44e-4cf0-b85f-d23410d6a84d",
"name": "ページHTMLを取得",
"type": "n8n-nodes-base.httpRequest",
"position": [
2736,
-432
],
"parameters": {},
"typeVersion": 4.2
},
{
"id": "ed14bf13-5e46-4465-b93b-0cf8b1cbcc16",
"name": "HTML",
"type": "n8n-nodes-base.html",
"position": [
2736,
-624
],
"parameters": {},
"typeVersion": 1.2
},
{
"id": "add88ee7-7e17-4c34-a539-7b727e57c3a9",
"name": "ページをループ",
"type": "n8n-nodes-base.splitInBatches",
"position": [
2544,
-528
],
"parameters": {},
"typeVersion": 3
},
{
"id": "ef4fcd5d-5fa5-4d75-af9c-58c4f559d7a3",
"name": "待機",
"type": "n8n-nodes-base.wait",
"position": [
2896,
-432
],
"webhookId": "9d87e60f-9df8-4a13-9c22-e3e5a5bb9c0e",
"parameters": {},
"typeVersion": 1.1
},
{
"id": "fd7d2d87-8f73-4ce8-8788-b7ee3c983a83",
"name": "ページURLを分割",
"type": "n8n-nodes-base.code",
"position": [
1696,
-544
],
"parameters": {},
"typeVersion": 2
},
{
"id": "81444721-dcc0-41dc-91f0-5c71f04e3033",
"name": "Pinecone ベクトルストア",
"type": "@n8n/n8n-nodes-langchain.vectorStorePinecone",
"position": [
3296,
-208
],
"parameters": {},
"typeVersion": 1.3
},
{
"id": "a986e0b4-c032-4335-9c9b-c56197f9fbf7",
"name": "デフォルトデータローダー",
"type": "@n8n/n8n-nodes-langchain.documentDefaultDataLoader",
"position": [
3488,
0
],
"parameters": {},
"typeVersion": 1.1
},
{
"id": "5e9546d6-b63e-4db8-8ccf-1580dd389079",
"name": "シンプルメモリ",
"type": "@n8n/n8n-nodes-langchain.memoryBufferWindow",
"position": [
1840,
928
],
"parameters": {},
"typeVersion": 1.3
},
{
"id": "a79d3e2d-b7c6-401b-a449-9a46a7d65f43",
"name": "Pinecone (情報取得)",
"type": "@n8n/n8n-nodes-langchain.vectorStorePinecone",
"position": [
2032,
928
],
"parameters": {},
"typeVersion": 1.3
},
{
"id": "3bef0066-c5f8-420a-8064-ed0311b03a97",
"name": "会社情報",
"type": "n8n-nodes-base.set",
"position": [
1568,
720
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "40eb17ab-e6cd-4a88-8842-de528839a47e",
"name": "テキストを抽出",
"type": "n8n-nodes-base.extractFromFile",
"position": [
2512,
32
],
"parameters": {},
"typeVersion": 1
},
{
"id": "51d7cd78-8fb6-43cf-af33-460105ea6185",
"name": "PDFを抽出",
"type": "n8n-nodes-base.extractFromFile",
"position": [
2512,
-128
],
"parameters": {},
"typeVersion": 1
},
{
"id": "673ce2d3-e67b-4d19-9d2b-16817d543b1a",
"name": "テキストを選択",
"type": "n8n-nodes-base.set",
"position": [
2704,
32
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "3f4379fb-1ee1-45a2-8038-41150aa0819d",
"name": "PDFまたはTXT",
"type": "n8n-nodes-base.switch",
"position": [
2304,
-48
],
"parameters": {},
"typeVersion": 3.2
},
{
"id": "15a0a6a4-302d-45e4-af7c-72b21efc59dc",
"name": "マージ",
"type": "n8n-nodes-base.merge",
"position": [
2192,
-528
],
"parameters": {},
"typeVersion": 3.2
},
{
"id": "9be77a2b-5508-414b-92a1-e4c3178cc160",
"name": "重複を削除",
"type": "n8n-nodes-base.removeDuplicates",
"position": [
2336,
-528
],
"parameters": {},
"typeVersion": 2
},
{
"id": "1ccd6382-e370-47f7-902a-bc9ecf7f1ac6",
"name": "ファイルをループ",
"type": "n8n-nodes-base.splitInBatches",
"position": [
2080,
-192
],
"parameters": {},
"typeVersion": 3
},
{
"id": "c55ec9ad-9cf9-4813-a1cb-5a5bc8844469",
"name": "Switch1",
"type": "n8n-nodes-base.switch",
"position": [
1376,
-384
],
"parameters": {},
"typeVersion": 3.2
},
{
"id": "907ad368-9129-4d81-acbd-ad7d48de0787",
"name": "Split_Binary",
"type": "n8n-nodes-base.code",
"position": [
1856,
-64
],
"parameters": {},
"typeVersion": 2
},
{
"id": "05ac9943-f6de-43ab-b9bd-470d39e0db3d",
"name": "チケットを取得",
"type": "n8n-nodes-base.googleSheetsTool",
"position": [
2384,
848
],
"parameters": {},
"typeVersion": 4.6
},
{
"id": "df90fdae-4d8f-43a7-acf9-1c2349b8cf02",
"name": "サポートチケットを作成",
"type": "n8n-nodes-base.googleSheetsTool",
"position": [
2560,
784
],
"parameters": {},
"typeVersion": 4.6
},
{
"id": "05b6a554-0465-4595-821a-eac544c98b51",
"name": "Gmailでメッセージを送信",
"type": "n8n-nodes-base.gmailTool",
"position": [
1856,
1200
],
"webhookId": "d78e82ae-5289-4213-b1f4-7fb749b83dad",
"parameters": {},
"typeVersion": 2.1
},
{
"id": "6d27f310-28e3-4698-b09c-d924e5d77b4a",
"name": "OpenAI チャットモデル",
"type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
"position": [
1664,
928
],
"parameters": {},
"typeVersion": 1.2
},
{
"id": "53eb3e5f-8a73-4e8d-ab6e-840eb196f61d",
"name": "Embeddings OpenAI",
"type": "@n8n/n8n-nodes-langchain.embeddingsOpenAi",
"position": [
2112,
1120
],
"parameters": {},
"typeVersion": 1.2
},
{
"id": "e6a670ff-1815-44f7-ad82-99a4ea356ebb",
"name": "Embeddings OpenAI1",
"type": "@n8n/n8n-nodes-langchain.embeddingsOpenAi",
"position": [
3280,
16
],
"parameters": {},
"typeVersion": 1.2
},
{
"id": "ac031d5a-ed46-4c36-8213-734a08fc2c1f",
"name": "WhatsApp トリガー",
"type": "n8n-nodes-base.whatsAppTrigger",
"position": [
1344,
544
],
"webhookId": "64048f32-bac4-473d-9a2a-9193401d3937",
"parameters": {},
"typeVersion": 1
},
{
"id": "77349f3e-1292-432f-822a-4ca1d0b4a20d",
"name": "付箋",
"type": "n8n-nodes-base.stickyNote",
"position": [
1008,
-688
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "29fe4f2c-eed7-4e14-9f89-53e7bf689eaf",
"name": "付箋1",
"type": "n8n-nodes-base.stickyNote",
"position": [
1008,
432
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "0bbf9a71-f76d-49c5-8552-ae7b34dd1798",
"name": "付箋2",
"type": "n8n-nodes-base.stickyNote",
"position": [
-64,
-688
],
"parameters": {
"content": ""
},
"typeVersion": 1
}
],
"pinData": {},
"connections": {
"f8d14cc9-8eb6-4fc6-9ffc-9c916738b09d": {
"main": [
[
{
"node": "5ebd8d66-9d86-400e-b601-7fa2e0eb40c0",
"type": "main",
"index": 0
}
]
]
},
"5ebd8d66-9d86-400e-b601-7fa2e0eb40c0": {
"main": [
[
{
"node": "15a0a6a4-302d-45e4-af7c-72b21efc59dc",
"type": "main",
"index": 1
}
]
]
},
"ed14bf13-5e46-4465-b93b-0cf8b1cbcc16": {
"main": [
[
{
"node": "81444721-dcc0-41dc-91f0-5c71f04e3033",
"type": "main",
"index": 0
}
]
]
},
"ef4fcd5d-5fa5-4d75-af9c-58c4f559d7a3": {
"main": [
[
{
"node": "add88ee7-7e17-4c34-a539-7b727e57c3a9",
"type": "main",
"index": 0
}
]
]
},
"15a0a6a4-302d-45e4-af7c-72b21efc59dc": {
"main": [
[
{
"node": "9be77a2b-5508-414b-92a1-e4c3178cc160",
"type": "main",
"index": 0
}
]
]
},
"c55ec9ad-9cf9-4813-a1cb-5a5bc8844469": {
"main": [
[
{
"node": "fd7d2d87-8f73-4ce8-8788-b7ee3c983a83",
"type": "main",
"index": 0
}
],
[
{
"node": "a0af59c0-9c5a-4e4a-8654-fd4546224646",
"type": "main",
"index": 0
}
],
[
{
"node": "907ad368-9129-4d81-acbd-ad7d48de0787",
"type": "main",
"index": 0
}
]
]
},
"3f4379fb-1ee1-45a2-8038-41150aa0819d": {
"main": [
[
{
"node": "51d7cd78-8fb6-43cf-af33-460105ea6185",
"type": "main",
"index": 0
}
],
[
{
"node": "40eb17ab-e6cd-4a88-8842-de528839a47e",
"type": "main",
"index": 0
}
]
]
},
"51d7cd78-8fb6-43cf-af33-460105ea6185": {
"main": [
[
{
"node": "673ce2d3-e67b-4d19-9d2b-16817d543b1a",
"type": "main",
"index": 0
}
]
]
},
"05ac9943-f6de-43ab-b9bd-470d39e0db3d": {
"ai_tool": [
[
{
"node": "91546766-7a95-4b59-8d13-e4b970b28e88",
"type": "ai_tool",
"index": 0
}
]
]
},
"673ce2d3-e67b-4d19-9d2b-16817d543b1a": {
"main": [
[
{
"node": "1ccd6382-e370-47f7-902a-bc9ecf7f1ac6",
"type": "main",
"index": 0
}
]
]
},
"3bef0066-c5f8-420a-8064-ed0311b03a97": {
"main": [
[
{
"node": "91546766-7a95-4b59-8d13-e4b970b28e88",
"type": "main",
"index": 0
}
]
]
},
"40eb17ab-e6cd-4a88-8842-de528839a47e": {
"main": [
[
{
"node": "1ccd6382-e370-47f7-902a-bc9ecf7f1ac6",
"type": "main",
"index": 0
}
]
]
},
"a0af59c0-9c5a-4e4a-8654-fd4546224646": {
"main": [
[
{
"node": "f8d14cc9-8eb6-4fc6-9ffc-9c916738b09d",
"type": "main",
"index": 0
}
]
]
},
"907ad368-9129-4d81-acbd-ad7d48de0787": {
"main": [
[
{
"node": "1ccd6382-e370-47f7-902a-bc9ecf7f1ac6",
"type": "main",
"index": 0
}
]
]
},
"5e9546d6-b63e-4db8-8ccf-1580dd389079": {
"ai_memory": [
[
{
"node": "91546766-7a95-4b59-8d13-e4b970b28e88",
"type": "ai_memory",
"index": 0
}
]
]
},
"7dd826d4-a44e-4cf0-b85f-d23410d6a84d": {
"main": [
[
{
"node": "ef4fcd5d-5fa5-4d75-af9c-58c4f559d7a3",
"type": "main",
"index": 0
}
]
]
},
"1ccd6382-e370-47f7-902a-bc9ecf7f1ac6": {
"main": [
[
{
"node": "81444721-dcc0-41dc-91f0-5c71f04e3033",
"type": "main",
"index": 0
}
],
[
{
"node": "3f4379fb-1ee1-45a2-8038-41150aa0819d",
"type": "main",
"index": 0
}
]
]
},
"add88ee7-7e17-4c34-a539-7b727e57c3a9": {
"main": [
[
{
"node": "ed14bf13-5e46-4465-b93b-0cf8b1cbcc16",
"type": "main",
"index": 0
}
],
[
{
"node": "7dd826d4-a44e-4cf0-b85f-d23410d6a84d",
"type": "main",
"index": 0
}
]
]
},
"fd7d2d87-8f73-4ce8-8788-b7ee3c983a83": {
"main": [
[
{
"node": "15a0a6a4-302d-45e4-af7c-72b21efc59dc",
"type": "main",
"index": 0
}
]
]
},
"ac031d5a-ed46-4c36-8213-734a08fc2c1f": {
"main": [
[
{
"node": "3bef0066-c5f8-420a-8064-ed0311b03a97",
"type": "main",
"index": 0
}
]
]
},
"53eb3e5f-8a73-4e8d-ab6e-840eb196f61d": {
"ai_embedding": [
[
{
"node": "a79d3e2d-b7c6-401b-a449-9a46a7d65f43",
"type": "ai_embedding",
"index": 0
}
]
]
},
"6d27f310-28e3-4698-b09c-d924e5d77b4a": {
"ai_languageModel": [
[
{
"node": "91546766-7a95-4b59-8d13-e4b970b28e88",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"9be77a2b-5508-414b-92a1-e4c3178cc160": {
"main": [
[
{
"node": "add88ee7-7e17-4c34-a539-7b727e57c3a9",
"type": "main",
"index": 0
}
]
]
},
"e6a670ff-1815-44f7-ad82-99a4ea356ebb": {
"ai_embedding": [
[
{
"node": "81444721-dcc0-41dc-91f0-5c71f04e3033",
"type": "ai_embedding",
"index": 0
}
]
]
},
"b4a7917b-a9e6-4076-9aad-efe7cc4d72c5": {
"main": [
[
{
"node": "c55ec9ad-9cf9-4813-a1cb-5a5bc8844469",
"type": "main",
"index": 0
}
]
]
},
"a986e0b4-c032-4335-9c9b-c56197f9fbf7": {
"ai_document": [
[
{
"node": "81444721-dcc0-41dc-91f0-5c71f04e3033",
"type": "ai_document",
"index": 0
}
]
]
},
"df90fdae-4d8f-43a7-acf9-1c2349b8cf02": {
"ai_tool": [
[
{
"node": "91546766-7a95-4b59-8d13-e4b970b28e88",
"type": "ai_tool",
"index": 0
}
]
]
},
"05b6a554-0465-4595-821a-eac544c98b51": {
"ai_tool": [
[
{
"node": "91546766-7a95-4b59-8d13-e4b970b28e88",
"type": "ai_tool",
"index": 0
}
]
]
},
"a79d3e2d-b7c6-401b-a449-9a46a7d65f43": {
"ai_tool": [
[
{
"node": "91546766-7a95-4b59-8d13-e4b970b28e88",
"type": "ai_tool",
"index": 0
}
]
]
},
"c5b15d1f-3f07-4075-83d6-e9b393a20a16": {
"main": [
[
{
"node": "3bef0066-c5f8-420a-8064-ed0311b03a97",
"type": "main",
"index": 0
}
]
]
}
}
}よくある質問
このワークフローの使い方は？
上記のJSON設定コードをコピーし、n8nインスタンスで新しいワークフローを作成して「JSONからインポート」を選択、設定を貼り付けて認証情報を必要に応じて変更してください。
このワークフローはどんな場面に適していますか？
上級 - サポートチャットボット, マルチモーダルAI
有料ですか？
このワークフローは完全無料です。ただし、ワークフローで使用するサードパーティサービス（OpenAI APIなど）は別途料金が発生する場合があります。
関連ワークフロー
n8nノードの探索（可視化リファレンスライブラリ内）
n8nノードを可視化リファレンスライブラリで探索
If
Ftp
Set
+
If
Ftp
Set
113 ノードI versus AI
その他
ウェブサイトからすべてのページコンテンツを取得してPineconeにGemini埋め込みで保存
ウェブサイトからすべてのページコンテンツを取得し、PineconeにGemini埋め込みで保存
Xml
Code
Html
+
Xml
Code
Html
16 ノードZain Khan
文書抽出
コンテキスト・ハイブリッドRAG AIコピー
RAGアプリケーション向けのGoogle DriveからSupabaseコンテキストベクトルデータベースへの同期
If
Set
Code
+
If
Set
Code
76 ノードMichael Taleb
AI RAG検索拡張
基于AIのMISエージェント
基于AIの管理信息系统エージェント
If
Set
Code
+
If
Set
Code
129 ノードKumar Shivam
サポート
ペットショップ 4
ペットショップ予約AIエージェント
If
Set
Code
+
If
Set
Code
187 ノードBruno Dias
人工知能
PineconeへのJira未解決タスクとコメントのロード
Jiraの課題をRAG駆動のサポートエージェントとして Pinecone と OpenAI を使用する
Set
Code
Merge
+
Set
Code
Merge
30 ノードBr1
コンテンツ作成
ワークフロー情報
難易度
上級
ノード数35
カテゴリー2
ノードタイプ23
作成者
Zain Khan
@zainI partner with businesses to streamline processes and accelerate growth through intelligent AI automation and Web/mobile Development. Leveraging deep expertise in GPT-4, LangChain, and n8n, I develop AI-powered agents and sophisticated LLM pipelines.
外部リンク
n8n.ioで表示 →
このワークフローを共有