WA-robot-module-questionnaire-v1-base-de-données-ventions-complet

Avancé

Ceci est unSales, Building Blocks, Marketingworkflow d'automatisation du domainecontenant 32 nœuds.Utilise principalement des nœuds comme If, Set, Switch, Postgres, WhatsApp. Collecter les réponses aux questionnaires WhatsApp dans Postgres (module "Anketa")

Prérequis
  • Informations de connexion à la base de données PostgreSQL
Aperçu du workflow
Visualisation des connexions entre les nœuds, avec support du zoom et du déplacement
Exporter le workflow
Copiez la configuration JSON suivante dans n8n pour importer et utiliser ce workflow
{
  "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": "Note adhésive3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        420,
        520
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "688a5af7-20df-4292-a6bc-d28e93aa4a24",
      "name": "Démarrages",
      "type": "n8n-nodes-base.whatsApp",
      "position": [
        480,
        560
      ],
      "webhookId": "efa7c03a-583d-49d2-96fa-1efab40353ac",
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "c31015af-d2ea-477a-b039-f99d4994a334",
      "name": "Obtenir l'état du bot",
      "type": "n8n-nodes-base.postgres",
      "position": [
        480,
        760
      ],
      "parameters": {},
      "executeOnce": true,
      "typeVersion": 2.5,
      "alwaysOutputData": true
    },
    {
      "id": "7db6bdbb-e9c8-4b1f-9a8d-f65557884af6",
      "name": "Note adhésive5",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        40,
        1340
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "3ccf8ac8-78b4-4332-a92f-c0c6ccdea135",
      "name": "Commandes",
      "type": "n8n-nodes-base.switch",
      "position": [
        980,
        760
      ],
      "parameters": {},
      "typeVersion": 3.2
    },
    {
      "id": "c88213ae-81d5-4bfa-9de0-7fa45979abd6",
      "name": "Menu principal",
      "type": "n8n-nodes-base.whatsApp",
      "position": [
        1260,
        560
      ],
      "webhookId": "bf5feea7-a8a6-40bb-b499-1ca96ad58efd",
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "a7411083-1ad9-4295-9f16-86baccb234b9",
      "name": "Initialisation",
      "type": "n8n-nodes-base.set",
      "position": [
        260,
        760
      ],
      "parameters": {},
      "typeVersion": 3.4
    },
    {
      "id": "173729da-c067-4a76-93df-35d2ffbcfd54",
      "name": "Test de démarrage",
      "type": "n8n-nodes-base.whatsApp",
      "position": [
        1260,
        760
      ],
      "webhookId": "a109a322-a4ac-4e54-818c-225e3b42a5cf",
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "2ce61e6d-bca9-4efd-8fd3-3a9e2ad9b590",
      "name": "Obtenir la première question",
      "type": "n8n-nodes-base.postgres",
      "position": [
        1480,
        760
      ],
      "parameters": {},
      "executeOnce": true,
      "typeVersion": 2.5
    },
    {
      "id": "d8747f70-ab23-49ee-87ec-798786711bd9",
      "name": "Mettre à jour l'état du bot sur ANKETA",
      "type": "n8n-nodes-base.postgres",
      "position": [
        1920,
        760
      ],
      "parameters": {},
      "typeVersion": 2.5
    },
    {
      "id": "d88b9f5d-7529-4a20-89a5-4007f30b9535",
      "name": "Note adhésive",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1860,
        720
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "f57e0e75-49e9-42ff-965d-b5cb6084ebee",
      "name": "Définir le flux",
      "type": "n8n-nodes-base.switch",
      "position": [
        700,
        760
      ],
      "parameters": {},
      "typeVersion": 3.2
    },
    {
      "id": "0fc45a08-2719-43fb-8999-637b68d29ce0",
      "name": "Mettre à jour l'état du bot sur START",
      "type": "n8n-nodes-base.postgres",
      "position": [
        2340,
        1180
      ],
      "parameters": {},
      "typeVersion": 2.5
    },
    {
      "id": "786e1ad6-5bb8-4ac5-a923-fafadabcc499",
      "name": "Obtenir les questions disponibles",
      "type": "n8n-nodes-base.postgres",
      "position": [
        1700,
        980
      ],
      "parameters": {},
      "typeVersion": 2.5,
      "alwaysOutputData": true
    },
    {
      "id": "5ebe7749-4f5f-44ec-b041-16a9a62e93cd",
      "name": "Des questions sont-elles disponibles ?",
      "type": "n8n-nodes-base.if",
      "position": [
        1920,
        980
      ],
      "parameters": {},
      "executeOnce": true,
      "typeVersion": 2.2
    },
    {
      "id": "b65f351d-78b5-46da-bd73-93d0ceb2a919",
      "name": "La question est-elle trouvée ?",
      "type": "n8n-nodes-base.if",
      "position": [
        1480,
        980
      ],
      "parameters": {},
      "typeVersion": 2.2
    },
    {
      "id": "2cccfa58-1492-4420-ab5b-42f16ac53e96",
      "name": "Première question",
      "type": "n8n-nodes-base.whatsApp",
      "position": [
        1700,
        760
      ],
      "webhookId": "3778ab5f-6e1e-45a2-97ae-f55ae13b0e9d",
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "feacdb2b-de64-4784-85e8-a12b35992384",
      "name": "Question",
      "type": "n8n-nodes-base.whatsApp",
      "position": [
        2140,
        980
      ],
      "webhookId": "c484c9c1-cf45-4a55-80a6-c9765ef650f8",
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "df3eb202-da56-4c03-b4c4-61b557d786eb",
      "name": "Ajouter la réponse précédente",
      "type": "n8n-nodes-base.postgres",
      "position": [
        2340,
        980
      ],
      "parameters": {},
      "typeVersion": 2.5
    },
    {
      "id": "a6818f00-dd39-4cbd-8f0a-018a80ef6064",
      "name": "Ajouter la réponse",
      "type": "n8n-nodes-base.postgres",
      "position": [
        1700,
        1180
      ],
      "parameters": {},
      "typeVersion": 2.5
    },
    {
      "id": "104a660d-5032-413f-a72f-62ae74e9d12f",
      "name": "Terminer l'Anketa",
      "type": "n8n-nodes-base.whatsApp",
      "position": [
        2140,
        1180
      ],
      "webhookId": "318e5835-f23a-4435-bc10-883c75fcf37f",
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "11b6580c-f083-45c6-8524-424c2ceef63b",
      "name": "Obtenir la réponse précédente",
      "type": "n8n-nodes-base.postgres",
      "position": [
        1260,
        980
      ],
      "parameters": {},
      "typeVersion": 2.5,
      "alwaysOutputData": true
    },
    {
      "id": "bfb2e3bd-7663-449d-8e61-b6125935aa3b",
      "name": "Note adhésive1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1180,
        720
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "5d5d103e-9365-4f62-9efe-8199ed8f5ce5",
      "name": "Note adhésive2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1180,
        960
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "199c0247-ecbd-4693-9572-1e70da007b44",
      "name": "Upsert l'état du bot sur START",
      "type": "n8n-nodes-base.postgres",
      "position": [
        700,
        560
      ],
      "parameters": {},
      "typeVersion": 2.5
    },
    {
      "id": "a164b652-b8cc-4edf-a552-293d613deb2e",
      "name": "Ajouter la réponse précédente",
      "type": "n8n-nodes-base.postgres",
      "position": [
        2140,
        760
      ],
      "parameters": {},
      "typeVersion": 2.5
    },
    {
      "id": "60a9c88a-c156-4b3f-abfd-f2f30b492058",
      "name": "Note adhésive7",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -400,
        760
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "1c5c37c4-89e8-4ed4-9013-0a9c3c1748d1",
      "name": "Note adhésive8",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -400,
        520
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "70f96a8e-c191-4f0e-9073-1f9bb1e8ef36",
      "name": "Note adhésive9",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        40,
        1080
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "d4f4e891-0c3b-425f-9dab-c83396cf4e27",
      "name": "Note adhésive10",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -400,
        1080
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "679715b4-677a-42c4-93ae-aba55a6cdc49",
      "name": "Note adhésive11",
      "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
          }
        ]
      ]
    }
  }
}
Foire aux questions

Comment utiliser ce workflow ?

Copiez le code de configuration JSON ci-dessus, créez un nouveau workflow dans votre instance n8n et sélectionnez "Importer depuis le JSON", collez la configuration et modifiez les paramètres d'authentification selon vos besoins.

Dans quelles scénarios ce workflow est-il adapté ?

Avancé - Ventes, Blocs de construction, Marketing

Est-ce payant ?

Ce workflow est entièrement gratuit et peut être utilisé directement. Veuillez noter que les services tiers utilisés dans le workflow (comme l'API OpenAI) peuvent nécessiter un paiement de votre part.

Informations sur le workflow
Niveau de difficulté
Avancé
Nombre de nœuds32
Catégorie3
Types de nœuds7
Description de la difficulté

Adapté aux utilisateurs avancés, avec des workflows complexes contenant 16+ nœuds

Auteur
Liens externes
Voir sur n8n.io

Partager ce workflow

Catégories

Catégories: 34