AI Customer Support Chat for Web Hosting with Google Gemini & WHMCS

This n8n template implements a Customer Support Chat Agent for Web Hosting Companies with Google Gemini, Google Sheets Knowledge base and WHMCS API to Check Domain Name Availability Who's it for This template is designed for web hosting companies, domain registrars, and IT service providers who want to automate their customer support with an AI-powered chatbot. It's perfect for businesses looking to provide 24/7 customer assistance for hosting plans, domain services, and technical support while maintaining a professional, human-like interaction experience. How it works / What it does This workflow creates an AI-powered customer support chatbot that provides comprehensive assistance for web hosting and domain services. The AI agent (named Matt) automatically: 1. Receives customer queries through a webhook endpoint 2. Captures customer information (name and email) at the start of each session 3. Processes natural language requests using Google Gemini AI 4. Accesses real-time information from multiple Google Sheets knowledge bases: - Shared Hosting Plans (pricing, features, specifications) - Domain Prices (registration, transfer, renewal costs) - Hosting Features (technical capabilities and specifications) - FAQs (common questions and answers) - Payment Method Details (accepted payment options) - Company Offerings (available products and services) 5. Checks domain availability via WHMCS API integration 6. Provides accurate, contextual responses based on the knowledge base 7. Maintains conversation history with session-based memory 8. Stores complete chat sessions in Google Sheets for analysis and follow-up The system ensures 100% accuracy by only providing information that exists in the knowledge base, eliminating guesswork and maintaining brand consistency. How to set up 1. Configure Google Sheets Knowledge Base - Set up a Google Sheets document with the following sheets: - SharedHostingPlans: Hosting plan details, pricing, and specifications - DomainPrices: Domain registration and renewal pricing - HostingFeatures: Technical features and capabilities - FAQs: Frequently asked questions and answers - PaymentMethodDetails: Payment options and instructions - Offerings: Available products and services - Update the Google Sheets credentials in each tool node 2. Set up Google Gemini API - Configure your Google Gemini API credentials in the Google Gemini Chat Model node - Ensure you have sufficient API quota for your expected usage 3. Configure WHMCS API (Optional) - Replace YourWHMCSIdentifier with your actual WHMCS API identifier - Replace YourWHMCSSecret with your actual WHMCS API secret - Update https://yourwhmcsurl.com/includes/api.php with your WHMCS domain - This enables domain availability checking for customers 4. Set up Chat Storage - Create a Google Sheet for storing chat inquiries - Update the document ID and credentials in the ChatInquiries node - This will automatically store all customer conversations for analysis 5. Deploy the Webhook - The workflow creates a unique webhook endpoint for receiving customer queries - Use this endpoint URL in your customer-facing application or chat interface Requirements - Google Sheets account with the knowledge base set up - Google Gemini API account with appropriate credentials - n8n instance (self-hosted or cloud) - WHMCS installation (optional, for domain availability checking) - Web hosting or domain services business How to customize the workflow Modify AI Agent Behavior - Edit the system message in the AI Agent node to change the bot's personality and response style - Adjust response length and tone to match your brand voice - Customize the agent's name (currently "Matt") Enhance Knowledge Base - Add more Google Sheets tools for additional information sources - Include product catalogs, pricing tables, or technical documentation - Add multi-language support for international customers Improve Customer Experience - Add domain suggestion algorithms based on customer input - Integrat