{"id":7967,"date":"2025-08-14T17:16:14","date_gmt":"2025-08-14T15:16:14","guid":{"rendered":"https:\/\/launix.de\/launix\/?p=7967"},"modified":"2025-08-19T11:09:38","modified_gmt":"2025-08-19T09:09:38","slug":"n8n-chatbot-kann-daten-aus-dem-crm-abfragen-und-supportanfragen-hinterlegen","status":"publish","type":"post","link":"https:\/\/launix.de\/launix\/en\/n8n-chatbot-kann-daten-aus-dem-crm-abfragen-und-supportanfragen-hinterlegen\/","title":{"rendered":"n8n: Chatbot kann Daten aus dem CRM abfragen und Supportanfragen hinterlegen"},"content":{"rendered":"<p>Chatbots sind eigentlich cool, aber nerven auch, wenn sie nur allgemein nett sind und keine n\u00fctzlichen Infos kennen oder zu relevanten Dingen aussagekr\u00e4ftig sind.<\/p>\n\n\n\n<!--more-->\n\n\n\n<p>Das kann man mit Tool Support \u00e4ndern. In diesem Video erkl\u00e4re ich, wie man einen Chatbot mit dem Launix-System verbinden kann.<\/p>\n\n\n\n<figure class=\"wp-block-embed is-type-video is-provider-youtube wp-block-embed-youtube wp-embed-aspect-16-9 wp-has-aspect-ratio\"><div class=\"wp-block-embed__wrapper\">\n<iframe loading=\"lazy\" title=\"n8n: Der Chatbot kann Informationen aus dem CRM abfragen\" width=\"751\" height=\"422\" src=\"https:\/\/www.youtube.com\/embed\/lEuvajzJdnU?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe>\n<\/div><\/figure>\n\n\n\n<p>Hier der Code zum Kopieren nach n8n:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>{\n  \"nodes\": &#91;\n    {\n      \"parameters\": {\n        \"options\": {}\n      },\n      \"type\": \"@n8n\/n8n-nodes-langchain.chatTrigger\",\n      \"typeVersion\": 1.3,\n      \"position\": &#91;\n        0,\n        0\n      ],\n      \"id\": \"0f882a01-7435-4146-a2e6-ac10188a3a28\",\n      \"name\": \"When chat message received\",\n      \"webhookId\": \"5e92851c-6277-4cda-af83-1cf819859ac9\"\n    },\n    {\n      \"parameters\": {\n        \"options\": {\n          \"systemMessage\": \"When you extract data from customers and you know a customer ID, you can build a link like &#91;customer name](https:\/\/launix.de\/fop\/crm-neu\/Tables\/Kunde\/view?id=ID)\"\n        }\n      },\n      \"type\": \"@n8n\/n8n-nodes-langchain.agent\",\n      \"typeVersion\": 2.2,\n      \"position\": &#91;\n        208,\n        0\n      ],\n      \"id\": \"c6286e3b-94bb-4761-b880-c59e8ef741fc\",\n      \"name\": \"AI Agent\"\n    },\n    {\n      \"parameters\": {\n        \"model\": {\n          \"__rl\": true,\n          \"mode\": \"list\",\n          \"value\": \"gpt-4.1-mini\"\n        },\n        \"options\": {}\n      },\n      \"type\": \"@n8n\/n8n-nodes-langchain.lmChatOpenAi\",\n      \"typeVersion\": 1.2,\n      \"position\": &#91;\n        80,\n        208\n      ],\n      \"id\": \"a45c8e47-dffa-497e-8e97-301a810ed811\",\n      \"name\": \"OpenAI Chat Model\",\n      \"credentials\": {\n        \"openAiApi\": {\n          \"id\": \"bvaEo3Nx6CCGnXwt\",\n          \"name\": \"OpenAi account\"\n        }\n      }\n    },\n    {\n      \"parameters\": {},\n      \"type\": \"@n8n\/n8n-nodes-langchain.memoryBufferWindow\",\n      \"typeVersion\": 1.3,\n      \"position\": &#91;\n        224,\n        208\n      ],\n      \"id\": \"2e2bc98a-e1d2-4eb9-a6c2-ddbe425ad1b2\",\n      \"name\": \"Simple Memory\"\n    },\n    {\n      \"parameters\": {\n        \"descriptionType\": \"manual\",\n        \"toolDescription\": \"wenn informationen \u00fcber kunden geholt werden sollen\",\n        \"table\": {\n          \"__rl\": true,\n          \"value\": \"Kunde\",\n          \"mode\": \"list\",\n          \"cachedResultName\": \"Kunde (kunde)\"\n        },\n        \"operation\": \"list\",\n        \"filterparams\": \"={{ $fromAI('Filter_and_Sort_Parameters', `json object with the following keys allowing to filter:\\n - filter_kunde_name for surnames\\n - filter_kunde_vorname for first names\\n - limit: 1 to retrieve only one item\\n - filter_kunde_firma to filter for company\\nempty json object {} to fetch all`, 'string') }}\"\n      },\n      \"type\": \"n8n-nodes-launix.launixNodeTool\",\n      \"typeVersion\": 1,\n      \"position\": &#91;\n        416,\n        208\n      ],\n      \"id\": \"0398b050-1365-4274-bc14-76bdc1dabd55\",\n      \"name\": \"Daten abfragen\",\n      \"credentials\": {\n        \"launixCredentialsApi\": {\n          \"id\": \"Uco1GL0LH7PpNaTY\",\n          \"name\": \"Launix Credentials account\"\n        }\n      }\n    },\n    {\n      \"parameters\": {\n        \"descriptionType\": \"manual\",\n        \"toolDescription\": \"when something is told that our company should know about the conversation\",\n        \"table\": {\n          \"__rl\": true,\n          \"value\": \"KundeHistory\",\n          \"mode\": \"list\",\n          \"cachedResultName\": \"Kommunikationsereignis (kundeHistory)\"\n        },\n        \"operation\": \"create\",\n        \"columns\": {\n          \"mappingMode\": \"defineBelow\",\n          \"value\": {\n            \"notiz\": \"={{ $fromAI('Notiz__notiz_', `write down important information about what the customer needs`, 'string') }}\"\n          },\n          \"matchingColumns\": &#91;],\n          \"schema\": &#91;\n            {\n              \"id\": \"date\",\n              \"displayName\": \"Datum (date)\",\n              \"required\": false,\n              \"defaultMatch\": false,\n              \"display\": true,\n              \"type\": \"string\",\n              \"canBeUsedToMatch\": true,\n              \"readOnly\": false,\n              \"removed\": true\n            },\n            {\n              \"id\": \"user\",\n              \"displayName\": \"Mitarbeiter (user)\",\n              \"required\": false,\n              \"defaultMatch\": false,\n              \"display\": true,\n              \"type\": \"string\",\n              \"canBeUsedToMatch\": true,\n              \"readOnly\": false,\n              \"removed\": true\n            },\n            {\n              \"id\": \"parent\",\n              \"displayName\": \"Kunde (parent)\",\n              \"required\": false,\n              \"defaultMatch\": false,\n              \"display\": true,\n              \"type\": \"string\",\n              \"canBeUsedToMatch\": true,\n              \"readOnly\": false,\n              \"removed\": true\n            },\n            {\n              \"id\": \"aktion\",\n              \"displayName\": \"Aktion (aktion)\",\n              \"required\": false,\n              \"defaultMatch\": false,\n              \"display\": true,\n              \"type\": \"string\",\n              \"canBeUsedToMatch\": true,\n              \"readOnly\": false,\n              \"removed\": true\n            },\n            {\n              \"id\": \"notiz\",\n              \"displayName\": \"Notiz (notiz)\",\n              \"required\": false,\n              \"defaultMatch\": false,\n              \"display\": true,\n              \"type\": \"string\",\n              \"canBeUsedToMatch\": true,\n              \"readOnly\": false,\n              \"removed\": false\n            },\n            {\n              \"id\": \"to-campaign\",\n              \"displayName\": \"Kampagne (to-campaign)\",\n              \"required\": false,\n              \"defaultMatch\": false,\n              \"display\": true,\n              \"type\": \"string\",\n              \"canBeUsedToMatch\": true,\n              \"readOnly\": false,\n              \"removed\": true\n            }\n          ],\n          \"attemptToConvertTypes\": false,\n          \"convertFieldsToString\": false\n        }\n      },\n      \"type\": \"n8n-nodes-launix.launixNodeTool\",\n      \"typeVersion\": 1,\n      \"position\": &#91;\n        576,\n        240\n      ],\n      \"id\": \"110afb33-35d6-459e-b113-10605f6c9374\",\n      \"name\": \"Notizen anlegen\",\n      \"credentials\": {\n        \"launixCredentialsApi\": {\n          \"id\": \"Uco1GL0LH7PpNaTY\",\n          \"name\": \"Launix Credentials account\"\n        }\n      }\n    }\n  ],\n  \"connections\": {\n    \"When chat message received\": {\n      \"main\": &#91;\n        &#91;\n          {\n            \"node\": \"AI Agent\",\n            \"type\": \"main\",\n            \"index\": 0\n          }\n        ]\n      ]\n    },\n    \"OpenAI Chat Model\": {\n      \"ai_languageModel\": &#91;\n        &#91;\n          {\n            \"node\": \"AI Agent\",\n            \"type\": \"ai_languageModel\",\n            \"index\": 0\n          }\n        ]\n      ]\n    },\n    \"Simple Memory\": {\n      \"ai_memory\": &#91;\n        &#91;\n          {\n            \"node\": \"AI Agent\",\n            \"type\": \"ai_memory\",\n            \"index\": 0\n          }\n        ]\n      ]\n    },\n    \"Daten abfragen\": {\n      \"ai_tool\": &#91;\n        &#91;\n          {\n            \"node\": \"AI Agent\",\n            \"type\": \"ai_tool\",\n            \"index\": 0\n          }\n        ]\n      ]\n    },\n    \"Notizen anlegen\": {\n      \"ai_tool\": &#91;\n        &#91;\n          {\n            \"node\": \"AI Agent\",\n            \"type\": \"ai_tool\",\n            \"index\": 0\n          }\n        ]\n      ]\n    }\n  },\n  \"pinData\": {},\n  \"meta\": {\n    \"templateCredsSetupCompleted\": true,\n    \"instanceId\": \"5d646b97a6f5b390970161e7d5b6c2999c720df20b57515df0439cbab498ca6c\"\n  }\n}<\/code><\/pre>","protected":false},"excerpt":{"rendered":"<p>Chatbots sind eigentlich cool, aber nerven auch, wenn sie nur allgemein nett sind und keine n\u00fctzlichen Infos kennen oder zu relevanten Dingen aussagekr\u00e4ftig sind.<\/p>","protected":false},"author":2,"featured_media":7968,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_editorskit_title_hidden":false,"_editorskit_reading_time":0,"_editorskit_is_block_options_detached":false,"_editorskit_block_options_position":"{}","_uag_custom_page_level_css":"","footnotes":""},"categories":[142,413],"tags":[],"class_list":["post-7967","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-handbuch","category-n8n","single-item"],"featured_image_urls_v2":{"full":["https:\/\/launix.de\/launix\/wp-content\/uploads\/2025\/08\/Bildschirmfoto-vom-2025-08-14-17-10-36.png",1920,1080,false],"thumbnail":["https:\/\/launix.de\/launix\/wp-content\/uploads\/2025\/08\/Bildschirmfoto-vom-2025-08-14-17-10-36-150x150.png",150,150,true],"medium":["https:\/\/launix.de\/launix\/wp-content\/uploads\/2025\/08\/Bildschirmfoto-vom-2025-08-14-17-10-36-300x169.png",300,169,true],"medium_large":["https:\/\/launix.de\/launix\/wp-content\/uploads\/2025\/08\/Bildschirmfoto-vom-2025-08-14-17-10-36-768x432.png",751,422,true],"large":["https:\/\/launix.de\/launix\/wp-content\/uploads\/2025\/08\/Bildschirmfoto-vom-2025-08-14-17-10-36-1024x576.png",751,422,true],"1536x1536":["https:\/\/launix.de\/launix\/wp-content\/uploads\/2025\/08\/Bildschirmfoto-vom-2025-08-14-17-10-36-1536x864.png",1536,864,true],"2048x2048":["https:\/\/launix.de\/launix\/wp-content\/uploads\/2025\/08\/Bildschirmfoto-vom-2025-08-14-17-10-36.png",1920,1080,false],"trp-custom-language-flag":["https:\/\/launix.de\/launix\/wp-content\/uploads\/2025\/08\/Bildschirmfoto-vom-2025-08-14-17-10-36-18x10.png",18,10,true],"xs-thumb":["https:\/\/launix.de\/launix\/wp-content\/uploads\/2025\/08\/Bildschirmfoto-vom-2025-08-14-17-10-36-64x64.png",64,64,true],"appku-shop-single":["https:\/\/launix.de\/launix\/wp-content\/uploads\/2025\/08\/Bildschirmfoto-vom-2025-08-14-17-10-36-620x500.png",620,500,true]},"post_excerpt_stackable_v2":"<p>Chatbots sind eigentlich cool, aber nerven auch, wenn sie nur allgemein nett sind und keine n\u00fctzlichen Infos kennen oder zu relevanten Dingen aussagekr\u00e4ftig sind. Das kann man mit Tool Support \u00e4ndern. In diesem Video erkl\u00e4re ich, wie man einen Chatbot mit dem Launix-System verbinden kann. Hier der Code zum Kopieren nach n8n: { &#8220;nodes&#8221;: &#91; { &#8220;parameters&#8221;: { &#8220;options&#8221;: {} }, &#8220;type&#8221;: &#8220;@n8n\/n8n-nodes-langchain.chatTrigger&#8221;, &#8220;typeVersion&#8221;: 1.3, &#8220;position&#8221;: &#91; 0, 0 ], &#8220;id&#8221;: &#8220;0f882a01-7435-4146-a2e6-ac10188a3a28&#8221;, &#8220;name&#8221;: &#8220;When chat message received&#8221;, &#8220;webhookId&#8221;: &#8220;5e92851c-6277-4cda-af83-1cf819859ac9&#8221; }, { &#8220;parameters&#8221;: { &#8220;options&#8221;: { &#8220;systemMessage&#8221;: &#8220;When you extract data from customers and you know a customer ID, you can&hellip;<\/p>\n","category_list_v2":"<a href=\"https:\/\/launix.de\/launix\/en\/category\/handbuch\/\" rel=\"category tag\">Handbuch<\/a>, <a href=\"https:\/\/launix.de\/launix\/en\/category\/n8n\/\" rel=\"category tag\">n8n<\/a>","author_info_v2":{"name":"Carl-Philip H\u00e4nsch","url":"https:\/\/launix.de\/launix\/en\/author\/carli\/"},"comments_num_v2":"0 comments","uagb_featured_image_src":{"full":["https:\/\/launix.de\/launix\/wp-content\/uploads\/2025\/08\/Bildschirmfoto-vom-2025-08-14-17-10-36.png",1920,1080,false],"thumbnail":["https:\/\/launix.de\/launix\/wp-content\/uploads\/2025\/08\/Bildschirmfoto-vom-2025-08-14-17-10-36-150x150.png",150,150,true],"medium":["https:\/\/launix.de\/launix\/wp-content\/uploads\/2025\/08\/Bildschirmfoto-vom-2025-08-14-17-10-36-300x169.png",300,169,true],"medium_large":["https:\/\/launix.de\/launix\/wp-content\/uploads\/2025\/08\/Bildschirmfoto-vom-2025-08-14-17-10-36-768x432.png",751,422,true],"large":["https:\/\/launix.de\/launix\/wp-content\/uploads\/2025\/08\/Bildschirmfoto-vom-2025-08-14-17-10-36-1024x576.png",751,422,true],"1536x1536":["https:\/\/launix.de\/launix\/wp-content\/uploads\/2025\/08\/Bildschirmfoto-vom-2025-08-14-17-10-36-1536x864.png",1536,864,true],"2048x2048":["https:\/\/launix.de\/launix\/wp-content\/uploads\/2025\/08\/Bildschirmfoto-vom-2025-08-14-17-10-36.png",1920,1080,false],"trp-custom-language-flag":["https:\/\/launix.de\/launix\/wp-content\/uploads\/2025\/08\/Bildschirmfoto-vom-2025-08-14-17-10-36-18x10.png",18,10,true],"xs-thumb":["https:\/\/launix.de\/launix\/wp-content\/uploads\/2025\/08\/Bildschirmfoto-vom-2025-08-14-17-10-36-64x64.png",64,64,true],"appku-shop-single":["https:\/\/launix.de\/launix\/wp-content\/uploads\/2025\/08\/Bildschirmfoto-vom-2025-08-14-17-10-36-620x500.png",620,500,true]},"uagb_author_info":{"display_name":"Carl-Philip H\u00e4nsch","author_link":"https:\/\/launix.de\/launix\/en\/author\/carli\/"},"uagb_comment_info":0,"uagb_excerpt":"Chatbots sind eigentlich cool, aber nerven auch, wenn sie nur allgemein nett sind und keine n\u00fctzlichen Infos kennen oder zu relevanten Dingen aussagekr\u00e4ftig sind.","_links":{"self":[{"href":"https:\/\/launix.de\/launix\/en\/wp-json\/wp\/v2\/posts\/7967","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/launix.de\/launix\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/launix.de\/launix\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/launix.de\/launix\/en\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/launix.de\/launix\/en\/wp-json\/wp\/v2\/comments?post=7967"}],"version-history":[{"count":2,"href":"https:\/\/launix.de\/launix\/en\/wp-json\/wp\/v2\/posts\/7967\/revisions"}],"predecessor-version":[{"id":7972,"href":"https:\/\/launix.de\/launix\/en\/wp-json\/wp\/v2\/posts\/7967\/revisions\/7972"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/launix.de\/launix\/en\/wp-json\/wp\/v2\/media\/7968"}],"wp:attachment":[{"href":"https:\/\/launix.de\/launix\/en\/wp-json\/wp\/v2\/media?parent=7967"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/launix.de\/launix\/en\/wp-json\/wp\/v2\/categories?post=7967"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/launix.de\/launix\/en\/wp-json\/wp\/v2\/tags?post=7967"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}