Clay Data Enrichment: Workflows & Automation Guide

Clay has quietly become the operating system for modern GTM teams. If you're still enriching data one provider at a time, manually copying prospect info between tools, or running outbound without lead scoring — Clay fixes all of that.

This guide covers everything: account setup, building tables, enrichment workflows, lead scoring, automation, cost optimization, and real-world use cases. Whether you're just signing up or looking to squeeze more out of an existing Clay setup, you'll find actionable steps here.

What is Clay and Why GTM Teams Are Switching

Clay is a data enrichment and workflow automation platform built for go-to-market teams. At its core, it's a spreadsheet with superpowers — every column can pull live data from 100+ enrichment providers, run AI prompts, execute HTTP requests, or apply conditional logic.

Here's why teams are moving to Clay over traditional enrichment approaches:

Single-provider limitations are real. No data vendor covers more than 40–70% of B2B contacts on their own. Clay lets you chain providers in waterfalls to hit 90%+ coverage without building custom integrations.

Manual enrichment doesn't scale. Copying data between Apollo, Hunter, Clearbit, and your CRM is busywork. Clay centralizes everything in one workspace. You define the logic once, and it runs on every new row.

Enrichment without workflow is incomplete. Finding an email is step one. Clay handles scoring, routing, formatting, and pushing enriched records straight into your CRM or outreach tool — automatically.

The teams getting the most out of Clay are SDR/BDR teams running cold outbound, revenue operations teams building enrichment pipelines, and agencies managing prospecting for multiple clients.

Getting Started with Clay

Account Setup and Plan Selection

Head to clay.com and create a free account. Clay offers several tiers:

• Free: 100 credits/month. Good for testing workflows before committing.
• Starter: ~$149/month. Includes CRM integrations and more credits.
• Explorer: ~$349/month. Unlocks advanced features like HTTP request columns and higher credit limits.
• Pro: ~$800/month. Full access including Clay AI columns, priority support, and team features.

If you're evaluating Clay, start on Free to build a proof-of-concept table. The free tier gives you enough credits to test enrichment waterfalls on 50–100 records and validate the workflow before scaling.

Understanding Clay's Credit System

Credits are the currency inside Clay. Every enrichment action, AI column execution, or data lookup costs credits. The number of credits varies by provider and action type.

Key things to know:

• Credits are consumed per row, per enrichment. Running an email finder on 1,000 rows costs 1,000 × the per-row credit cost.
• Failed lookups still cost credits in most cases. If a provider returns no result, you've still used the credit for the API call.
• Waterfalls compound credit usage. If Provider A misses and you fall back to Provider B, that row costs credits from both providers.
• Some providers cost more than others. Premium data sources (like mobile phone finders) cost more credits per lookup than email finders.

This is why provider selection order matters. Put your highest-accuracy provider first to minimize fallback usage. LeadMagic's 97% accuracy rate means fewer rows fall through to more expensive secondary providers.

Navigating the Interface

Clay's workspace is organized around a few core concepts:

• Tables: Your primary workspace. Each table holds a set of records (people or companies) with columns of data.
• Columns: Can be static (manual data), enrichment (pulling from a provider), formula (computed from other columns), or AI-generated.
• Sources: Where your records come from — CSV imports, CRM syncs, LinkedIn, or Clay's own prospecting tools.
• Integrations: Connections to external tools for both pulling data in and pushing results out.

The left sidebar shows your tables and workspace. The top bar in any table lets you add columns, filter rows, and control enrichment runs. The right panel (when you click a column header) is where you configure enrichment logic, conditions, and field mappings.

Building Your First Table

Importing Data

Clay supports several import methods. Choose based on where your prospect data lives:

CSV Upload: Click "Add Data" → "Import CSV." Map columns during import. Best for one-time list enrichment — you've got a spreadsheet of leads from an event, a purchased list, or an export from another tool.

CRM Integration: Connect Salesforce or HubSpot directly. Clay pulls records in and can push enriched data back. Set up a two-way sync so enriched fields automatically update in your CRM. This is the setup most RevOps teams use for ongoing data hygiene.

LinkedIn Import: Use Clay's Chrome extension to pull prospects from LinkedIn Sales Navigator searches directly into a table. This is the fastest path from "I found interesting prospects" to "they're enriched and in my outreach sequence."

Clay Prospecting: Use Clay's built-in "Find People" or "Find Companies" sources. You can filter by job title, company size, industry, location, and more. This is useful when you don't have an existing list and need to build one from scratch.

Webhook / API: For automated pipelines, set up a webhook source so external tools can push records into Clay in real-time. Useful for enriching form submissions, event registrations, or intent signals.

