Back to library
Clay template

Inbound lead triage table

A ready Clay table layout that scores, routes and dedupes every inbound signup before it hits the CRM.

Columns it needs

email

The snippet

Columns, in order:
1. email (input)
2. work_email = IF(CONTAINS(email,"gmail.com"),"personal","work")
3. domain = SPLIT(email,"@",2)
4. Enrich company (domain)
5. employees, industry, country
6. icp_fit = AI column, output "strong|weak|no"
7. dedupe_key = LOWER(domain)
8. owner = lookup from territory table
9. route = IF(icp_fit="strong","AE","nurture")

How to use it

  1. 1Create a blank table and add the columns top to bottom in this order.
  2. 2Set run conditions so enrichment only fires when work_email = "work".
  3. 3Add a webhook write-back on route so the CRM gets the owner immediately.
inboundroutingtable

Related patterns