Futurise
Charlie Woodstock
Charlie Woodstock
May 15·Introductions

Hello, I'm Charlie. I need to build a location based email extractor bot.

Hello, I'm the Creative Director at CXX in the UK. We specialise in marketing services for SME's, primarily coffee shops and restaurants.

I have a robot that I need to build which is quite urgent, need this done by tomorrow, so don't have a lot of time.

There is a coffee franchise called Greggs in the UK. I want to scrape the email addresses of the 20 closest coffee shops to all the Greggs in the UK (competitors essentially). I need their email addresses saved to an Excel or Google sheet.

I've been doing this manually with Google Maps, navigating to each Greggs and zooming out looking for nearby coffee shops, then going to their website and looking for their email address. It's taking too long and I'm sure there is a better way to do this?

Any idea how to do this? Was thinking of a Make or Zapier workflow but not sure where to start? Also, i don't have much time. Would appreciate any advice.
1 likes 3 comments

Comments

Leon PetrouLeon Petrou· May 15
Hi Charlie, welcome to Futurise. There are many ways to do this, but the quickest and easiest is by using https://outscraper.com that allows you to scrape both locations and email addresses (and even validate them). You can configure the API's in any tool of your choice, they have integrations with Make, Zapier, n8n, etc. Step 1) Use their Google Places v3 (speed optimized) API https://app.outscraper.cloud/api-docs#tag/Businesses-and-POI Query: Greggs Limit: 500 (or more than the max number if Greggs in the UK) Step 2) Use their Google Places v3 (speed optimized) API again. https://app.outscraper.cloud/api-docs#tag/Businesses-and-POI query: Coffee Shop limit: 20 coordinates: latitude and longitude of each Greggs from Step 1. See documentation for correct format. This will scrape 20 coffee shops around those GPS coordinates (most likely including Greggs, so just delete those out manually afterwards). https://app.outscraper.cloud/api-docs#tag/Businesses-and-POI This will return phone numbers for each nearby coffee shop. This may be useful to you too. Then it will also return the website for the coffeeshops which have a website. Step 3: Use their Email & Contacts API. Use an array of the websites for the query and a preferredContacts filter if you want, e.g. "decision makers". https://app.outscraper.cloud/api-docs#tag/Email-Related/paths/~1emails-and-contacts/get This will then output a sheet of email addresses for those businesses, scraping the email addresses directly from their websites. You can validate email addresses too to make sure that they're deliverable. This protects your email domain reputation, it's not good to send emails which bounce. This can result in your verified emails going to spam if too many unverified emails bounce. However, since the emails are scraped directly from the websites they should all be good. https://app.outscraper.cloud/api-docs#tag/Email-Related/paths/~1email-validator/get This isn't a full proof solution because the emails addresses may not belong to the representatives at the exact branch you're interested in, though it should be fine in most cases. And you have the phone numbers too for each branch. A cool automation to get the email address of each branch would be an AI phone call bot that calls each branch's phone number and confirms their email address.
Charlie WoodstockCharlie Woodstock· May 15
Wow! Thanks for such a detailed solution. I'll try it out with Make and let you know if I have any issues setting it up.
Leon PetrouLeon Petrou· May 15
No problem, will be here if you have any questions. :)

Join Futurise to participate in the discussion