Understanding Column Types

Every column in Clay falls into one of these categories:

• Static columns: Plain data fields — text, numbers, URLs. These hold your imported data or manually entered values.
• Enrichment columns: Connected to a data provider. When triggered, they make an API call and populate the cell with the result.
• Formula columns: Computed from other columns using Clay's formula syntax (similar to spreadsheet formulas). Use these for consolidation ({Col A} || {Col B}), string manipulation, or conditional logic.
• AI columns: Powered by GPT or Claude. Feed in data from other columns and get structured output — lead scoring, personalization snippets, ICP matching, data cleanup.
• HTTP Request columns: Make arbitrary API calls to any endpoint. Useful for connecting to tools that don't have native Clay integrations.

Adding Your First Enrichment Column

Here's a concrete walkthrough:

1. Open your table with at least First Name, Last Name, and Company Domain columns.
2. Click "+ Add Column" → "Enrich Data".
3. Search for "LeadMagic" in the provider list.
4. Select "Email Finder".
5. Map the input fields:
   • first_name → your First Name column
   • last_name → your Last Name column
   • domain → your Company Domain column
6. Click "Run" to enrich all rows, or select specific rows to test first.

The results populate in the new column. Each cell shows the found email address, and you can expand the cell to see the full API response (including confidence scores and verification status).

Data Enrichment in Clay

How Clay's Enrichment Marketplace Works

Clay's enrichment marketplace is a catalog of 100+ data providers, all accessible without separate contracts or API keys for most providers. You browse providers by category (email, phone, company data, technographics, etc.), add them as columns, and Clay handles the API calls behind the scenes.

Each provider has a listed accuracy rate based on Clay's own testing and user feedback. This is important — it's not just the provider's self-reported number. The marketplace ratings give you a real comparison across vendors.

For the providers on Clay's marketplace, credits are deducted from your Clay balance. Some premium providers (like LeadMagic) also offer a "bring your own API key" option, which lets you use your own account balance instead of Clay credits — often at a lower effective cost per lookup.

Why LeadMagic is the Top-Rated Provider

LeadMagic consistently ranks as a top-rated enrichment provider on Clay's marketplace. Here's why that matters in practice:

• 97% accuracy on email finding: Verified against real mailboxes, not just pattern matching. This means fewer bounces and better deliverability. See how it works at our Email Finder product page.
• Real-time verification built in: Every email returned is validated at the time of lookup. You're not getting stale cached data — you're getting a live check.
• Direct mobile numbers: LeadMagic's Mobile Finder returns direct-dial cell numbers, not switchboard numbers. Coverage sits at 85%+ for US B2B contacts.
• Company enrichment: Get firmographic data — revenue, headcount, industry, tech stack — from a domain or company name. See the Company Enrichment details.
• Credit-efficient: Because accuracy is high, fewer rows fall through to fallback providers, saving you credits on secondary lookups.

Setting Up LeadMagic Enrichment Columns

To use LeadMagic in Clay, you have two options:

Option A — Clay marketplace (credits deducted from Clay):

1. Add enrichment column → search "LeadMagic" → select the action (Email Finder, Mobile Finder, etc.)
2. Map your input fields
3. Run enrichment

Option B — Bring your own API key (credits deducted from LeadMagic):

1. Go to your LeadMagic dashboard and copy your API key
2. In Clay, go to Settings → Integrations → Add LeadMagic API key
3. Now when you add a LeadMagic column, it uses your own key and balance

Option B is often cheaper at scale. If you're enriching 10,000+ records per month, compare the per-lookup cost on Clay credits vs. your LeadMagic plan rate.

Using Conditional Logic for Waterfalls

Waterfall enrichment is the core value proposition of Clay. Here's how to set one up for email finding:

Step 1 — Primary provider (LeadMagic Email Finder): Add a LeadMagic Email Finder column. Map first name, last name, and domain. Run it on all rows.

Step 2 — Fallback provider with condition: Add a second enrichment column (e.g., Apollo or Hunter). Click the "Conditions" tab and set:

• Condition: {LeadMagic Email} is empty
• This ensures the fallback only runs on rows where LeadMagic didn't return a result.

Step 3 — Consolidate into a single column: Add a formula column:

{LeadMagic Email} || {Apollo Email} || {Hunter Email}

This picks the first non-empty value. Since LeadMagic ran first and has the highest accuracy, those results take priority.

Step 4 — Validate the final email: Add a LeadMagic Email Validation column. Map the consolidated email column as input. This catches any invalid or risky emails from the fallback providers. Read more about validation best practices.

