I'd like to run a column in Clay that checks if a business is already in a HubSpot list using a company domain name. Is this possible?
You could set up a table, and import using the "Import companies from Hubspot" to bring those companies into Clay. You'll use that table as a reference. Then, in your working table with companies, use "Lookup Single Row in Table" to scan for a match. The result of that query can be used to take other actions. This video walks through a use case for lookups. The UI is a bit different, but the principle is the same: https://www.loom.com/share/ad767e3be9914d19a2f6647efe4dfa85 High-level docs on the import + lookup features here: https://docs.clay.com/en/articles/9672455-pull-in-a-list-of-companies-with-hubspot https://docs.clay.com/en/articles/9672418-lookup-single-row-in-other-table-with-clay
Unfortunately our newsletter list is like 90,000 people so this won't work I don't think, right?
Do you know the # of companies/domains you have? Clay does have a 50k limit for a given table. The current Hubspot integration doesn't allow for querying list memberships, directly, but I'm wondering if we can think of another approach. I'm curious to learn more about your use case. If this is an ongoing need vs. one-time bulk enrichment, how this will fit in with the ultimate goal for the workflow, etc..
ongoing need
Hey there Annamarie thanks for reaching out, jumping in for Mark here, we do have an integration that can check whether or not a Company exist in your HubSpot by using a Company domain. It is called "Lookup Company" and you can find it in the enrichment menu by searching for HubSpot and this integration will appear. What this integration does is it take ins a Company Domain and checks to see if the company exist in HubSpot https://downloads.intercomcdn.com/i/o/w28k1kwz/1248077183/dc5b03887af8e6bccb8e51e43306/image.png?expires=1731369600&signature=4dc8667eee9fb4990f558e437578c9d8c223066d2682b145245b301968b6108f&req=dSIjHsl5moBXWvMW1HO4zQmCQgJMK7Ghypzs%2BEVxvv44VDzGDhho%2FPi01bhe%0AgwJF%0A
Hey there - just wanted to check in here to see if you needed anything else! Feel free to reply back here if you do.
We haven't heard back from you in a bit, so we're going to go ahead and close things out here - feel free to let us know if you still need something!
Hi Annamarie G.! This thread was recently closed by our Support team. If you have a moment, please share your feedback: