Skip to content

getaero-io/gtm-eng-skills / skills/deepline-gtm

deepline-gtm

Unverified

GTM leads, enrichment, outreach, Plays, developer signals/Reo.dev. Providers: adyntel,affinity,ai_ark,akta,allegrow,amplemarket,apify,attention,attio,aviato,bettercontact,bigquery,bluesky,bounceban,brave,browserbase,builtwith,buyercaddy,cbinsights,clay,clickhouse,close,cloudflare,contactout,contextdev,crunchbase,crustdata-v3,customer_db,databricks,dataforseo,datagma,dealroom,deepline_ip_to_company,deepline_native,deeplineagent,deepseek,discolike,dnb,edges,emailbison,emailguard,enformion,enigma,exa,findymail,firecrawl,fireflies,firmable,forager,fullenrich,fundable,generic_http,getleads,gong,google_ads_audiences,google_workspace,govfiles,grain,hackernews,harvestapi,heyreach,hubspot,hunter,icypeas,instantly,intercom,ipqs,kaspr,kernel,kickbox,leadmagic,lemlist,limadata,linkedin_ads_audiences,luma,lusha,meerapi,meta_audiences,millionverifier,nooks,notion,openmart,opensosdata,openwebninja,outreach,parallel,particle,peopledatalabs,pitchbook,podscan,polymarket,postgres,predictleads,prospeo,quickenrich,rapidapi,….

