GB | MikeBot

AI-Powered Pool Maintenance Operations Chatbot This workflow, named "GB | MikeBot," is an advanced AI-powered chatbot designed to streamline the daily operational management of a pool maintenance company. It acts as an intelligent assistant for a manager, allowing them to interact with their business data in a conversational way. Instead of manually navigating spreadsheets or a CRM, a manager can simply chat with the bot to get information, reassign work, and manage daily schedules. The core value of this automation is its ability to handle dynamic, real-world operational changes, such as an employee's unexpected absence. The AI can understand a request like "Jacob is out today, reassign his pools evenly," and then use its tools to execute the complex database updates required to rebalance the workload among the remaining employees, saving significant administrative time and reducing errors. Technologies & Services - n8n: The central platform for coordinating the entire workflow logic. - LangChain: The framework used to build the AI agent, providing it with reasoning capabilities, memory, and access to tools. - OpenRouter / ChatGPT: The Large Language Model (LLM) that serves as the "brain" of the AI, enabling natural language understanding and planning. - Airtable: Acts as the primary database (CRM) for storing all business data, including employee lists, customer details, and daily service routes. - Mapbox: Used to generate static map images for visualizing customer locations or daily routes. AI Integration: The Conversational Core The workflow's intelligence is centered around the GB Assistant, an AI Agent built with n8n's LangChain nodes. This is not just a simple question-and-answer bot; it's an agent that can reason and take action. 1. Understanding Intent: When a user sends a message (e.g., "Show me Will's list for today"), the ChatGPT model analyzes the text to understand the user's goal. 2. Planning & Tool Selection: The GB Assistant agent then consults its detailed system prompt, which contains rules, examples, and a list of available tools. It formulates a plan to fulfill the request.