Yellow Pages has the largest pool of data for businesses. Being in the corporate world you must be well aware of the term lead generation. It is a process in which you approach your prospects via emails, calls, or messages and aware them of your services. And if they like whatever you are selling or servicing for then they might buy it from you.
Now, the question is how will you generate leads and extract data to get the emails or contact numbers of these prospects. Here’s what you can do to get these data: –
- You can use prospecting tools like LinkedIn premium.
- You can scrape Yelp.
- You can scrape Google search results.
- You can scrape Yellow Pages. (Further, in this blog)
In this blog, we are going to scrape Yellowpages to get phone numbers and other details.
Let’s Web Scrape Yellow Pages for Leads
Let’s assume you are a kitchen utensil manufacturer or a dealer and you are searching for potential buyers for your product. Since restaurants could be one of your major targets hence we are going to scrape restaurant details from the yellow pages.
We are more interested in the phone number, address and obviously the name of the restaurant. We will target restaurants in New York. Consider this URL as our target URL.
We are going to use python to scrape this website and I am assuming that you already have python installed. Further, we are going to use libraries like requests and beautifulsoup to execute this task.
Know More: A Detailed Tutorial on Web Scraping with Python!!
So, the first task is to create a folder and install these libraries.
>> mkdir yellopages
>> pip install requests
>> pip install beautifulsoup4Everything is set now, let’s code. To begin with, you have to create a file, you can name it anything you like. I will use ypages.py. In that file, we will import the libraries we just installed.
import requests
from bs4 import BeautifulSoup
data=[]
obj={}The next part would be to declare the target website for scraping from yellow pages.
target_website = "https://www.yellowpages.com/new-york-ny/restaurants"
resp = requests.get(target_website).textWe have made the GET request to our target website using the requests library. We will use BS4 on the data stored in resp variable to create an HTML tree from where we can extract our data of interest.
Let’s first check where all these results are stored by inspecting the webpage.
As we can see that all these results are stored under div tag with the class result. We will find the name, address, and phone number inside this div so let’s find the location of those too.
The name is stored under a tag with the class name as “business-name”. Next, we will check for phone numbers.
The last one will be the address.
The address is stored under the div tag with the class name as adr. Since we have all the information we need to extract the data, let’s run a for loop to extract details from these results one by one.
for i in range(0,len(allResults)):
try:
obj["name"]=allResults[i].find("a",{"class":"business-name"}).text
except:
obj["name"]=None
try:
obj["phoneNumber"]=allResults[i].find("div",{"class":"phones"}).text
except:
obj["phoneNumber"]=None
try:
obj["address"]=allResults[i].find("div",{"class":"adr"}).text
except:
obj["address"]=None
data.append(obj)
obj={}
print(data)We are using try and except blocks in case of any errors. This for loop will help us to reach each and every result and all the data will be stored inside the array data. Once you print you will get this.
We have successfully scraped all the target data. Now, what if you want to scrape the email and website of the Restaurant as well?
For that, you have to open all the dedicated pages of each restaurant and then extract them. Let’s see how it can be done.
Scraping Emails & Websites from Yellow Pages
Let’s first check the location of emails and website addresses for the particular restaurant in Yellow Pages.
The website is stored under a tag inside href attribute.
You can find the email inside href attribute with a tag.
Our logic to scrape all these details will be to create a new target website for each restaurant. For example, Mr. K’s restaurant has a dedicated URL https://www.yellowpages.com/new-york-ny/mip/mr-ks-407372?lid=1001117676060.
The part until .com/ will remain the same but the string after that will change according to the restaurant. We can find these strings on the main page.
Here are the steps we are going to do in order to scrape our data of interest.
- We will extract lateral strings from the main page.
- We will make a GET request to the new URL.
- Extract emails and websites from this new URL.
- Repeat for every result on the main page.
We will make some changes inside the last for loop.
for i in range(0,len(allResults)):
try:
lateral_string=allResults[i].find("a",{"class":"business-name"}).get('href')
except:
lateral_string=None
target_website = 'https://www.yellowpages.com{}'.format(lateral_string)
print(lateral_string)
resp = requests.get(target_website).text
soup=BeautifulSoup(resp, 'html.parser')Our new target_website will be a link to the dedicated restaurant page. Then we are going to extract data from these pages.
for i in range(0,len(allResults)):
try:
lateral_string=allResults[i].find("a",{"class":"business-name"}).get('href')
except:
lateral_string=None
target_website = 'https://www.yellowpages.com{}'.format(lateral_string)
print(lateral_string)
resp = requests.get(target_website).text
soup=BeautifulSoup(resp, 'html.parser')
try:
obj["Website"]=soup.find("p",{"class":"website"}).find("a").get("href")
except:
obj["Website"]=None
try:
obj["Email"]=soup.find("a",{"class":"email-business"}).get('href').replace("mailto:","")
except:
obj["Email"]=None
data.append(obj)
obj={}
print(data).get() function of BS4 will help us to extract data from any attribute. Once we print it we get all the emails and website URLs stored inside an array object.
Now, you can use these prospects for cold emailing or can do cold calling.
Complete Code
import requests
from bs4 import BeautifulSoup
data=[]
obj={}
target_website = "https://www.yellowpages.com/new-york-ny/restaurants"
resp = requests.get(target_website)
soup=BeautifulSoup(resp.text, 'html.parser')
allResults = soup.find_all("div",{"class":"result"})
for i in range(0,len(allResults)):
try:
lateral_string=allResults[i].find("a",{"class":"business-name"}).get('href')
except:
lateral_string=None
target_website = 'https://www.yellowpages.com{}'.format(lateral_string)
print(lateral_string)
resp = requests.get(target_website).text
soup=BeautifulSoup(resp, 'html.parser')
try:
obj["Website"]=soup.find("p",{"class":"website"}).find("a").get("href")
except:
obj["Website"]=None
try:
obj["Email"]=soup.find("a",{"class":"email-business"}).get('href').replace("mailto:","")
except:
obj["Email"]=None
data.append(obj)
obj={}
print(data)Read More: How to Extract Email Addresses from any Website using Python
Conclusion
We learned how you can create a target prospect list for your company. Using this approach or the code you can scrape emails and phone numbers for any industry you like. As I said YellowPages is a data-rich website and can be used for multiple purposes.
Collecting prospects is not limited to just Yellowpages only, you can scrape google as well to get some qualified leads. Of course, you will need an advanced web scraper to scrape that. For that, you can always use Scrapingdog which offers a generous free 1000 calls to new users.
I hope you will like this tutorial and if so then please do not hesitate to share it online. Thanks! again for reading.
Additional Resources
Here are a few additional resources you can read: –