FileKindSize
SKILL.mdskill md15.9 KB
claude-deepline-statusline.mjsexecutablescript25.0 KB
prompts.jsonconfig297.9 KB
provider-playbooks/adyntel.mdmarkdown1.2 KB
provider-playbooks/affinity.mdmarkdown825 B
provider-playbooks/ai-ark.mdmarkdown10.6 KB
provider-playbooks/akta.mdmarkdown1.5 KB
provider-playbooks/allegrow.mdmarkdown4.6 KB
provider-playbooks/amplemarket.mdmarkdown2.8 KB
provider-playbooks/apify.mdmarkdown1.8 KB
provider-playbooks/attention.mdmarkdown449 B
provider-playbooks/attio.mdmarkdown5.6 KB
provider-playbooks/aviato.mdmarkdown756 B
provider-playbooks/bettercontact.mdmarkdown1.7 KB
provider-playbooks/bigquery.mdmarkdown1019 B
provider-playbooks/bloomberry.mdmarkdown935 B
provider-playbooks/bluesky.mdmarkdown139 B
provider-playbooks/bounceban.mdmarkdown1.6 KB
provider-playbooks/brave.mdmarkdown422 B
provider-playbooks/browserbase.mdmarkdown1.0 KB
provider-playbooks/builtwith.mdmarkdown1.0 KB
provider-playbooks/buyercaddy.mdmarkdown2.3 KB
provider-playbooks/cbinsights.mdmarkdown436 B
provider-playbooks/clay.mdmarkdown875 B
provider-playbooks/clickhouse.mdmarkdown1.1 KB
provider-playbooks/close.mdmarkdown2.6 KB
provider-playbooks/cloudflare.mdmarkdown2.3 KB
provider-playbooks/contactout.mdmarkdown8.3 KB
provider-playbooks/contextdev.mdmarkdown582 B
provider-playbooks/crunchbase.mdmarkdown742 B
provider-playbooks/crustdata-v2.mdmarkdown490 B
provider-playbooks/crustdata-v3.mdmarkdown8.4 KB
provider-playbooks/crustdata.mdmarkdown6.8 KB
provider-playbooks/databricks.mdmarkdown3.5 KB
provider-playbooks/dataforseo.mdmarkdown950 B
provider-playbooks/datagma.mdmarkdown6.0 KB
provider-playbooks/dealroom.mdmarkdown632 B
provider-playbooks/deepline-ip-to-company.mdmarkdown480 B
provider-playbooks/deepline-native-osint.mdmarkdown1.5 KB
provider-playbooks/deepline-native.mdmarkdown25.1 KB
provider-playbooks/deeplineagent.mdmarkdown2.7 KB
provider-playbooks/deepseek.mdmarkdown1.2 KB
provider-playbooks/discolike.mdmarkdown6.2 KB
provider-playbooks/dnb.mdmarkdown1.4 KB
provider-playbooks/dropleads.mdmarkdown10.2 KB
provider-playbooks/edges.mdmarkdown875 B
provider-playbooks/emailbison.mdmarkdown634 B
provider-playbooks/emailguard.mdmarkdown243 B
provider-playbooks/enformion.mdmarkdown9.3 KB
provider-playbooks/enigma.mdmarkdown1.7 KB
provider-playbooks/exa.mdmarkdown1.4 KB
provider-playbooks/file-transport.mdmarkdown739 B
provider-playbooks/findymail.mdmarkdown880 B
provider-playbooks/firecrawl.mdmarkdown2.4 KB
provider-playbooks/fireflies.mdmarkdown988 B
provider-playbooks/firmable.mdmarkdown1.3 KB
provider-playbooks/forager.mdmarkdown2.3 KB
provider-playbooks/fullenrich.mdmarkdown2.1 KB
provider-playbooks/fundable.mdmarkdown2.0 KB
provider-playbooks/generic-http.mdmarkdown348 B
provider-playbooks/getleads.mdmarkdown2.2 KB
provider-playbooks/gong.mdmarkdown488 B
provider-playbooks/google-ads-audiences.mdmarkdown2.0 KB
provider-playbooks/google-calendar-availability.mdmarkdown1.6 KB
provider-playbooks/google-calendar.mdmarkdown1.1 KB
provider-playbooks/google-sheets.mdmarkdown842 B
provider-playbooks/google-workspace.mdmarkdown2.1 KB
provider-playbooks/govfiles.mdmarkdown1.8 KB
provider-playbooks/grain.mdmarkdown1.0 KB
provider-playbooks/hackernews.mdmarkdown208 B
provider-playbooks/harvestapi.mdmarkdown3.5 KB
provider-playbooks/heyreach.mdmarkdown1.6 KB
provider-playbooks/hubspot.mdmarkdown3.3 KB
provider-playbooks/hunter.mdmarkdown849 B
provider-playbooks/icypeas.mdmarkdown1.8 KB
provider-playbooks/instantly.mdmarkdown1.6 KB
provider-playbooks/integration-operation.mdmarkdown704 B
provider-playbooks/intercom.mdmarkdown275 B
provider-playbooks/ipqs.mdmarkdown1.7 KB
provider-playbooks/kaspr.mdmarkdown822 B
provider-playbooks/kernel.mdmarkdown875 B
provider-playbooks/leadmagic.mdmarkdown5.3 KB
provider-playbooks/lemlist.mdmarkdown7.5 KB
provider-playbooks/limadata.mdmarkdown636 B
provider-playbooks/linkedin-ads-audiences.mdmarkdown629 B
provider-playbooks/luma.mdmarkdown3.2 KB
provider-playbooks/lusha.mdmarkdown3.5 KB
provider-playbooks/meerapi.mdmarkdown1.2 KB
provider-playbooks/meta-audiences.mdmarkdown4.8 KB
provider-playbooks/millionverifier.mdmarkdown618 B
provider-playbooks/nooks.mdmarkdown1.0 KB
provider-playbooks/notion.mdmarkdown724 B
provider-playbooks/openmart.mdmarkdown2.3 KB
provider-playbooks/opensosdata.mdmarkdown4.0 KB
provider-playbooks/openwebninja.mdmarkdown315 B
provider-playbooks/outreach.mdmarkdown2.6 KB
provider-playbooks/parallel.mdmarkdown4.4 KB
provider-playbooks/particle.mdmarkdown2.0 KB
provider-playbooks/peopledatalabs.mdmarkdown4.5 KB
provider-playbooks/pipedrive.mdmarkdown582 B
provider-playbooks/pitchbook.mdmarkdown606 B
provider-playbooks/podscan.mdmarkdown2.7 KB
provider-playbooks/polymarket.mdmarkdown2.2 KB
provider-playbooks/postgres.mdmarkdown553 B
provider-playbooks/predictleads.mdmarkdown622 B
provider-playbooks/prospeo.mdmarkdown2.4 KB
provider-playbooks/quickenrich.mdmarkdown595 B
provider-playbooks/rapidapi.mdmarkdown2.5 KB
provider-playbooks/rb2b.mdmarkdown247 B
provider-playbooks/redshift.mdmarkdown763 B
provider-playbooks/reo-write.mdmarkdown1.6 KB
provider-playbooks/reo.mdmarkdown2.0 KB
provider-playbooks/resend.mdmarkdown3.6 KB
provider-playbooks/salesforce.mdmarkdown3.6 KB
provider-playbooks/salesforge.mdmarkdown274 B
provider-playbooks/salesloft.mdmarkdown1.0 KB
provider-playbooks/scrapecreators.mdmarkdown3.4 KB
provider-playbooks/searchbug.mdmarkdown637 B
provider-playbooks/sec-edgar.mdmarkdown1.6 KB
provider-playbooks/sentrion.mdmarkdown737 B
provider-playbooks/serper.mdmarkdown1011 B
provider-playbooks/slack.mdmarkdown21.1 KB
provider-playbooks/smartleads.mdmarkdown11.8 KB
provider-playbooks/snitcher.mdmarkdown302 B
provider-playbooks/snowflake.mdmarkdown768 B
provider-playbooks/socrata.mdmarkdown3.2 KB
provider-playbooks/sumble.mdmarkdown1.3 KB
provider-playbooks/tamradar.mdmarkdown1.4 KB
provider-playbooks/test-unhinted.mdmarkdown505 B
provider-playbooks/test.mdmarkdown254 B
provider-playbooks/theirstack.mdmarkdown4.4 KB
provider-playbooks/theswarm.mdmarkdown1.4 KB
provider-playbooks/treg.mdmarkdown1.5 KB
provider-playbooks/trestle.mdmarkdown3.7 KB
provider-playbooks/trykitt.mdmarkdown862 B
provider-playbooks/twitterapi.mdmarkdown3.6 KB
provider-playbooks/unipile.mdmarkdown4.8 KB
provider-playbooks/upcell.mdmarkdown715 B
provider-playbooks/vector.mdmarkdown257 B
provider-playbooks/versium.mdmarkdown690 B
provider-playbooks/wiza.mdmarkdown2.0 KB
provider-playbooks/wizleads.mdmarkdown1.1 KB
provider-playbooks/zerobounce.mdmarkdown1.3 KB
provider-playbooks/zoho-crm.mdmarkdown630 B
provider-playbooks/zoominfo.mdmarkdown1.2 KB
recipes/account-orgchart.mdmarkdown35.6 KB
recipes/build-tam.mdmarkdown3.7 KB
recipes/clay-to-deepline.mdmarkdown26.8 KB
recipes/deepline-monitors.mdmarkdown32.5 KB
recipes/developer-signals.mdmarkdown14.7 KB
recipes/find-qualified-titles.mdmarkdown5.2 KB
recipes/portfolio-prospecting.mdmarkdown3.6 KB
recipes/small-business-prospecting.mdmarkdown3.0 KB
references/clay-action-mappings.mdmarkdown40.0 KB
references/clay-api-surface.mdmarkdown18.6 KB
references/clay-extraction.mdmarkdown16.2 KB
references/industry-radars.mdmarkdown3.3 KB
references/monitor-contract-reference.mdmarkdown25.9 KB
references/monitor-operations.mdmarkdown12.4 KB
references/monitor-sdk.mdmarkdown3.2 KB
references/run-events.mdmarkdown14.3 KB
scripts/clay-extract-bookmarklet.jsscript10.5 KB
scripts/clay-extract-bookmarklet.url.txtmarkdown8.2 KB
scripts/clay-extract.pyscript17.9 KB
scripts/clay-har-miner.pyscript5.8 KB
scripts/clay-to-deepline.mjsscript134.1 KB
scripts/contact-accuracy-audit.pyscript8.9 KB
scripts/fixtures_contact_accuracy_audit.jsonconfig5.5 KB
scripts/fixtures_current_role.jsonconfig10.3 KB
scripts/flatten-search-contact-persons.pyscript3.3 KB
scripts/select-current-role.pyscript12.2 KB
scripts/validate-emails.pyexecutablescript2.0 KB
skill-metadata.jsonconfig2.2 KB
writing-outreach.mdmarkdown14.1 KB

