Good Morning guys,
I am a single developer in a marketing bussiness. Most of our clients are hotels which always have to deal with the same stupid questions from clients. Thats why i came up with the idea of programming an AI chatbot which deals with this questions. My question is, how can i give this data to my chatbot? I mean i have setup an excel file for my clients where they simply write down question and answer. Is there any way I can tell che chatbot to answer only to questions he can find in this list and still being able to make conversations?
2 Likes
Hello!
Take a look at this it may help you with your setup. You don’t need to use a local agent, you can simply use OpenAI Api or any other provider you like.
{
"cells": [
{
"cell_type": "code",
"execution_count": null,
"id": "8520d840-fcf6-4458-b85c-8a2ff80a34eb",
"metadata": {},
"outputs": [],
"source": [
"! pip install -U langchain-nomic langchain_community tiktoken langchainhub chromadb langchain langgraph tavily-python gpt4all"
]
},
{
"attachments": {
"7b00797e-fb85-4474-9a9e-c505b61add81.png": {
"image/png": "iVBORw0KGgoAAAANSUhEUgAAC00AAAK1CAYAAACuduSpAAAAAXNSR0IArs4c6QAAIABJREFUeF7s3QdwVOUaxvEnPSEhECD0EnrvHUGkiHSpYsGG2LGDFwuIYLsKiO3aEFQEpBdpUkSKSJXee++9JCQkufMdzZrNbpJNCCmb/5nxhpz92vs7hxnvzLOvHrGxsbHiQgABBBBAAAEEEEAAAQQQQAABBBBAAAEEEEAAAQQQQAABBBBAAAEEEEAAAQQQQAABBBBAAAEE3FTAg9C0mz5ZykIAAQQQQAABBBBAAAEEEEAAAQQQQAABBBBAAAEEEEAAAQQQQAABBBBAAAEEEEAAAQQQQAABS4DQNC8CAggggAACCCCAAAIIIIAAAggggAACCCCAAAIIIIAAAggggAACCCCAAAIIIIAAAggggAACCLi1AKFpt368FIcAAggggAACCCCAAAIIIIAAAggggAACCCCAAAIIIIAAAggggAACCCCAAAIIIIAAAggggAAChKZ5BxBAAAEEEEAAAQQQQAABBBBAAAEEEEAAAQQQQAABBBBAAAEEEEAAAQQQQAABBBBAAAEEEEDArQUITbv146U4BBBAAAEEEEAAAQQQQAABBBBAAAEEEEAAAQQQQAABBBBAAAEEEEAAAQQQQAABBBBAAAEEECA0zTuAAAIIIIAAAggggAACCCCAAAIIIIAAAggggAACCCCAAAIIIIAAAggggAACCCCAAAIIIIAAAm4tQGjarR8vxSGAAAIIIIAAAggggAACCCCAAAIIIIAAAggggAACCCCAAAIIIIAAAggggAACCCCAAAIIIIAAoWneAQQQQAABBBBAAAEEEEAAAQQQQAABBBBAAAEEEEAAAQQQQAABBBBAAAEEEEAAAQQQQAABBBBwawFC0279eCkOAQQQQAABBBBAAAEEEEAAAQQQQAABBBBAAAEEEEAAAQQQQAABBBBAAAEEEEAAAQQQQAABBAhN8w4ggAACCCCAAAIIIIAAAggggAACCCCAAAIIIIAAAggggAACCCCAAAIIIIAAAggggAACCCCAgFsLEJp268dLcQgggAACCCCAAAIIIIAAAggggAACCCCAAAIIIIAAAggggAACCCCAAAIIIIAAAggggAACCCBAaJp3AAEEEEAAAQQQQAABBBBAAAEEEEAAAQQQQAABBBBAAAEEEEAAAQQQQAABBBBAAAEEEEAAAQTcWoDQtFs/XopDAAEEEEAAAQQQQAABBBBAAAEEEEAAAQQQQAABBBBAAAEEEEAAAQQQQAABBBBAAAEEEEAAAULTvAMIIIAAAggggAACCCCAAAIIIIAAAggggAACCCCAAAIIIIAAAggggAACCCCAAAIIIIAAAggg4NYChKbd+vFSHAIIIIAAAggggAACCCCAAAIIIIAAAggggAACCCCAAAIIIIAAAggggAACCCCAAAIIIIBAcgLXosI1a+8Ca1i70i0V6JMjuSl8nsUECE1nsQfGcRFAAAEEEEAAAQQQQAABBBBAAAEEEEAAAQQQQAABBBBAAAEEEEAAAQQQQAABBBBAAAEE0k7gxNXT6jb9cV2JvGot6uXppcX3TVawb1DabcJKGS5AaDrDHwEHQAABBBBAAAEEEEAAAQQQQAABBBBAAAEEEEAAAQQQQAABBBBAAAEEEEAAAQQQQAABBBDIKIHP/xqtkRvH2W3/3u391bZ0i4w6EvveAgFC07cAlSURQAABBBBAAAEEEEAAAQQQQAABBBBAAAEEEEAAAQQQQAABBBBAAAEEEEAAAQQQQAABBLKGwAO/9NHWMzvtDvtRswG6M+z2rFEAp3RJgNC0S0wMQgABBBBAAAEEEEAAAQQQQAABBBBAAAEEEEAAAQQQQAABBBBAAAEEEEAAAQQQQAABBBBwN4FrUeFq9FNHh7K+azNMtQtWc7dys3U9hKaz9eOneAQQQAABBBBAAAEEEEAAAQQQQAABBBBAAAEEEEAAAQQQQAABBBBAAAEEEEAAAQQQQCD7Ciw4sFT9Fg9xAJjS+VuVzh2WfWHcsHJC0274UCkJAQQQQAABBBBAAAEEEEAAAQQQQAABBBBAAAEEEEAAAQQQQAABBBBAAAEEEEAAAQQQQCB5gT4L3tDyI6sdBi66d6LyBoQkvwAjsowAoeks86g4KAIIIIAAAggggAACCCCAAAIIIIAAAggggAACCCCAAAIIIIAAAggggAACCCCAAAJpJzB8zdfad+GQteDdZe/SnWG3J7p4dEy0+i95T+E3Iqwx/6n/rIoFF067w7DSTQscu3JSA5d9pMJBBVQpXzk1L3Gb8ufId9PruvMC+y8cUudpjzktcd3D8+Tl6eXO5We72ghNZ7tHTsEIIIAAAggggAACCCCAAAIIIIAAAggggAACCCCAAAIIIIAAAggggAACCCCAAAIISBO2z9T7Kz+zKHL5Beu3eycmGhKdsnO2hqwYYY0N8g3U7/dNlrenN4yZSGDtiY3qPbev7USBPjnUulQzVQ+tqOYlGlvPjcte4KVFg7T40B9OWTY8ugAuNxMgNO1mD5RyEEAAAQQQQAABBBBAAAEEEEAAAQQQQAABBBBAAAEEEEAAAQQQQAABBBBAAAEEEHBFwHSPbv7zPbp4/ZI1fOBtL6tLuTYOU2NiY9RsfHfbuAGNXlTX8u1c2YIx6Sxw6NJR/XFkjeYfWKL1J7fYdvfz8lXLsCZW9+kmRevL18s3nU+W+bYzPo/OecnpwXL4BGhFz5mZ79Cc6KYECE3fFB+TEUAAAQQQQAABBBBAAAEEEEAAAQQQQAABBBBAAAEEEEAAAQQQQAABBBBAAAEEEMi6AjN2/6q3lg+1Csjjn1sL750oTw8Pu4J+2TNfA5Z9FG/MBHl6eGbdorPJyU14+s9ja7X8yBoduHjYVnW+HHnUvPjf4ekmxepnEw37Mm/E3FDrSQ/ozLVzTus3Rgt7TMiWNu5cNKFpd3661IYAAggggAACCCCAAAIIIIAAAggggAACCCCAAAIIIIAAAggggAACCCCAAAIIIIBAEgIxsbFqNfFeW3j03dv7q13pFrYZsYrVnRMS/9zZ0seunNSxKydUPLiI8ufIlyL/a1HhVkfr8xEXdTnqqgK9A5TLP9gKdJvuvx6yD3SnaPFsPHjdiU1admSVfj/0p12AunTuMN1VsqlalWyqsFzFso3Q5+tGaeSm8YnWWzJXMU3rMipDPMz7b7pg7zq3T7vO79Pe8wfk4+VjPZ+elbqoWv5KGXIud9iU0LQ7PEVqQAABBBBAAAEEEEAAAQQQQAABBBBAAAEEEEAAAQQQQAABBBBAAAEEEEAAAQQQQCCVAr/u/13/+f1da3aBwFDNu2esLZw8b/9i9f/9Paefxd/OBD1NN+o/jq5RdEy07SMvTy/dU76DXq73pHw8vZ2e8Gz4eY3bNk2z9i7UyaunE63i69Yfqn6hmqmskmlxAtN3z9OcvYu0+viGf5+Th5ctPH1H8UZujbX/wiF1nvZYkjWWCC6qGV1Hp5uD+Tsw/8ASzdqzUFvP7Ex0X/P36bd7JyqXX3C6nS1uI/O+jNk6WeaLDQ9W7qrk3pPwGxGKirmhYN+gFJ/1xNVTmrl7vhX0P33tnK5EXVUuv5wqGJjfCo+3KdVMtQtWS/GXKAhNp/hRMAEBBBBAAAEEEEAAAQQQQAABBBBAAAEEEEAAAQQQQAABBBBAAAEEEEAAAQQQQAAB9xEw3aTbT35IRy+fsIr68I43rc7D5mo98QGZAKO5hjV/Sy1KNHYofMfZPeo192UrTJnYZcKO07uMkr+3n92Qy5FX1G36E0mGpeMm/NL1BxULLuw+8BlcyYqjazVn3yLN2fubYmJjbKeplLesWpW8Q61L3WGFVN3pMu/6PdOf1O7z+21lmQ7mAxq9qNeWvG+7l9pO0+ciLmjz6R26FnVNhYMKqHr+yonymUDxqmN/afy26daXDVy9xnX4QpXylUty+Jlr5+Tr7ZuqwLKzheN/scJ83rBIbX3Z6gOHoabL/NDVX+qPI2t0PTrS+twEvcOCi+n+Sp3UoUwr+Xr5JHn2fRcO6r6Zz9jmJzbYfMHjo2YDVC20oqt0IjTtMhUDEUAAAQQQQAABBBBAAAEEEEAAAQQQQAABBBBAAAEEEEAAAQQQQAABBBBAAAEEEHBPgaWHV+r5hQOs4orkLKjZ3cZo0cHleuW3t617JqxsQsvOrq7THtfeCwdsHzUpVl8FA0O178IhrTuxyXb/8eoP6Nlaj9gt0W/xEC04sNR2z3TQrVWgqvIE5FaAt7/VtdoEq89HXNSIloMT7Vbtnk8lfaoyz2723r/D03EBebNzTt8gtS3dXO1KtVC1/JXS5zC3eJfP143SyE3j7XYxXwYwtT4xr5/tftmQkprU6RuH05hA7+HLx1UlX3nlDQix+3zL6R16bO4rdmHfF+r01qNVezis8/P2Gfpo9Zd2XdldLX3pA9MSDUP/eXSd3lv5qQ5fOmYtZ8LgXcu3c3Vpp+OWHV6l5xa+afeZqcnUFneZTvOfrRutyTtnJblX6dxh+r7dx5a3s8uErrtNfzzJL2AknPdQlW56sc7j8vTwTLZOQtPJEjEAAQQQQAAshow original
Thank you, I will try.
Still if someone has another input i am always happy to see different solutions.
Thank you guys
Hey, hey.
It depends where you’re chatbot is being built, and how you’re displaying it and how you’re connecting to OpenAI.
Assistants already have a place where you can System Instructions and a Knowledge Base. Then you just call the Assistant for your Chatbot.
I use a Customer Service Chatbot that fulfills the same function developed on Zapier . You can similarly upload files, or use one of the Zapier Tables if you want something more than one person can access. Otherwise, this is just an Assistant but they do the coding for the chatbot and offer other low-to-no-code solutions.
In the System Instructions, clearly reference the spreadsheet as a FAQ, and the bot will go right to the answer.
