Build a Website Customer Support Chatbot with Groq AI and Google Sheets as its Knowledge Base.
Add Required Credentials:
Configure the Groq Chat Model:
Set Up Your Knowledge Base:
Configure the Google Sheets Node:
Customize the AI Agent:
Test the Chatbot:
Deploy to Your Website:
Your Google Sheet should be structured with clear headers and organized data. Example format:
Question | Answer | Category | Keywords |
---|---|---|---|
How do I reset my password? | To reset your password, click the "Forgot Password" link on the login page and follow the instructions sent to your email. | Account | password, reset, forgot, login |
What are your shipping rates? | Standard shipping is $5.99. Express shipping is $12.99. Orders over $50 qualify for free standard shipping. | Shipping | rates, costs, delivery, free shipping |
How do I return an item? | Returns can be initiated within 30 days of purchase by logging into your account and selecting "Start a Return" in your order history. | Returns | return policy, exchange, refund |
Each row should contain a complete customer query and response pair, with optional categorization and keywords to help the AI find relevant information quickly.
You can use and replace the placeholders in the following code: View on Codepen (external link)
Put the customized Code inside your website's head element (before the </head>
tag).