For a deeper dive on waterfall setup specifically, see our Clay Waterfall Enrichment Guide.

Lead Scoring Workflows

Lead scoring in Clay replaces the rigid point systems in your CRM with flexible, enrichment-powered scoring that updates in real-time.

Building a Point-Based Scoring System

Create a formula column called "Lead Score" that sums points based on enriched data:

(IF({Employee Count} > 500, 20, IF({Employee Count} > 100, 10, 0)))
+ (IF({Title} CONTAINS "VP", 15, IF({Title} CONTAINS "Director", 12, IF({Title} CONTAINS "Manager", 8, 0))))
+ (IF({Email Verified} = "valid", 10, 0))
+ (IF({Mobile Found} IS NOT EMPTY, 10, 0))
+ (IF({Industry} = "SaaS", 15, IF({Industry} = "Technology", 10, 0)))

This gives you a numeric score per lead. Adjust the weights based on your ICP:

Using Clay AI Columns for ICP Matching

For more nuanced scoring, use an AI column. This is where Clay gets powerful — you can feed in multiple data points and get a structured assessment.

Create an AI column with a prompt like:

You are a lead qualification expert. Based on the following prospect data, score this lead from 0-100 for fit with our ICP (B2B SaaS companies, 100-5000 employees, in the US/EU, where the contact is a VP+ in Sales, Marketing, or RevOps).

Company: {Company Name}
Industry: {Industry}
Employees: {Employee Count}
Revenue: {Revenue}
Location: {HQ Country}
Title: {Job Title}
Department: {Department}

Return ONLY a JSON object: {"score": <number>, "tier": "<hot|warm|cold>", "reason": "<one sentence>"}

Parse the JSON response into separate columns for Score, Tier, and Reason. Now you have AI-powered lead scoring that considers the full context of each prospect — not just rigid point rules.

Combining Enrichment Data for Scoring

The best scoring systems layer multiple enrichment sources. A practical setup:

1. Company enrichment for firmographics (size, industry, revenue)
2. Email Finder for contact reachability
3. Mobile Finder for phone reachability
4. Job Change Detector for timing signals (new role = buying window)
5. Technographic data for product fit signals
6. AI column to synthesize everything into a final score and routing recommendation

With this stack, your score isn't just "does this person match our ICP?" — it's "does this person match our ICP, can we reach them, and is the timing right?"

Automation and Workflows

Triggering Enrichments on New Rows

By default, enrichment columns in Clay only run when you manually trigger them. For an automated pipeline, configure columns to auto-run on new rows:

1. Click on the enrichment column header
2. Go to the "Settings" tab
3. Enable "Run automatically on new rows"

Now, anytime a new record enters the table — via CRM sync, webhook, or manual add — all configured enrichment columns fire automatically in sequence.

This is the foundation of a "set it and forget it" enrichment pipeline. Leads come in, get enriched, scored, and routed without anyone touching a spreadsheet.

Scheduling Regular Re-enrichment

B2B data decays at roughly 30% per year. People change jobs, companies get acquired, emails go stale. Clay lets you schedule re-enrichment to keep data fresh:

• Job change monitoring: Set up a recurring run of LeadMagic's Job Change Detector on your key accounts. When a champion changes roles, you know immediately.
• Email re-validation: Schedule quarterly re-validation of your email list using LeadMagic Email Validation. Catch emails that have gone invalid before they hurt your sender reputation.
• Company data refresh: Re-enrich firmographic data semi-annually to catch headcount changes, funding rounds, or tech stack shifts.

To schedule re-enrichment, use Clay's "Scheduled Run" feature (available on Explorer plans and above) or connect via Zapier / Make to trigger enrichment on a cron schedule.

Pushing Results to Your CRM

Enriched data sitting in Clay isn't useful until it reaches your systems of record.

Salesforce Integration:

1. Go to Settings → Integrations → Salesforce
2. Authenticate with your Salesforce org
3. In your table, add a "Push to Salesforce" action column
4. Map Clay columns to Salesforce fields (e.g., {Verified Email} → Email, {Lead Score} → Lead_Score__c)
5. Set conditions for when to push (e.g., only push leads with score > 50)

HubSpot Integration:

1. Connect HubSpot under Settings → Integrations
2. Add a "Push to HubSpot" column
3. Map fields and set push conditions
4. Enable auto-push on new rows for real-time sync

Key tip: Don't push every enriched record into your CRM. Use your lead score or tier as a gate. Only push qualified leads to keep your CRM clean and your sales team focused on high-value prospects.

Connecting to Outreach Tools

