← Retour aux workflows
Workflow n8n

Automatisation eCommerce avec n8n : classification de formulaires

Ce workflow n8n a pour objectif d'automatiser la classification des textes soumis via un formulaire dans le cadre d'une activité eCommerce. En utilisant des outils avancés comme OpenAI et Google Sheets, ce processus permet de gérer efficacement les réponses des clients tout en optimisant le traitement des données. Les cas d'usage incluent la catégorisation des demandes clients, l'envoi d'emails aux départements concernés et la mise à jour des bases de données.

  • Étape 1 : Le workflow est déclenché par la soumission d'un formulaire, grâce au nœud 'On form submission'.
  • Étape 2 : Le texte soumis est ensuite analysé par le nœud 'Text Classifier', qui utilise des modèles d'IA pour déterminer la catégorie appropriée.
  • Étape 3 : En fonction de la classification, plusieurs nœuds d'envoi d'emails (comme 'Prod. Dep.', 'Quote Dep.', etc.) sont activés pour notifier les départements concernés. Parallèlement, les informations sont enregistrées dans des Google Sheets via les nœuds 'Quote DB', 'Prod DB', et d'autres, permettant une gestion centralisée des données. Les bénéfices business incluent une réduction significative du temps de traitement des demandes, une meilleure réactivité aux besoins des clients et une amélioration de la satisfaction client. En intégrant cette automatisation n8n, les entreprises peuvent se concentrer sur des tâches à plus forte valeur ajoutée tout en assurant un suivi rigoureux des interactions clients.
Tags clés :automatisationeCommerceGoogle SheetsOpenAIworkflow n8n
🎯Pour qui ?🧩Problème résolu📋Étapes du flux🛠Guide de personnalisation
Catégorie: Webhook · Tags: automatisation, eCommerce, Google Sheets, OpenAI, workflow n8n❤ 0

Workflow n8n eCommerce, Google Sheets, OpenAI, workflow n8n : vue d'ensemble

Schéma des nœuds et connexions de ce workflow n8n, généré à partir du JSON n8n.

React Flow
Besoin d'aide ?

Workflow n8n eCommerce, Google Sheets, OpenAI, workflow n8n : détail des nœuds

  • On form submission

    Ce noeud déclenche le workflow lors de la soumission d'un formulaire.

  • Text Classifier

    Ce noeud classe le texte d'entrée en fonction des catégories définies.

  • OpenAI

    Ce noeud utilise le modèle OpenAI pour générer des réponses basées sur les options fournies.

  • Prod. Dep.

    Ce noeud envoie un email avec les détails de production spécifiés.

  • Quote Dep.

    Ce noeud envoie un email contenant un devis avec les informations fournies.

  • Gen. Dep.

    Ce noeud envoie un email avec des informations générales de dépôt.

  • Order Dep.

    Ce noeud envoie un email concernant une commande avec les détails appropriés.

  • Other Dep.

    Ce noeud envoie un email avec des informations sur d'autres dépôts.

  • Quote DB

    Ce noeud interagit avec Google Sheets pour gérer les devis dans la feuille spécifiée.

  • Prod DB

    Ce noeud interagit avec Google Sheets pour gérer les informations de production dans la feuille spécifiée.

  • General DB

    Ce noeud interagit avec Google Sheets pour gérer les données générales dans la feuille spécifiée.

  • Order DB

    Ce noeud interagit avec Google Sheets pour gérer les commandes dans la feuille spécifiée.

  • Other DB

    Ce noeud interagit avec Google Sheets pour gérer d'autres données dans la feuille spécifiée.

  • Sticky Note

    Ce noeud crée une note autocollante avec le contenu et les dimensions spécifiés.

Inscris-toi pour voir l'intégralité du workflow

Inscription gratuite

