The Clay Cookbook: 25 Production-Ready Workflows for GTM Teams

Clay workflows are automated data enrichment and orchestration sequences built inside Clay's table-based platform that connect multiple data providers, AI models, and output destinations to power go-to-market operations. A Clay workflow can take a company domain, resolve it to decision-maker contacts, verify their emails, score them against your ICP, generate personalized outreach copy, and push them into your sequencing tool - all without human intervention. These 25 workflows are production-tested recipes that we run for clients at GTME, covering enrichment, prospecting, signal detection, personalization, and CRM operations.

Each workflow below includes what it does, the Clay columns you need, the providers it connects to, and what you should expect as output. These aren't theoretical - they're workflows running in production right now across 40+ B2B GTM operations.

Enrichment Workflows

Workflow 1: The Company Enrichment Waterfall

What it does: Takes a list of company domains and enriches them with complete firmographic, technographic, and funding data using a cascading sequence of providers.

Clay columns:

1. domain (input) - Company website domain
2. apollo_company - Apollo Company Enrichment
3. clearbit_company - Clearbit Company Enrichment (fallback)
4. employee_count - Formula: coalesce Apollo count, Clearbit count
5. industry - Formula: coalesce Apollo industry, Clearbit industry
6. revenue_range - Formula: derive from Apollo or Clearbit revenue data
7. hq_location - Formula: coalesce location fields
8. year_founded - Formula: coalesce founding year fields
9. linkedin_url - Formula: extract from enrichment results
10. builtwith_tech - BuiltWith Technology Lookup
11. crunchbase_funding - Crunchbase Company Search
12. total_funding - Formula: extract from Crunchbase
13. last_funding_round - Formula: extract round type and date
14. icp_score - Formula: weighted score based on size, industry, tech stack, funding

Providers used: Apollo, Clearbit, BuiltWith, Crunchbase Expected output: 85-95% fill rate on core firmographic fields, complete tech stack data for 70-80% of companies, funding data for 40-60% of companies (higher for VC-backed) Cost per company: $0.05-0.15

Workflow 2: Find Decision Makers at Target Accounts

What it does: Given a list of company domains, finds the right contacts by title, seniority, and department. Returns verified decision-makers with full profile data.

Clay columns:

1. domain (input) - Target company domain
2. target_titles (input) - Title keywords to match (e.g., "VP Sales, CRO, Head of Revenue")
3. target_departments (input) - Department filter (e.g., "Sales, Revenue Operations")
4. apollo_people_search - Apollo People Search with title and department filters
5. linkedin_search - LinkedIn Sales Navigator Search (backup via Proxycurl or PhantomBuster)
6. contact_name - Formula: extract from best result
7. contact_title - Formula: extract exact title
8. contact_linkedin - Formula: extract LinkedIn profile URL
9. contact_seniority - Formula: classify as C-Level, VP, Director, Manager, IC
10. enrichment_score - Formula: rank contacts by seniority and title relevance

Providers used: Apollo, Proxycurl (LinkedIn), PhantomBuster (optional) Expected output: 2-5 relevant contacts per company, 80-90% of target companies return at least 1 match Cost per company: $0.10-0.30

Workflow 3: Email Waterfall

What it does: Takes a contact (name + company domain) and runs through multiple email-finding providers in sequence until a verified email is found.

Clay columns:

1. full_name (input)
2. domain (input)
3. linkedin_url (input, optional but improves results)
4. apollo_email - Apollo Contact Enrichment (email)
5. hunter_email - Hunter.io Email Finder
6. dropcontact_email - Dropcontact Email Finder
7. findymail_email - FindyMail Email Finder
8. snov_email - Snov.io Email Finder
9. best_email - Formula: first non-null from waterfall priority order
10. email_verification - ZeroBounce or MillionVerifier verification on best_email
11. email_status - Formula: extract valid/invalid/risky/catch-all
12. verified_email - Formula: only output if status is "valid"

Providers used: Apollo, Hunter.io, Dropcontact, FindyMail, Snov.io, ZeroBounce Expected output: 85-95% email coverage, 92-97% accuracy after verification Cost per contact: $0.03-0.12

