WA-ロボットモジュール-問卷-v1-データベース-販売-完全版

上級

これはSales, Building Blocks, Marketing分野の自動化ワークフローで、32個のノードを含みます。主にIf, Set, Switch, Postgres, WhatsAppなどのノードを使用。 Postgres において WhatsApp アンケート回答を収集する(「Anketa」モジュール)

前提条件
  • PostgreSQLデータベース接続情報
ワークフロープレビュー
ノード接続関係を可視化、ズームとパンをサポート
ワークフローをエクスポート
以下のJSON設定をn8nにインポートして、このワークフローを使用できます
{
  "id": "5vWy0IdYDMinpbbv",
  "meta": {
    "instanceId": "888b5b52ac2aa3f8f1bab6800cae8fce6f3d7947e840e64245b5198449908655",
    "templateCredsSetupCompleted": true
  },
  "name": "WA-Bot-Module-Anketa-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": "74e77f18-8de5-4f3b-95ef-d97b38a8af97",
      "name": "WhatsApp Trigger",
      "type": "n8n-nodes-base.whatsAppTrigger",
      "position": [
        40,
        760
      ],
      "webhookId": "8658e600-ca72-4153-889d-7a9439b19aff",
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "13dfccbd-47d9-434b-8c54-4b7b33364f49",
      "name": "付箋3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        420,
        520
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "688a5af7-20df-4292-a6bc-d28e93aa4a24",
      "name": "開始",
      "type": "n8n-nodes-base.whatsApp",
      "position": [
        480,
        560
      ],
      "webhookId": "efa7c03a-583d-49d2-96fa-1efab40353ac",
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "c31015af-d2ea-477a-b039-f99d4994a334",
      "name": "ボットステータス取得",
      "type": "n8n-nodes-base.postgres",
      "position": [
        480,
        760
      ],
      "parameters": {},
      "executeOnce": true,
      "typeVersion": 2.5,
      "alwaysOutputData": true
    },
    {
      "id": "7db6bdbb-e9c8-4b1f-9a8d-f65557884af6",
      "name": "付箋5",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        40,
        1340
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "3ccf8ac8-78b4-4332-a92f-c0c6ccdea135",
      "name": "コマンド",
      "type": "n8n-nodes-base.switch",
      "position": [
        980,
        760
      ],
      "parameters": {},
      "typeVersion": 3.2
    },
    {
      "id": "c88213ae-81d5-4bfa-9de0-7fa45979abd6",
      "name": "メインメニュー",
      "type": "n8n-nodes-base.whatsApp",
      "position": [
        1260,
        560
      ],
      "webhookId": "bf5feea7-a8a6-40bb-b499-1ca96ad58efd",
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "a7411083-1ad9-4295-9f16-86baccb234b9",
      "name": "初期化",
      "type": "n8n-nodes-base.set",
      "position": [
        260,
        760
      ],
      "parameters": {},
      "typeVersion": 3.4
    },
    {
      "id": "173729da-c067-4a76-93df-35d2ffbcfd54",
      "name": "テスト開始",
      "type": "n8n-nodes-base.whatsApp",
      "position": [
        1260,
        760
      ],
      "webhookId": "a109a322-a4ac-4e54-818c-225e3b42a5cf",
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "2ce61e6d-bca9-4efd-8fd3-3a9e2ad9b590",
      "name": "最初の質問を取得",
      "type": "n8n-nodes-base.postgres",
      "position": [
        1480,
        760
      ],
      "parameters": {},
      "executeOnce": true,
      "typeVersion": 2.5
    },
    {
      "id": "d8747f70-ab23-49ee-87ec-798786711bd9",
      "name": "ANKETAでボットステータスを更新",
      "type": "n8n-nodes-base.postgres",
      "position": [
        1920,
        760
      ],
      "parameters": {},
      "typeVersion": 2.5
    },
    {
      "id": "d88b9f5d-7529-4a20-89a5-4007f30b9535",
      "name": "付箋",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1860,
        720
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "f57e0e75-49e9-42ff-965d-b5cb6084ebee",
      "name": "フローを定義",
      "type": "n8n-nodes-base.switch",
      "position": [
        700,
        760
      ],
      "parameters": {},
      "typeVersion": 3.2
    },
    {
      "id": "0fc45a08-2719-43fb-8999-637b68d29ce0",
      "name": "STARTでボットステータスを更新",
      "type": "n8n-nodes-base.postgres",
      "position": [
        2340,
        1180
      ],
      "parameters": {},
      "typeVersion": 2.5
    },
    {
      "id": "786e1ad6-5bb8-4ac5-a923-fafadabcc499",
      "name": "利用可能な質問を取得",
      "type": "n8n-nodes-base.postgres",
      "position": [
        1700,
        980
      ],
      "parameters": {},
      "typeVersion": 2.5,
      "alwaysOutputData": true
    },
    {
      "id": "5ebe7749-4f5f-44ec-b041-16a9a62e93cd",
      "name": "質問は利用可能ですか?",
      "type": "n8n-nodes-base.if",
      "position": [
        1920,
        980
      ],
      "parameters": {},
      "executeOnce": true,
      "typeVersion": 2.2
    },
    {
      "id": "b65f351d-78b5-46da-bd73-93d0ceb2a919",
      "name": "質問は見つかりましたか?",
      "type": "n8n-nodes-base.if",
      "position": [
        1480,
        980
      ],
      "parameters": {},
      "typeVersion": 2.2
    },
    {
      "id": "2cccfa58-1492-4420-ab5b-42f16ac53e96",
      "name": "最初の質問",
      "type": "n8n-nodes-base.whatsApp",
      "position": [
        1700,
        760
      ],
      "webhookId": "3778ab5f-6e1e-45a2-97ae-f55ae13b0e9d",
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "feacdb2b-de64-4784-85e8-a12b35992384",
      "name": "質問",
      "type": "n8n-nodes-base.whatsApp",
      "position": [
        2140,
        980
      ],
      "webhookId": "c484c9c1-cf45-4a55-80a6-c9765ef650f8",
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "df3eb202-da56-4c03-b4c4-61b557d786eb",
      "name": "前の回答を追加",
      "type": "n8n-nodes-base.postgres",
      "position": [
        2340,
        980
      ],
      "parameters": {},
      "typeVersion": 2.5
    },
    {
      "id": "a6818f00-dd39-4cbd-8f0a-018a80ef6064",
      "name": "回答を追加",
      "type": "n8n-nodes-base.postgres",
      "position": [
        1700,
        1180
      ],
      "parameters": {},
      "typeVersion": 2.5
    },
    {
      "id": "104a660d-5032-413f-a72f-62ae74e9d12f",
      "name": "アンケートを終了",
      "type": "n8n-nodes-base.whatsApp",
      "position": [
        2140,
        1180
      ],
      "webhookId": "318e5835-f23a-4435-bc10-883c75fcf37f",
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "11b6580c-f083-45c6-8524-424c2ceef63b",
      "name": "前の回答を取得",
      "type": "n8n-nodes-base.postgres",
      "position": [
        1260,
        980
      ],
      "parameters": {},
      "typeVersion": 2.5,
      "alwaysOutputData": true
    },
    {
      "id": "bfb2e3bd-7663-449d-8e61-b6125935aa3b",
      "name": "付箋1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1180,
        720
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "5d5d103e-9365-4f62-9efe-8199ed8f5ce5",
      "name": "付箋2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1180,
        960
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "199c0247-ecbd-4693-9572-1e70da007b44",
      "name": "STARTでボットステータスをUPSERT",
      "type": "n8n-nodes-base.postgres",
      "position": [
        700,
        560
      ],
      "parameters": {},
      "typeVersion": 2.5
    },
    {
      "id": "a164b652-b8cc-4edf-a552-293d613deb2e",
      "name": "前の回答を追加",
      "type": "n8n-nodes-base.postgres",
      "position": [
        2140,
        760
      ],
      "parameters": {},
      "typeVersion": 2.5
    },
    {
      "id": "60a9c88a-c156-4b3f-abfd-f2f30b492058",
      "name": "付箋7",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -400,
        760
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "1c5c37c4-89e8-4ed4-9013-0a9c3c1748d1",
      "name": "付箋8",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -400,
        520
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "70f96a8e-c191-4f0e-9073-1f9bb1e8ef36",
      "name": "付箋9",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        40,
        1080
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "d4f4e891-0c3b-425f-9dab-c83396cf4e27",
      "name": "付箋10",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -400,
        1080
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "679715b4-677a-42c4-93ae-aba55a6cdc49",
      "name": "付箋11",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        40,
        520
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    }
  ],
  "active": false,
  "pinData": {},
  "settings": {
    "executionOrder": "v1"
  },
  "versionId": "e4ca2f56-6081-4e5f-814f-98bea4d20b0a",
  "connections": {
    "688a5af7-20df-4292-a6bc-d28e93aa4a24": {
      "main": [
        [
          {
            "node": "199c0247-ecbd-4693-9572-1e70da007b44",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "3ccf8ac8-78b4-4332-a92f-c0c6ccdea135": {
      "main": [
        [
          {
            "node": "c88213ae-81d5-4bfa-9de0-7fa45979abd6",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "173729da-c067-4a76-93df-35d2ffbcfd54",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "feacdb2b-de64-4784-85e8-a12b35992384": {
      "main": [
        [
          {
            "node": "a164b652-b8cc-4edf-a552-293d613deb2e",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "a6818f00-dd39-4cbd-8f0a-018a80ef6064": {
      "main": [
        [
          {
            "node": "786e1ad6-5bb8-4ac5-a923-fafadabcc499",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "f57e0e75-49e9-42ff-965d-b5cb6084ebee": {
      "main": [
        [
          {
            "node": "688a5af7-20df-4292-a6bc-d28e93aa4a24",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "3ccf8ac8-78b4-4332-a92f-c0c6ccdea135",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "11b6580c-f083-45c6-8524-424c2ceef63b",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "173729da-c067-4a76-93df-35d2ffbcfd54": {
      "main": [
        [
          {
            "node": "2ce61e6d-bca9-4efd-8fd3-3a9e2ad9b590",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "104a660d-5032-413f-a72f-62ae74e9d12f": {
      "main": [
        [
          {
            "node": "0fc45a08-2719-43fb-8999-637b68d29ce0",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "2cccfa58-1492-4420-ab5b-42f16ac53e96": {
      "main": [
        [
          {
            "node": "d8747f70-ab23-49ee-87ec-798786711bd9",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "c31015af-d2ea-477a-b039-f99d4994a334": {
      "main": [
        [
          {
            "node": "f57e0e75-49e9-42ff-965d-b5cb6084ebee",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "a7411083-1ad9-4295-9f16-86baccb234b9": {
      "main": [
        [
          {
            "node": "c31015af-d2ea-477a-b039-f99d4994a334",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "11b6580c-f083-45c6-8524-424c2ceef63b": {
      "main": [
        [
          {
            "node": "b65f351d-78b5-46da-bd73-93d0ceb2a919",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "74e77f18-8de5-4f3b-95ef-d97b38a8af97": {
      "main": [
        [
          {
            "node": "a7411083-1ad9-4295-9f16-86baccb234b9",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "2ce61e6d-bca9-4efd-8fd3-3a9e2ad9b590": {
      "main": [
        [
          {
            "node": "2cccfa58-1492-4420-ab5b-42f16ac53e96",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "b65f351d-78b5-46da-bd73-93d0ceb2a919": {
      "main": [
        [
          {
            "node": "786e1ad6-5bb8-4ac5-a923-fafadabcc499",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "a6818f00-dd39-4cbd-8f0a-018a80ef6064",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "786e1ad6-5bb8-4ac5-a923-fafadabcc499": {
      "main": [
        [
          {
            "node": "5ebe7749-4f5f-44ec-b041-16a9a62e93cd",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "5ebe7749-4f5f-44ec-b041-16a9a62e93cd": {
      "main": [
        [
          {
            "node": "feacdb2b-de64-4784-85e8-a12b35992384",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "104a660d-5032-413f-a72f-62ae74e9d12f",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "0fc45a08-2719-43fb-8999-637b68d29ce0": {
      "main": [
        []
      ]
    },
    "d8747f70-ab23-49ee-87ec-798786711bd9": {
      "main": [
        [
          {
            "node": "a164b652-b8cc-4edf-a552-293d613deb2e",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}
よくある質問

このワークフローの使い方は?

上記のJSON設定コードをコピーし、n8nインスタンスで新しいワークフローを作成して「JSONからインポート」を選択、設定を貼り付けて認証情報を必要に応じて変更してください。

このワークフローはどんな場面に適していますか?

上級 - 営業, ビルディングブロック, マーケティング

有料ですか?

このワークフローは完全無料です。ただし、ワークフローで使用するサードパーティサービス(OpenAI APIなど)は別途料金が発生する場合があります。

ワークフロー情報
難易度
上級
ノード数32
カテゴリー3
ノードタイプ7
難易度説明

上級者向け、16ノード以上の複雑なワークフロー

外部リンク
n8n.ioで表示

このワークフローを共有

カテゴリー

カテゴリー: 34