Hello! I have created a list in HubSpot with a bunch of companies we would like to prospect on. A lot of these companies do not have a contact associated to them. Is it possible to upload the list of companies into Clay for Clay to enrich with contacts (emails and names) of people working there? Many thanks!
👋 Hey there! Our support team has got your message - we'll be back in touch soon. If you haven't already, please include the URL of your table in this thread so that we can help you as quickly as possible!
Hey Denise, thanks for reaching out! This is absolutely possible. Given you're on an explorer plan you would have to export these companies as a CSV and re-upload them into Clay. From there you can use information like 'company website or domain' to enrich the companies further if you'd like. Then using our 'Find Contacts at Companies' enrichment will use either the company domain or Company LinkedIn URL to search for contacts at those companies. Hope this helps! Let me know if you have any other questions, concerns, or need a hand setting up this workflow. :)
Super, many thanks 🙂 Will do that!
Of course! Let me know if you have any other questions! In the meantime, I’ll go ahead and close this ticket. :)
Thanks! We've reopened this thread. You can continue to add more detail directly in this thread.
Hello again! Can I paste a copy of my table to see if I'm doing it correct?
Hey Denise! Actually, could you share the URL to the Clay table you're referring to here? Happy to take a closer look. :)
Awesome, thank you! This was successfully imported, and taking a look at the data you have, most of these companies (1,203 total) have a domain associated with them from HubSpot so you could find contacts at these companies right away if you'd like. I would suggest adding the following conditional formula into the 'Find Domain' enrichment to save some credits and avoid finding the domains of companies you already have this data point for. I've mapped these data points into their own columns to show this and in the first image you can see some of these companies already have a domain but this enrichment is still running because there is no conditional formula in place. Once this conditional formula is in place you can choose to run all rows which will only enrich the remaining ~300 rows (the companies that don't already have a domain). We can then take this data, merge it into a 'Final Domain' column and then search for contacts from there. https://downloads.intercomcdn.com/i/o/w28k1kwz/1276525117/aa76142d5f7ea3ad41ead2385d31/CleanShot+2024-12-04+at+11_00_09%402x.png?expires=1733329800&signature=8764ffce87ad37f2384e7f516b4172294c00e802f1094dca28eec9a8d149ccd6&req=dSIgEMx8mIBeXvMW1HO4zYi0pVFpYEU0FuZy7VFx1jcnYwc41pcC2HBt%2BuP2%0A5YlA%0A https://downloads.intercomcdn.com/i/o/w28k1kwz/1276526633/e02aa80497428f2d574e379d7c0a/CleanShot+2024-12-04+at+11_01_05%402x.png?expires=1733329800&signature=c406dd5101623010dd8a71fb0ca452361c5ab5ee77184e2023071baa8503e0bb&req=dSIgEMx8m4dcWvMW1HO4zeOEcpY%2FEEQ2HWn5nW7MGmHUyYsdYU0d1z5Q9azA%0AmbtU%0A
With regards to finding contacts, I would suggest using our filtered search with the 'Find People at these companies' action which can be found in the Action tab. You'll have to select a column to use to identify which companies to find people at in which the 'master domain' column mentioned previously will work great! https://downloads.intercomcdn.com/i/o/w28k1kwz/1276532042/d0dbd1028aef88cef0d99e89f7bf/CleanShot+2024-12-04+at+11_03_27%402x.png?expires=1733329800&signature=7f5f8ebd95b08dd31eb2cac10ea394f4e056c123fef94fe2e4cde1732b1bcb76&req=dSIgEMx9n4FbW%2FMW1HO4zdF8Jk1bIidgiyPVHCzmIMqeWj8vgFqkcrm47YIm%0AUulk%0A
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.