Workflow 4: Phone Number Finder

What it does: Finds direct dial phone numbers and mobile numbers through multiple providers.

Clay columns:

1. full_name (input)
2. domain (input)
3. linkedin_url (input)
4. apollo_phone - Apollo Contact Enrichment (phone)
5. cognism_phone - Cognism Phone Lookup
6. lusha_phone - Lusha Contact Enrichment
7. rocketreach_phone - RocketReach Phone Finder
8. best_phone - Formula: first non-null direct dial
9. phone_type - Formula: classify as direct dial, mobile, or main line
10. phone_validated - Phone validation provider check

Providers used: Apollo, Cognism, Lusha, RocketReach Expected output: 40-65% direct dial coverage, higher for US-based contacts Cost per contact: $0.05-0.20

Workflow 5: Tech Stack Detection

What it does: Identifies the complete technology stack of a target company, with focus on tools relevant to your product category.

Clay columns:

1. domain (input)
2. builtwith_results - BuiltWith Technology Lookup
3. wappalyzer_results - Wappalyzer Technology Lookup
4. crm_detected - Formula: extract CRM (HubSpot, Salesforce, Pipedrive, etc.)
5. outbound_tools - Formula: extract outbound tools (Outreach, Salesloft, Instantly, etc.)
6. enrichment_tools - Formula: extract enrichment tools (ZoomInfo, Apollo, Clearbit, etc.)
7. marketing_automation - Formula: extract MAP (HubSpot, Marketo, Pardot, etc.)
8. analytics_tools - Formula: extract analytics (GA4, Mixpanel, Amplitude, etc.)
9. competitor_detected - Formula: boolean flag if competitor product is in tech stack
10. tech_fit_score - Formula: score based on presence of complementary tools and absence of competitors

Providers used: BuiltWith, Wappalyzer Expected output: Tech stack data for 75-85% of companies (higher for SaaS companies, lower for SMBs) Cost per company: $0.02-0.05

Signal Detection Workflows

Workflow 6: Funding Signal Monitor

What it does: Monitors target accounts for recent funding events and triggers enrichment + outreach when detected.

Clay columns:

1. domain (input) - Company domain from your target account list
2. crunchbase_latest - Crunchbase Company Search (latest funding)
3. funding_date - Formula: extract date of most recent round
4. funding_amount - Formula: extract round size
5. funding_round - Formula: extract round type (Seed, Series A, B, C, etc.)
6. days_since_funding - Formula: date difference from today
7. funding_is_recent - Formula: true if days_since_funding < 30
8. trigger_outreach - Formula: true if recent AND matches target round types

Providers used: Crunchbase Expected output: Flags accounts with funding in last 30 days, typically 2-5% of a 1,000-account watch list per month Cost per check: $0.01-0.03 Schedule: Run weekly against full target account list

Workflow 7: Hiring Signal Trigger

What it does: Detects when target accounts are hiring for specific roles, indicating growth, budget availability, or relevant team expansion.

Clay columns:

1. domain (input)
2. company_name (input)
3. job_postings_search - Google Search or LinkedIn Jobs API for "[company_name] careers [target department]"
4. open_roles_count - AI column: parse search results to count relevant open positions
5. relevant_roles - AI column: extract titles of positions relevant to your product
6. hiring_signal_strength - Formula: score based on number and seniority of open roles
7. trigger_outreach - Formula: true if 3+ relevant roles or 1+ senior role (VP/Director)

Providers used: Google Search (via SerpAPI or similar), AI analysis Expected output: Hiring signal data for 80-90% of companies checked, triggers on 5-15% showing active relevant hiring Cost per check: $0.02-0.05 Schedule: Run bi-weekly against target account list

Workflow 8: LinkedIn Profile Enricher

What it does: Takes a LinkedIn profile URL and extracts comprehensive profile data including work history, education, skills, recent activity, and mutual connections.

Clay columns:

