Clay Icon

How to Use Write-To Enrichment on Clay for Data Integration

ยท
ยท

Hi! Could someone show me how to use the "write-to" enrichment on Clay? Hopefully shouldn't be too long - i just get an error for all the variables i'm trying to pull from one table to another i have a table which is finding people but has no information on their company i have another table which has the company data i want So i really want to fill in the people table with company data (company name, primary industry, size, location, country) So that for each row in the people table i can see the person + their respective company data.

  • Avatar of Jani V.
    Jani V.
    ยท
    ยท

    I think you need to use the lookup single row in another table enrichment, not the write to essentially, this will allow you to look up a record in another table that shares a unique identifier between the tables, like a company's domain or linkedin URL hope that helps!

  • Avatar of LuisArturo
    LuisArturo
    ยท
    ยท

    Hey there William thanks for reaching out and appreciate you jumping in Jani! As Jani mentioned a "Lookup Single row in Other Table" will work best here. The following loom can help you understand how the integration works: https://www.loom.com/share/72f4e67e20424ba7a784ca9a5056f1a9?sid=722bc6b6-7668-468d-8989-dc65cafcaa9e

  • Avatar of William R.
    William R.
    ยท
    ยท

    ah amazing thank you so much both! Really appreciate it :

  • Avatar of William R.
    William R.
    ยท
    ยท

    ๐Ÿ™‚

  • Avatar of Channeled
    Channeled
    APP
    ยท
    ยท

    Hi William R.! This thread was recently closed by our Support team. If you have a moment, please share your feedback: