Automatisation Intelligente des Formulaires de Contact eCommerce

Optimisez votre gestion de formulaires de contact avec ce workflow automatisé et intelligent. En utilisant n8n, ce système classe automatiquement les messages reçus via un formulaire en ligne et les redirige vers le bon département pour traitement rapide. Grâce à l'intégration d'un classificateur de texte et à l'envoi d'emails automatisés, réduisez le temps de réponse et améliorez la satisfaction client. De plus, toutes les données sont stockées dans Google Sheets pour un suivi facile et une analyse approfondie.

21,078 vues
9,379 copies
Automatisation

Documentation Complète

📋 Automatisation Intelligente des Formulaires de Contact eCommerce

💡 Description

Optimisez votre gestion de formulaires de contact avec ce workflow automatisé et intelligent. En utilisant n8n, ce système classe automatiquement les messages reçus via un formulaire en ligne et les redirige vers le bon département pour traitement rapide. Grâce à l'intégration d'un classificateur de texte et à l'envoi d'emails automatisés, réduisez le temps de réponse et améliorez la satisfaction client. De plus, toutes les données sont stockées dans Google Sheets pour un suivi facile et une analyse approfondie.

📈 Impact & ROI: Réduction significative du temps de traitement des demandes clients, augmentant ainsi la satisfaction et potentiellement les ventes.

🚀 Fonctionnalités Clés

  • ✅ Classification automatique des messages - Gain de précision
  • ✅ Envoi d'emails ciblés - Amélioration du service client
  • ✅ Stockage centralisé dans Google Sheets - Facilite le suivi
  • ✅ Intégration fluide avec OpenAI - Amélioration continue

📊 Architecture Technique

14
Nodes
8
Connexions
5
Services

🔌 Services Intégrés

n8n-nodes-base.formTrigger@n8n/n8n-nodes-langchain.textClassifier@n8n/n8n-nodes-langchain.lmChatOpenAin8n-nodes-base.emailSendn8n-nodes-base.googleSheets

🔧 Composition du Workflow

NodeTypeDescription
On form submissionformTriggerTraitement des données
Text Classifier@n8n/n8n-nodes-langchain.textClassifierCondition logique pour router le flux
OpenAI@n8n/n8n-nodes-langchain.lmChatOpenAiTraitement des données
Prod. Dep.emailSendTraitement des données
Quote Dep.emailSendTraitement des données
Gen. Dep.emailSendTraitement des données
Order Dep.emailSendTraitement des données
Other Dep.emailSendTraitement des données
Quote DBgoogleSheetsTraitement des données
Prod DBgoogleSheetsTraitement des données
General DBgoogleSheetsTraitement des données
Order DBgoogleSheetsTraitement des données
Other DBgoogleSheetsTraitement des données
Sticky NotestickyNoteTraitement des données

📖 Guide d'Implémentation

  1. Import du workflow: Téléchargez le fichier JSON et importez-le dans votre instance n8n
  2. Configuration des credentials: Configurez les accès pour chaque service utilisé
  3. Personnalisation: Adaptez les paramètres selon vos besoins spécifiques
  4. Test: Exécutez le workflow en mode test pour vérifier le bon fonctionnement
  5. Activation: Activez le workflow pour une exécution automatique

🏷️ Tags

eCommerceautomatisationformulaireclassement

Structure JSON

Voir le code JSON complet
{
    "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
                    }
                ]
            ]
        }
    }
}
                                

Workflows Similaires

Automatisez le Résumé de Vos Emails avec A.I. et Messagerie

Ce workflow n8n vous permet d'automatiser la gestion de vos emails en utilisant l'intelligence artificielle pour résume...

Automatisation de gestion des réunions Zoom et communication

Ce workflow est conçu pour automatiser le processus de planification et de gestion des réunions Zoom tout en assurant ...

Automatisez vos Tweets d'images humoristiques à 17h

Ce workflow n8n est conçu pour les professionnels des réseaux sociaux cherchant à automatiser leur contenu humoristiq...