1. linkedin_url (input)
2. proxycurl_profile - Proxycurl Person Profile Enrichment
3. full_name - Formula: extract from Proxycurl
4. current_title - Formula: extract current position title
5. current_company - Formula: extract current company
6. time_in_role - Formula: calculate months since current position start date
7. previous_company - Formula: extract most recent previous employer
8. previous_title - Formula: extract previous position title
9. education - Formula: extract university and degree
10. skills - Formula: extract listed skills
11. connections_count - Formula: extract connection count
12. recent_posts_summary - AI column: summarize recent LinkedIn activity if available

Providers used: Proxycurl Expected output: Full profile data for 90-95% of valid LinkedIn URLs Cost per profile: $0.01-0.03

Workflow 9: Website Scraper for Personalization

What it does: Scrapes a prospect's company website to extract messaging, value propositions, product descriptions, and other content that can be used for personalization.

Clay columns:

1. domain (input)
2. homepage_scrape - Clay Web Scraper (homepage)
3. about_page_scrape - Clay Web Scraper (/about or /about-us)
4. product_page_scrape - Clay Web Scraper (/product or /solutions)
5. company_description - AI column: synthesize a 2-sentence company description from scraped content
6. value_proposition - AI column: extract the company's primary value proposition
7. target_market - AI column: identify who the company sells to based on website content
8. recent_news - AI column: extract any news, announcements, or blog headlines
9. personalization_hooks - AI column: generate 3 specific angles that could be used in outreach

Providers used: Clay Web Scraper, Claude/GPT AI columns Expected output: Usable website data for 85-90% of companies, 3 personalization angles per company Cost per company: $0.03-0.08

Workflow 10: Job Change Detector

What it does: Monitors a list of target personas for job changes and triggers enrichment + outreach when someone moves to a new role.

Clay columns:

1. linkedin_url (input) - LinkedIn URLs of target personas
2. person_name (input)
3. last_known_company (input) - Their company when you added them
4. current_enrichment - Proxycurl or Apollo person enrichment
5. current_company - Formula: extract current company from enrichment
6. company_changed - Formula: compare current_company to last_known_company
7. new_company_domain - Formula: extract domain if company changed
8. new_company_icp_check - Company enrichment on new domain to check ICP fit
9. is_icp_match - Formula: does new company match your ICP criteria?
10. trigger_outreach - Formula: true if company_changed AND is_icp_match

Providers used: Proxycurl or Apollo, company enrichment providers Expected output: Job changes detected for 100% of people who changed (within data provider update frequency), typically 8-12% of a persona list changes jobs per year Cost per check: $0.01-0.03 Schedule: Run monthly against full persona list

Personalization and Outreach Workflows

Workflow 11: AI Email Writer

What it does: Takes enrichment data about a prospect and generates a personalized cold email using AI, following best-practice frameworks for cold outreach.

Clay columns:

1. prospect_name (input)
2. prospect_title (input)
3. prospect_company (input)
4. company_description (from Workflow 9)
5. tech_stack (from Workflow 5)
6. recent_signal (from Workflows 6, 7, or 10)
7. personalization_hooks (from Workflow 9)
8. email_subject - AI column: generate 3 subject line variants (under 6 words each)
9. email_body - AI column: generate personalized email body (50-80 words) using enrichment context
10. email_ps - AI column: generate a P.S. line with social proof or relevant case study reference
11. quality_score - AI column: self-evaluate the email on personalization, relevance, and tone (1-10)
12. final_email - Formula: combine best subject, body, and PS if quality_score >= 7

AI prompt framework for email generation:

The prompt should include:

• All enrichment data about the prospect
• Your value proposition and target outcomes
• 2-3 example emails that performed well historically
• Constraints: under 80 words, no spam trigger phrases, no "I noticed" or "I came across," conversational tone, ends with specific question

Providers used: Claude API or GPT-4 via Clay AI column Expected output: Personalized email for 95%+ of enriched prospects, 70-80% score 7+ on quality Cost per email: $0.02-0.08

Workflow 12: Lead Scoring Calculator

