8
n8n Deutschamn8n.com

LENOHA-Kundensupport

Experte

Dies ist ein Automatisierungsworkflow mit 20 Nodes. Hauptsächlich werden If, Set, Merge, GoogleSheets, ManualTrigger und andere Nodes verwendet. Ein zweigleisiges Kunden-Support-System mit Google Sheets, Vektoren und Gemini LLM erstellen

Voraussetzungen
  • •Google Sheets API-Anmeldedaten

Verwendete Nodes (20)

If
Set
Merge
StickyNote
GoogleSheets
ManualTrigger
Chat
ChatTrigger
GoogleGemini
VectorStoreInMemory
DocumentDefaultDataLoader
EmbeddingsHuggingFaceInference

Kategorie

-
Workflow-Vorschau
Visualisierung der Node-Verbindungen, mit Zoom und Pan
React Flow
Workflow exportieren
Kopieren Sie die folgende JSON-Konfiguration und importieren Sie sie in n8n
{
  "id": "FqCqWFe2l39CkWJJ",
  "meta": {
    "instanceId": "1587aac4fefe327cb562f0b60579d4f70119b083ab9ab93deb05f9d7431f8788",
    "templateCredsSetupCompleted": true
  },
  "name": "LENOHA-Customer-Support",
  "tags": [],
  "nodes": [
    {
      "id": "a1572a1d-1d1f-4abc-8f1d-364e58381368",
      "name": "Bei Klick auf 'Workflow ausführen'",
      "type": "n8n-nodes-base.manualTrigger",
      "position": [
        -64,
        -432
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "31098d41-56e5-4859-8218-41b79b6878c1",
      "name": "Embeddings HuggingFace Inference",
      "type": "@n8n/n8n-nodes-langchain.embeddingsHuggingFaceInference",
      "position": [
        480,
        -208
      ],
      "parameters": {
        "options": {}
      },
      "credentials": {
        "huggingFaceApi": {
          "id": "pTwemQjQAyHf8rnL",
          "name": "HuggingFaceApi account"
        }
      },
      "typeVersion": 1
    },
    {
      "id": "41ff1a9f-9b1a-4ae4-a93b-f55c63ad430b",
      "name": "Standard-Datenlader",
      "type": "@n8n/n8n-nodes-langchain.documentDefaultDataLoader",
      "position": [
        688,
        -208
      ],
      "parameters": {
        "options": {}
      },
      "typeVersion": 1.1
    },
    {
      "id": "d22d074b-35f8-4a65-9b2d-1e9d697076f5",
      "name": "Bei Empfang einer Chat-Nachricht",
      "type": "@n8n/n8n-nodes-langchain.chatTrigger",
      "position": [
        -128,
        496
      ],
      "webhookId": "fb5ca44e-a73c-44dd-834b-2df1ca9b49d6",
      "parameters": {
        "options": {
          "responseMode": "responseNodes"
        }
      },
      "typeVersion": 1.3
    },
    {
      "id": "8209ba33-0036-45e7-993b-d3a1ee26c4db",
      "name": "Auf Chat antworten",
      "type": "@n8n/n8n-nodes-langchain.chat",
      "position": [
        1104,
        192
      ],
      "parameters": {
        "message": "={{ $json.Answer }}",
        "options": {}
      },
      "typeVersion": 1
    },
    {
      "id": "9142cb58-be78-476c-a545-83f6f75c1986",
      "name": "Kurznotiz1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -128,
        -560
      ],
      "parameters": {
        "width": 1104,
        "height": 512,
        "content": "## 0. Create Embeddings\n- Get common questions from your own knowledge base\n- Use persistent vector store for embeddings"
      },
      "typeVersion": 1
    },
    {
      "id": "c36b56dc-375f-417f-ae07-38433f800cca",
      "name": "Kurznotiz3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -256,
        384
      ],
      "parameters": {
        "color": 2,
        "width": 368,
        "height": 272,
        "content": "## 1. Receive a user message"
      },
      "typeVersion": 1
    },
    {
      "id": "5f7477ea-3529-427e-a565-8653e4ba5210",
      "name": "Kurznotiz",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        272,
        32
      ],
      "parameters": {
        "color": 3,
        "width": 528,
        "height": 480,
        "content": "## 2. Evaluate user message\n- Generate embeddings for the user message\n- Check against your vector store for relevant questions\n- IMPORTANT: You need to fine-tune your similarity score threshold within the If/Else-Node"
      },
      "typeVersion": 1
    },
    {
      "id": "b5a86a31-cc26-43ec-bebc-18c3e6077777",
      "name": "Kurznotiz2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        832,
        32
      ],
      "parameters": {
        "color": 4,
        "width": 512,
        "height": 352,
        "content": "## 3.1 Reply from FAQ\n- If the user query is similar to a question from your knowledge base, the pre-defined, static answer is returned"
      },
      "typeVersion": 1
    },
    {
      "id": "361a09fd-2384-478b-b05e-3dc07fcc6c40",
      "name": "Kurznotiz4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        816,
        432
      ],
      "parameters": {
        "color": 4,
        "width": 784,
        "height": 368,
        "content": "## 3.2 Reply via LLM\n- If the user query is not found within the knowledge base, a smaller LLM can answer"
      },
      "typeVersion": 1
    },
    {
      "id": "ea069bda-92ef-441b-ab7c-79aa85602d0a",
      "name": "Embeddings HuggingFace Inference2",
      "type": "@n8n/n8n-nodes-langchain.embeddingsHuggingFaceInference",
      "position": [
        432,
        368
      ],
      "parameters": {
        "options": {}
      },
      "credentials": {
        "huggingFaceApi": {
          "id": "pTwemQjQAyHf8rnL",
          "name": "HuggingFaceApi account"
        }
      },
      "typeVersion": 1
    },
    {
      "id": "f04bce14-f24f-4ef2-968a-5d9c529ee9de",
      "name": "Auf Chat antworten1",
      "type": "@n8n/n8n-nodes-langchain.chat",
      "position": [
        1392,
        544
      ],
      "parameters": {
        "message": "={{ $json.content.parts[0].text }}",
        "options": {}
      },
      "typeVersion": 1
    },
    {
      "id": "4a302856-38e1-413f-8810-d140a99a0187",
      "name": "Wissensdatenbank",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        144,
        -432
      ],
      "parameters": {
        "options": {
          "returnFirstMatch": false
        },
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": 1748220104,
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1tSEu_-7KAupdkFJGzoPBc-zqBBAmPgGoc89JyvqhY90/edit#gid=1748220104",
          "cachedResultName": "Tabellenblatt2"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "1tSEu_-7KAupdkFJGzoPBc-zqBBAmPgGoc89JyvqhY90",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1tSEu_-7KAupdkFJGzoPBc-zqBBAmPgGoc89JyvqhY90/edit?usp=drivesdk",
          "cachedResultName": "Stripe_Dummy_FAQ"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "DOSJUMfKHxvCgJTm",
          "name": "Google Sheets account"
        }
      },
      "typeVersion": 4.7,
      "alwaysOutputData": false
    },
    {
      "id": "d9c346d2-4b07-460d-8154-1a0749e4d921",
      "name": "Fragen extrahieren",
      "type": "n8n-nodes-base.set",
      "position": [
        352,
        -432
      ],
      "parameters": {
        "options": {},
        "assignments": {
          "assignments": [
            {
              "id": "48e49d98-11b7-478a-91fb-ecf198fdd9e7",
              "name": "row_number",
              "type": "number",
              "value": "={{ $json.row_number }}"
            },
            {
              "id": "9b40b5a1-a73b-4af3-a96c-bc52226cc4bc",
              "name": "Question",
              "type": "string",
              "value": "={{ $json.Question }}"
            }
          ]
        }
      },
      "typeVersion": 3.4
    },
    {
      "id": "dc2510c2-0cc2-436c-92eb-854aae56efd8",
      "name": "Embeddings generieren & speichern",
      "type": "@n8n/n8n-nodes-langchain.vectorStoreInMemory",
      "position": [
        560,
        -432
      ],
      "parameters": {
        "mode": "insert",
        "memoryKey": {
          "__rl": true,
          "mode": "list",
          "value": "vector_store_key"
        },
        "embeddingBatchSize": 1
      },
      "typeVersion": 1.3
    },
    {
      "id": "672b7a01-d236-412b-acef-09b1e7674ae9",
      "name": "Embeddings abrufen & bewerten",
      "type": "@n8n/n8n-nodes-langchain.vectorStoreInMemory",
      "position": [
        336,
        208
      ],
      "parameters": {
        "mode": "load",
        "topK": 2,
        "prompt": "={{ $json.chatInput }}",
        "memoryKey": {
          "__rl": true,
          "mode": "list",
          "value": "vector_store_key"
        }
      },
      "typeVersion": 1.2
    },
    {
      "id": "b5d2db8d-b14c-4162-8fd1-c3163efd2b72",
      "name": "Fragentyp bestimmen",
      "type": "n8n-nodes-base.if",
      "position": [
        624,
        208
      ],
      "parameters": {
        "options": {},
        "conditions": {
          "options": {
            "version": 2,
            "leftValue": "",
            "caseSensitive": true,
            "typeValidation": "strict"
          },
          "combinator": "and",
          "conditions": [
            {
              "id": "f6f2c4ab-cebf-4dea-baec-5ec3e50e88ab",
              "operator": {
                "type": "number",
                "operation": "gte"
              },
              "leftValue": "={{ $json.score }}",
              "rightValue": 0.8
            }
          ]
        }
      },
      "typeVersion": 2.2
    },
    {
      "id": "d182bbc1-1822-424f-8c05-b3503b53b6c1",
      "name": "Entsprechende Antworten abrufen",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        880,
        192
      ],
      "parameters": {
        "options": {},
        "filtersUI": {
          "values": [
            {
              "lookupValue": "={{ $json.document.pageContent }}",
              "lookupColumn": "Question"
            }
          ]
        },
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": 1748220104,
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1tSEu_-7KAupdkFJGzoPBc-zqBBAmPgGoc89JyvqhY90/edit#gid=1748220104",
          "cachedResultName": "Tabellenblatt2"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "1tSEu_-7KAupdkFJGzoPBc-zqBBAmPgGoc89JyvqhY90",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1tSEu_-7KAupdkFJGzoPBc-zqBBAmPgGoc89JyvqhY90/edit?usp=drivesdk",
          "cachedResultName": "Stripe_Dummy_FAQ"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "DOSJUMfKHxvCgJTm",
          "name": "Google Sheets account"
        }
      },
      "typeVersion": 4.7
    },
    {
      "id": "2f3bf992-7f08-40f4-86ab-16242abc79d5",
      "name": "Chat-Nachricht weiterleiten",
      "type": "n8n-nodes-base.merge",
      "position": [
        880,
        544
      ],
      "parameters": {
        "mode": "chooseBranch",
        "useDataOfInput": 2
      },
      "typeVersion": 3.2
    },
    {
      "id": "69646d36-32f5-4f04-bf15-4463398d969d",
      "name": "Chat-Modell",
      "type": "@n8n/n8n-nodes-langchain.googleGemini",
      "position": [
        1072,
        544
      ],
      "parameters": {
        "modelId": {
          "__rl": true,
          "mode": "list",
          "value": "models/gemini-2.5-flash-lite",
          "cachedResultName": "models/gemini-2.5-flash-lite"
        },
        "options": {
          "systemMessage": "# Role:\nYou are a conversational AI assistant. Your primary function is to handle casual conversation and general inquiries that do not pertain to specific company policies or user account details.\n\n# Task:\nEngage the user in a friendly, helpful, and brief manner. You are the fallback agent for queries that could not be answered by our primary FAQ knowledge base.\n\n# CRITICAL RULES:\nScope Limitation: You MUST NOT attempt to answer any specific questions related to policies, pricing, fees, disputes, payout schedules, security, or personal account information. Your knowledge base does not contain this information.\nNo Speculation: If you are unsure about a user's query, NEVER guess the answer. It is safer to state your limitation.\nBrevity: Keep your responses concise and to the point (1-2 sentences).\n\n# Response Strategy & Disclaimer:\nIf a user's question seems to be asking for specific details, even if it appears simple, you must use the following disclaimer. Do not attempt to answer the question first.\n\n# Disclaimer: \"I am not equipped to handle specific policy or account-level questions to ensure your information is kept safe and accurate. For detailed assistance, I recommend checking our official Help Center or contacting a human support agent.\""
        },
        "messages": {
          "values": [
            {
              "content": "={{ $json.chatInput }}"
            }
          ]
        }
      },
      "credentials": {
        "googlePalmApi": {
          "id": "GcENObs5mnIvIGOc",
          "name": "Google Gemini(PaLM) Api account"
        }
      },
      "typeVersion": 1
    }
  ],
  "active": false,
  "pinData": {},
  "settings": {
    "executionOrder": "v1"
  },
  "versionId": "650ce0df-104b-417a-903d-160f095dc823",
  "connections": {
    "69646d36-32f5-4f04-bf15-4463398d969d": {
      "main": [
        [
          {
            "node": "f04bce14-f24f-4ef2-968a-5d9c529ee9de",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "d9c346d2-4b07-460d-8154-1a0749e4d921": {
      "main": [
        [
          {
            "node": "dc2510c2-0cc2-436c-92eb-854aae56efd8",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "4a302856-38e1-413f-8810-d140a99a0187": {
      "main": [
        [
          {
            "node": "d9c346d2-4b07-460d-8154-1a0749e4d921",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "41ff1a9f-9b1a-4ae4-a93b-f55c63ad430b": {
      "ai_document": [
        [
          {
            "node": "dc2510c2-0cc2-436c-92eb-854aae56efd8",
            "type": "ai_document",
            "index": 0
          }
        ]
      ]
    },
    "2f3bf992-7f08-40f4-86ab-16242abc79d5": {
      "main": [
        [
          {
            "node": "69646d36-32f5-4f04-bf15-4463398d969d",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "d182bbc1-1822-424f-8c05-b3503b53b6c1": {
      "main": [
        [
          {
            "node": "8209ba33-0036-45e7-993b-d3a1ee26c4db",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "b5d2db8d-b14c-4162-8fd1-c3163efd2b72": {
      "main": [
        [
          {
            "node": "d182bbc1-1822-424f-8c05-b3503b53b6c1",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "2f3bf992-7f08-40f4-86ab-16242abc79d5",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "d22d074b-35f8-4a65-9b2d-1e9d697076f5": {
      "main": [
        [
          {
            "node": "672b7a01-d236-412b-acef-09b1e7674ae9",
            "type": "main",
            "index": 0
          },
          {
            "node": "2f3bf992-7f08-40f4-86ab-16242abc79d5",
            "type": "main",
            "index": 1
          }
        ]
      ]
    },
    "dc2510c2-0cc2-436c-92eb-854aae56efd8": {
      "main": [
        []
      ]
    },
    "672b7a01-d236-412b-acef-09b1e7674ae9": {
      "main": [
        [
          {
            "node": "b5d2db8d-b14c-4162-8fd1-c3163efd2b72",
            "type": "main",
            "index": 0
          }
        ]
      ],
      "ai_tool": [
        []
      ]
    },
    "31098d41-56e5-4859-8218-41b79b6878c1": {
      "ai_embedding": [
        [
          {
            "node": "dc2510c2-0cc2-436c-92eb-854aae56efd8",
            "type": "ai_embedding",
            "index": 0
          }
        ]
      ]
    },
    "ea069bda-92ef-441b-ab7c-79aa85602d0a": {
      "ai_embedding": [
        [
          {
            "node": "672b7a01-d236-412b-acef-09b1e7674ae9",
            "type": "ai_embedding",
            "index": 0
          }
        ]
      ]
    },
    "a1572a1d-1d1f-4abc-8f1d-364e58381368": {
      "main": [
        [
          {
            "node": "4a302856-38e1-413f-8810-d140a99a0187",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}
Häufig gestellte Fragen

Wie verwende ich diesen Workflow?

Kopieren Sie den obigen JSON-Code, erstellen Sie einen neuen Workflow in Ihrer n8n-Instanz und wählen Sie "Aus JSON importieren". Fügen Sie die Konfiguration ein und passen Sie die Anmeldedaten nach Bedarf an.

Für welche Szenarien ist dieser Workflow geeignet?

Experte

Ist es kostenpflichtig?

Dieser Workflow ist völlig kostenlos. Beachten Sie jedoch, dass Drittanbieterdienste (wie OpenAI API), die im Workflow verwendet werden, möglicherweise kostenpflichtig sind.

Verwandte Workflows

n8n-Knoten in der visuellen Referenzbibliothek erkunden
Erkundung von n8n-Knoten in der visuellen Referenzbibliothek
If
Ftp
Set
+
If
Ftp
Set
113 NodesI versus AI
Sonstiges
KI-Assistent: Konversation mit Supabase-Speicher und Google Drive-Dateien
KI-Smart-Assistent: Konversation mit Dateien in Supabase Storage und Google Drive
If
Set
Wait
+
If
Set
Wait
62 NodesMark Shcherbakov
Engineering
AI-Powered MIS Agent
If
Set
Code
+
If
Set
Code
129 NodesKumar Shivam
Support
Beispiel für Bewertungsmetriken: RAG-Dokumentenrelevanz
Beispiel für Bewertungsmetriken: RAG-Dokumentenrelevanz
Set
Evaluation
Google Sheets
+
Set
Evaluation
Google Sheets
26 NodesDavid Roberts
Engineering
KI-Produktfotos mit Gemini Nano Banana über JotForm und Google Sheets generieren
KI-Produktfotos aus JotForm und Google Sheets mit Gemini Nano Banana generieren
If
Set
Merge
+
If
Set
Merge
24 NodesZain Khan
🤖 KI-angetriebener RAG-Chatbot für Ihre Dokumente + Google Drive + Gemini + Qdrant
🤖 KI-angetriebener RAG-Chatbot für Ihre Dokumente + Google Drive + Gemini + Qdrant
If
Set
Wait
+
If
Set
Wait
50 NodesJoseph LePage
Künstliche Intelligenz
Workflow-Informationen
Schwierigkeitsgrad
Experte
Anzahl der Nodes20
Kategorie-
Node-Typen12
Schwierigkeitsbeschreibung

Für fortgeschrittene Benutzer, komplexe Workflows mit 16+ Nodes

Autor
Maxim Osipovs

Maxim Osipovs

@maximosipovs
Externe Links
Auf n8n.io ansehen →

Diesen Workflow teilen

Kategorien

Multimodales KI
1540
Künstliche Intelligenz
1108
Content-Erstellung
695
KI-Zusammenfassung
516
Marketing
419
KI-Chatbot
251
Engineering
241
Marktforschung
203
Verschiedenes
193
Sonstiges
176
Vertrieb
162
IT-Betrieb
156
Dokumentenextraktion
147
KI RAG
146
Bausteine
144
Soziale Medien
137
Lead-Generierung
125
Persönliche Produktivität
117
DevOps
111
Personalwesen
101
Support
97
Lead-Pflege
87
Kundenbeziehungsmanagement
82
Finanzen
81
Produkt
77
Support-Chatbot
76
Design
70
Ticketverwaltung
67
Sicherheitsbetrieb
57
Rechnungsverarbeitung
53
Krypto-Handel
49
Dateiverwaltung
39
Projektmanagement
35
Internes Wiki
32

Kategorien: 34