scripts/clay-extract.py

View on GitHub
#!/usr/bin/env python3
"""
Clay Table Config Extractor

Extracts Clay table configs (fields, prompts, action settings, sample records)
via Clay's internal API.

Usage:
    # First time: paste a cURL from Chrome DevTools to save your session
    python3 scripts/clay-extract.py --auth
    # (In Chrome: DevTools → Network → any api.clay.com request → Copy as cURL → paste)

    # Extract a specific table
    python3 scripts/clay-extract.py https://app.clay.com/workspaces/502058/workbooks/wb_xxx/tables/t_xxx

    # List all tables in a workspace folder
    python3 scripts/clay-extract.py https://app.clay.com/workspaces/502058/home/f_xxx

    # Extract by table ID directly
    python3 scripts/clay-extract.py t_0t5pj9mqNnpxxjM6jaV

Session is saved to .clay-session.json and reused until it expires.
Output goes to tmp/clay_extract_<table_name>.json (won't overwrite existing files).
"""

import json
import os
import re
import sys
import time
from pathlib import Path
from urllib.parse import urlparse

SESSION_FILE = Path(".clay-session.json")

# ---------------------------------------------------------------------------
# Session management
# ---------------------------------------------------------------------------

def extract_cookie_from_curl(curl_str: str) -> str | None:
    """Parse a 'Copy as cURL' string to extract the Cookie header."""
    # Match -b 'cookie...' or --cookie 'cookie...' or -H 'cookie: ...'
    patterns = [
        r"-b\s+'([^']+)'",
        r"-b\s+\"([^\"]+)\"",
        r"--cookie\s+'([^']+)'",
        r"--cookie\s+\"([^\"]+)\"",
        r"-H\s+'[Cc]ookie:\s*([^']+)'",
        r'-H\s+"[Cc]ookie:\s*([^"]+)"',
    ]
    for pattern in patterns:
        match = re.search(pattern, curl_str)
        if match:
            cookie = match.group(1).strip()
            if "claysession" in cookie:
                return cookie
    return None


