Apollo Fails for Local SMBs: What Actually Works

import requests

def find_local_businesses(query: str, location: str) -> list:
    """Find local SMBs using Google Maps search data."""
    resp = requests.post(
        "https://api.scavio.dev/api/v1/search",
        headers={"x-api-key": "YOUR_KEY"},
        json={
            "query": f"{query} {location}",
            "num_results": 20
        }
    )
    data = resp.json()

    # Extract local pack results (Google Maps listings)
    local_results = data.get("local_results", [])
    return [
        {
            "name": r.get("title", ""),
            "address": r.get("address", ""),
            "phone": r.get("phone", ""),
            "website": r.get("website", ""),
            "rating": r.get("rating", ""),
            "reviews": r.get("reviews_count", 0)
        }
        for r in local_results
    ]

# Find plumbers in Austin
businesses = find_local_businesses("plumbers", "Austin TX")
for b in businesses:
    print(f"{b['name']}")
    print(f"  Phone: {b['phone']} | Rating: {b['rating']}")
    print(f"  Website: {b['website']}")

// Generate SMB lead list for a specific niche + location
async function buildSmBLeadList(category, locations) {
  const leads = [];

  for (const loc of locations) {
    const resp = await fetch("https://api.scavio.dev/api/v1/search", {
      method: "POST",
      headers: {
        "x-api-key": process.env.SCAVIO_KEY,
        "Content-Type": "application/json"
      },
      body: JSON.stringify({
        query: category + " " + loc,
        num_results: 20
      })
    });

    const data = await resp.json();
    const localResults = data.local_results || [];

    for (const r of localResults) {
      leads.push({
        name: r.title,
        location: loc,
        phone: r.phone || "",
        website: r.website || "",
        rating: r.rating,
        reviews: r.reviews_count || 0,
        hasWebsite: Boolean(r.website)
      });
    }
  }

  return leads;
}

const leads = await buildSmBLeadList("HVAC contractors", [
  "Austin TX", "Dallas TX", "Houston TX"
]);

// Filter: businesses with website but low reviews (need marketing help)
const prospects = leads.filter(l => l.hasWebsite && l.reviews < 20);
console.log("Prospects:", prospects.length);

Tool        | SMB coverage | Cost/mo | Data quality
Apollo      | Poor         | $49+    | Stale for SMBs
Google Maps | Excellent    | $0.005/q| Live data
Outscraper  | Good         | $25+    | Monthly scrape
Scavio API  | Excellent    | $30=7K  | Live SERP data