website logo
🔭Overview
💼Platform Actions
💜Integrations
🧰Custom Actions
🛠️Developer's Guide
Navigate through spaces
⌘K
🔗Integrations
📄Integrations
📗OAuth2 - Google Sheets
📗Gmail - outgoing
📗Gmail - incoming
📗SendSMS
📗SMSO
📗WebFlow
📗Typeform
📗SendGrid
📗GetGist
📗SendinBlue
📗Airtable
📗Yahoo
📗SmartSheet
📗Microsoft Outlook
📗Hubspot
📗Google Sheets
💯Demos
📘Build a Conversational Chatbot with Archbee and Chat GPT
📘Google Forms & PROCESIO
📘Using the Document Designer to send customized emails.
📘Audio to Text using OpenAI's Whisper
📘How to Track read emails?
📘HubSpot contacts analytics
📘How to integrate with JIRA to create tickets
📘How to create an order confirmation process
📘Typeform + PROCESIO +Airtable
📘Webflow + PROCESIO + Airtable integration
📘Sending criteria based alerts to contacts from an excel workbook
📘How to integrate with UIPath robots
📘How to extract e-mail addresses from websites
📘SenseTask OCR integration + notifications
Retry Process that fails
📘FTP to FTP transfer
Articles
Docs powered by
Archbee
Demos

Build a Conversational Chatbot with Archbee and Chat GPT

18min


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.

Document image


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.

ConversationalChatBot.zip

Document image


The below processes will be imported into your workspace, together with others (4 credentials and a data model) in order for everything to work.

Document image


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

Useful selects.sql: 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.

Document image


See below how you can find the Organization for your OpenAI account:

Document image


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:



Document image


To get a docSpaceId you can go to document info and copy the Doc Space Id value:

Document image


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.

Document image


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:

Document image


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.

Updated 13 Jun 2023
Did this page help you?
PREVIOUS
Google Sheets
NEXT
Google Forms & PROCESIO
Docs powered by
Archbee
TABLE OF CONTENTS
Step 1: Import the .procesio file into your workspace
Step 1: Setting up the database, Archbee and Chat GPT connections
Step 2: Connecting Archbee and Chat GPT
Congrats! You can now run and test your configuration! 🎉
Once you hit run, this is what will happen behind the scenes:
1) Deconstructing User Queries
2) Searching and Caching Articles
3) Calculating Relevance and Scoring
4) Generating a Response
5) Testing and Debugging
Conclusion:
Docs powered by
Archbee