In this video, I show you a method to scrape LinkedIn data utilizing a Python script to scrape Google SERP with meta data.
This method will return you leads with:
Full Name
Position Title
Company Name
Email
Phone Number
You can get very targeted leads by adjusting the search query to your desired parameters.
Excel Formula To Extract Email Addresses (change A1 to whatever cell you are staring at)
=TRIM(RIGHT(SUBSTITUTE(LEFT(A1,FIND(" ",A1&" ",FIND("@",A1))-1)," ",REPT(" ",LEN(A1))),LEN(A1)))
Excel Formula To Extract Phone Numbers (change A1 to whatever cell you are staring at)
=MID(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1," ","-"),"(",""),")",""),".","-")&"-",SEARCH("???-???-????-",SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1," ","-"),"(",""),")",""),".","-")&"-"),12)
