Is there a way to narrow down the imported Companies (filter), so that...

·

Is there a way to narrow down the imported Companies (filter), so that Clay only pulls in the Companies with a certain set of criteria?

9 comments

Clay Team
APP
·
Hey hey! Can you drop the URL for your table here? (if applicable) 🫶 Don't worry, only admins will be able to open your table 😉
Mat
·
https://app.clay.com/workspaces/45055/tables/t_NcmEBDPtcorp/views/gv_KliJyFdzRoHM
Clay Team
APP
·
Hey Matthew!! Curious— what criteria or additional filters you're looking for here? The team is working on a few and we could consider more if you have some in mind
Mat
·
Ideally, I'd be able to see sample parameters from within HubSpot, and narrow the returned rows by telling Clay something like this: Only bring back companies where: Shirt size = XL State = Minnesota Favorite Ice Cream = Chocolate Chip Revenue >= $1
Mat
·
I have way too many companies in HubSpot to fit them all on one Clay table, and need to narrow them down, so want to see if there's an option to do it within Clay (rather than making a list in HubSpot).
Clay Team
APP
·
Ahh, I see! Not sure if HubSpot offers those filters via their import API but the lists. Do you happen to know if that would be possible, Keethu R., to add more filter options to pull from HS? For now, I do think the best bet is to use lists and import only those.
Keethu R.
·
Hi Mat, just checked and the API doesn't allow for that kind of filtering, unfortunately, so I think Arturo's suggestion is the best route forward here
Mat
·
Looks like you can't import from a list in HubSpot either tho, Keethu R..
Keethu R.
·
You'll need to re-authorize your Hubspot account to be able to see the lists. Here's the loom: https://www.loom.com/share/dd849850eba647138ed09791acc8799c?sid=a050f11c-60bf-4d17-9c44-fd70c985a737