What it does: Takes enrichment data and calculates a composite lead score based on ICP fit, intent signals, and engagement data.

Clay columns:

1. domain (input)
2. employee_count (from Workflow 1)
3. industry (from Workflow 1)
4. revenue_range (from Workflow 1)
5. tech_stack_fit (from Workflow 5)
6. funding_recency (from Workflow 6)
7. hiring_signal (from Workflow 7)
8. job_change_signal (from Workflow 10)
9. firmographic_score - Formula: 0-30 points based on size, industry, revenue match
10. technographic_score - Formula: 0-20 points based on tech stack compatibility
11. intent_score - Formula: 0-30 points based on signals (funding, hiring, job change)
12. engagement_score - Formula: 0-20 points based on website visits, content downloads
13. total_score - Formula: sum of all component scores (0-100)
14. tier - Formula: Tier 1 (80+), Tier 2 (60-79), Tier 3 (40-59), Tier 4 (below 40)
15. recommended_action - Formula: Tier-specific action (Tier 1: immediate outreach, Tier 2: add to sequence, Tier 3: nurture, Tier 4: monitor)

Providers used: None additional - uses data from other workflows Expected output: Scored and tiered lead list with action recommendations Cost per lead: $0.00 (formulas only, no API calls)

Workflow 13: CRM Sync (HubSpot)

What it does: Pushes enriched, scored, and qualified leads from Clay into HubSpot with all enrichment data mapped to CRM properties.

Clay columns:

1. All enrichment fields from upstream workflows
2. hubspot_contact_create - HubSpot Create/Update Contact action
3. hubspot_company_create - HubSpot Create/Update Company action
4. hubspot_deal_create - HubSpot Create Deal (optional, for Tier 1 leads)
5. sync_status - Formula: success/failure status of HubSpot sync
6. hubspot_contact_id - Formula: extract created contact ID for reference

Field mapping:

Clay Field: verified_email | HubSpot Property: email | Type: Contact

Clay Field: full_name | HubSpot Property: firstname, lastname | Type: Contact

Clay Field: current_title | HubSpot Property: jobtitle | Type: Contact

Clay Field: linkedin_url | HubSpot Property: linkedin_profile | Type: Contact

Clay Field: best_phone | HubSpot Property: phone | Type: Contact

Clay Field: lead_score | HubSpot Property: lead_score (custom) | Type: Contact

Clay Field: tier | HubSpot Property: lead_tier (custom) | Type: Contact

Clay Field: domain | HubSpot Property: domain | Type: Company

Clay Field: employee_count | HubSpot Property: numberofemployees | Type: Company

Clay Field: industry | HubSpot Property: industry | Type: Company

Clay Field: revenue_range | HubSpot Property: annualrevenue | Type: Company

Clay Field: total_funding | HubSpot Property: total_funding (custom) | Type: Company

Clay Field: tech_stack | HubSpot Property: tech_stack (custom) | Type: Company

Providers used: HubSpot API via Clay integration Expected output: Contacts and companies created/updated in HubSpot with full enrichment data Cost per sync: $0.00 (included in Clay plan)

Workflow 14: Duplicate Detection

What it does: Checks incoming leads against your existing CRM database and Clay tables to prevent duplicate outreach and wasted enrichment spend.

Clay columns:

1. email (input) - New lead email
2. domain (input) - New lead company domain
3. hubspot_search - HubSpot Search Contact by email
4. existing_contact_id - Formula: extract HubSpot ID if exists
5. is_existing_contact - Formula: boolean true if found in HubSpot
6. hubspot_company_search - HubSpot Search Company by domain
7. existing_company_id - Formula: extract company ID if exists
8. has_active_deal - HubSpot check for open deals at the company
9. suppress - Formula: true if existing contact with recent activity, OR has active deal, OR on suppression list
10. action - Formula: "skip" if suppress, "enrich and send" if new, "update existing" if stale record

Providers used: HubSpot API Expected output: Deduplication decision for every incoming lead, typically suppresses 15-30% of raw lists Cost per check: $0.00 (CRM API calls)

