{"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 class=\"wp-block-paragraph\">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 class=\"wp-block-paragraph\">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 class=\"wp-block-paragraph\">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"],"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}]}}