def save_session(cookie: str):
    """Persist cookie for reuse."""
    SESSION_FILE.write_text(json.dumps({
        "cookie": cookie,
        "savedAt": time.time(),
    }, indent=2))
    gitignore = Path(".gitignore")
    if gitignore.exists():
        content = gitignore.read_text()
        if ".clay-session.json" not in content:
            with open(gitignore, "a") as f:
                f.write("\n.clay-session.json\n")
    print(f"[OK] Session saved to {SESSION_FILE}")


def get_saved_session() -> str | None:
    """Load saved cookie if still fresh."""
    if not SESSION_FILE.exists():
        return None
    try:
        data = json.loads(SESSION_FILE.read_text())
        cookie = data.get("cookie", "")
        saved_at = data.get("savedAt", 0)
        if time.time() - saved_at > 20 * 3600:
            return None
        if "claysession" not in cookie:
            return None
        return cookie
    except Exception:
        return None


def test_session(cookie: str) -> bool:
    """Quick check if the cookie is still valid."""
    import requests
    try:
        # /v3/users/me returns 403; use workspace resources as a lightweight auth check
        resp = requests.get(
            "https://api.clay.com/v3/actions?workspaceId=502058",
            headers={"accept": "application/json", "cookie": cookie, "origin": "https://app.clay.com"},
            timeout=10,
        )
        return resp.status_code == 200
    except Exception:
        return False