Workflow 15: Multi-Channel Sequence Loader

What it does: Takes qualified, enriched leads and pushes them into the appropriate email sequence in Instantly or Smartlead, with personalized email copy pre-loaded.

Clay columns:

1. All enrichment and personalization fields from upstream workflows
2. tier (from Workflow 12)
3. sequence_id - Formula: map tier to appropriate sequence (Tier 1 -> high-touch sequence, Tier 2 -> standard, etc.)
4. email_step_1 (from Workflow 11)
5. email_step_2 - AI column: generate follow-up email
6. email_step_3 - AI column: generate third touch
7. instantly_push - Instantly Add Lead to Campaign action
8. push_status - Formula: success/failure of sequence enrollment

Providers used: Instantly or Smartlead API Expected output: Qualified leads automatically enrolled in appropriate sequences with personalized copy Cost per lead: $0.00-0.02 (API costs only)

Advanced Workflows

Workflow 16: Competitor Displacement Campaign Builder

What it does: Identifies companies using a specific competitor product and generates targeted displacement messaging.

Clay columns:

1. domain (input) - Target company domain
2. builtwith_tech - BuiltWith Technology Lookup
3. competitor_detected - Formula: check for specific competitor tool
4. competitor_name - Formula: extract which competitor is installed
5. time_on_competitor - Formula: estimate based on BuiltWith first-detected date
6. company_enrichment - Standard company enrichment (Workflow 1)
7. displacement_angle - AI column: generate 3 messaging angles based on known competitor weaknesses and prospect context
8. email_body - AI column: write displacement-focused outreach using best angle
9. case_study_match - Formula: select most relevant case study of a company that switched from this competitor

Providers used: BuiltWith, AI columns, company enrichment providers Expected output: Targeted displacement campaigns with competitor-specific messaging Cost per company: $0.05-0.15

Workflow 17: LinkedIn Content Engagement Tracker

What it does: Monitors LinkedIn posts by target prospects and identifies engagement opportunities.

Clay columns:

1. linkedin_url (input) - Target person's LinkedIn profile
2. recent_posts - Proxycurl or PhantomBuster recent activity pull
3. post_topics - AI column: categorize each recent post by topic
4. relevant_posts - Formula: filter for posts related to your product category
5. engagement_opportunity - AI column: generate a thoughtful comment or reply for relevant posts
6. outreach_angle - AI column: create an outreach message that references their LinkedIn content naturally

Providers used: Proxycurl, PhantomBuster, AI columns Expected output: Content-based engagement opportunities and personalized outreach angles Cost per profile: $0.03-0.08

Workflow 18: Event Attendee Enricher

What it does: Takes a list of event attendees (from conferences, webinars, etc.) and enriches them for targeted post-event outreach.

Clay columns:

1. full_name (input)
2. company_name (input)
3. email (input, possibly from registration)
4. event_name (input)
5. linkedin_search - Find LinkedIn profile from name + company
6. company_enrichment - Full company enrichment waterfall
7. contact_enrichment - Full contact enrichment
8. icp_match - Formula: does this person match your ICP?
9. event_personalization - AI column: create outreach that references the shared event naturally
10. email_body - AI column: write post-event outreach combining event context with their company data

Providers used: Apollo, Proxycurl, Clearbit, AI columns Expected output: Enriched attendee list with personalized post-event outreach ready Cost per attendee: $0.10-0.25

Workflow 19: Account Expansion Signal Detector

What it does: For existing customers, monitors for expansion signals that indicate upsell or cross-sell opportunities.

Clay columns:

1. customer_domain (input) - Existing customer domains
2. current_arr (input) - Current contract value
3. employee_growth - Apollo or Clearbit company enrichment (compare to last check)
4. new_departments - AI analysis: detect new department creation from hiring patterns
5. funding_event - Crunchbase check for new funding
6. tech_stack_change - BuiltWith delta from last check
7. hiring_in_your_department - Job posting check for roles in the department you serve
8. expansion_score - Formula: weighted score of expansion signals
9. recommended_play - AI column: suggest specific upsell/cross-sell play based on signals
10. account_owner_alert - Formula: generate Slack message for account owner if expansion_score exceeds threshold

