plghubspot-agent

This application syncs HubSpot CRM data (contacts and companies) to a local MySQL database, enriches records using Apollo, ZeroBounce, and Perplexity APIs, and uses AI (OpenAI) to classify commercial real estate contacts into business categories (e.g., "Direct/Developer," "Broker - Debt," "Lender," "PACE Broker"). Enriched and categorized data is then pushed back to HubSpot. The tool is designed for a C-PACE financing business to segment and prioritize leads based on their role in commercial real estate transactions. A web dashboard with authentication was added later to visualize data and manage enrichment suggestions.

Built to automate lead qualification and contact enrichment for a C-PACE (Commercial Property Assessed Clean Energy) financing company. The core problem was categorizing thousands of HubSpot contacts by their business type to prioritize outreach—distinguishing high-value targets (developers, brokers) from low-priority ones (leasing agents, competitors). The classification guide (classification.md) shows the business logic: finding decision-makers with financing authority and identifying PACE-savvy brokers.

Laravel 11 (PHP), MySQL, Blade templates, Tailwind CSS, Vite. Integrates HubSpot API (Private App), OpenAI GPT-4, Apollo.io, ZeroBounce email validation, and Perplexity AI. Includes queue/job system for async enrichment, middleware for authentication and admin roles, and GitHub Actions CI/CD workflow for DreamHost deployment.

Last active Jun 14, 2025 — 18 commits across 3 active days (spanning 28 days).

Developed over a 28-day span with 18 commits concentrated in 3 active days (17 commits in August, 1 in July). The work pattern suggests intensive build sessions focused on implementing features, debugging authentication deployment issues, and adding enrichment services.

This is a functional internal business tool with clear deployment artifacts (DreamHost deployment guide, GitHub Actions workflow, production auth setup command) and comprehensive documentation showing real-world use. The authentication system, admin approval workflow, multi-API enrichment pipeline, and HubSpot bidirectional sync demonstrate a production-ready application. The detailed classification guide and cost-tracking service indicate it was designed for ongoing operational use.