def get_clay_cookie_from_env() -> str | None:
    """Read CLAY_COOKIE from .env.deepline if it exists."""
    env_file = Path(".env.deepline")
    if not env_file.exists():
        return None
    for line in env_file.read_text().splitlines():
        line = line.strip()
        if line.startswith("CLAY_COOKIE="):
            val = line[len("CLAY_COOKIE="):]
            if (val.startswith("'") and val.endswith("'")) or (val.startswith('"') and val.endswith('"')):
                val = val[1:-1]
            return val
    return None


def do_auth():
    """Interactive auth: user pastes a cURL command."""
    print("Paste a cURL command from Chrome DevTools (any api.clay.com request):")
    print("  Chrome → DevTools (Cmd+Option+I) → Network → click any api.clay.com request")
    print("  → Right-click → Copy → Copy as cURL")
    print()

    lines = []
    print("Paste here (press Enter twice when done):")
    empty_count = 0
    while True:
        try:
            line = input()
            if not line.strip():
                empty_count += 1
                if empty_count >= 1 and lines:
                    break
            else:
                empty_count = 0
                lines.append(line)
        except EOFError:
            break

    curl_str = " ".join(lines)
    cookie = extract_cookie_from_curl(curl_str)

    if not cookie:
        print("[FAIL] Could not find claysession in the pasted cURL.")
        print("  Make sure you're copying from an api.clay.com request while logged in.")
        sys.exit(1)

    if test_session(cookie):
        save_session(cookie)
        print("[OK] Session is valid. You can now run extraction commands.")
    else:
        print("[FAIL] Cookie found but session is invalid/expired. Try copying a fresh cURL.")
        sys.exit(1)


def get_cookie() -> str:
    """Get a valid Clay session cookie."""
    # 1. Saved session
    cookie = get_saved_session()
    if cookie and test_session(cookie):
        print("[OK] Using saved Clay session")
        return cookie

    # 2. .env.deepline
    cookie = get_clay_cookie_from_env()
    if cookie and test_session(cookie):
        print("[OK] Using Clay session from .env.deepline")
        save_session(cookie)
        return cookie

    # 3. Need auth
    print("[AUTH] No valid session found. Run with --auth first:")
    print(f"  python3 {sys.argv[0]} --auth")
    sys.exit(1)


# ---------------------------------------------------------------------------
# Clay API client
# ---------------------------------------------------------------------------

