I need someone to collect/extract data GOOGLE Maps Business search engine for placement in an Excel template.
Information to be extracted is as follows:
Company Name/ Listing name
Address Line 1
Address Line 2
City
State
Zip Code
Phone
Fax
Email
WWW (website if any)
Steps to be followed:
1. Gather listings from GOOGLE Maps Business search engine.
2. Check if data extracted is valid (by cross checking).
3. Remove duplicate entries.
4. Submit file in provided excel template
I have provided a list of the categories and links to the first page of the results of the needed listings. One issue I have found with Google is if a category contains 2,800 listings it will only let you see 990 of the listings, hopefully you can find a way to fix this!
While this could be done Data Entry I feel a script could be written to extract this data quite easily.
List of needed categories and expected number of leads to be found in each excel file. Each category should have it's own Excel template file.
[login to view URL];hl=en&geocode=&q=category:+%22spa%22+loc:+oceanside+ca&jsv=129e&sll=33.19388,-117.297592&sspn=0.343611,0.727844&ie=UTF8&sa=N&start=0
category: "spa" loc: oceanside ca
131
[login to view URL];hl=en&geocode=&q=category:+%22Spas+Beauty+%26+Day%22+loc:+oceanside+ca&jsv=129e&sll=33.190327,-117.310568&sspn=0.082459,0.181961&ie=UTF8&sa=N&start=0
category: "Spas Beauty & Day" loc: oceanside ca
1,013
[login to view URL];hl=en&geocode=&q=category:+%22chiropractors%22+loc:+oceanside+ca&jsv=129e&sll=33.175557,-117.348926&sspn=0.041236,0.090981&ie=UTF8&sa=N&start=0
category: "chiropractors" loc: oceanside ca
2,225
[login to view URL];hl=en&geocode=&q=category:+%22acupuncture%22+loc:+oceanside+ca&jsv=129e&sll=33.210542,-117.336044&sspn=0.171773,0.363922&ie=UTF8&sa=N&start=0
category: "acupuncture" loc: oceanside ca
1,002
[login to view URL];hl=en&geocode=&q=category:+%22Body+Piercing%
22+loc:+oceanside+ca&jsv=129e&sll=33.199626,-
117.246094&sspn=1.374336,2.911377&ie=UTF8&sa=N&start=1
category: "Body Piercing" loc: oceanside ca
102 Listings
[login to view URL];hl=en&geocode=&q=category:+%22Nail+Salons+%26+Services%
22+loc:+oceanside+ca&jsv=129e&sll=33.172043,-
117.246094&sspn=1.374768,2.911377&ie=UTF8&sa=N&start=0
category: "Nail Salons & Services" loc: oceanside ca
2,076 Listings
[login to view URL];hl=en&geocode=&q=category:+%22Massage%
22+loc:+oceanside+ca&jsv=129e&sll=33.203073,-
117.304459&sspn=0.085894,0.181961&ie=UTF8&sa=N&start=0
category: "Massage" loc: oceanside ca
1,408
[login to view URL];hl=en&geocode=&q=category:+%22Skin+Care%
22+loc:+oceanside+ca&jsv=129e&sll=33.199258,-
117.32144&sspn=0.085898,0.181961&ie=UTF8&sa=N&start=0
category: "Skin Care" loc: oceanside ca
1,150
[login to view URL];hl=en&geocode=&q=category:+%22Tanning+Salons%
22+loc:+oceanside+ca&jsv=129e&sll=33.195908,-
117.330827&sspn=0.085901,0.181961&ie=UTF8&sa=N&start=0
category: "Tanning Salons" loc: oceanside ca
375
[login to view URL];hl=en&geocode=&q=category:+%22tattooing%
22+loc:+oceanside+ca&jsv=129e&sll=33.163766,-
117.394308&sspn=1.319734,2.911377&ie=UTF8&sa=N&start=0
category: "tattooing" loc: oceanside ca
265
[login to view URL];hl=en&geocode=&q=category:+%22wedding+photographers%
22+loc:+oceanside+ca&jsv=129e&sll=33.069098,-
117.211459&sspn=0.3441,0.727844&ie=UTF8&sa=N&start=0
category: "wedding photographers" loc: oceanside ca
311
[login to view URL];hl=en&geocode=&q=category:+%22wedding+planning%
22+loc:+oceanside+ca&jsv=129e&sll=33.086245,-
117.25763&sspn=0.330225,0.727844&ie=UTF8&sa=N&start=0
category: "wedding planning" loc: oceanside ca
480
[login to view URL];hl=en&geocode=&q=category:+%22modeling+agencies%
22+loc:+oceanside+ca&jsv=129e&sll=33.182362,-
117.291453&sspn=0.329864,0.727844&ie=UTF8&sa=N&start=0
category: "modeling agencies" loc: oceanside ca
85
[login to view URL];hl=en&geocode=&q=category:+%22hair+removal%
22+loc:+oceanside+ca&jsv=129e&sll=33.158191,-
117.369074&sspn=1.319803,2.911377&ie=UTF8&sa=N&start=0
category: "hair removal" loc: oceanside ca
355
[login to view URL];hl=en&geocode=&q=category:+%22dating%
22+loc:+oceanside+ca&jsv=129e&sll=33.121058,-
117.28408&sspn=0.330095,0.727844&ie=UTF8&sa=N&start=0
category: "dating" loc: oceanside ca
107
[login to view URL];hl=en&geocode=&q=category:+%22beauty+salons%22+loc:+oceanside+ca&jsv=129e&sll=33.199986,-117.348388&sspn=0.082449,0.181961&ie=UTF8&sa=N&start=0
category: "beauty salons" loc: oceanside ca
10,175
[login to view URL];hl=en&geocode=&q=category:+%22barbers%22+loc:+oceanside+ca&jsv=129e&sll=33.21126,-117.326088&sspn=0.085886,0.181961&ie=UTF8&sa=N&start=0
category: "barbers" loc: oceanside ca
1,363
[login to view URL];hl=en&geocode=&q=category:+%22salon%22+loc:+oceanside+ca&jsv=129e&sll=33.043889,-117.222574&sspn=0.660763,1.455688&ie=UTF8&sa=N&start=0
category: "salon" loc: oceanside ca
1,270
Payment only at completion of the project.