Providers used: Apollo, Crunchbase, BuiltWith, Google Search, AI columns Expected output: Expansion opportunity alerts for 5-15% of customer base per month Cost per customer check: $0.05-0.15 Schedule: Run monthly

Workflow 20: ICP Lookalike Finder

What it does: Takes your best customers and finds companies that look like them across multiple dimensions.

Clay columns:

1. customer_domain (input) - Your top 20-50 customer domains
2. customer_profile - Full company enrichment for each customer
3. common_attributes - AI column: analyze customer cohort to identify shared firmographic, technographic, and behavioral patterns
4. apollo_similar_search - Apollo Company Search with filters matching common attributes
5. lookalike_companies - Results from Apollo search
6. lookalike_enrichment - Full company enrichment on lookalike results
7. similarity_score - Formula: calculate how closely each lookalike matches the ideal customer profile derived from actual customers
8. already_in_pipeline - CRM check to exclude existing prospects and customers
9. net_new_lookalikes - Formula: filter to only new, high-similarity companies

Providers used: Apollo, company enrichment waterfall, HubSpot CRM check Expected output: 200-500 net new target accounts that closely resemble your best customers Cost per batch run: $10-30

Workflow 21: Inbound Lead Instant Enrichment

What it does: Triggers when a new lead comes in via form submission (webhook from HubSpot/website), instantly enriches them, scores them, and routes them.

Clay columns:

1. email (webhook input)
2. full_name (webhook input)
3. company (webhook input)
4. form_source (webhook input) - Which form they filled out
5. email_verification - Instant email verification
6. is_valid_email - Formula: filter out typos and spam submissions
7. contact_enrichment - Apollo or Clearbit person enrichment
8. company_enrichment - Clearbit or Apollo company enrichment from domain
9. lead_score - Formula: instant ICP scoring
10. tier - Formula: Hot / Warm / Nurture / Disqualified
11. assigned_rep - Formula: territory-based or round-robin assignment
12. hubspot_update - Push all enrichment data back to HubSpot contact record
13. slack_alert - Send notification to assigned rep's Slack with full context
14. calendar_link - Formula: generate rep-specific booking link

Providers used: ZeroBounce (verification), Apollo or Clearbit (enrichment), HubSpot (CRM), Slack Expected output: Full enrichment and routing in under 60 seconds from form submission Cost per lead: $0.05-0.15

Workflow 22: Bounced Lead Recovery

What it does: Takes contacts whose emails bounced in outbound campaigns, attempts to find alternative email addresses, and re-enrolls them if successful.

Clay columns:

1. full_name (input) - From bounced contact list
2. domain (input)
3. bounced_email (input) - The email that bounced
4. linkedin_url (input, if available)
5. alternative_email_1 - Hunter.io (different search than original)
6. alternative_email_2 - Dropcontact
7. alternative_email_3 - FindyMail
8. alternative_email_4 - Snov.io
9. best_alternative - Formula: first non-null that isn't the bounced email
10. verification - ZeroBounce on best_alternative
11. is_valid - Formula: verified as valid
12. re_enroll - Formula: push to sequence if valid alternative found

Providers used: Hunter.io, Dropcontact, FindyMail, Snov.io, ZeroBounce Expected output: Recovers valid email addresses for 30-50% of bounced contacts Cost per contact: $0.05-0.15

Workflow 23: Persona-Based Content Recommender

What it does: Matches prospects to the most relevant content assets (case studies, blog posts, guides) based on their persona, industry, and company stage.

Clay columns:

1. prospect_title (input)
2. prospect_industry (input)
3. company_size (input)
4. company_stage (input)
5. detected_pain_points (from Workflow 9 personalization hooks)
6. content_match - AI column: given the prospect profile and a list of your content assets (passed as context), recommend the top 3 most relevant pieces
7. primary_content_url - Formula: extract URL of best match
8. content_angle - AI column: write a 1-sentence explanation of why this content is relevant to this specific prospect

