Exploit for kog-bonds-poc

## https://sploitus.com/exploit?id=7DED9958-CEC1-56F3-8CB4-F1C5C57E75E7
# KOG Bonds POC Agent

Complete proof-of-concept demonstrating end-to-end automated outbound marketing for surety bond services targeting MWBE and SDVOB certified construction contractors.

## POC Objective

Build a **working demonstration** of automated contractor outreach to secure the full commercial project from KOG International.

**POC Success Criteria:**
- ✅ Scrape 50-100 real contractors from MWBE + SDVOB databases
- ✅ AI-enrich all contractors with profiles, contacts, and scores
- ✅ Send automated email campaigns (demo to KOG team)
- ✅ Demonstrate response handling with AI analysis
- ✅ Generate comprehensive analytics report

## Architecture

```
Source Files → Parser → Multi-Database Scraper → Deduplicator
                              ↓
                     Google Sheets Database
                              ↓
                     Enrichment Agent (AI)
                              ↓
                     Campaign Agent (Personalized Emails)
                              ↓
                     Response Agent (AI Analysis)
                              ↓
                     Reporting Agent (Executive Summary)
```

## Features

### 1. Multi-Source Scraping
- NYC SBS Connect Directory (MWBE)
- VA VetBiz Directory (SDVOB)
- NYS Certified MWBE Directory
- Automatic deduplication
- Google Sheets storage

### 2. AI-Powered Enrichment (3 Templates)
- **Company Profile:** Revenue, specialties, certifications
- **Contact Extraction:** Emails, phones, decision makers
- **Qualification Scoring:** 0-100 score + tier classification

### 3. Personalized Email Campaigns
- **Tier 1 (70-100):** High-touch personalized outreach
- **Tier 2 (50-69):** Educational resource sharing
- **Tier 3 (30-49):** Awareness building
- AI-generated personalization for each contractor

### 4. Response Intelligence
- Sentiment analysis (Interested/Question/Not Now/etc.)
- Urgency assessment
- Buying signal detection
- Auto-generated reply suggestions

### 5. Executive Reporting
- Comprehensive metrics
- Google Sheets dashboard
- Email to management
- Production roadmap

## Installation

### Prerequisites
- Python 3.8+
- Google Cloud Project (for Sheets API)
- Firecrawl API key
- Anthropic API key

### Setup

1. **Clone/Navigate to project:**
```bash
cd /Users/sivam1mac/Projects/kog-bonds-poc
```

2. **Install dependencies:**
```bash
pip install firecrawl-py anthropic gspread google-auth pandas python-dotenv beautifulsoup4 lxml
```

3. **Configure environment:**
```bash
cp .env.template .env
# Edit .env and add your API keys
```

4. **Set up Google Sheets:**
- Create a Google Cloud Project
- Enable Google Sheets API + Google Drive API
- Create a Service Account
- Download credentials JSON
- Update `GOOGLE_SHEETS_CREDENTIALS_PATH` in `.env`

## Configuration

Edit `config.json` to customize:

```json
{
  "poc_settings": {
    "contractor_limit": 50,
    "demo_email_recipients": ["your-email@kogbonds.com"],
    "google_sheet_name": "KOG POC Contractors",
    "source_files": ["path/to/html/files"],
    "target_databases": {
      "nyc_sbs": {...},
      "va_vetbiz": {...}
    }
  }
}
```

## Usage

### Run Complete POC

```bash
python3 kog_poc_agent.py
```

This executes all 6 stages:
1. Foundation Setup (Google Sheets)
2. Scraping (50-100 contractors)
3. Enrichment (AI-powered)
4. Email Campaigns (personalized)
5. Response Handling (AI analysis)
6. Reporting (executive summary)

### Resume from Cache

If interrupted, the agent automatically resumes from the last checkpoint:
```bash
python3 kog_poc_agent.py
```

Cached data is stored in `processed_contractors.json`.

## Output

### Google Sheets Database
Columns (26 total):
- Contractor identification (ID, name, website)
- Contact information (email, phone, address)
- Certification details (MWBE, SDVOB, etc.)
- Enrichment data (revenue, specialties, NAICS)
- Qualification scoring (0-100 score, tier)
- Campaign tracking (emails sent, responses)
- Demo status

### Executive Report
Saved as: `POC_Report_YYYYMMDD_HHMMSS.txt`

Sections:
- Executive Summary
- Data Quality Metrics
- Campaign Performance
- Response Intelligence
- Production Roadmap

## Project Structure

```
kog-bonds-poc/
├── kog_poc_agent.py              # Main orchestrator (800 lines)
├── config.json                   # Configuration
├── enrichment_templates.json     # AI enrichment prompts
├── email_templates.json          # Email templates (3 tiers)
├── .env                          # API keys (never commit)
├── .env.template                 # Template for .env
├── processed_contractors.json    # Cache file
├── logs/                         # Execution logs
└── README.md                     # This file
```

## API Usage & Costs

### POC Costs (~$50-100)
- **Firecrawl:** ~$20-40 (50-100 scrapes + searches)
- **Claude API:** ~$30-60 (150-300 API calls)

### Production Costs (~$220-320/month)
- **Firecrawl Pro:** $49/month
- **Claude API:** $150-250/month (2000+ contractors)
- **SendGrid:** $19.95/month (2000-5000 emails)

## Troubleshooting

### "No contractors scraped"
- Check Firecrawl API key
- Verify source HTML files exist
- Review rate limits

### "Enrichment failed"
- Check Claude API key
- Verify website URLs are valid
- Check API rate limits

### "Google Sheets error"
- Verify service account credentials
- Check Sheet name in config
- Ensure API is enabled in Google Cloud

## Demo Script

For KOG presentation:

1. **Show Google Sheets** (5 min)
   - 50-100 contractors
   - Enriched data quality
   - Tier distribution

2. **Email Examples** (5 min)
   - Personalization quality
   - Tier-based messaging

3. **Response Intelligence** (5 min)
   - AI analysis examples
   - Sentiment detection

4. **Dashboard Metrics** (5 min)
   - Funnel visualization
   - Top leads

5. **Production Roadmap** (5 min)
   - Scale to 2000+ contractors
   - Expected outcomes

## Production Roadmap

### Phase 1: Database Expansion (4 weeks)
- All 50 state MWBE/SDVOB databases
- Target: 2,000+ contractors
- Daily automated scraping

### Phase 2: Campaign Automation (4 weeks)
- SendGrid integration
- UTM tracking
- A/B testing

### Phase 3: Response Management (4 weeks)
- Gmail monitoring (MCP)
- Real-time AI analysis
- CRM integration
- Sales rep notifications

### Expected Outcomes
- **100+ qualified responses/month**
- **20+ proposals/month**
- **5-10 deals/month**
- **10:1 revenue to cost ratio**

## Support

For questions or issues:
- Email: siva@progrowth.services
- Company: ProGrowth Marketing

## License

Proprietary - KOG International POC
© 2026 ProGrowth Marketing