class ClayAPI:
    BASE = "https://api.clay.com"

    def __init__(self, cookie: str):
        import requests
        self.session = requests.Session()
        self.session.headers.update({
            "accept": "application/json",
            "content-type": "application/json",
            "cookie": cookie,
            "origin": "https://app.clay.com",
            "referer": "https://app.clay.com/",
        })

    def get(self, path: str):
        resp = self.session.get(f"{self.BASE}{path}")
        if resp.status_code == 401:
            print(f"[FAIL] 401 on {path} — session expired. Run: python3 {sys.argv[0]} --auth")
            sys.exit(1)
        resp.raise_for_status()
        return resp.json()

    def post(self, path: str, body: dict = None):
        resp = self.session.post(f"{self.BASE}{path}", json=body or {})
        if resp.status_code == 401:
            print(f"[FAIL] 401 on {path} — session expired. Run: python3 {sys.argv[0]} --auth")
            sys.exit(1)
        resp.raise_for_status()
        return resp.json()

    def get_table_config(self, table_id: str) -> dict:
        print(f"  Fetching table config for {table_id}...")
        return self.get(f"/v3/tables/{table_id}")

    def get_table_schema_v2(self, table_id: str, view_id: str) -> dict:
        print(f"  Fetching schema + example records...")
        return self.get(f"/v3/tables/{table_id}/views/{view_id}/table-schema-v2")

    def list_workspace_resources(self, workspace_id: str) -> dict:
        print(f"  Listing workspace {workspace_id} resources...")
        return self.post(f"/v3/workspaces/{workspace_id}/resources_v2/")

    def list_workbook_tables(self, workbook_id: str) -> list[dict]:
        """Get tables from a workbook (returns list of {id, name})."""
        print(f"  Listing tables in workbook {workbook_id}...")
        tables = self.get(f"/v3/workbooks/{workbook_id}/tables")
        if isinstance(tables, list):
            return [{"id": t["id"], "name": t.get("name", "")} for t in tables if "id" in t]
        return []

    def search_workbooks(self, workspace_id: str, query: str) -> list[dict]:
        """Search workspace workbooks by name (case-insensitive substring match)."""
        resources = self.list_workspace_resources(workspace_id)
        workbooks = [
            r for r in resources.get("resources", [])
            if r.get("resourceType") == "WORKBOOK"
        ]
        q = query.lower()
        matches = [wb for wb in workbooks if q in wb.get("name", "").lower()]
        return matches

    def extract_table(self, table_id: str) -> dict:
        config = self.get_table_config(table_id)
        table = config.get("table", config)
        view_id = table.get("firstViewId")

        result = {
            "_meta": {
                "extractedAt": time.strftime("%Y-%m-%dT%H:%M:%SZ", time.gmtime()),
                "method": "clay-extract.py",
                "tableId": table_id,
            },
            "table": {
                "id": table.get("id"),
                "name": table.get("name"),
                "workbookId": table.get("workbookId"),
                "workspaceId": table.get("workspaceId"),
                "firstViewId": view_id,
                "tableSettings": table.get("tableSettings"),
            },
            "fields": [],
            "exampleRecords": [],
        }

        for f in table.get("fields", []):
            result["fields"].append({
                "id": f.get("id"),
                "name": f.get("name"),
                "type": f.get("type"),
                "actionType": f.get("actionType"),
                "inputFieldIds": f.get("inputFieldIds", []),
                "typeSettings": f.get("typeSettings"),
            })

        if view_id:
            try:
                schema_data = self.get_table_schema_v2(table_id, view_id)
                result["tableSchema"] = schema_data.get("tableSchema")
                result["exampleRecords"] = schema_data.get("exampleRecords", [])
            except Exception as e:
                print(f"  [WARN] Could not fetch schema-v2: {e}")

        return result


# ---------------------------------------------------------------------------
# URL parsing
# ---------------------------------------------------------------------------

def parse_clay_input(arg: str, workspace_id: str | None = None):
    # Direct table ID
    if re.match(r"^t_[a-zA-Z0-9]+$", arg):
        return {"type": "table", "table_id": arg}

    # Direct workbook ID
    if re.match(r"^wb_[a-zA-Z0-9]+$", arg):
        return {"type": "workbook", "workbook_id": arg, "workspace_id": workspace_id}

    # URL parsing
    parsed = urlparse(arg)
    path = parsed.path

    if path.startswith("/"):
        table_match = re.search(r"/tables/(t_[a-zA-Z0-9]+)", path)
        if table_match:
            return {"type": "table", "table_id": table_match.group(1)}

        wb_match = re.search(r"/workspaces/(\d+)/workbooks/(wb_[a-zA-Z0-9]+)", path)
        if wb_match:
            return {"type": "workbook", "workspace_id": wb_match.group(1), "workbook_id": wb_match.group(2)}

        folder_match = re.search(r"/workspaces/(\d+)/home/(f_[a-zA-Z0-9]+)", path)
        if folder_match:
            return {"type": "folder", "workspace_id": folder_match.group(1), "folder_id": folder_match.group(2)}

        ws_match = re.search(r"/workspaces/(\d+)", path)
        if ws_match:
            return {"type": "workspace", "workspace_id": ws_match.group(1)}

    # Name-based search — anything that's not an ID or URL
    return {"type": "search", "query": arg, "workspace_id": workspace_id}


