Cómo crear una lista de leads locales en Claude Code con Scavio MCP

import csv
import os
from urllib.parse import urlparse
import requests

API_KEY = os.environ["SCAVIO_API_KEY"]
CITIES = ["Austin", "Dallas", "Houston", "San Antonio", "Fort Worth"]
TRADE = "plumbers"

def search(query):
    r = requests.post(
        "https://api.scavio.dev/api/v1/google",
        headers={"Authorization": f"Bearer {API_KEY}"},
        json={"query": query, "light_request": False},
        timeout=60,
    )
    r.raise_for_status()
    return r.json().get("organic", [])

def domain(url):
    return urlparse(url).netloc.lower().replace("www.", "")

seen = set()
rows = []
for city in CITIES:
    for item in search(f"{TRADE} in {city}"):
        link = item.get("link", "")
        d = domain(link)
        if not d or d in seen:
            continue
        seen.add(d)
        rows.append({
            "business_name": item.get("title", ""),
            "website": link,
            "city": city,
            "snippet": item.get("snippet", ""),
        })

with open("leads.csv", "w", newline="", encoding="utf-8") as f:
    w = csv.DictWriter(f, fieldnames=["business_name", "website", "city", "snippet"])
    w.writeheader()
    w.writerows(rows)

print(f"Wrote {len(rows)} leads to leads.csv")

import fs from "node:fs";

const API_KEY = process.env.SCAVIO_API_KEY;
const CITIES = ["Austin", "Dallas", "Houston", "San Antonio", "Fort Worth"];
const TRADE = "plumbers";

async function search(query) {
  const res = await fetch("https://api.scavio.dev/api/v1/google", {
    method: "POST",
    headers: {
      "Authorization": `Bearer ${API_KEY}`,
      "Content-Type": "application/json",
    },
    body: JSON.stringify({ query, light_request: false }),
  });
  if (!res.ok) throw new Error(`HTTP ${res.status}`);
  const data = await res.json();
  return data.organic || [];
}

function domain(url) {
  try {
    return new URL(url).hostname.toLowerCase().replace("www.", "");
  } catch {
    return "";
  }
}

const seen = new Set();
const rows = [];
for (const city of CITIES) {
  const results = await search(`${TRADE} in ${city}`);
  for (const item of results) {
    const link = item.link || "";
    const d = domain(link);
    if (!d || seen.has(d)) continue;
    seen.add(d);
    rows.push({ business_name: item.title || "", website: link, city, snippet: item.snippet || "" });
  }
}

const header = "business_name,website,city,snippet\n";
const body = rows
  .map((r) => [r.business_name, r.website, r.city, r.snippet].map((v) => `"${String(v).replace(/"/g, '""')}"`).join(","))
  .join("\n");
fs.writeFileSync("leads.csv", header + body);
console.log(`Wrote ${rows.length} leads to leads.csv`);

business_name,website,city,snippet
Daniel's Plumbing & Air Conditioning,https://danielsaustin.com,Austin,"24/7 plumbing repair and water heater installation in Austin, TX."
Reliant Plumbing,https://reliantplumbing.com,Austin,"Same-day plumbers serving Austin and surrounding areas."
Baker Brothers Plumbing,https://bakerbrothersplumbing.com,Dallas,"Licensed plumbers in Dallas-Fort Worth since 1945."
Abacus Plumbing,https://abacusplumbing.net,Houston,"Award-winning plumbing, AC, and electrical in Houston."

Wrote 47 leads to leads.csv