I am looking to create a chatbot in Microsoft Teams that can answer questions about my MySQL database. Is this possible? I basically just want to integrate Teams into David Roberts’ workflow here: Chat with a database using AI | n8n workflow template
I was able to get it to work with just a chat input and not Teams but I am pretty new to n8n so I’m unsure how to properly integrate Teams into it.
Additionally, would it be possible for this Teams “bot” to read content from a Microsoft Word document that I send it?
Hi @maxg! Thanks for reaching out and being a part of the community!
Great question. You can certainly configure it to work within Microsoft Teams.
First, you would want to set up an outgoing webhook in Teams. You would use the webhook url provided by a webhook trigger in n8n to fill in the callback url required by Teams. That would get incoming messages from teams to trigger the workflow.
Next, you’d want to connect the SQL Agent to your MySQL db. Once you add your MySQL Credentials then you would just need to update the prompt to be the output of your trigger node (formatted for your needs).
Thank you! I actually got the webhook to work and pass the Teams message into the AI but am now just having issues having the respond to web hook return me the correct answer on Teams. I have gotten the correct output from the AI agent node but am unable to receive it back on teams.
Do you know why this is happening? I am just getting the message “Sorry, there was a problem encountered with your request” from the bot on Teams.
@Ludwig Sorry for the multiple replies. I was able to get it to work for simple questions however the Microsoft teams bot sends “Sorry, there was a problem encountered with your request” whenever the web hook response takes more than 5 seconds. Do you know if there is a way to get around this?
