Back to Portfolio

A3E Environmental — New Flo CRM & AI Assistant

Enterprise AI + CRM

A comprehensive platform for A3 Environmental Consultants combining a full-stack CRM (companies, contacts, projects, proposals) with SparkyBot — a natural-language AI assistant in Google Chat powered by LangChain and a custom MCP server framework. Features Gmail sync pipeline, Stripe payments, and a pioneering MCP implementation with 20+ production tools and zero-downtime deployment.

Impact & Results

20+ production tools covering Google Workspace integration
Zero-downtime capability additions
Client independently extending AI assistant features
Enterprise-ready Google Chat integration with persistent memory

Business Impact

Technical Architecture

Industry-leading MCP implementation LangChain agent orchestration Claude.md documentation-driven development Dynamic context injection system Google Chat Cards V2 support Comprehensive E2E testing with Playwright

Challenges & Solutions

Challenge 1

Environmental consultants drowning in manual coordination emails

Solution 1

SparkyBot: natural language AI in Google Chat for daily operations

Challenge 2

Vehicle reservations, field schedules, and timesheets managed through spreadsheets

Solution 2

Dynamic MCP server system with runtime tool management

Challenge 3

No centralized system connecting Google Workspace tools

Solution 3

HTTP wrapper transforming stdio MCP to RESTful services

Challenge 4

Client needed to extend AI capabilities without developer involvement

Solution 4

Claude.md workflow enabling client to extend capabilities

Technology Stack

Python Flask SQLModel SQLAlchemy Alembic Celery Redis PostgreSQL LangChain MCP Protocol Google Cloud Google OAuth Gmail API Google Chat Stripe Socket.IO Playwright