Build a Conversational Chatbot with Archbee and Chat GPT

in this article, we will explore the process of creating a conversational chatbot using archbee and chat gpt by leveraging the power of archbee's documentation platform and integrating it with the capabilities of chat gpt, we can develop a chatbot that interacts with users and retrieves information from a knowledge base or data source this article will guide you through the steps required to set up and configure the chatbot, highlighting the use of archbee and chat gpt in the process step 1 import the procesio file into your workspace we have already prepared for you the process flows needed to build this use case for that, go to your workspace in procesio press import/export , and continue with importing the conversationalcahtbot procesio file we have attached below https //archbee doc uploads s3 amazonaws com/pd o7nzlwdisbwglsha9q/ nekxa ntvkbo3hpeu tp conversationalchatbot zip the below processes will be imported into your workspace, together with others (4 credentials and a data model) in order for everything to work step 1 setting up the database, archbee and chat gpt connections to begin, we need to ensure that we have archbee and chat gpt credentials properly configured go to credentials manager and update the following credential configurations with your details chatbot database chatgpt it is now time to run the sql scripts to create and update your database chat create all db objects sql https //drive google com/file/d/1x9vkl3x1bbpmlgldh3ao5iyotvext7ur/view https //drive google com/file/d/1x9vkl3x1bbpmlgldh3ao5iyotvext7ur/view useful selects sql https //drive google com/file/d/1yux6isjpni zoziokieimnmdwhqyuhg7/view https //drive google com/file/d/1yux6isjpni zoziokieimnmdwhqyuhg7/view the " chat create all db objects sql " file contains the scripts that need to be executed in the database to create the necessary objects this file is essential for setting up the database structure correctly the " useful selects sql " file contains several useful queries that can be executed in the database these queries provide insights into the received questions, response times, keywords, relevance scores, missing keywords, and more by analyzing this data, you can a identify the missing information in the documentation that needs to be completed b understand the information that users frequently inquire about c determine the most sought after articles or topics step 2 connecting archbee and chat gpt next, we establish the connection between archbee and chat gpt archbee allows us to extract relevant information from the documentation by connecting it to an sql database by caching the necessary data, we avoid redundant queries and enhance the chatbot's response time ensure that the archbee credentials are correctly set up to connect with the sql database (check step 1) to make this, go to process chatbot/1 call gptchat and select the call gpt api action in its setting, make sure you add your openai organization in headers see below how you can find the organization for your openai account next, go to chatbot/1 archbee get articles by searchterm process if you also use archbee as a source, you need to add the docsspaceid value to the body of the search archbee action, like below to get a docspaceid you can go to document info and copy the doc space id value congrats! you can now run and test your configuration! 🎉 go to process chatbot/0 search and press run a modal will pop up requesting input parameters add your question and press run again to initiate the flows once you hit run, this is what will happen behind the scenes 1\) deconstructing user queries when a user interacts with the chatbot, the first step is to deconstruct their question into keywords using chat gpt this process helps in identifying the user's intent and extracting the most relevant information from the documentation 2\) searching and caching articles using the extracted keywords, the chatbot searches the archbee documentation for relevant articles the retrieved articles are then cached in the sql database for faster access this caching mechanism eliminates the need for repeated searches for previously answered queries 3\) calculating relevance and scoring for each keyword extracted from the user's question, chat gpt calculates its relevance to the articles found in the documentation based on this relevance calculation, a score is assigned to each keyword, determining its importance in answering the user's query accurately 4\) generating a response using the scored keywords and associated articles, chat gpt formulates a response to the user's question by leveraging the power of language generation, chat gpt provides a coherent and informative answer based on the most relevant articles from the archbee documentation to see the output, go to process chatbot/0 search and check instances click on the question answer action to see the variables used for configuration the variable gptreplytoquestionssql stores the answer that is returned to users in the chatbot 5\) testing and debugging once the chatbot setup is complete, it is essential to thoroughly test and debug the system through the chat interface, you can interact with the chatbot by asking various questions and verifying the accuracy of its responses debugging allows you to examine the input, intermediate steps, and output to ensure the chatbot is functioning as intended conclusion by combining the capabilities of archbee's documentation platform with the conversational prowess of chat gpt, you can build a powerful and intelligent chatbot the seamless integration of archbee and chat gpt enables the retrieval of relevant information from the knowledge base, resulting in accurate and informative responses as you explore this technology further, you can enhance the chatbot's capabilities, incorporate context awareness, and integrate with other systems in your organization start building your conversational chatbot with archbee and chat gpt today and revolutionize how you interact with users and provide them with valuable information