← Skills

lead-research

Nightly lead research — Upwork jobs + DFW Google Maps prospecting

Lead Research Skill

Purpose

Consolidated lead generation and prospecting operations for Rick (revenue). Covers Upwork prospecting and DFW Google Maps pipeline.

Environment

  • Lead Engine path: C:/Users/Administrator/.openclaw/workspace/leadspanther-lead-engine (alias: $LE)
  • Database: Supabase (accessed via lead-engine CLI)
  • Tier 1 verticals: dental offices, HVAC, plumbing, landscaping, cleaning services, lawyers, accountants

nightly-lead-research

Schedule: 11:00 PM daily | Agent: Rick

Run the nightly lead research cycle:

  1. Upwork prospecting: Search for new lead-gen/CRM/automation jobs posted in last 24h matching our ICP. Use upwork-prospector skill. Filter: $500-5,000 budget, client has spend history.
  2. DFW import: Run lead-engine import for DFW metro area — target one Tier 1 vertical (rotate daily: dental, HVAC, plumbing, landscaping, cleaning, lawyers, accountants):
    npm --prefix $LE run import:google-maps -- --query '[vertical]' --counties 'Tarrant,Dallas,Collin,Denton' --pages 2
  3. Enrichment pipeline:
    npm --prefix $LE run enrich:places-details -- --limit 200 npm --prefix $LE run enrich:emails -- --limit 100 npm --prefix $LE run analyze:gbp -- --limit 1000 npm --prefix $LE run compute:ready -- --limit 5000
  4. Score leads: Against Pain + Budget ($5K+) + Access framework using DB data
  5. Query pipeline: npm --prefix $LE run query:pipeline -- --ready --recent 1 to find today's outreach-ready leads
  6. Flag top 3 hottest prospects for morning brief
  7. Report results to Alfred via Telegram

dfw-prospecting

Schedule: 9:00 PM daily | Agent: Rick

Run Google Maps prospecting for DFW metro area:

  1. Vertical rotation: Use a different Tier 1 vertical each day (rotate through the list)
  2. Import:
    npm --prefix $LE run import:google-maps -- --query '[vertical]' --counties 'Tarrant,Dallas,Collin,Denton,Johnson,Wise,Parker' --pages 2
  3. Enrichment:
    npm --prefix $LE run enrich:places-details -- --limit 200 npm --prefix $LE run enrich:emails -- --limit 100 npm --prefix $LE run analyze:gbp -- --limit 1000 npm --prefix $LE run compute:ready -- --limit 5000
  4. Query new leads: npm --prefix $LE run query:pipeline -- --ready --recent 1 --verbose
  5. Score: Pain + Budget ($5K+) + Access framework
  6. Report results to Alfred via Telegram with DB metrics
View raw SKILL.md
# Lead Research Skill

## Purpose
Consolidated lead generation and prospecting operations for Rick (revenue). Covers Upwork prospecting and DFW Google Maps pipeline.

## Environment
- Lead Engine path: `C:/Users/Administrator/.openclaw/workspace/leadspanther-lead-engine` (alias: `$LE`)
- Database: Supabase (accessed via lead-engine CLI)
- Tier 1 verticals: dental offices, HVAC, plumbing, landscaping, cleaning services, lawyers, accountants

## nightly-lead-research
**Schedule**: 11:00 PM daily | **Agent**: Rick

Run the nightly lead research cycle:
1. **Upwork prospecting**: Search for new lead-gen/CRM/automation jobs posted in last 24h matching our ICP. Use upwork-prospector skill. Filter: $500-5,000 budget, client has spend history.
2. **DFW import**: Run lead-engine import for DFW metro area — target one Tier 1 vertical (rotate daily: dental, HVAC, plumbing, landscaping, cleaning, lawyers, accountants):
   ```
   npm --prefix $LE run import:google-maps -- --query '[vertical]' --counties 'Tarrant,Dallas,Collin,Denton' --pages 2
   ```
3. **Enrichment pipeline**:
   ```
   npm --prefix $LE run enrich:places-details -- --limit 200
   npm --prefix $LE run enrich:emails -- --limit 100
   npm --prefix $LE run analyze:gbp -- --limit 1000
   npm --prefix $LE run compute:ready -- --limit 5000
   ```
4. **Score leads**: Against Pain + Budget ($5K+) + Access framework using DB data
5. **Query pipeline**: `npm --prefix $LE run query:pipeline -- --ready --recent 1` to find today's outreach-ready leads
6. **Flag top 3** hottest prospects for morning brief
7. Report results to Alfred via Telegram

## dfw-prospecting
**Schedule**: 9:00 PM daily | **Agent**: Rick

Run Google Maps prospecting for DFW metro area:
1. **Vertical rotation**: Use a different Tier 1 vertical each day (rotate through the list)
2. **Import**:
   ```
   npm --prefix $LE run import:google-maps -- --query '[vertical]' --counties 'Tarrant,Dallas,Collin,Denton,Johnson,Wise,Parker' --pages 2
   ```
3. **Enrichment**:
   ```
   npm --prefix $LE run enrich:places-details -- --limit 200
   npm --prefix $LE run enrich:emails -- --limit 100
   npm --prefix $LE run analyze:gbp -- --limit 1000
   npm --prefix $LE run compute:ready -- --limit 5000
   ```
4. **Query new leads**: `npm --prefix $LE run query:pipeline -- --ready --recent 1 --verbose`
5. **Score**: Pain + Budget ($5K+) + Access framework
6. Report results to Alfred via Telegram with DB metrics