Back to library
Clay formula

Build email from a known pattern

Constructs first.last style addresses when you already know the company's pattern.

Columns it needs

First NameLast NameCompany domain

The snippet

LOWER(CONCAT(TRIM({{First Name}}), ".", TRIM({{Last Name}}), "@", {{Company domain}}))

How to use it

  1. 1Only use as the last step of a waterfall, after paid providers return empty.
  2. 2Always pass the result through a validation step before sending.
emailpatternwaterfall

Related patterns