Goal: Automate the manual grunt work of finding leads and writing personalized emails.
Tools:
- Clay: The “Central Hub” where you find leads and organize data.
- OpenAI (ChatGPT): The “Writer” (integrated inside Clay) that analyzes the data and drafts the emails.
- Smartlead / Instantly: The “Sender.” Clay doesn’t send mass emails; you export your finished data here to launch the campaign.
Outcome: A self-filling pipeline of verified leads with custom email drafts ready to send.
Note: This is a fully no-code workflow designed for non-technical founders. If you are a developer looking for the advanced n8n/scraping version, see our technical playbook: Automate Cold Email Personalization with AI.
The biggest bottleneck in sales isn’t sending emails—it’s the research. Most teams waste hours copying data from LinkedIn to Excel, only to send generic messages that get ignored. This playbook builds an “Automated Research Agent” that scrapes LinkedIn for your ideal clients, finds their verified emails, and writes a unique intro line for every single person—automatically.
Step 1: Automate Lead Sourcing
Instead of buying a stagnant list, set up a “live” feed of prospects directly from LinkedIn.
- Create a New Workspace: Open Clay and select New Table.
- Select the “Live” Source: Choose Find People from LinkedIn (this uses a built-in scraper).
- Set Your Targeting: Input your Ideal Customer Profile (ICP).
- Example: Job Title: “CMO” OR “Head of Marketing”; Location: “New York”; Company Size: “11–50 employees.”
- Import: The system will pull a fresh list of real people matching those criteria into your spreadsheet rows.
Step 2: The “Waterfall” Enrichment (Finding Emails)
We use a “Waterfall” method to check multiple databases instantly, ensuring high deliverability.
- Add Enrichment: Right-click the list and select Enrich Data -> Find Work Email.
- Configure Providers: Set the order of providers the Agent should check.
- Result: The system automatically loops through these tools and outputs a verified email address.
Step 3: The “Reasoning” Agent (The AI Step)
This is where the “Agent” comes in. Unlike a simple mail-merge that just swaps names, this step uses GPT-4 or latest version to analyze the prospect’s context and synthesize a new observation.
- Add an AI Column: Click Enrich Data → AI → Use AI (ChatGPT).
- The Reasoning Prompt: Give the AI a specific research task:
- “Act as a sales analyst. Read the
[Company Description]and the prospect’s[Job Title].
Task: Write a 15-word observation connecting their company’s specific industry to [Your Service].
Constraint: Do not use generic fluff like ‘I hope you are well’. Be specific.”
- “Act as a sales analyst. Read the
- The Agentic Output:
- Input: “Head of Growth” + “Company selling specialized vegan dog food.”
- AI Decision: It synthesizes these facts to write: “Saw you’re scaling direct-to-consumer pet food—guessing customer retention is a major focus right now.”
Step 4: Quality Control & Sync
Before sending, we do a quick human check to ensure the AI didn’t hallucinate, then push the data to our sending tool.
- The “Sanity Check”: Scan the AI output column. If a sentence looks robotic, double-click the cell and rewrite it manually.
- Export the Data: Click Export in the top right corner.
- Connect Your Sender: Select your email platform (e.g., Smartlead or Instantly).
- Map the Variables: Map your new
AI Output Columnto a custom variable like{{custom_intro}}.
Step 5: The “Plug-and-Play” Template
Now, go into your email sending tool and use a template that leverages the research you just did.
Subject: Thought regarding {{companyName}}
Hi {{firstName}},
{{custom_intro}}
I’m reaching out because we help companies like yours avoid [Specific Pain Point] by automating [Your Solution].
We recently helped [Competitor/Client] achieve [Result X] in under 30 days.
Open to a brief chat to see if this applies to you?
Best, [Your Name]