The last mile of a Clay workflow is getting enriched, scored leads into your outreach sequences.

Instantly / Smartlead / Lemlist:

1. Add a "Push to [Tool]" action column (or use an HTTP Request column for tools without native integration)
2. Map the enriched email, first name, company, and any personalization fields
3. Set conditions: {Lead Score} > 60 AND {Email Verified} = "valid"
4. Enable auto-push on new rows

Outreach / Salesloft: Use Clay's native integrations or push via your CRM (if you sync from Clay → Salesforce → Outreach). The CRM-middleman approach gives you a single source of truth for attribution.

Custom webhook: For any tool without a native Clay integration, use an HTTP Request column to POST enriched data to a webhook endpoint. This works with virtually any modern SaaS tool.

Advanced Clay Techniques

AI Columns for Data Transformation

Beyond lead scoring, AI columns handle messy data problems that would take hours to clean manually:

Title normalization: Feed in raw job titles and get standardized versions.

Input: "VP, Demand Gen & Growth Marketing"
Prompt: "Standardize this job title into: standard_title, seniority_level (C-Suite/VP/Director/Manager/IC), department (Sales/Marketing/Engineering/Operations/Other). Return JSON."
Output: {"standard_title": "VP of Demand Generation", "seniority_level": "VP", "department": "Marketing"}

Personalization at scale: Generate custom first lines for cold emails based on enriched company data.

Prompt: "Write a cold email opening line (under 20 words) for {First Name} at {Company Name}. Reference their {Industry} industry and recent {Company News}. Be specific, not generic."

ICP matching narrative: Generate a paragraph explaining why a company is a good fit, useful for enterprise AE handoffs.

HTTP Request Columns for Custom APIs

When Clay's marketplace doesn't have a provider you need, HTTP Request columns let you call any REST API:

1. Add column → HTTP Request
2. Set method (GET/POST), URL, headers, and body
3. Use column references in the URL or body: https://api.example.com/lookup?domain={Domain}
4. Map response fields to parse specific values from the JSON response

Common use cases:

• Calling your own internal enrichment API
• Fetching data from niche providers not in Clay's marketplace
• Hitting your company's Clearbit or 6sense instance directly
• Calling LeadMagic's API directly with your own key for maximum flexibility

Table-to-Table Connections

Clay tables can reference each other. This lets you build multi-stage pipelines:

Example pipeline:

• Table 1 — Companies: Enriched company list with firmographics, tech stack, and ICP score
• Table 2 — People: Contacts at those companies, linked to Table 1 for company-level data
• Table 3 — Outreach Queue: Filtered, scored, and formatted records ready for sequence import

Table-to-table connections mean you enrich company data once and reference it across all contact records at that company. No duplicate lookups, no wasted credits.

Templates and Table Duplication

Once you build a workflow that works, save it:

• Duplicate a table to reuse the same column structure and enrichment logic on a new data set. This is ideal for agencies running the same workflow for different clients.
• Clay templates (community-shared table blueprints) let you start from a proven workflow. Search Clay's template library for "waterfall email" or "ABM enrichment" to find starting points.
• Export column configurations by duplicating a table and clearing the data. Keep a "template" table with zero rows but all your columns, formulas, and conditions pre-configured.

Cost Optimization

Clay credits disappear fast if you're not strategic. Here's how to get maximum value.

Provider Selection Strategy

Order matters in a waterfall. The goal is to maximize results while minimizing total credits consumed.

General strategy:

1. First: Highest accuracy provider (LeadMagic at 97%). More records resolved on the first try = fewer fallback credits spent.
2. Second: Best coverage for the records the first provider missed. Look at complementary coverage — some providers are stronger in certain geographies or industries.
3. Third (optional): Budget provider for the remaining long-tail misses.

Running a quick test is the best way to decide your order. Take 200 records, run them through each provider separately, compare hit rates and accuracy, then build your waterfall based on actual performance with your data.

Conditional Enrichment to Avoid Waste

Don't enrich every record. Use conditions aggressively:

• Skip enrichment if data already exists: {Email} is empty — don't re-enrich records that already have an email from your CRM.
• Only enrich ICP-fit records: {Employee Count} > 50 AND {Industry} IN ("SaaS", "Technology", "Financial Services") — don't spend credits on companies outside your target.
• Gate expensive enrichments behind cheap ones: Run free/cheap company enrichment first. Then only run Mobile Finder (more expensive) on records that pass your ICP filter.

A well-conditioned table can cut credit usage by 40–60% compared to running every enrichment on every row.

Credit Management Best Practices

