Claude Code + Clay Makes Lead Generation Actually Fun
An 18-minute walkthrough of wiring Claude Code into Clay's data platform to source, enrich, and write cold email copy for 50 leads from one natural-language prompt.
July 12thA 23-minute live demo and setup walkthrough for a conversational Claude Code agent that scrapes Apify leads and exports them to Google Sheets.
A two-layer Claude Code folder architecture separating orchestration (CLAUDE.md) from target-specific detail (YAML per ICP) lets you describe an audience in plain language and get a clean Google Sheet of leads without touching a scraper UI.
The system works by giving Claude Code a two-layer workspace: a CLAUDE.md that defines the agent role, and YAML files per client encoding specific ICP filters. When you ask Claude to scrape leads for a client, it reads the ICP YAML, calls the Apify actor with the right parameters, runs a test batch to self-qualify, then exports to Google Sheets via OAuth credentials.json. Lead generation becomes a background task -- you speak, Claude runs it while you do other work, and a clean sheet appears when done.
Sign in and you get 23 free chat messages on us — ask for the hook, quote a framework, find the exact transcript moment, generate a markdown action plan. Bring your own key when you want unlimited.
Create a free account →
Full working system shown cold: ICP prompt to Claude, Apify test runs with self-qualification, export to Google Sheets. Viewer sees the end state before any setup.

Claude Code (Pro/Max plan), terminal choice (Cursor or Antigravity), Apify account ($29/mo), Google Cloud project with Sheets API.

The two-layer design: CLAUDE.md as root orchestration file, .env for keys, clients/ with per-client README + ICP YAMLs, execution/ with generic Python scripts.

Paste CLAUDE.md into terminal to instantiate folder structure; add lead-scraping skill; supply Apify actor slug and API token via .env.

Create Google Cloud project, enable Sheets API, create OAuth desktop client ID, download credentials.json, drop in project folder, complete browser auth flow.

Clean lead sheet with industry, job title, email. Instruction to save scripts for reuse. Soft CTA: free Skool resources and paid implementation call.
When the agent knows what kind of agent it is, a simple ICP description is all it needs to run a full scrape, qualify results, and deliver a clean sheet.
“Claude Code is now my orchestration layer, and it is how I run my business.”
“Things that might have taken all of your focus can now just be running in the background while you are on a call or filming a YouTube video.”
“Once you configure it, it only gets better.”
See every word as it's spoken — crank it to 2× and still catch all of it. The same dual-channel trick behind Amazon's Kindle + Audible.
Every lead list starts the same way: open the scraper, set the filters, wait, export, clean the columns, repeat for every client. David Mendoza collapsed that entire chain into a single natural-language prompt -- and this video shows the working system before explaining how to build it.
Separates generic execution logic from client-specific ICP configuration so one workspace handles unlimited clients without rewriting prompts.
“If you want to leverage AI inside of your business, go ahead and book a call with me.”
Soft close after the working system is shown; free Skool resources offered first, paid implementation second.
00:00
00:26
00:44
01:01
01:19
01:37
01:55
02:12
02:30
02:48
03:05
03:23
03:41
03:58
04:16
04:34
04:46
05:11
05:27
05:45
06:01
06:20
06:46
06:55
07:13
07:30
07:48
08:05
08:23
08:40
08:57
09:23
09:32
09:50
10:07
10:25
10:42
11:00
11:17
11:35
11:52
12:09
12:25
12:47
13:00
13:13
13:37
13:54
14:12
14:29
14:47
15:04
15:21
15:39
15:56
16:14
16:31
16:52
17:10
17:24
17:41
17:58
18:07
18:33
18:51
19:08
19:26
19:50
20:01
20:18
20:37
20:45
21:08
21:27
21:49
22:03
22:20
22:38
22:55
23:14An 18-minute walkthrough of wiring Claude Code into Clay's data platform to source, enrich, and write cold email copy for 50 leads from one natural-language prompt.
July 12thA screen-recorded walkthrough plugs Clay's new CLI straight into Claude Code, turning a single spoken prompt into a scraped, verified, cold-email-ready B2B prospect list.
July 17thA breakdown of three automation buckets — sales, research, and content — built on Claude Code and an indexed Obsidian vault, reclaiming five to ten hours a week.
July 15thA local-SEO tutorial on ranking dozens of one-niche, one-suburb 'microsites' around a city, then renting the phone calls they generate back to local businesses.
July 15thA five-level blueprint for turning one frontier model subscription into a personal operating system that remembers everything, debates itself, and keeps working while you sleep.
July 6thSix habit fixes for the actual bottleneck on your Claude Code output — you.
July 7th