S'inscrire gratuitementBesoin d'aide ?
{
  "id": "LGpVLWPpNZSt9ISM",
  "meta": {
    "instanceId": "a4bfc93e975ca233ac45ed7c9227d84cf5a2329310525917adaf3312e10d5462",
    "templateCredsSetupCompleted": true
  },
  "name": "Contact Form Text Classifier for eCommerce",
  "tags": [],
  "nodes": [
    {
      "id": "13175d48-c3a6-4ca6-afed-b70f40289f38",
      "name": "On form submission",
      "type": "n8n-nodes-base.formTrigger",
      "position": [
        -480,
        -320
      ],
      "webhookId": "8e10c8ca-895c-4274-ba95-0d646b8bda4e",
      "parameters": {
        "options": {},
        "formTitle": "Contacts",
        "formFields": {
          "values": [
            {
              "fieldLabel": "Name",
              "placeholder": "Name",
              "requiredField": true
            },
            {
              "fieldLabel": "Email",
              "placeholder": "Email",
              "requiredField": true
            },
            {
              "fieldType": "textarea",
              "fieldLabel": "Message",
              "placeholder": "Message",
              "requiredField": true
            }
          ]
        },
        "responseMode": "lastNode",
        "formDescription": "Basic Contact Form"
      },
      "typeVersion": 2.2
    },
    {
      "id": "7b352c9f-5d2e-46ca-9499-594063167e9a",
      "name": "Text Classifier",
      "type": "@n8n/n8n-nodes-langchain.textClassifier",
      "position": [
        -160,
        -320
      ],
      "parameters": {
        "options": {
          "fallback": "other",
          "systemPromptTemplate": "=Please classify the text provided by the user into one of the following categories: {categories}, and use the provided formatting instructions below. Don't explain, and only output the json with the selected {categories}."
        },
        "inputText": "={{ $json.Message }}",
        "categories": {
          "categories": [
            {
              "category": "Request Quote",
              "description": "Request for quote"
            },
            {
              "category": "Product info",
              "description": "General information about a product"
            },
            {
              "category": "General problem",
              "description": "General problems about a product"
            },
            {
              "category": "Order",
              "description": "Information about an order placed"
            }
          ]
        }
      },
      "typeVersion": 1
    },
    {
      "id": "efef4c71-5f56-44b0-a613-9fa888e495b8",
      "name": "OpenAI",
      "type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
      "position": [
        -220,
        -100
      ],
      "parameters": {
        "model": {
          "__rl": true,
          "mode": "list",
          "value": "gpt-4o-mini",
          "cachedResultName": "gpt-4o-mini"
        },
        "options": {}
      },
      "credentials": {
        "openAiApi": {
          "id": "CDX6QM4gLYanh0P4",
          "name": "OpenAi account"
        }
      },
      "typeVersion": 1.2
    },
    {
      "id": "83f0d528-884c-4701-8fdd-dc07c05fafb5",
      "name": "Prod. Dep.",
      "type": "n8n-nodes-base.emailSend",
      "position": [
        320,
        -540
      ],
      "parameters": {
        "html": "=Name: {{ $json.Name }}\nEmail: {{ $json.Email }}\n\nMessage:\n{{ $json.Message }}\n\nTipo prodotto: {{ $json[\"tipo prodotto\"] }}",
        "options": {
          "replyTo": "={{ $json.Email }}"
        },
        "subject": "=[n8n Contacts] Product info",
        "toEmail": "to@domain.com",
        "fromEmail": "from@domain.com"
      },
      "credentials": {
        "smtp": {
          "id": "hRjP3XbDiIQqvi7x",
          "name": "SMTP info@n3witalia.com"
        }
      },
      "typeVersion": 2.1
    },
    {
      "id": "88486500-dcea-4db9-9ffd-f55193eaa83d",
      "name": "Quote Dep.",
      "type": "n8n-nodes-base.emailSend",
      "position": [
        320,
        -780
      ],
      "parameters": {
        "html": "=Name: {{ $json.Name }}\nEmail: {{ $json.Email }}\n\nMessage:\n{{ $json.Message }}\n\nTipo prodotto: {{ $json[\"tipo prodotto\"] }}",
        "options": {
          "replyTo": "={{ $json.Email }}"
        },
        "subject": "=[n8n Contacts] Quote",
        "toEmail": "to@domain.com",
        "fromEmail": "from@domain.com"
      },
      "credentials": {
        "smtp": {
          "id": "hRjP3XbDiIQqvi7x",
          "name": "SMTP info@n3witalia.com"
        }
      },
      "typeVersion": 2.1
    },
    {
      "id": "f6a63c4f-ee2e-42f1-a12c-b1fc6cf48f94",
      "name": "Gen. Dep.",
      "type": "n8n-nodes-base.emailSend",
      "position": [
        320,
        -320
      ],
      "parameters": {
        "html": "=Name: {{ $json.Name }}\nEmail: {{ $json.Email }}\n\nMessage:\n{{ $json.Message }}\n\nTipo prodotto: {{ $json[\"tipo prodotto\"] }}",
        "options": {
          "replyTo": "={{ $json.Email }}"
        },
        "subject": "=[n8n Contacts] General",
        "toEmail": "to@domain.com",
        "fromEmail": "from@domain.com"
      },
      "credentials": {
        "smtp": {
          "id": "hRjP3XbDiIQqvi7x",
          "name": "SMTP info@n3witalia.com"
        }
      },
      "typeVersion": 2.1
    },
    {
      "id": "04a3e144-af75-4a95-819f-d5f1d4591b67",
      "name": "Order Dep.",
      "type": "n8n-nodes-base.emailSend",
      "position": [
        320,
        -80
      ],
      "parameters": {
        "html": "=Name: {{ $json.Name }}\nEmail: {{ $json.Email }}\n\nMessage:\n{{ $json.Message }}\n\nTipo prodotto: {{ $json[\"tipo prodotto\"] }}",
        "options": {
          "replyTo": "={{ $json.Email }}"
        },
        "subject": "=[n8n Contacts] Order info",
        "toEmail": "to@domain.com",
        "fromEmail": "from@domain.com"
      },
      "credentials": {
        "smtp": {
          "id": "hRjP3XbDiIQqvi7x",
          "name": "SMTP info@n3witalia.com"
        }
      },
      "typeVersion": 2.1
    },
    {
      "id": "3767e3c7-b792-4b0d-a1f2-fc068310cb11",
      "name": "Other Dep.",
      "type": "n8n-nodes-base.emailSend",
      "position": [
        320,
        140
      ],
      "parameters": {
        "html": "=Name: {{ $json.Name }}\nEmail: {{ $json.Email }}\n\nMessage:\n{{ $json.Message }}\n\nTipo prodotto: {{ $json[\"tipo prodotto\"] }}",
        "options": {
          "replyTo": "={{ $json.Email }}"
        },
        "subject": "=[n8n Contacts] Other",
        "toEmail": "to@domain.com",
        "fromEmail": "from@domain.com"
      },
      "credentials": {
        "smtp": {
          "id": "hRjP3XbDiIQqvi7x",
          "name": "SMTP info@n3witalia.com"
        }
      },
      "typeVersion": 2.1
    },
    {
      "id": "c411a82d-0b86-49da-a11f-47ec79f9f7ff",
      "name": "Quote DB",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        520,
        -780
      ],
      "parameters": {
        "columns": {
          "value": {
            "TO": "={{ (JSON.stringify($json.envelope.to)) }}",
            "DATA": "={{ $('Text Classifier').item.json.submittedAt }}",
            "NOME": "={{ $('Text Classifier').item.json.Name }}",
            "EMAIL": "={{ $('Text Classifier').item.json.Email }}",
            "CATEGORIA": "info prodotti",
            "RICHIESTA": "={{ $('Text Classifier').item.json.Message }}"
          },
          "schema": [
            {
              "id": "DATA",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "DATA",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "NOME",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "NOME",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "EMAIL",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "EMAIL",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "RICHIESTA",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "RICHIESTA",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "CATEGORIA",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "CATEGORIA",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "TO",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "TO",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            }
          ],
          "mappingMode": "defineBelow",
          "matchingColumns": [],
          "attemptToConvertTypes": false,
          "convertFieldsToString": false
        },
        "options": {},
        "operation": "append",
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": "gid=0",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1D6tfsAK81ZE6VA0-sd_syuyI_rloNYjgWOhwgszPIZw/edit#gid=0",
          "cachedResultName": "Foglio1"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "1D6tfsAK81ZE6VA0-sd_syuyI_rloNYjgWOhwgszPIZw",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1D6tfsAK81ZE6VA0-sd_syuyI_rloNYjgWOhwgszPIZw/edit?usp=drivesdk",
          "cachedResultName": "Classified Contact Form"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "JYR6a64Qecd6t8Hb",
          "name": "Google Sheets account"
        }
      },
      "typeVersion": 4.5
    },
    {
      "id": "c14008fb-8932-44ad-88ef-42f6d4029fb1",
      "name": "Prod DB",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        520,
        -540
      ],
      "parameters": {
        "columns": {
          "value": {
            "TO": "={{ (JSON.stringify($json.envelope.to)) }}",
            "DATA": "={{ $('Text Classifier').item.json.submittedAt }}",
            "NOME": "={{ $('Text Classifier').item.json.Name }}",
            "EMAIL": "={{ $('Text Classifier').item.json.Email }}",
            "CATEGORIA": "info prodotti",
            "RICHIESTA": "={{ $('Text Classifier').item.json.Message }}"
          },
          "schema": [
            {
              "id": "DATA",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "DATA",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "NOME",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "NOME",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "EMAIL",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "EMAIL",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "RICHIESTA",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "RICHIESTA",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "CATEGORIA",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "CATEGORIA",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "TO",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "TO",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            }
          ],
          "mappingMode": "defineBelow",
          "matchingColumns": [],
          "attemptToConvertTypes": false,
          "convertFieldsToString": false
        },
        "options": {},
        "operation": "append",
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": "gid=0",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1D6tfsAK81ZE6VA0-sd_syuyI_rloNYjgWOhwgszPIZw/edit#gid=0",
          "cachedResultName": "Foglio1"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "1D6tfsAK81ZE6VA0-sd_syuyI_rloNYjgWOhwgszPIZw",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1D6tfsAK81ZE6VA0-sd_syuyI_rloNYjgWOhwgszPIZw/edit?usp=drivesdk",
          "cachedResultName": "Classified Contact Form"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "JYR6a64Qecd6t8Hb",
          "name": "Google Sheets account"
        }
      },
      "typeVersion": 4.5
    },
    {
      "id": "f2e02c07-7218-4d08-a816-1ce2de289312",
      "name": "General DB",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        520,
        -320
      ],
      "parameters": {
        "columns": {
          "value": {
            "TO": "={{ (JSON.stringify($json.envelope.to)) }}",
            "DATA": "={{ $('Text Classifier').item.json.submittedAt }}",
            "NOME": "={{ $('Text Classifier').item.json.Name }}",
            "EMAIL": "={{ $('Text Classifier').item.json.Email }}",
            "CATEGORIA": "info prodotti",
            "RICHIESTA": "={{ $('Text Classifier').item.json.Message }}"
          },
          "schema": [
            {
              "id": "DATA",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "DATA",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "NOME",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "NOME",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "EMAIL",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "EMAIL",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "RICHIESTA",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "RICHIESTA",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "CATEGORIA",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "CATEGORIA",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "TO",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "TO",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            }
          ],
          "mappingMode": "defineBelow",
          "matchingColumns": [],
          "attemptToConvertTypes": false,
          "convertFieldsToString": false
        },
        "options": {},
        "operation": "append",
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": "gid=0",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1D6tfsAK81ZE6VA0-sd_syuyI_rloNYjgWOhwgszPIZw/edit#gid=0",
          "cachedResultName": "Foglio1"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "1D6tfsAK81ZE6VA0-sd_syuyI_rloNYjgWOhwgszPIZw",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1D6tfsAK81ZE6VA0-sd_syuyI_rloNYjgWOhwgszPIZw/edit?usp=drivesdk",
          "cachedResultName": "Classified Contact Form"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "JYR6a64Qecd6t8Hb",
          "name": "Google Sheets account"
        }
      },
      "typeVersion": 4.5
    },
    {
      "id": "d6ee5c05-d966-47c1-a7ec-df721f77c5d0",
      "name": "Order DB",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        520,
        -80
      ],
      "parameters": {
        "columns": {
          "value": {
            "TO": "={{ (JSON.stringify($json.envelope.to)) }}",
            "DATA": "={{ $('Text Classifier').item.json.submittedAt }}",
            "NOME": "={{ $('Text Classifier').item.json.Name }}",
            "EMAIL": "={{ $('Text Classifier').item.json.Email }}",
            "CATEGORIA": "info prodotti",
            "RICHIESTA": "={{ $('Text Classifier').item.json.Message }}"
          },
          "schema": [
            {
              "id": "DATA",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "DATA",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "NOME",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "NOME",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "EMAIL",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "EMAIL",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "RICHIESTA",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "RICHIESTA",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "CATEGORIA",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "CATEGORIA",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "TO",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "TO",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            }
          ],
          "mappingMode": "defineBelow",
          "matchingColumns": [],
          "attemptToConvertTypes": false,
          "convertFieldsToString": false
        },
        "options": {},
        "operation": "append",
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": "gid=0",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1D6tfsAK81ZE6VA0-sd_syuyI_rloNYjgWOhwgszPIZw/edit#gid=0",
          "cachedResultName": "Foglio1"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "1D6tfsAK81ZE6VA0-sd_syuyI_rloNYjgWOhwgszPIZw",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1D6tfsAK81ZE6VA0-sd_syuyI_rloNYjgWOhwgszPIZw/edit?usp=drivesdk",
          "cachedResultName": "Classified Contact Form"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "JYR6a64Qecd6t8Hb",
          "name": "Google Sheets account"
        }
      },
      "typeVersion": 4.5
    },
    {
      "id": "b4f344bd-a5c4-4977-af96-edbab85b49d0",
      "name": "Other DB",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        520,
        140
      ],
      "parameters": {
        "columns": {
          "value": {
            "TO": "={{ (JSON.stringify($json.envelope.to)) }}",
            "DATA": "={{ $('Text Classifier').item.json.submittedAt }}",
            "NOME": "={{ $('Text Classifier').item.json.Name }}",
            "EMAIL": "={{ $('Text Classifier').item.json.Email }}",
            "CATEGORIA": "info prodotti",
            "RICHIESTA": "={{ $('Text Classifier').item.json.Message }}"
          },
          "schema": [
            {
              "id": "DATA",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "DATA",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "NOME",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "NOME",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "EMAIL",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "EMAIL",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "RICHIESTA",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "RICHIESTA",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "CATEGORIA",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "CATEGORIA",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "TO",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "TO",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            }
          ],
          "mappingMode": "defineBelow",
          "matchingColumns": [],
          "attemptToConvertTypes": false,
          "convertFieldsToString": false
        },
        "options": {},
        "operation": "append",
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": "gid=0",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1D6tfsAK81ZE6VA0-sd_syuyI_rloNYjgWOhwgszPIZw/edit#gid=0",
          "cachedResultName": "Foglio1"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "1D6tfsAK81ZE6VA0-sd_syuyI_rloNYjgWOhwgszPIZw",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1D6tfsAK81ZE6VA0-sd_syuyI_rloNYjgWOhwgszPIZw/edit?usp=drivesdk",
          "cachedResultName": "Classified Contact Form"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "JYR6a64Qecd6t8Hb",
          "name": "Google Sheets account"
        }
      },
      "typeVersion": 4.5
    },
    {
      "id": "99872f49-85c3-47a0-b0ea-10ebbdbb67f5",
      "name": "Sticky Note",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -480,
        -680
      ],
      "parameters": {
        "width": 580,
        "height": 280,
        "content": "## Important notes\n\nThis very simple workflow is ideal for eCommerce businesses or customer support teams looking to automate and streamline the handling of contact form submissions.\n\n- It is possible to hook any external form such as CF7 for Wordpress through a webhook\n- It is possible to send the email through other providers by replacing them with the relative nodes (Gmail, Outlook....)\n- It is possible to change the collection database with other tools"
      },
      "typeVersion": 1
    }
  ],
  "active": false,
  "pinData": {},
  "settings": {
    "executionOrder": "v1"
  },
  "versionId": "649d6a6a-a2a1-49f6-b63a-6def1a8831f1",
  "connections": {
    "OpenAI": {
      "ai_languageModel": [
        [
          {
            "node": "Text Classifier",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "Gen. Dep.": {
      "main": [
        [
          {
            "node": "General DB",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Order Dep.": {
      "main": [
        [
          {
            "node": "Order DB",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Other Dep.": {
      "main": [
        [
          {
            "node": "Other DB",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Prod. Dep.": {
      "main": [
        [
          {
            "node": "Prod DB",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Quote Dep.": {
      "main": [
        [
          {
            "node": "Quote DB",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Text Classifier": {
      "main": [
        [
          {
            "node": "Quote Dep.",
            "type": "main",
            "index": 0
          },
          {
            "node": "Prod. Dep.",
            "type": "main",
            "index": 0
          }
        ],
        [],
        [
          {
            "node": "Gen. Dep.",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Order Dep.",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Other Dep.",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "On form submission": {
      "main": [
        [
          {
            "node": "Text Classifier",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}

Workflow n8n eCommerce, Google Sheets, OpenAI, workflow n8n : pour qui est ce workflow ?

Ce workflow s'adresse aux entreprises eCommerce souhaitant optimiser la gestion de leurs formulaires clients. Il est idéal pour les équipes marketing, de support client et de gestion des données, quel que soit leur niveau technique. Les PME et les startups peuvent particulièrement bénéficier de cette automatisation pour améliorer leur efficacité opérationnelle.

Workflow n8n eCommerce, Google Sheets, OpenAI, workflow n8n : problème résolu

Ce workflow résout le problème de la gestion manuelle des demandes clients, qui peut être chronophage et sujet à des erreurs. En automatisant la classification des textes et l'envoi d'emails aux départements concernés, il réduit les risques de perte d'informations et améliore la réactivité. Les utilisateurs peuvent ainsi s'attendre à une gestion plus fluide des demandes, une réduction des délais de réponse et une meilleure satisfaction client.

Workflow n8n eCommerce, Google Sheets, OpenAI, workflow n8n : étapes du workflow

Étape 1 : Le workflow est déclenché par la soumission d'un formulaire.

  • Étape 1 : Le texte soumis est analysé par le nœud 'Text Classifier' pour déterminer sa catégorie.
  • Étape 2 : Selon la classification, les nœuds d'envoi d'emails sont activés pour notifier les départements concernés.
  • Étape 3 : Les données sont enregistrées dans les Google Sheets appropriés pour un suivi centralisé.

Workflow n8n eCommerce, Google Sheets, OpenAI, workflow n8n : guide de personnalisation

Pour personnaliser ce workflow, vous pouvez modifier les paramètres du nœud 'On form submission' pour adapter le formulaire à vos besoins spécifiques. Assurez-vous de configurer les catégories dans le nœud 'Text Classifier' selon vos critères d'analyse. Vous pouvez également ajuster les adresses email dans les nœuds d'envoi pour notifier les bonnes personnes. Enfin, adaptez les noms et colonnes des Google Sheets pour qu'ils correspondent à votre structure de données.