Through my company, I have access to just about every company in the US, but find that our domain data for each company often leaves a bit to be desired (if it exists).
For small datasets, Iāve written some code in Excel that can give me the āIām feeling luckyā result on a company name from Google and it works surprisingly well to find the domain of most companies. However, Google starts blocking my IP address after a dozen or so automated searches, and Iād often like to be looking up the domain on hundreds of companies. At this point, I really wouldnāt mind paying for a service.
Do you have any recommendation for a tool that does a good job of looking up domains based on company name and address info?
Clearbit is one that I have seen used for similar purposes. They have some package and integration offers along with some public APIs you can use. As long as you are using it to enhance data on contacts/companies you already have it would be a good fit for HubSpot. While they offer an integration but it may be overkill for the purpose here.
jfields: Thanks for the idea around Clearbit. I didnāt know they had an integration. Thatās really interesting. I know our IT team looked into Clearbit a year or so ago (their URL look up is free from what I remember), but they werenāt impressed with the URL matching. However, I think they only ran a small test and you have me thinking itās something that we should revisit. Thanks!
@jfields has an excellent idea here, and Iāve done it before using Gsheets and an open endpoint from Clearbit, all thatās needed is your company names. Hereās the gist:
Then in Gsheets, open Tools > Script Editor and paste this code:
function FETCH(url) {var response = UrlFetchApp.fetch(url);Logger.log(response.getContentText());var out = JSON.parse(response.getContentText());return out[0]['domain'];}
Lastly, in an empy column, just apply the function: FETCH (url)
*url = the cell with your generated request.
This is from this article I found a while back. Hereās an example sheet Iāve created:
Hope this helps! On another note, you can update that ādomainā to be additional fields to populate more columns if need be!
Hey @Bryantworks : This is definitely helpful. Iāve not had a ton of luck with the quality of results I was getting with Clearbit when I tried it a year or two ago, but youāre inspiring me to give it another shot and love that itās built into a google spreadsheet.
And since everyone is being so helpful, I feel somewhat compelled to share my hack that looks up the company domain based on googleās āIām feeling luckyā search. Iām not much of a coder in VBA, but managed to cobble together a solution and you can download the excel file here: Google Company Lookup.
As I mentioned, the biggest issue with this approach is that google will inevitably (temporarily) throttle your IP after you look up a dozen or two dozen companies using this approach.
The benefit is that for a small number of companies, itās dumb simple and it delivers a shockingly high number of acurate results.
To use the tool, simply 1) highlight a (small) list of companies, and 2) click the large grey box. The VBA code then returns the āIām feeling luckyā results in one column to the right.
Hi! I just launched a service that does exactly this ie. accurately find the domain name from the company name. It provides much better results. Itās not free but not expensive either. Please see the details at https://www.datyle.co/find_a_domain_name_from_company_name.html
I can offer a generous amount of testing credits. Thanks!
Hey, @smercer4 Welcome to our community! Please note this is a post from 2020 and may not be monitored by the OP. Iād suggest making new posts and interacting with current posts as a way to connect with our fantastic community members ā Jaycee
Welcome to our community! Please note this is a post from 2020 and may not be monitored by the OP. Iād suggest making new posts and interacting with current posts as a way to connect with our fantastic community members 
ā Jaycee