WA-ロボットモジュール-クイズ-v1-完全版（DBセール）
上級
これはSales, Marketing分野の自動化ワークフローで、39個のノードを含みます。主にIf, Set, Sort, Switch, Postgresなどのノードを使用。 PostgreSQL を使用した WhatsApp クイズと結果ランキングの自動化（「クイズ」モジュール）
前提条件
- •PostgreSQLデータベース接続情報
ワークフロープレビュー
ノード接続関係を可視化、ズームとパンをサポート
ワークフローをエクスポート
以下のJSON設定をn8nにインポートして、このワークフローを使用できます
{
"id": "QTuJfyY6vm7iEIH6",
"meta": {
"instanceId": "888b5b52ac2aa3f8f1bab6800cae8fce6f3d7947e840e64245b5198449908655",
"templateCredsSetupCompleted": true
},
"name": "WA-Bot-Module-Quiz-v1-db-sell-full",
"tags": [
{
"id": "XPad0ERjSdqfxG52",
"name": "module",
"createdAt": "2025-03-31T08:11:00.151Z",
"updatedAt": "2025-03-31T08:11:00.151Z"
},
{
"id": "NeRMkUNq0sRVlL99",
"name": "whatsapp",
"createdAt": "2025-03-10T18:20:40.864Z",
"updatedAt": "2025-03-10T18:20:40.864Z"
},
{
"id": "2ocrWSzdKoCOU2AC",
"name": "sell",
"createdAt": "2025-04-19T15:39:51.859Z",
"updatedAt": "2025-04-19T15:39:51.859Z"
}
],
"nodes": [
{
"id": "6eb96949-f6bc-4044-b0cf-7bac329ce722",
"name": "付箋3",
"type": "n8n-nodes-base.stickyNote",
"position": [
420,
520
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "42f5adf9-8663-44f7-a2da-20631d01dc0f",
"name": "付箋4",
"type": "n8n-nodes-base.stickyNote",
"position": [
20,
520
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "2e406d54-a333-4767-a1bb-e2c61d60c5b6",
"name": "開始",
"type": "n8n-nodes-base.whatsApp",
"position": [
480,
560
],
"webhookId": "c9e66b18-77be-4d85-94f5-11824c2ce53c",
"parameters": {},
"typeVersion": 1
},
{
"id": "7d6e48cb-6154-48a5-97c5-aef2bfcffc58",
"name": "ボットステータス取得",
"type": "n8n-nodes-base.postgres",
"position": [
480,
760
],
"parameters": {},
"executeOnce": true,
"typeVersion": 2.5,
"alwaysOutputData": true
},
{
"id": "a998e1fe-c919-4b61-a051-17afa7f14c0e",
"name": "付箋5",
"type": "n8n-nodes-base.stickyNote",
"position": [
20,
1400
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "2ed48b30-5737-4d84-bceb-a8046c950fe6",
"name": "コマンド",
"type": "n8n-nodes-base.switch",
"position": [
980,
760
],
"parameters": {},
"typeVersion": 3.2
},
{
"id": "0039047d-110f-4726-a29d-2d1035e924ec",
"name": "メインメニュー",
"type": "n8n-nodes-base.whatsApp",
"position": [
1260,
560
],
"webhookId": "4ab7201b-786d-4004-96ec-e0a4c7105ed1",
"parameters": {},
"typeVersion": 1
},
{
"id": "53c8427c-a23d-4818-a2d5-f8ad3cd78816",
"name": "付箋",
"type": "n8n-nodes-base.stickyNote",
"position": [
2960,
940
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "743ef248-8f5c-444b-91c9-07249ae98540",
"name": "フロー定義",
"type": "n8n-nodes-base.switch",
"position": [
700,
760
],
"parameters": {},
"typeVersion": 3.2
},
{
"id": "68ae7054-369d-4b61-ad76-eeba27d8fc98",
"name": "付箋2",
"type": "n8n-nodes-base.stickyNote",
"position": [
1220,
740
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "988f33f4-a8d9-44d9-ac2c-3ad00c64217f",
"name": "START時のボットステータス更新（UPSERT）",
"type": "n8n-nodes-base.postgres",
"position": [
700,
560
],
"parameters": {},
"typeVersion": 2.5
},
{
"id": "719d9e1d-61e1-44de-8cfc-bc28b8e5f53c",
"name": "初期化",
"type": "n8n-nodes-base.set",
"position": [
240,
760
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "2908320f-4f14-4d9a-9896-72b4187f8217",
"name": "START時のボットステータス更新",
"type": "n8n-nodes-base.postgres",
"position": [
1480,
560
],
"parameters": {},
"typeVersion": 2.5
},
{
"id": "ef1d9288-56f0-41ce-81a3-c3452e6ac86a",
"name": "TEST時のボットステータス更新",
"type": "n8n-nodes-base.postgres",
"position": [
3020,
960
],
"parameters": {},
"typeVersion": 2.5
},
{
"id": "a42629ec-0966-4e63-b863-a0f541003171",
"name": "質問をランダム化",
"type": "n8n-nodes-base.sort",
"position": [
2360,
960
],
"parameters": {},
"executeOnce": false,
"typeVersion": 1
},
{
"id": "08429844-5483-44d7-8a5c-4e9e0f6f120e",
"name": "質問はありますか？",
"type": "n8n-nodes-base.if",
"position": [
2140,
1160
],
"parameters": {},
"typeVersion": 2.2
},
{
"id": "c2fe1635-6536-4895-9842-a815eb7902aa",
"name": "回答を更新",
"type": "n8n-nodes-base.postgres",
"position": [
1700,
1160
],
"parameters": {},
"executeOnce": true,
"typeVersion": 2.5
},
{
"id": "ea2fe4f7-1cd3-41a8-a1b1-1fe94e416a5f",
"name": "未回答の質問を取得",
"type": "n8n-nodes-base.postgres",
"position": [
1920,
1160
],
"parameters": {},
"typeVersion": 2.5,
"alwaysOutputData": true
},
{
"id": "3000d5c8-a99c-4d1d-b6ff-a49ec1ea73c2",
"name": "テストを取得",
"type": "n8n-nodes-base.postgres",
"position": [
1480,
760
],
"parameters": {},
"typeVersion": 2.5
},
{
"id": "118fe642-e11f-4f1d-ab38-34f9b4b3e329",
"name": "番号と質問を結合",
"type": "n8n-nodes-base.set",
"position": [
1700,
760
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "aa592693-5434-44e8-8e90-00887b261b1f",
"name": "リストを結合",
"type": "n8n-nodes-base.summarize",
"position": [
1920,
760
],
"parameters": {},
"typeVersion": 1.1
},
{
"id": "fcac55cc-3ce0-4f2c-8d36-605927fce0fb",
"name": "回答を計算",
"type": "n8n-nodes-base.postgres",
"position": [
2360,
1160
],
"parameters": {},
"typeVersion": 2.5
},
{
"id": "c03e0632-74ea-471a-a0d4-7f754d062db4",
"name": "WhatsAppトリガー",
"type": "n8n-nodes-base.whatsAppTrigger",
"position": [
20,
760
],
"webhookId": "314e7a55-d4ca-4514-9d28-0b41c7d64945",
"parameters": {},
"typeVersion": 1
},
{
"id": "726f6b67-542f-4a11-aa48-e1427be1074e",
"name": "テスト一覧",
"type": "n8n-nodes-base.whatsApp",
"position": [
2140,
760
],
"webhookId": "d7d17714-5fe6-4d42-82a0-23590e4cf957",
"parameters": {},
"typeVersion": 1
},
{
"id": "c365a231-8572-4a40-8c07-21000690e9af",
"name": "一覧？",
"type": "n8n-nodes-base.if",
"position": [
1260,
760
],
"parameters": {},
"typeVersion": 2.2
},
{
"id": "94d08401-dc68-4979-b94e-600e79000679",
"name": "テストを取得",
"type": "n8n-nodes-base.postgres",
"position": [
1700,
960
],
"parameters": {},
"executeOnce": true,
"typeVersion": 2.5
},
{
"id": "ff451553-cae3-450d-8f0c-ae4a89f146d8",
"name": "テストを取得",
"type": "n8n-nodes-base.postgres",
"position": [
1480,
960
],
"parameters": {},
"executeOnce": true,
"typeVersion": 2.5
},
{
"id": "66608e4e-2771-4210-aee8-f1fcb3453cef",
"name": "テスト",
"type": "n8n-nodes-base.whatsApp",
"position": [
1920,
960
],
"webhookId": "0e07e27a-bce0-4c89-8b7a-afad148361ca",
"parameters": {},
"typeVersion": 1
},
{
"id": "3e36fbcd-fbe7-4343-8eb7-2ee0c2bac223",
"name": "質問と回答を取得",
"type": "n8n-nodes-base.postgres",
"position": [
2140,
960
],
"parameters": {},
"executeOnce": true,
"typeVersion": 2.5
},
{
"id": "78efdb33-a094-4a36-98f8-30de68292d4c",
"name": "回答を更新（UPSERT）",
"type": "n8n-nodes-base.postgres",
"position": [
2580,
960
],
"parameters": {},
"executeOnce": true,
"typeVersion": 2.5
},
{
"id": "6ff36dd2-b8b0-4f45-997a-7d098f9eb56f",
"name": "回答をリクエスト",
"type": "n8n-nodes-base.whatsApp",
"position": [
2800,
960
],
"webhookId": "4e533cdd-57de-43b6-8b24-36b93013fb01",
"parameters": {},
"typeVersion": 1
},
{
"id": "75937466-26c4-424b-ae46-54890d044c12",
"name": "回答を取得",
"type": "n8n-nodes-base.postgres",
"position": [
1260,
1160
],
"parameters": {},
"executeOnce": true,
"typeVersion": 2.5
},
{
"id": "9638190f-351e-40ee-8708-20231701c650",
"name": "結果",
"type": "n8n-nodes-base.whatsApp",
"position": [
2580,
1160
],
"webhookId": "5869922e-9e0e-4482-9637-21e753689c22",
"parameters": {},
"typeVersion": 1
},
{
"id": "65c40000-24b8-4317-a3f8-99cf8618b508",
"name": "質問バリエーションを取得",
"type": "n8n-nodes-base.postgres",
"position": [
1480,
1160
],
"parameters": {},
"executeOnce": true,
"typeVersion": 2.5
},
{
"id": "a082da78-ab1a-4e61-8d6b-cb24ffb3ed9d",
"name": "START時のボットステータス更新",
"type": "n8n-nodes-base.postgres",
"position": [
2800,
1160
],
"parameters": {},
"typeVersion": 2.5
},
{
"id": "1ea5577a-5ac6-4884-9ec3-f20bc17c33e4",
"name": "付箋7",
"type": "n8n-nodes-base.stickyNote",
"position": [
-420,
760
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "0cc3c717-85c3-4cb0-8526-4f4e6b6a54dd",
"name": "付箋8",
"type": "n8n-nodes-base.stickyNote",
"position": [
-420,
520
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "08ed150c-151c-42f9-9f72-cf46b2791011",
"name": "付箋9",
"type": "n8n-nodes-base.stickyNote",
"position": [
20,
1080
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "f31fa5b3-0c9d-4479-8026-70fc779ed579",
"name": "付箋6",
"type": "n8n-nodes-base.stickyNote",
"position": [
-420,
1080
],
"parameters": {
"content": ""
},
"typeVersion": 1
}
],
"active": false,
"pinData": {},
"settings": {
"executionOrder": "v1"
},
"versionId": "ddae069a-aa64-4421-9090-01171c60d0d0",
"connections": {
"66608e4e-2771-4210-aee8-f1fcb3453cef": {
"main": [
[
{
"node": "3e36fbcd-fbe7-4343-8eb7-2ee0c2bac223",
"type": "main",
"index": 0
}
]
]
},
"c365a231-8572-4a40-8c07-21000690e9af": {
"main": [
[
{
"node": "ff451553-cae3-450d-8f0c-ae4a89f146d8",
"type": "main",
"index": 0
}
],
[
{
"node": "ff451553-cae3-450d-8f0c-ae4a89f146d8",
"type": "main",
"index": 0
}
]
]
},
"9638190f-351e-40ee-8708-20231701c650": {
"main": [
[
{
"node": "a082da78-ab1a-4e61-8d6b-cb24ffb3ed9d",
"type": "main",
"index": 0
}
]
]
},
"2e406d54-a333-4767-a1bb-e2c61d60c5b6": {
"main": [
[
{
"node": "988f33f4-a8d9-44d9-ac2c-3ad00c64217f",
"type": "main",
"index": 0
}
]
]
},
"2ed48b30-5737-4d84-bceb-a8046c950fe6": {
"main": [
[
{
"node": "0039047d-110f-4726-a29d-2d1035e924ec",
"type": "main",
"index": 0
}
],
[
{
"node": "c365a231-8572-4a40-8c07-21000690e9af",
"type": "main",
"index": 0
}
]
]
},
"ff451553-cae3-450d-8f0c-ae4a89f146d8": {
"main": [
[
{
"node": "ff451553-cae3-450d-8f0c-ae4a89f146d8",
"type": "main",
"index": 0
}
]
]
},
"0039047d-110f-4726-a29d-2d1035e924ec": {
"main": [
[
{
"node": "a082da78-ab1a-4e61-8d6b-cb24ffb3ed9d",
"type": "main",
"index": 0
}
]
]
},
"75937466-26c4-424b-ae46-54890d044c12": {
"main": [
[
{
"node": "65c40000-24b8-4317-a3f8-99cf8618b508",
"type": "main",
"index": 0
}
]
]
},
"aa592693-5434-44e8-8e90-00887b261b1f": {
"main": [
[
{
"node": "726f6b67-542f-4a11-aa48-e1427be1074e",
"type": "main",
"index": 0
}
]
]
},
"743ef248-8f5c-444b-91c9-07249ae98540": {
"main": [
[
{
"node": "2e406d54-a333-4767-a1bb-e2c61d60c5b6",
"type": "main",
"index": 0
}
],
[
{
"node": "2ed48b30-5737-4d84-bceb-a8046c950fe6",
"type": "main",
"index": 0
}
],
[
{
"node": "75937466-26c4-424b-ae46-54890d044c12",
"type": "main",
"index": 0
}
]
]
},
"c2fe1635-6536-4895-9842-a815eb7902aa": {
"main": [
[
{
"node": "ea2fe4f7-1cd3-41a8-a1b1-1fe94e416a5f",
"type": "main",
"index": 0
}
]
]
},
"08429844-5483-44d7-8a5c-4e9e0f6f120e": {
"main": [
[
{
"node": "a42629ec-0966-4e63-b863-a0f541003171",
"type": "main",
"index": 0
}
],
[
{
"node": "fcac55cc-3ce0-4f2c-8d36-605927fce0fb",
"type": "main",
"index": 0
}
]
]
},
"7d6e48cb-6154-48a5-97c5-aef2bfcffc58": {
"main": [
[
{
"node": "743ef248-8f5c-444b-91c9-07249ae98540",
"type": "main",
"index": 0
}
]
]
},
"719d9e1d-61e1-44de-8cfc-bc28b8e5f53c": {
"main": [
[
{
"node": "7d6e48cb-6154-48a5-97c5-aef2bfcffc58",
"type": "main",
"index": 0
}
]
]
},
"6ff36dd2-b8b0-4f45-997a-7d098f9eb56f": {
"main": [
[
{
"node": "ef1d9288-56f0-41ce-81a3-c3452e6ac86a",
"type": "main",
"index": 0
}
]
]
},
"c03e0632-74ea-471a-a0d4-7f754d062db4": {
"main": [
[
{
"node": "719d9e1d-61e1-44de-8cfc-bc28b8e5f53c",
"type": "main",
"index": 0
}
]
]
},
"fcac55cc-3ce0-4f2c-8d36-605927fce0fb": {
"main": [
[
{
"node": "9638190f-351e-40ee-8708-20231701c650",
"type": "main",
"index": 0
}
]
]
},
"78efdb33-a094-4a36-98f8-30de68292d4c": {
"main": [
[
{
"node": "6ff36dd2-b8b0-4f45-997a-7d098f9eb56f",
"type": "main",
"index": 0
}
]
]
},
"a42629ec-0966-4e63-b863-a0f541003171": {
"main": [
[
{
"node": "78efdb33-a094-4a36-98f8-30de68292d4c",
"type": "main",
"index": 0
}
]
]
},
"65c40000-24b8-4317-a3f8-99cf8618b508": {
"main": [
[
{
"node": "c2fe1635-6536-4895-9842-a815eb7902aa",
"type": "main",
"index": 0
}
]
]
},
"3e36fbcd-fbe7-4343-8eb7-2ee0c2bac223": {
"main": [
[
{
"node": "a42629ec-0966-4e63-b863-a0f541003171",
"type": "main",
"index": 0
}
]
]
},
"ea2fe4f7-1cd3-41a8-a1b1-1fe94e416a5f": {
"main": [
[
{
"node": "08429844-5483-44d7-8a5c-4e9e0f6f120e",
"type": "main",
"index": 0
}
]
]
},
"118fe642-e11f-4f1d-ab38-34f9b4b3e329": {
"main": [
[
{
"node": "aa592693-5434-44e8-8e90-00887b261b1f",
"type": "main",
"index": 0
}
]
]
}
}
}よくある質問
このワークフローの使い方は？
上記のJSON設定コードをコピーし、n8nインスタンスで新しいワークフローを作成して「JSONからインポート」を選択、設定を貼り付けて認証情報を必要に応じて変更してください。
このワークフローはどんな場面に適していますか？
上級 - 営業, マーケティング
有料ですか？
このワークフローは完全無料です。ただし、ワークフローで使用するサードパーティサービス（OpenAI APIなど）は別途料金が発生する場合があります。
関連ワークフロー
WA-ロボットモジュール-予約-v1-データベース-セールス-フルバージョン
自動顧客予約（Telegram、PostgreSQL。予約モジュールを使用）
If
Set
Merge
+
If
Set
Merge
49 ノードAndrew
営業
TG-Bot-Module-Quiz-v4-db-sell-full
Telegram経由でPostgresで自動テストと応答の収集（"クイズ"モジュール）
If
Set
Code
+
If
Set
Code
36 ノードAndrew
営業
WA-ロボットモジュール-問卷-v1-データベース-販売-完全版
Postgres において WhatsApp アンケート回答を収集する（「Anketa」モジュール）
If
Set
Switch
+
If
Set
Switch
32 ノードAndrew
営業
TG-botモジュール-マルチプラットフォーム公開-v1-データベース-販売完全版
"クロスプラットフォーム投稿"モジュールを使用してPostgresでTelegramチャンネルの投稿を自動化
If
Set
Switch
+
If
Set
Switch
47 ノードAndrew
営業
マルチプラットフォーム売上エージェントの自動化
RAG、CRM、および決済処理を使用したマルチプラットフォーム販売エージェント
If
Set
Switch
+
If
Set
Switch
83 ノードElectrabot
営業
メールアドレスとドメインを使ってBright DataとGoogle検索で売り手データを補完
Bright DataとGoogle検索を使ってメールアドレスとドメインからセラーデータを豊富に見つける
If
Set
Code
+
If
Set
Code
32 ノードCyril Nicko Gaspar
営業