Providers used: AI columns only (no external APIs needed beyond enrichment) Expected output: Personalized content recommendation for every prospect Cost per prospect: $0.01-0.03

Workflow 24: Meeting Prep Package Generator

What it does: For prospects who have booked meetings, generates a comprehensive prep package for the AE with all relevant context.

Clay columns:

1. contact_email (input) - From calendar booking notification
2. full_enrichment - Run complete contact and company enrichment
3. linkedin_activity - Pull recent LinkedIn posts and activity
4. company_news - Google News search for recent company mentions
5. tech_stack - BuiltWith technology lookup
6. open_roles - Job posting search
7. competitive_landscape - AI column: identify which competitors they might be evaluating
8. talk_tracks - AI column: generate 3 conversation openers based on prospect context
9. potential_objections - AI column: predict likely objections based on company profile
10. meeting_brief - AI column: synthesize all data into a 1-page meeting prep brief

Providers used: Apollo, Proxycurl, BuiltWith, Google Search, AI columns Expected output: Comprehensive meeting prep document in under 2 minutes from booking Cost per meeting: $0.15-0.30

Workflow 25: Win/Loss Enrichment Analyzer

What it does: Enriches won and lost deals with additional data to identify patterns that predict future outcomes.

Clay columns:

1. company_domain (input) - From CRM closed deals
2. deal_outcome (input) - Won or Lost
3. deal_value (input)
4. sales_cycle_days (input)
5. full_company_enrichment - Complete firmographic, technographic, funding data
6. tech_stack_at_close - BuiltWith snapshot
7. employee_count_at_close - Apollo company data
8. industry_classification - Standardized industry from enrichment
9. had_champion_title - Formula: was the primary contact at VP+ level?
10. had_funding_signal - Formula: did they raise funding in the 6 months before deal?
11. pattern_analysis - AI column: compare won vs. lost deal attributes and identify predictive patterns
12. icp_refinement - AI column: suggest ICP adjustments based on win/loss patterns

Providers used: Company enrichment waterfall, BuiltWith, AI columns Expected output: Enriched win/loss dataset with pattern analysis for ICP refinement Cost per deal: $0.10-0.20 Schedule: Run quarterly on all closed deals

Workflow Chaining: How to Connect These Together

The real power of Clay workflows is chaining them into end-to-end pipelines. Here are three production-ready chains:

Chain A: Full Prospecting Pipeline

`` Workflow 1 (Company Enrichment) -> Workflow 5 (Tech Stack Detection) -> Workflow 2 (Find Decision Makers) -> Workflow 3 (Email Waterfall) -> Workflow 4 (Phone Number Finder) -> Workflow 14 (Duplicate Detection) -> Workflow 12 (Lead Scoring) -> Workflow 11 (AI Email Writer) -> Workflow 15 (Sequence Loader) -> Workflow 13 (CRM Sync) ``

Total cost per fully processed lead: $0.30-0.80 Total time per lead: 2-5 minutes (automated) What you get: A fully enriched, scored, deduplicated lead enrolled in a personalized email sequence with all data synced to your CRM.

Chain B: Signal-Triggered Outreach

`` Workflow 6 (Funding Monitor) OR Workflow 7 (Hiring Signal) OR Workflow 10 (Job Change) -> Workflow 1 (Company Enrichment) -> Workflow 2 (Find Decision Makers) -> Workflow 3 (Email Waterfall) -> Workflow 9 (Website Scraper) -> Workflow 11 (AI Email Writer - with signal context) -> Workflow 15 (Sequence Loader) -> Workflow 13 (CRM Sync) ``

Total cost per signal-triggered lead: $0.25-0.60 Cadence: Runs weekly/bi-weekly, processes 20-100 triggered leads per cycle What you get: Timely, signal-based outreach that reaches prospects within days of a buying signal.

Chain C: Inbound Processing