# ---------------------------------------------------------------------------
# Output
# ---------------------------------------------------------------------------

def save_extract(extract: dict, output_dir: Path):
    table_name = extract["table"]["name"] or extract["table"]["id"]
    safe_name = re.sub(r"[^a-zA-Z0-9_-]", "_", table_name).strip("_").lower()
    filename = f"clay_extract_{safe_name}.json"
    output_path = output_dir / filename

    if output_path.exists():
        i = 2
        while True:
            alt = output_dir / f"clay_extract_{safe_name}_{i}.json"
            if not alt.exists():
                output_path = alt
                break
            i += 1

    output_path.write_text(json.dumps(extract, indent=2, default=str))
    return output_path


def print_summary(extract: dict):
    table = extract["table"]
    fields = extract["fields"]
    records = extract.get("exampleRecords", [])

    print(f"\n{'='*60}")
    print(f"Table: {table['name']} ({table['id']})")
    print(f"Fields: {len(fields)}  |  Example records: {len(records)}")
    print(f"{'='*60}")

    for f in fields:
        ts = f.get("typeSettings") or {}
        action_key = ts.get("actionKey", "")
        ftype = f["type"]
        marker = ""
        if ftype == "action":
            marker = f" [{action_key}]"
        elif ftype == "source":
            marker = " [source]"
        print(f"  {f['id'][:20]:20s}  {ftype:8s}  {f['name'][:40]}{marker}")


# ---------------------------------------------------------------------------
# Main
# ---------------------------------------------------------------------------

def main():
    if len(sys.argv) < 2:
        print(__doc__)
        sys.exit(1)

    if sys.argv[1] == "--auth":
        do_auth()
        return

    # Parse args: [--workspace WORKSPACE_ID] <query>
    args = sys.argv[1:]
    workspace_id = None
    if "--workspace" in args:
        idx = args.index("--workspace")
        workspace_id = args[idx + 1]
        args = args[:idx] + args[idx + 2:]

    arg = " ".join(args)
    output_dir = Path("tmp")
    output_dir.mkdir(exist_ok=True)

    info = parse_clay_input(arg, workspace_id)
    print(f"[INPUT] Parsed as: {info['type']}")

    cookie = get_cookie()
    api = ClayAPI(cookie)

    extracts = []

    if info["type"] == "table":
        extracts.append(api.extract_table(info["table_id"]))

    elif info["type"] == "workbook":
        tables = api.list_workbook_tables(info["workbook_id"])
        if not tables:
            print("  [FAIL] No tables found in workbook.")
            sys.exit(1)
        print(f"  Found {len(tables)} table(s)")
        for t in tables:
            print(f"\n--- Extracting: {t['name'] or t['id']} ---")
            try:
                extracts.append(api.extract_table(t["id"]))
            except Exception as e:
                print(f"  [ERROR] {t['id']}: {e}")

    elif info["type"] == "search":
        ws_id = info.get("workspace_id")
        if not ws_id:
            # Try to get workspace ID from saved session or recent extracts
            print("[FAIL] Name search requires a workspace ID.")
            print("  Use: python3 scripts/clay-extract.py --workspace 502058 \"Demo Requests\"")
            print("  Or provide a full Clay URL instead.")
            sys.exit(1)

        query = info["query"]
        print(f"  Searching workspace {ws_id} for \"{query}\"...")
        matches = api.search_workbooks(ws_id, query)

        if not matches:
            print(f"  No workbooks matching \"{query}\"")
            # Also search table names inside all workbooks
            print("  Searching table names...")
            resources = api.list_workspace_resources(ws_id)
            all_wbs = [r for r in resources.get("resources", []) if r.get("resourceType") == "WORKBOOK"]
            for wb in all_wbs:
                try:
                    tables = api.list_workbook_tables(wb["id"])
                    for t in tables:
                        if query.lower() in t.get("name", "").lower():
                            print(f"  Found table: {t['name']} in workbook \"{wb['name']}\"")
                            extracts.append(api.extract_table(t["id"]))
                except Exception:
                    pass
            if not extracts:
                print(f"  [FAIL] No workbooks or tables matching \"{query}\"")
                sys.exit(1)
        else:
            print(f"  Found {len(matches)} workbook(s):")
            for m in matches:
                print(f"    {m['id']} — {m['name']}")

            for wb in matches:
                tables = api.list_workbook_tables(wb["id"])
                for t in tables:
                    print(f"\n--- Extracting: {t['name'] or t['id']} (from \"{wb['name']}\") ---")
                    try:
                        extracts.append(api.extract_table(t["id"]))
                    except Exception as e:
                        print(f"  [ERROR] {t['id']}: {e}")

    elif info["type"] in ("workspace", "folder"):
        try:
            resources = api.list_workspace_resources(info["workspace_id"])
            workbook_ids = [
                r["id"] for r in resources.get("resources", [])
                if r.get("resourceType") == "WORKBOOK"
            ]
        except Exception as e:
            workbook_ids = []
            print(f"  [WARN] resources_v2 failed: {e}")

        if info["type"] == "folder":
            print(f"  [NOTE] Folder children aren't in the API response.")
            print(f"  Found {len(workbook_ids)} top-level workbooks.")
            if not workbook_ids:
                sys.exit(1)

        print(f"  Resolving {len(workbook_ids)} workbooks to tables...")
        table_ids = []
        for wb_id in workbook_ids:
            try:
                tables = api.list_workbook_tables(wb_id)
                table_ids.extend([t["id"] for t in tables])
            except Exception:
                pass

        if not table_ids:
            print("  [FAIL] No tables found.")
            sys.exit(1)

        print(f"  Found {len(table_ids)} table(s) total")
        for tid in table_ids:
            print(f"\n--- Extracting: {tid} ---")
            try:
                extracts.append(api.extract_table(tid))
            except Exception as e:
                print(f"  [ERROR] {tid}: {e}")

    if not extracts:
        print("\n[FAIL] No tables extracted.")
        sys.exit(1)

    for extract in extracts:
        print_summary(extract)
        path = save_extract(extract, output_dir)
        print(f"  Saved to: {path}")

    print(f"\n[DONE] Extracted {len(extracts)} table(s)")


