Not for mass-email or anything illegal, just doing this manually is driving me nuts.
Basically, I've got a spreadsheet of a few 1000 keywords and cities.
For each city + keyword, I want to get 10-20 business listings from Google local and Yelp, then import them into Salesforce.com as a target list for sales activities.
* Business Name
* Web Site
* Email address
* Phone Number
Bonus:
* Person's name
* Contact form URL if no email
Example:
Search google for "san francisco oral surgery", then grab the contact information of Google local listings and top yelp results and stick it into a spreadsheet.
Advice? I'd consider buying from data providers but don't have a lot of $$ and don't think they'd be specific enough anyway.
Basically, I've got a spreadsheet of a few 1000 keywords and cities.
For each city + keyword, I want to get 10-20 business listings from Google local and Yelp, then import them into Salesforce.com as a target list for sales activities.
* Business Name
* Web Site
* Email address
* Phone Number
Bonus:
* Person's name
* Contact form URL if no email
Example:
Search google for "san francisco oral surgery", then grab the contact information of Google local listings and top yelp results and stick it into a spreadsheet.
Advice? I'd consider buying from data providers but don't have a lot of $$ and don't think they'd be specific enough anyway.