Clay Icon

Help Needed: Mapping Colleagues in Clay by Matching Domains

Β·
Β·

Hey Clay legends - need some help over here 🫢 I have a table with 2k contacts Unique companies are approx 1k So there are multiple contacts per company I want to create a new column, to map out "colleagues" by basically matching the domains and IF there's a duplicate, output the data of the "first name" column into a new column I know how to do this with googlesheet - been doing this for multi-threading campaigns (e.g. "also reached out to your {{colleague}}) I'm wondering if we can do this with Clay. Any pros?