The $70K Sheet

<aside> 🛠️ A Clay build that scores and color-codes your whole market runs five figures by the time you stack the seat, the enrichment credits, and the partner who wires it up. This is the full SOP, and it comes with a runnable starter: clone the repo, connect Google once, run four steps, and you get the same color-coded, scored sheet on your own account. You own all of it.

</aside>

What you're looking at

The qualification dashboard, built and color-coded by the pipeline in this repo: 15,421 contacts narrowed to 8,464 qualified and 4,476 reachable.

The qualification dashboard, built and color-coded by the pipeline in this repo: 15,421 contacts narrowed to 8,464 qualified and 4,476 reachable.

<aside> 💸 A live, color-coded, scored Google Sheet of an entire market. Every contact ranked 1 to 5, every score explained, a dashboard tab on top.

</aside>

<aside> ⚡ It is built by a handful of scripts you run yourself, local-first. The re-run is free, and the sheet rebuilds in place so the link never changes.

</aside>

<aside> 🤖 The data lives in SQLite (and Supabase if you want a cloud master). You query it, version it, roll it back. It is yours.

</aside>

Run it yourself in five minutes

<aside> ✅ This is not a screenshot you have to take on faith. It is a real starter in a public repo. The image below is the actual output of python3 build_sheet.py on the included sample data.

</aside>

The live sheet this starter builds: 25 sample accounts scored 1 to 5, red to green gradient, A-D tier colors, a one-line fit_reason on every row.

The live sheet this starter builds: 25 sample accounts scored 1 to 5, red to green gradient, A-D tier colors, a one-line fit_reason on every row.

git clone <https://github.com/shawnla90/gtm-coding-agent.git>
cd gtm-coding-agent/starters/market-scoring-sheet
python3 -m venv venv && source venv/bin/activate
pip install -r requirements.txt
python3 setup_oauth.py     # one-time Google connection (steps below)
bash run.sh                # load -> score -> build the sheet

<aside> 🎯 It prints a Google Sheet URL at the end. Open it, and that is your market, scored and color-coded. Swap sample_market.csv for your own list (same columns) and edit the maps in score.py so the scoring matches your ICP.

</aside>

Connect Google Workspace (do this once, before anything else)

<aside> 💡 🔌 The builder writes to Google Sheets as you, over OAuth. Handing the prompt straight to Claude Code fails right here, because there is no token yet. Do this once and everything after it works.

</aside>

python3 setup_oauth.py