Playbooks Clay
Clay Clay

Generate Qualified Sales Leads in Minutes

Use Clay to import raw prospect data, enrich it with web and CRM information, score each prospect, and automatically create personalized outreach emails—all in under 10 minutes.

Takes
Csv Url Text Spreadsheet
Produces
Csv Text Document
What you'll produce
Input
dentists.csv: Name,City Dr. Jane Smith,Los Angeles Dr. John Doe,Chicago
Output
Enriched row example: Name: Dr. Jane Smith City: Los Angeles Website: Email: Phone: 555‑123‑4567 Score: 78 (Weak SEO, No Google Ads) Cold Email: "Hi Dr. Smith, I noticed your website could rank higher for local dental searches. Our SEO package helped a similar practice in LA increase organic leads by 45%..."

The Workflow

7 steps · click a step number to mark it done

Open Clay and have it ready before you start

Upload a CSV file of raw prospects (e.g., dentist names and cities) into a new Clay table

Add a column and select the Google Search action; prompt Clay with "Find the website for {{Name}} in {{City}}" to populate a website URL column

Connect a third‑party enrichment partner such as ZoomInfo, then add columns for work email and phone number using the partner’s lookup action

Create a custom AI prompt column that evaluates each website’s SEO health, ad activity, and social presence, returning a numeric score and brief notes

Sort the table by the prospect score column to surface the highest‑need dental practices

Add another AI prompt column that generates a personalized cold‑email using the prospect’s score, website weaknesses, and your service offering

Export the email column (and any other needed fields) as a CSV or copy the content directly into your email sequencing tool

Ready to run this workflow?

Open Clay and follow the steps above.

Open Clay
Did this workflow help?
🔍 Looking for AI tools? Try searching!