This page requires JavaScript to display.
The Nolan Scott Team Sells and buys businesses from $1M to $15M+, and advises on the real estate that comes with them. nolanscottteam.com →
Example 04 / 18 · a sample from our Rolodex of 100+ automations Claude Skill
Automation Breakdown · Claude Skill

Yellow Pages Prospector

Not a workflow engine, a Claude skill. Claude itself drives the browser, the state registry, the skip-trace API, and the spreadsheet: it scrapes Yellow Pages for owner-operated businesses, finds the legal owner, traces their personal cell and email, writes a cold-call opener, and delivers a dialer-ready list in Close CRM.

11 pipeline steps
4 systems · YP, GA SoS, Tracerfy, Close
batches of 25 run to completion
1 cumulative master sheet
True AI automation isn’t one clever workflow. It takes 20 to 40 workflows working together to make a real impact on a business. That’s what we do: a Rolodex of 100+ automations across different CRMs and platforms, ready to be custom-built for your specific CRM and software stack.
The Workflow
Scroll sideways · click any step for its explanation
loop
done
A Claude skill, not a workflow engine
There are no nodes running on a server. Claude itself drives the browser, the APIs, and the spreadsheet, reasoning through edge cases a rigid workflow would break on.
Why the home address matters
The YP number rings a front desk. Tracing the owner at their commercial address returns strangers. The residential trace returns real cells + personal emails, proven 2-for-3 vs 0-for-3.
One master sheet, forever
Every run appends to the same workbook. Qualified AND dropped rows are logged with a disposition, so nothing is ever pulled, or paid for, twice.
▶
“Run the Prospector”
Trent says go
GD
Read Master Sheet
source of truth
{ }
Reconstruct State
Run Log + counts
{ }
Check Worklists
pending sub-tasks
A\
State-Aware Intake
fewest questions
↻
Loop Blocks of 25
run to completion
A\
Session Summary
counts + top 5
Ch
Scrape Yellow Pages
Claude in Chrome
{ }
Filter Listings
drop chains + young
{ }
Dedup vs Master
name + phone
C
Dedup vs Close
search leads
Ch
State Registry Lookup
GA SoS
Ch
Find Residential Address
agent-name search
⊕
Tracerfy Skip Trace
name + home address
⊕
DNC Scrub
flag + demote
{ }
Score & Rank
0–100 weighted
A\
Write Openers
Trent’s voice
GD
Append Master Sheet
+ Run Log row
C
Push to Close CRM
dialer-ready
◈
The skill at a glance
Click any step to see exactly what it does. The pipeline reads left to right: reconstruct state from the master sheet, then run blocks of 25 end-to-end, scrape, dedup, find the owner, trace their cell, score, script, and push to the dialer.
Claude in Chrome
Google Drive sheet
Tracerfy API
Close CRM
Claude reasoning
Logic / rules
Loop
Trigger
How It Works

From a listing to the owner’s cell phone

01 · State First
The sheet is the memory

Every run starts by reading the one cumulative master spreadsheet, the source of truth. Claude reconstructs where things stand (which sectors are done, which metros are covered, what worklists are pending) before asking a single question, so it only asks what the data can’t answer.

02 · Harvest
Scrape, filter, dedup

Claude drives Chrome to scrape Yellow Pages listings for the sector and city, filters out chains, too-young shops, and no-phone rows, then dedups against both the master sheet and Close CRM, no business is ever pulled or paid for twice. Dropped rows are logged with a reason, never silently discarded.

03 · Owner Enrichment
Registry → home → cell

The YP number rings a front desk. So Claude looks up the legal owner in the state business registry, cross-references the owner’s name to find their residential address, and skip-traces it through Tracerfy for a direct cell and personal email, then scrubs every number against Do-Not-Call lists.

04 · Deliver
Scored, scripted, in the dialer

Each prospect gets a 0–100 reachability-weighted score and a tailored cold-call opener written in Trent’s voice. The block is appended to the master sheet, qualified leads are pushed to Close as dialer-ready contacts, and the batch closes with a full session summary. Then the next block of 25 begins.

Next example: Directory Scraper →
AI · nolan scott team
Unpacking...