• Set credit alerts in Clay settings. Get notified at 50% and 80% usage.
• Run small batches first. Test on 50 rows before running on 5,000.
• Audit credit usage monthly. Go to Settings → Usage and identify which enrichments consume the most credits. Optimize or replace expensive, low-return providers.
• Use "Bring Your Own Key" (BYOK) for high-volume providers. LeadMagic's direct pricing is often more cost-effective than Clay marketplace credits at scale.
• Cache results aggressively. If you've already enriched a domain or contact, reference existing data from another table instead of re-running the lookup.

Real-World Use Cases

Cold Outbound Prospecting

The most common Clay workflow. Here's a production-ready setup:

1. Source: Pull ICP companies from Clay prospecting or import from LinkedIn Sales Navigator
2. Company enrichment: LeadMagic Company Enrichment for firmographics, verify ICP fit
3. People search: Find contacts by title at those companies (VP Sales, Head of RevOps, etc.)
4. Email waterfall: LeadMagic Email Finder → fallback provider → consolidate
5. Email validation: LeadMagic Email Validation to remove invalids and catch-alls
6. Phone enrichment: LeadMagic Mobile Finder for phone-first outreach candidates
7. Lead scoring: AI column scores 0-100, assigns hot/warm/cold tier
8. Personalization: AI column generates custom first lines using company + person data
9. Push to outreach: Auto-push "hot" leads to Instantly/Smartlead, "warm" leads to a nurture sequence

This pipeline runs end-to-end on autopilot. New companies enter → fully enriched, scored, personalized leads appear in your outreach tool within minutes.

ABM Account Research

For account-based motions, Clay replaces the manual research SDRs do before outreach:

1. Start with target account list (50-500 companies)
2. Deep company enrichment: Firmographics, tech stack, funding history, recent news
3. Org chart mapping: Find 3-5 contacts per account across buying committee roles
4. Multi-channel enrichment: Email + mobile for every contact
5. Account scoring: AI column assesses overall account fit + timing signals
6. Research brief: AI column generates a 3-sentence account summary for the AE
7. Push to CRM: Create/update Account + Contact records in Salesforce/HubSpot

The output is a fully researched account brief with verified contact data for the entire buying committee — in minutes instead of hours.

Re-enrichment and Data Hygiene

Your CRM data degrades over time. Use Clay for periodic data hygiene:

1. Pull stale records from CRM (e.g., contacts not updated in 6+ months)
2. Re-validate emails: Run through LeadMagic Email Validation. Flag invalids for removal.
3. Re-enrich missing fields: Find phone numbers for contacts that only had email, or vice versa.
4. Detect job changes: Run Job Change Detector to find contacts who've left their company. This both cleans dead records and creates warm outreach opportunities (people who know your product now at a new company).
5. Push updates back to CRM: Update fields, change lead status on invalids, create tasks for job-change follow-ups.

Run this quarterly. A clean database improves email deliverability, call connect rates, and forecast accuracy.

Event Follow-Up Enrichment

After a conference, webinar, or product demo:

1. Import attendee list (usually a CSV from the event platform)
2. Enrich immediately: Email verification, company data, title normalization
3. Score based on engagement: Combine event data (attended session, visited booth, asked questions) with firmographic fit
4. Route by score: Hot leads → immediate AE follow-up in CRM. Warm leads → automated nurture sequence. Cold leads → marketing drip.
5. Personalize follow-up: AI column references the specific event or session for relevant outreach

Speed matters here. The team that follows up within 24 hours of an event gets 3-5x higher response rates. Clay lets you go from raw attendee list to enriched, scored, and routed leads in under an hour.

Bringing It All Together

Clay is at its best when you stop thinking of it as a spreadsheet and start thinking of it as an enrichment and routing engine. The pattern is always the same:

1. Get records in (import, CRM sync, webhook, prospecting)
2. Enrich with data (LeadMagic as primary, fallbacks as needed)
3. Score and filter (formulas + AI columns)
4. Route to action (CRM, outreach tool, Slack alert)

Start simple. Build a basic email waterfall on 100 records. Once that's working, add phone enrichment. Then add scoring. Then add CRM sync. Each layer compounds the value of the one before it.

For specific waterfall setups, check out our Clay Waterfall Enrichment Guide and Email Waterfall Tutorial. For an overview of all enrichment approaches, see our Data Enrichment and Waterfall Enrichment pages.

The teams getting the best results with Clay aren't the ones using the most providers — they're the ones who pick high-accuracy providers like LeadMagic first, apply smart conditions to avoid waste, and automate the full pipeline from enrichment to outreach.