`` Workflow 21 (Inbound Instant Enrichment) -> Workflow 12 (Lead Scoring) -> Workflow 14 (Duplicate Detection) -> Workflow 13 (CRM Sync with routing) -> Workflow 24 (Meeting Prep - if meeting booked) ``

Total cost per inbound lead: $0.10-0.25 Processing time: Under 60 seconds What you get: Instantly enriched, scored, and routed inbound leads with zero manual work.

Cost Summary Table

Workflow: 1. Company Enrichment | Cost Per Unit: $0.05-0.15 | Typical Volume/Month: 2,000 companies | Monthly Cost: $100-300

Workflow: 2. Find Decision Makers | Cost Per Unit: $0.10-0.30 | Typical Volume/Month: 2,000 companies | Monthly Cost: $200-600

Workflow: 3. Email Waterfall | Cost Per Unit: $0.03-0.12 | Typical Volume/Month: 5,000 contacts | Monthly Cost: $150-600

Workflow: 4. Phone Number Finder | Cost Per Unit: $0.05-0.20 | Typical Volume/Month: 2,000 contacts | Monthly Cost: $100-400

Workflow: 5. Tech Stack Detection | Cost Per Unit: $0.02-0.05 | Typical Volume/Month: 2,000 companies | Monthly Cost: $40-100

Workflow: 6-10. Signal Detection | Cost Per Unit: $0.01-0.05 | Typical Volume/Month: 5,000 checks | Monthly Cost: $50-250

Workflow: 11. AI Email Writer | Cost Per Unit: $0.02-0.08 | Typical Volume/Month: 3,000 emails | Monthly Cost: $60-240

Workflow: 12. Lead Scoring | Cost Per Unit: $0.00 | Typical Volume/Month: Unlimited | Monthly Cost: $0

Workflow: 13-15. CRM/Sequence | Cost Per Unit: $0.00-0.02 | Typical Volume/Month: 3,000 leads | Monthly Cost: $0-60

Workflow: Total typical monthly | Cost Per Unit: $700-2,550 | Typical Volume/Month: | Monthly Cost:

FAQ

How long does it take to build these workflows in Clay?

Simple workflows (like the Email Waterfall or Company Enrichment) take 1-2 hours to build if you're familiar with Clay. Complex workflows with AI columns and multi-step logic (like the AI Email Writer or Meeting Prep Generator) take 3-5 hours. A complete Chain A (full prospecting pipeline) typically takes 2-3 days to build and test. If you're new to Clay, add 50-100% more time for the learning curve, or consider hiring an agency that specializes in Clay implementations.

Which Clay plan do I need for these workflows?

Most of these workflows require Clay's Pro or Enterprise plan ($500-2,000+/month) for adequate enrichment credits and table row limits. The Explorer plan works for testing individual workflows but hits credit limits quickly in production. The biggest cost driver is enrichment provider credits - a high-volume prospecting operation can consume 10,000+ credits per month.

Can I run these workflows on a schedule without manual intervention?

Yes. Clay supports scheduled table runs (daily, weekly, or custom) and webhook triggers for real-time processing. Signal detection workflows (6, 7, 10) should run on weekly or bi-weekly schedules. Inbound processing (Workflow 21) should run via webhook for real-time response. Prospecting pipelines (Chain A) can run on demand when new target account lists are loaded.

How do I handle rate limits and API failures?

Clay handles most rate limiting internally for its native integrations. For custom HTTP requests, build retry logic using Clay's conditional columns - if the first attempt returns an error, trigger a second attempt after a delay. For critical workflows (like CRM sync), add a sync_status column that flags failures for manual review. In production, expect 2-5% of API calls to fail on any given run due to rate limits, provider downtime, or data issues.

Should I build these myself or hire someone?

If you have a technical team member who can dedicate 20-40 hours to Clay setup and ongoing maintenance, building in-house is cost-effective. If you need all 25 workflows running in production within 30 days and can't dedicate internal resources, hiring a Clay-specialized agency (like GTME) is faster and produces more reliable results. The typical agency engagement for a full Clay implementation is 4-8 weeks and $5,000-15,000 in setup fees plus ongoing management.