Clay Icon
Join the Community
02 Support

How to Enrich HubSpot Data in Clay Without Creating New Columns

Avatar of Benjamin D.Benjamin D.
·
·

New to Clay, just signed up, daft question and I am sure it's very simple. I am importing data from Hubspot, using Clay to clean the data and as a cold CRM for various outreach tools we use. When I enrich data to find missing stuff, how do I set it so Clay can fill in the missing data rather than create new cols? For example, we might have a table with 100 contacts in, 50 of them will have a First Name and Last Name I can enrich the data using various tools such as Linked in, which creates the col and fills int the info, but I want that back in my Hubspot record so I can write it back into Hubspot... does that makes sense?

2 comments

  • Avatar of Channeled
    Channeled
    APP
    ·
    ·

    To fill in missing data in existing columns and sync it back to HubSpot, you can use our enhanced HubSpot integration. Here's how: 1. Go to "Add Enrichment" and select "HubSpot". 2. Choose the "Update" action. 3. Enable the "Ignore Blanks" option to prevent overwriting existing data. 4. Select the fields you want to update in HubSpot. This process will update your HubSpot records with the enriched data from Clay, filling in missing information without creating new columns. The "Ignore Blanks" feature ensures that only empty fields are updated, preserving your existing data. To sync the data back to HubSpot, Clay uses the ID from your initial import to update the corresponding records in your CRM. This closed-loop system keeps your HubSpot data current with the latest enriched information from Clay.

  • Avatar of Channeled
    Channeled
    APP
    ·
    ·