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