Finding website domains from a list of company names can be a time-consuming task, especially if you have a long list to process. I guess nobody is willing to do it manually, so I’d like to show you how to easily automate this tedious job.
By the end of this post, you’ll have the skills to efficiently gather the domain URLs based off a long list of company names, turning a daunting task into a streamlined process. Let’s get started!
Understanding the Basics
Finding company domain URLs from a list of company names can be highly beneficial: many companies have large existing datasets in their CRM, marketing automation system, or user database that don’t have a domain name associated with each record. So, let’s bridge that gap!
The Need for Automation
Automated tools can process large datasets quickly, significantly reducing the time required compared to manual methods. It also minimizes the risk of human error, ensuring more accurate and consistent results. Thus, by saving time and reducing errors, automation can lower the overall cost of data collection and management.
In the next sections, we will introduce ImportFromWeb, a powerful tool that simplifies the conversion of company names into domain URLs, ensuring efficiency and accuracy in your data collection process.
Introducing the scraping tool ImportFromWeb
If you would have to handle the domain URLs collection, what would you do? You would search the company name in Google and copy/paste the link of the 1st result in your CRM or data set, right? Guess what? There’s a Google Sheets app, named ImportFromWeb, that does exactly the same!
ImportFromWeb is actually a Google Sheets add-on that enables to extract Google SERP links for any queries. The process relies on a simple Google sheets function – named =IMPORTFROMGOOGLE() – that we’ll discover and use in the next section.
4 quick steps to find domain URLs from a list of company names
To make this step by step as concrete as possible, let’s consider you have a data base with the top building companies in the US.
Step 1: Install and activate the ImportFromWeb add-on
First, make sure to install ImportFromWeb from the Google Workspace Marketplace and activate it in a new Google Sheets (from the Extension menu).
Step 2: Input the list of company names
Input the list of the company names in the column A.
Step 3: Input the =IMPORTFROMGOOGLE() formula!
Now simply enter the following formula in B1:
=IMPORTFROMGOOGLE(A1,"link","num_results:1")
The “num_results” parameter in the formula – when set at 1 – enables to retrieve the 1st result from Google SERP, which is indeed the company’s website domain.
As a final step, drag down the formula to the last row, so your data base is fully enriched in a 1 clic and within a few seconds!
Get started with a ready to use template
If you don’t want to follow the above step-by-step, you can use the following google sheets template to find website domains from a list of company names! All you have to do is to make a copy of the template and activate the ImportFromWeb add-on.
