KI-basierter WhatsApp-Support-Bot (Google Sheets-Ticket-Erstellung)

Experte

Dies ist ein Support Chatbot, Multimodal AI-Bereich Automatisierungsworkflow mit 35 Nodes. Hauptsächlich werden Set, Xml, Code, Html, Wait und andere Nodes verwendet. KI-basierter WhatsApp-Support-Bot (Google Sheets-Ticket-Erstellung)

Voraussetzungen
  • Google-Konto + Gmail API-Anmeldedaten
  • Möglicherweise sind Ziel-API-Anmeldedaten erforderlich
  • Google Sheets API-Anmeldedaten
  • OpenAI API Key
  • Pinecone API Key
Workflow-Vorschau
Visualisierung der Node-Verbindungen, mit Zoom und Pan
Workflow exportieren
Kopieren Sie die folgende JSON-Konfiguration und importieren Sie sie in n8n
{
  "nodes": [
    {
      "id": "c5b15d1f-3f07-4075-83d6-e9b393a20a16",
      "name": "Wenn Chat-Nachricht empfangen",
      "type": "@n8n/n8n-nodes-langchain.chatTrigger",
      "position": [
        1344,
        720
      ],
      "webhookId": "5365fa15-96ef-4437-90f5-8faeb595b03a",
      "parameters": {},
      "typeVersion": 1.1
    },
    {
      "id": "91546766-7a95-4b59-8d13-e4b970b28e88",
      "name": "KI-Agent",
      "type": "@n8n/n8n-nodes-langchain.agent",
      "position": [
        1776,
        720
      ],
      "parameters": {},
      "typeVersion": 2.1
    },
    {
      "id": "b4a7917b-a9e6-4076-9aad-efe7cc4d72c5",
      "name": "Bei Formularübermittlung",
      "type": "n8n-nodes-base.formTrigger",
      "position": [
        1104,
        -368
      ],
      "webhookId": "8e81bc08-6fc8-4a47-8e45-63fe28046b5b",
      "parameters": {},
      "typeVersion": 2.2
    },
    {
      "id": "f8d14cc9-8eb6-4fc6-9ffc-9c916738b09d",
      "name": "XML",
      "type": "n8n-nodes-base.xml",
      "position": [
        1856,
        -368
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "a0af59c0-9c5a-4e4a-8654-fd4546224646",
      "name": "HTTP Request",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        1696,
        -368
      ],
      "parameters": {},
      "typeVersion": 4.2
    },
    {
      "id": "5ebd8d66-9d86-400e-b601-7fa2e0eb40c0",
      "name": "Code",
      "type": "n8n-nodes-base.code",
      "position": [
        2000,
        -368
      ],
      "parameters": {},
      "typeVersion": 2
    },
    {
      "id": "7dd826d4-a44e-4cf0-b85f-d23410d6a84d",
      "name": "HTML-Seite abrufen",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        2736,
        -432
      ],
      "parameters": {},
      "typeVersion": 4.2
    },
    {
      "id": "ed14bf13-5e46-4465-b93b-0cf8b1cbcc16",
      "name": "HTML",
      "type": "n8n-nodes-base.html",
      "position": [
        2736,
        -624
      ],
      "parameters": {},
      "typeVersion": 1.2
    },
    {
      "id": "add88ee7-7e17-4c34-a539-7b727e57c3a9",
      "name": "Über Seiten iterieren",
      "type": "n8n-nodes-base.splitInBatches",
      "position": [
        2544,
        -528
      ],
      "parameters": {},
      "typeVersion": 3
    },
    {
      "id": "ef4fcd5d-5fa5-4d75-af9c-58c4f559d7a3",
      "name": "Warten",
      "type": "n8n-nodes-base.wait",
      "position": [
        2896,
        -432
      ],
      "webhookId": "9d87e60f-9df8-4a13-9c22-e3e5a5bb9c0e",
      "parameters": {},
      "typeVersion": 1.1
    },
    {
      "id": "fd7d2d87-8f73-4ce8-8788-b7ee3c983a83",
      "name": "Seiten-URLs aufteilen",
      "type": "n8n-nodes-base.code",
      "position": [
        1696,
        -544
      ],
      "parameters": {},
      "typeVersion": 2
    },
    {
      "id": "81444721-dcc0-41dc-91f0-5c71f04e3033",
      "name": "Pinecone Vector Store",
      "type": "@n8n/n8n-nodes-langchain.vectorStorePinecone",
      "position": [
        3296,
        -208
      ],
      "parameters": {},
      "typeVersion": 1.3
    },
    {
      "id": "a986e0b4-c032-4335-9c9b-c56197f9fbf7",
      "name": "Standard-Datenlader",
      "type": "@n8n/n8n-nodes-langchain.documentDefaultDataLoader",
      "position": [
        3488,
        0
      ],
      "parameters": {},
      "typeVersion": 1.1
    },
    {
      "id": "5e9546d6-b63e-4db8-8ccf-1580dd389079",
      "name": "Einfacher Speicher",
      "type": "@n8n/n8n-nodes-langchain.memoryBufferWindow",
      "position": [
        1840,
        928
      ],
      "parameters": {},
      "typeVersion": 1.3
    },
    {
      "id": "a79d3e2d-b7c6-401b-a449-9a46a7d65f43",
      "name": "Pinecone (Info abrufen)",
      "type": "@n8n/n8n-nodes-langchain.vectorStorePinecone",
      "position": [
        2032,
        928
      ],
      "parameters": {},
      "typeVersion": 1.3
    },
    {
      "id": "3bef0066-c5f8-420a-8064-ed0311b03a97",
      "name": "Firmeninfo",
      "type": "n8n-nodes-base.set",
      "position": [
        1568,
        720
      ],
      "parameters": {},
      "typeVersion": 3.4
    },
    {
      "id": "40eb17ab-e6cd-4a88-8842-de528839a47e",
      "name": "Text extrahieren",
      "type": "n8n-nodes-base.extractFromFile",
      "position": [
        2512,
        32
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "51d7cd78-8fb6-43cf-af33-460105ea6185",
      "name": "PDF extrahieren",
      "type": "n8n-nodes-base.extractFromFile",
      "position": [
        2512,
        -128
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "673ce2d3-e67b-4d19-9d2b-16817d543b1a",
      "name": "Text auswählen",
      "type": "n8n-nodes-base.set",
      "position": [
        2704,
        32
      ],
      "parameters": {},
      "typeVersion": 3.4
    },
    {
      "id": "3f4379fb-1ee1-45a2-8038-41150aa0819d",
      "name": "PDF oder TXT",
      "type": "n8n-nodes-base.switch",
      "position": [
        2304,
        -48
      ],
      "parameters": {},
      "typeVersion": 3.2
    },
    {
      "id": "15a0a6a4-302d-45e4-af7c-72b21efc59dc",
      "name": "Zusammenführen",
      "type": "n8n-nodes-base.merge",
      "position": [
        2192,
        -528
      ],
      "parameters": {},
      "typeVersion": 3.2
    },
    {
      "id": "9be77a2b-5508-414b-92a1-e4c3178cc160",
      "name": "Duplikate entfernen",
      "type": "n8n-nodes-base.removeDuplicates",
      "position": [
        2336,
        -528
      ],
      "parameters": {},
      "typeVersion": 2
    },
    {
      "id": "1ccd6382-e370-47f7-902a-bc9ecf7f1ac6",
      "name": "Über Dateien iterieren",
      "type": "n8n-nodes-base.splitInBatches",
      "position": [
        2080,
        -192
      ],
      "parameters": {},
      "typeVersion": 3
    },
    {
      "id": "c55ec9ad-9cf9-4813-a1cb-5a5bc8844469",
      "name": "Switch1",
      "type": "n8n-nodes-base.switch",
      "position": [
        1376,
        -384
      ],
      "parameters": {},
      "typeVersion": 3.2
    },
    {
      "id": "907ad368-9129-4d81-acbd-ad7d48de0787",
      "name": "Split_Binary",
      "type": "n8n-nodes-base.code",
      "position": [
        1856,
        -64
      ],
      "parameters": {},
      "typeVersion": 2
    },
    {
      "id": "05ac9943-f6de-43ab-b9bd-470d39e0db3d",
      "name": "Tickets abrufen",
      "type": "n8n-nodes-base.googleSheetsTool",
      "position": [
        2384,
        848
      ],
      "parameters": {},
      "typeVersion": 4.6
    },
    {
      "id": "df90fdae-4d8f-43a7-acf9-1c2349b8cf02",
      "name": "Support-Tickets erstellen",
      "type": "n8n-nodes-base.googleSheetsTool",
      "position": [
        2560,
        784
      ],
      "parameters": {},
      "typeVersion": 4.6
    },
    {
      "id": "05b6a554-0465-4595-821a-eac544c98b51",
      "name": "Nachricht in Gmail senden",
      "type": "n8n-nodes-base.gmailTool",
      "position": [
        1856,
        1200
      ],
      "webhookId": "d78e82ae-5289-4213-b1f4-7fb749b83dad",
      "parameters": {},
      "typeVersion": 2.1
    },
    {
      "id": "6d27f310-28e3-4698-b09c-d924e5d77b4a",
      "name": "OpenAI Chat Model",
      "type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
      "position": [
        1664,
        928
      ],
      "parameters": {},
      "typeVersion": 1.2
    },
    {
      "id": "53eb3e5f-8a73-4e8d-ab6e-840eb196f61d",
      "name": "Embeddings OpenAI",
      "type": "@n8n/n8n-nodes-langchain.embeddingsOpenAi",
      "position": [
        2112,
        1120
      ],
      "parameters": {},
      "typeVersion": 1.2
    },
    {
      "id": "e6a670ff-1815-44f7-ad82-99a4ea356ebb",
      "name": "Embeddings OpenAI1",
      "type": "@n8n/n8n-nodes-langchain.embeddingsOpenAi",
      "position": [
        3280,
        16
      ],
      "parameters": {},
      "typeVersion": 1.2
    },
    {
      "id": "ac031d5a-ed46-4c36-8213-734a08fc2c1f",
      "name": "WhatsApp Trigger",
      "type": "n8n-nodes-base.whatsAppTrigger",
      "position": [
        1344,
        544
      ],
      "webhookId": "64048f32-bac4-473d-9a2a-9193401d3937",
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "77349f3e-1292-432f-822a-4ca1d0b4a20d",
      "name": "Haftnotiz",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1008,
        -688
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "29fe4f2c-eed7-4e14-9f89-53e7bf689eaf",
      "name": "Haftnotiz1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1008,
        432
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "0bbf9a71-f76d-49c5-8552-ae7b34dd1798",
      "name": "Haftnotiz2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -64,
        -688
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    }
  ],
  "pinData": {},
  "connections": {
    "f8d14cc9-8eb6-4fc6-9ffc-9c916738b09d": {
      "main": [
        [
          {
            "node": "5ebd8d66-9d86-400e-b601-7fa2e0eb40c0",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "5ebd8d66-9d86-400e-b601-7fa2e0eb40c0": {
      "main": [
        [
          {
            "node": "15a0a6a4-302d-45e4-af7c-72b21efc59dc",
            "type": "main",
            "index": 1
          }
        ]
      ]
    },
    "ed14bf13-5e46-4465-b93b-0cf8b1cbcc16": {
      "main": [
        [
          {
            "node": "81444721-dcc0-41dc-91f0-5c71f04e3033",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "ef4fcd5d-5fa5-4d75-af9c-58c4f559d7a3": {
      "main": [
        [
          {
            "node": "add88ee7-7e17-4c34-a539-7b727e57c3a9",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "15a0a6a4-302d-45e4-af7c-72b21efc59dc": {
      "main": [
        [
          {
            "node": "9be77a2b-5508-414b-92a1-e4c3178cc160",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "c55ec9ad-9cf9-4813-a1cb-5a5bc8844469": {
      "main": [
        [
          {
            "node": "fd7d2d87-8f73-4ce8-8788-b7ee3c983a83",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "a0af59c0-9c5a-4e4a-8654-fd4546224646",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "907ad368-9129-4d81-acbd-ad7d48de0787",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "3f4379fb-1ee1-45a2-8038-41150aa0819d": {
      "main": [
        [
          {
            "node": "51d7cd78-8fb6-43cf-af33-460105ea6185",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "40eb17ab-e6cd-4a88-8842-de528839a47e",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "51d7cd78-8fb6-43cf-af33-460105ea6185": {
      "main": [
        [
          {
            "node": "673ce2d3-e67b-4d19-9d2b-16817d543b1a",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "05ac9943-f6de-43ab-b9bd-470d39e0db3d": {
      "ai_tool": [
        [
          {
            "node": "91546766-7a95-4b59-8d13-e4b970b28e88",
            "type": "ai_tool",
            "index": 0
          }
        ]
      ]
    },
    "673ce2d3-e67b-4d19-9d2b-16817d543b1a": {
      "main": [
        [
          {
            "node": "1ccd6382-e370-47f7-902a-bc9ecf7f1ac6",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "3bef0066-c5f8-420a-8064-ed0311b03a97": {
      "main": [
        [
          {
            "node": "91546766-7a95-4b59-8d13-e4b970b28e88",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "40eb17ab-e6cd-4a88-8842-de528839a47e": {
      "main": [
        [
          {
            "node": "1ccd6382-e370-47f7-902a-bc9ecf7f1ac6",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "a0af59c0-9c5a-4e4a-8654-fd4546224646": {
      "main": [
        [
          {
            "node": "f8d14cc9-8eb6-4fc6-9ffc-9c916738b09d",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "907ad368-9129-4d81-acbd-ad7d48de0787": {
      "main": [
        [
          {
            "node": "1ccd6382-e370-47f7-902a-bc9ecf7f1ac6",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "5e9546d6-b63e-4db8-8ccf-1580dd389079": {
      "ai_memory": [
        [
          {
            "node": "91546766-7a95-4b59-8d13-e4b970b28e88",
            "type": "ai_memory",
            "index": 0
          }
        ]
      ]
    },
    "7dd826d4-a44e-4cf0-b85f-d23410d6a84d": {
      "main": [
        [
          {
            "node": "ef4fcd5d-5fa5-4d75-af9c-58c4f559d7a3",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "1ccd6382-e370-47f7-902a-bc9ecf7f1ac6": {
      "main": [
        [
          {
            "node": "81444721-dcc0-41dc-91f0-5c71f04e3033",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "3f4379fb-1ee1-45a2-8038-41150aa0819d",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "add88ee7-7e17-4c34-a539-7b727e57c3a9": {
      "main": [
        [
          {
            "node": "ed14bf13-5e46-4465-b93b-0cf8b1cbcc16",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "7dd826d4-a44e-4cf0-b85f-d23410d6a84d",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "fd7d2d87-8f73-4ce8-8788-b7ee3c983a83": {
      "main": [
        [
          {
            "node": "15a0a6a4-302d-45e4-af7c-72b21efc59dc",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "ac031d5a-ed46-4c36-8213-734a08fc2c1f": {
      "main": [
        [
          {
            "node": "3bef0066-c5f8-420a-8064-ed0311b03a97",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "53eb3e5f-8a73-4e8d-ab6e-840eb196f61d": {
      "ai_embedding": [
        [
          {
            "node": "a79d3e2d-b7c6-401b-a449-9a46a7d65f43",
            "type": "ai_embedding",
            "index": 0
          }
        ]
      ]
    },
    "6d27f310-28e3-4698-b09c-d924e5d77b4a": {
      "ai_languageModel": [
        [
          {
            "node": "91546766-7a95-4b59-8d13-e4b970b28e88",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "9be77a2b-5508-414b-92a1-e4c3178cc160": {
      "main": [
        [
          {
            "node": "add88ee7-7e17-4c34-a539-7b727e57c3a9",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "e6a670ff-1815-44f7-ad82-99a4ea356ebb": {
      "ai_embedding": [
        [
          {
            "node": "81444721-dcc0-41dc-91f0-5c71f04e3033",
            "type": "ai_embedding",
            "index": 0
          }
        ]
      ]
    },
    "b4a7917b-a9e6-4076-9aad-efe7cc4d72c5": {
      "main": [
        [
          {
            "node": "c55ec9ad-9cf9-4813-a1cb-5a5bc8844469",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "a986e0b4-c032-4335-9c9b-c56197f9fbf7": {
      "ai_document": [
        [
          {
            "node": "81444721-dcc0-41dc-91f0-5c71f04e3033",
            "type": "ai_document",
            "index": 0
          }
        ]
      ]
    },
    "df90fdae-4d8f-43a7-acf9-1c2349b8cf02": {
      "ai_tool": [
        [
          {
            "node": "91546766-7a95-4b59-8d13-e4b970b28e88",
            "type": "ai_tool",
            "index": 0
          }
        ]
      ]
    },
    "05b6a554-0465-4595-821a-eac544c98b51": {
      "ai_tool": [
        [
          {
            "node": "91546766-7a95-4b59-8d13-e4b970b28e88",
            "type": "ai_tool",
            "index": 0
          }
        ]
      ]
    },
    "a79d3e2d-b7c6-401b-a449-9a46a7d65f43": {
      "ai_tool": [
        [
          {
            "node": "91546766-7a95-4b59-8d13-e4b970b28e88",
            "type": "ai_tool",
            "index": 0
          }
        ]
      ]
    },
    "c5b15d1f-3f07-4075-83d6-e9b393a20a16": {
      "main": [
        [
          {
            "node": "3bef0066-c5f8-420a-8064-ed0311b03a97",
            "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 - Support-Chatbot, Multimodales KI

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.

Workflow-Informationen
Schwierigkeitsgrad
Experte
Anzahl der Nodes35
Kategorie2
Node-Typen23
Schwierigkeitsbeschreibung

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

Autor
Zain Khan

Zain Khan

@zain

I partner with businesses to streamline processes and accelerate growth through intelligent AI automation and Web/mobile Development. Leveraging deep expertise in GPT-4, LangChain, and n8n, I develop AI-powered agents and sophisticated LLM pipelines.

Externe Links
Auf n8n.io ansehen

Diesen Workflow teilen

Kategorien

Kategorien: 34