GB ⚙️| Record Keeper 📝

GB ⚙️| Record Keeper 📝 Workflow Overview This workflow automates the processing and archival of pool maintenance service reports. It acts as a central data processor that receives maintenance data from a field technician, enriches it using Artificial Intelligence, performs complex calculations, and then systematically stores the complete, enhanced record in an Airtable CRM. The primary value is the complete automation of administrative tasks associated with logging service visits. It eliminates manual data entry, standardizes record-keeping, and generates valuable insights (summarized notes, water balance index) that would otherwise require significant manual effort and specialized knowledge. Technologies Used - n8n: The core automation platform coordinating the entire process. - Webhook: Serves as the entry point, receiving data from an external source (e.g., a form app like Zoho Forms). - Airtable: The destination database/CRM where the final, processed records are stored. - AI (LangChain Agents): AI is used for two distinct, value-add tasks: - OpenRouter (o3-mini): Powers a summarization agent. - Anthropic (Claude): Powers a specialized calculation agent. - LangChain Tools (Calculator): An AI tool used to ensure mathematical accuracy for complex calculations. How AI Integrates into the Flow This workflow uses two distinct AI agents to intelligently process and enrich the incoming data: 1. AI-Powered Technician Note Summarization An AI agent, the Technician Notes Overseer, is tasked with reading the raw, unstructured notes submitted by a field technician. Using a system prompt that defines its role as a "modern summarization AI," it condenses these notes into a concise, professional overview. This process is crucial for transforming informal field jargon and observations into a clean, easily digestible summary for the CRM, ensuring that important details, customer requests, or noted issues are highlighted and not lost in the raw text. 2. AI-Driven Scientific Calculation (LSI) A second, highly specialized AI agent, the LSI Calculator, performs a complex scientific calculation known as the Langelier Saturation Index (LSI).