Clay Icon

Guidelines for Enriching Company Data in Clay Tables

Β·
Β·

I uploaded a list of companies (name, address, phone, domain, LLC name and address) via csv into a clay table. Next I tried to enrich for CEO and/or Founder. Then I enriched for work and personal email address. Most of the companies are owned by LLCs so I enriched for owner/ceo of LLC and work/personal email and phone This is the final list that would like to have I got close and was trying to all of the info on one table so I can export to my CRM. GPT recommends Duplicating the table clicking a three dot menu in the upper right of the table. However there are three dots on the upper right. It also recommends filtering and creating a new table. But got a little bit confusing

  • Avatar of Channeled
    Channeled
    APP
    Β·
    Β·

    To consolidate enriched information into one table for CRM export, you can follow these steps: 1. Create a new table in Clay by clicking "Create New" > "Table" and choosing the appropriate type (Custom, Company, or People). 2. Use the "Lookup" feature to pull data from other tables. This allows you to combine information from multiple sources into your new table. 3. Once your data is consolidated, use Clay's CRM export feature. Click on "Actions" in the top right of your table, select "Export," and choose your CRM (e.g., HubSpot, Salesforce). 4. Map your Clay table fields to the corresponding CRM fields, ensuring data types match to avoid errors. 5. Run the export to push your consolidated, enriched data to your CRM. This process streamlines your workflow, ensuring all enriched data is in one place before exporting to your CRM.

  • Avatar of Channeled
    Channeled
    APP
    Β·
    Β·