Clay playbook · Problem 4 of 5 · Data orchestration

Inbound: Enrich, Score & Route in Minutes

Responding to an inbound lead within 5 minutes makes you 21 times more likely to qualify it, yet the average first touch takes 42 to 47 hours. This playbook builds the Clay pipeline that enriches, scores and routes every lead while the buyer is still on your site.

By Langley Erickson · CascadeGTM · July 2026

The problem

The lead arrives with a name, an email and little else. Someone has to figure out who they are, whether they fit, and whose territory they belong to, and until that happens nothing moves. Manual triage batches into mornings, weekends stack up, hot leads cool, and the demo request you paid marketing to generate gets its first reply two days later.

This playbook is part of the companion set to Data Orchestration in 2026: Why Clay Sits Under Every Modern GTM Stack. Read that first for the strategy; this is the build.

What you will build

An Inbound Pipeline table triggered by webhook the moment a form submits. Clay enriches the person and company in seconds through a waterfall, scores fit against your ICP with a transparent formula, routes to the right owner, writes the enriched lead to the CRM, and alerts the rep in Slack with everything they need to respond immediately. Median speed to lead: under five minutes, around the clock.

The stack

Clay (Growth plan)Required: webhook intake, HTTP API columns and CRM auto-sync are Growth features.
Form source: HubSpot forms, Marketo or TypeformFires the webhook on submit.
Providers: Apollo + Prospeo + a company enricherFast waterfall for person and firmographic fill.
CRM: Salesforce or HubSpotReceives the enriched, scored, routed lead.
SlackThe rep alert channel; the alert is the speed.
Calendar link (Chili Piper or native)Optional: qualified leads get routed straight to booking.

Architecture

Event-driven, not batch: the form fires a webhook, Clay does the thinking in seconds, and the rep gets a ready-to-act alert instead of a raw form fill.

Form submitwebhook fires
Enrichfast waterfall
Score + routeICP formula + lookup
CRM + Slackowner alerted
Event-driven end to end: under five minutes from submit to rep alert.

Clay tables and connected objects:

Inbound Pipeline (Clay table) · Source: monitor webhook. Columns: payload fields, enrichment waterfall outputs, ICP score with reasons, assigned owner, CRM write status, Slack alert status, timestamps for each stage.
Routing rules (Clay lookup table) · Territory and segment map: country + employee band + segment to owner. Sales leadership owns the contents; the pipeline reads it.
CRM Lead/Contact object · Receives the enriched record with score and owner set; assignment rules stay off because Clay already decided.
SLA view (Clay) · Every lead with elapsed minutes from submit to first rep touch; the number the whole system answers to.

The build, step by step

1

Catch the lead with a webhook

Create a table from Import data → Monitor webhook and paste the generated URL into your form tool's webhook action (HubSpot workflows, Marketo webhook step, or Typeform connect).

Payload to send from the form
{"email": "jane@acme.com", "first_name": "Jane", "last_name": "Doe",
 "company": "Acme", "message": "interested in a demo",
 "form": "demo-request", "page": "/pricing",
 "submitted_at": "2026-07-07T14:02:11Z"}

Include the form name and page; they matter for scoring (a pricing-page demo request is not a whitepaper download).

2

Enrich at webhook speed

Add a short waterfall: person enrichment from the email (Apollo then Prospeo), and company enrichment from the domain (industry, employee count, tech stack, funding). Keep this chain to two or three fast providers; this is the one place where latency matters more than the last few points of coverage. Set every column to run automatically on new rows.

3

Score fit with a transparent formula

Resist the black-box scoring temptation; reps need to see why. Use an additive formula:

Formula prompt: ICP score (0-100)
Start at 0. Add 30 if Employee Count is between 100 and 2000.
Add 20 if Industry is in (Software, Fintech, Business Services).
Add 20 if Title contains VP, Head, Director, or C-level.
Add 15 if Form is "demo-request"; add 5 if Page contains "pricing".
Add 15 if Tech Stack contains Salesforce or HubSpot.
Cap at 100. Also return the list of reasons that fired.

Then a tier formula: 70+ is hot, 40-69 is warm, under 40 is nurture. Sales leadership signs off on the weights, and the reasons column travels with the lead.

4

Route with the lookup table

Add a lookup against the Routing Rules table on country + employee band + segment to resolve the owner. Round-robin within a territory by cycling a counter column. Because leadership edits the routing table directly in Clay, territory changes take effect without touching the pipeline.

5

Write to CRM and fire the alert

Write the enriched, scored, owner-assigned lead to the CRM, then send the Slack alert in the same run:

HTTP API column: Slack rep alert
POST https://slack.com/api/chat.postMessage
Body: {"channel": "{{Owner Slack ID}}",
 "text": "HOT inbound ({{Score}}): {{First Name}} {{Last Name}}, {{Title}}
at {{Company}} ({{Employees}} ppl, {{Industry}}). Asked: '{{Message}}'
from {{Page}}. Reasons: {{Score Reasons}}. CRM: {{Record Link}}.
Clock is running: respond within 5 minutes."}

For hot leads, optionally skip the human: route straight to a booking link in the auto-reply. For everyone else, the rep replies with full context in one glance.

6

Instrument the SLA

Timestamp each stage (received, enriched, routed, alerted, first touch from CRM activity) and build the SLA view on elapsed minutes. Post a daily digest to the sales channel: median speed to lead, leads over SLA, conversion by tier. What gets posted publicly gets fixed.

Measuring success

One number rules this playbook: median minutes from form submit to first rep touch. Everything else is diagnosis.

MetricWhere to measureTargetYou know it is solved when
Median speed to leadClay SLA view + CRM first-activity timestampUnder 5 minutes for hot tierThe 42-hour average becomes a war story
Lead-to-opportunity conversionCRM funnel report by tier, before vs afterMeaningful lift on hot tier within one quarterMarketing stops arguing about lead quality and starts arguing about volume
Routing accuracyReassignment count in CRMUnder 2% of leads reassignedTerritory disputes leave the pipeline meeting agenda
Enrichment latencyClay stage timestampsUnder 60 seconds submit to alertReps trust the alert enough to act on it alone

Staffing the workflow

Growth plan is non-negotiable here; webhooks and HTTP API carry the whole flow. The build is a focused sprint.

PhaseHoursWho
Build: webhook, waterfall, scoring, routing, alerts20 to 30 hoursGTM engineer
Rollout: SLA baseline, rep training, routing sign-off6 to 8 hoursGTM engineer + sales leadership
Maintenance3 to 4 hours per monthGTM engineer

Maintenance and monitoring

Workflows drift as your GTM strategy, ICP and stack change. Keep this one honest with the following cadence.

Related

Want this running in your stack?

I build Clay-powered data orchestration systems for growth-stage GTM teams: this playbook and the four beside it, tuned to your ICP, CRM and motion.