if __name__ == "__main__":
    main()
deprecation-and-migrationaddyosmani/agent-skillsManages deprecation and migration. Use when removing old systems, APIs, or features. Use when migrating users from one implementation to another. Use when migrating a database schema in production, such as renaming or dropping a column without downtime (expand/contract). Use when deciding whether to maintain or sunset existing code.Stars: 119kUpdated Claude CodeCodexVerifiedInstall
performance-optimizationaddyosmani/agent-skillsOptimizes application performance across frontend, backend, queries, and databases. Use when performance requirements exist, when you suspect performance regressions, when Core Web Vitals or load times need improvement, when N+1 query patterns need fixing, or when profiling reveals bottlenecks.Stars: 119kUpdated Claude CodeCodexVerifiedInstall
agent-cost-reportthedotmack/claude-memBelievable agent cost report for any period, default the last 7 full days PT, not counting today. Measured tokens from Claude Code transcripts priced at OpenRouter list prices (ESTIMATED), measured provider spend when a sanctioned source exists, note-taker cost separate, Timing-style HTML/PDF plus report.json, line-items.csv, evidence.json.Stars: 118kUpdated Claude CodeCodexVerifiedInstall
agent-cost-reportthedotmack/claude-memBelievable agent cost report for any period, default the last 7 full days PT, not counting today. Measured tokens from Claude Code transcripts priced at OpenRouter list prices (ESTIMATED), measured provider spend when a sanctioned source exists, note-taker cost separate, Timing-style HTML/PDF plus report.json, line-items.csv, evidence.json.Stars: 118kUpdated Claude CodeCodexVerifiedInstall