Limiting Column Imports from HubSpot in Clay: A Guide

Mattijs · 2025-07-02 13:36:04.446173+00

I'm looking whether and how I can limit which columns I pull from HubSpot when either importing objects from lists or using the HubSpot lookup function. I've seen some references to being able to limit which columns are being imported but can't find it in Clay ;-(

Limiting Column Imports from HubSpot in Clay: A Guide | Clay

6 comments

· Sorted by Oldest

Clay
APP
·
·
You can selectively choose which data fields to import from HubSpot in Clay. With access to over 370 properties from HubSpot, you can tailor your import to include precisely the information you need - for instance, you might choose to pull email addresses and company names for each contact. When importing, you'll have options to: ** Include read-only properties (helpful for non-editable fields) ** Exclude empty properties (reduces clutter in your Clay table) Once imported, data appears in a single column with all associated values. You can then extract specific data points by clicking into a record and selecting the data field you need, then extract multiple fields to separate columns for better organization.
Sources: Import from CRM [CRM Enrichment] - Clay University Import from CRM [Clay 101] - Clay University Import from CRM [Clay 101] - Clay University
Mattijs
·
·
That's not what I'm looking for. The customer I'm working for wants to limit the data before it's being pulled in Clay. The solution you've provided toggles which data is presented in a Clay table; but at that stage it's already somewhere in Clay, correct?
LuisArturo (Clay)
·
·
Hey there Mattijs thanks for reaching out, sorry for the delay here, to clarify here if you are trying to limit which properties will be added to Clay when importing, then this would be done within HubSpot by editing the Property visibility inside of HubSpot, from the Property Management menu
Mattijs
·
·
Wow that sounds like a really neat feature. Is that available in the Clay app settings in HubSpot?
LuisArturo (Clay)
·
·
Hey there Mattijs sorry for the delay here, within the the companies page, you can click on "Actions" and then select "Edit Properties".
(40 kB)
From here you can select which properties you want to manage access for which will appear as "Manage access"
(33 kB)
Channeled
APP
·
·
This thread was picked up by our in-app web widget and will no longer sync to Slack. If you are the original poster, you can continue this conversation by logging into https://app.clay.com and clicking "Support" in the sidebar. If you're not the original poster and require help from support, please post in 02 Support.

Clay
APP
·
·
You can selectively choose which data fields to import from HubSpot in Clay. With access to over 370 properties from HubSpot, you can tailor your import to include precisely the information you need - for instance, you might choose to pull email addresses and company names for each contact. When importing, you'll have options to: ** Include read-only properties (helpful for non-editable fields) ** Exclude empty properties (reduces clutter in your Clay table) Once imported, data appears in a single column with all associated values. You can then extract specific data points by clicking into a record and selecting the data field you need, then extract multiple fields to separate columns for better organization.
Sources: Import from CRM [CRM Enrichment] - Clay University Import from CRM [Clay 101] - Clay University Import from CRM [Clay 101] - Clay University
Mattijs
·
·
That's not what I'm looking for. The customer I'm working for wants to limit the data before it's being pulled in Clay. The solution you've provided toggles which data is presented in a Clay table; but at that stage it's already somewhere in Clay, correct?
LuisArturo (Clay)
·
·
Hey there Mattijs thanks for reaching out, sorry for the delay here, to clarify here if you are trying to limit which properties will be added to Clay when importing, then this would be done within HubSpot by editing the Property visibility inside of HubSpot, from the Property Management menu
Mattijs
·
·
Wow that sounds like a really neat feature. Is that available in the Clay app settings in HubSpot?
LuisArturo (Clay)
·
·
Hey there Mattijs sorry for the delay here, within the the companies page, you can click on "Actions" and then select "Edit Properties".
(40 kB)
From here you can select which properties you want to manage access for which will appear as "Manage access"
(33 kB)
Channeled
APP
·
·
This thread was picked up by our in-app web widget and will no longer sync to Slack. If you are the original poster, you can continue this conversation by logging into https://app.clay.com and clicking "Support" in the sidebar. If you're not the original poster and require help from support, please post in 02 Support.