> ## Content Index
> Fetch the complete content index at: https://serpapi.com/blog/llms.txt
> Use this file to discover other available public pages before exploring further.

# Mastering Sales Prospecting: A Guide to Generating a Targeted List of 500 Restaurants, Bars, and Pubs
- URL: https://serpapi.com/blog/mastering-sales-prospecting-a-guide-to-generating-a-targeted-list-of-500-restaurants-bars-and-pubs/
- Published: 2023-11-27T08:47:46.000Z
- Updated: 2024-09-20T06:03:02.000Z
- Author: Andy L

When you start a new business, how can you approach your clients? Having a targeted list of potential clients can make your life simpler.

![](https://lh7-us.googleusercontent.com/-KrT4xLAH-bFByifdcpOyryTmi_J2MUaPduuipTSeFxYPwE5ggl_1xT-TpgsBgSNsyGKZpQTdUVyyM554Apwhsj34Ber0y95HX-XQondwbODKjp6aeMxn77p50l3PyHoDtbJnIprWgj-eBExO8QeFU8)

In this tutorial, we can run a case when you want to get 500 restaurants, bars, pubs, alongside a location with website and phone information.

![](https://lh7-us.googleusercontent.com/caTozENpfBoAhZr3YyZ8v2dhF4m8OJCzSo-qykPVwl7hVyKjoGXsen9Iq1CoYHzBms5j9nZCc-sne75u1rGc2YBz7iUC0AJ5-bZPOdlZqToFezvVU89GTXZ8ql95gelWiH7ZQO87Jb6pej7HLZXz6y8)
  
  
More than that, I'll guide you on how to get emails and you can send your cold mail to gain a success rate.

Scraping quality results is not easy, but [SerpApi](https://serpapi.com/) makes it easier and more accessible to us. Let's start with Google Maps results.

### Setting up a SerpApi account

[SerpApi](https://serpapi.com/) offers a free plan for newly created accounts. Head to the [sign-up](https://serpapi.com/users/sign%5Fup?plan=free) page to register an account and complete your first search with our [interactive playground](https://serpapi.com/playground?engine=google%5Fmaps). When you want to do more searches with us, please visit the [pricing page](https://serpapi.com/pricing).

Once you are familiar with all results, you can utilize SERP APIs using your [API Key](https://serpapi.com/manage-api-key).

![](https://storage.ghost.io/c/a5/00/a5004977-0dd2-4bcd-9292-dd0e05d4c59e/content/images/2023/11/Screenshot-2023-11-20-at-17.30.49.png)

### Scrape your first 60 Restaurant results with SerpApi

Head to the Google Maps Results from the [documentation](https://serpapi.com/google-maps-api) on [SerpApi](https://serpapi.com/) for details.

This tutorial will scrape the list of restaurants in Sydney, Australia. You can visit [Google Maps search](https://www.google.com/maps/search/restaurant/@-33.8651304,151.1939402,15z?entry=ttu) to see the list.

Link: <https://www.google.com/maps/search/restaurant/@-33.8651304,151.1939402,15z?entry=ttu>

The location will be [@-33.8651304,151.1939402,15z](https://www.google.com/maps/place/Restaurant+Hubert/@-33.8651304,151.1939402,15z/data=!3m1!5s0x6b12ae3fac78adcd:0x45b9272485555889!4m10!1m2!2m1!1srestaurant!3m6!1s0x6b12ae6a74919f17:0xa44a2ebe1f7fb3e6!8m2!3d-33.8651304!4d151.2104197!15sCgpyZXN0YXVyYW50WgwiCnJlc3RhdXJhbnSSARFmcmVuY2hfcmVzdGF1cmFudOABAA!16s%2Fg%2F11clyc38gm?entry=ttu) (Townhall, Sydney, Australia).

Google also returns basic information of businesses:

![](https://storage.ghost.io/c/a5/00/a5004977-0dd2-4bcd-9292-dd0e05d4c59e/content/images/2023/11/Screenshot-2023-11-20-at-17.35.14.png)

When searching with SerpApi, you can have them all:

[SerpApi Playground - SerpApiTest SerpApi’s Google Search, Google Maps, YouTube, Bing, Walmart, Ebay, Baidu, Yandex and more APIs for free in the interactive playground!![](https://serpapi.com/apple-touch-icon.png)SerpApiSerpApi![](https://serpapi.com/assets/serpapi-text-logo-621a467e3b1e907622c18a6ac81455032e9784d6a86e81a1b4f6407d3f0120a6.svg)](https://serpapi.com/playground?engine=google%5Fmaps&q=Restaurant&ll=%40-33.8651304%2C151.1939402%2C15z&hl=en&type=search&no%5Fcache=true)

Based on Google policy, Google doesn't publish the email of the business. But most of the time, we can visit the restaurant's website and get contact information. For e.g, I visit <https://swillhouse.com/venues/restaurant-hubert/>

![](https://lh7-us.googleusercontent.com/EGzK5d3YNQgfR9ZmWH8FDoehULL_ADeHJgDtm7eMJF7LQSeTt8bqeLgT5j8ijb09e2QWtmGDtM5QJQTDLtpwgXIUB-9qqgE4Fh46by_qnrm7GEzbvEJe-RjrQnn9wE8IMqoHH367cjs2Y7lCII9d_tk)

Let's do this step by step.

First, you need to install the [SerpApi client library](https://github.com/serpapi/google-search-results-python?ref=serpapi.com).

```python
pip install google-search-results
```

Set up the[ SerpApi](https://serpapi.com/?ref=serpapi.com)[ credentials](https://serpapi.com/manage-api-key?ref=serpapi.com) and search.

```python
import serpapi, os, json

params = {
    'api_key': 'YOUR_API_KEY',         # your serpapi api
    'engine': 'google_maps',           # SerpApi search engine	
    'q': 'Restaurant',
    'll': '@-33.8651304,151.1939402,15z'
}

```

To retrieve a list of Restaurants, you can use the following code:

```python
results = serpapi.Client().search(params)["local_results"]

```

You can store Restaurant JSON data in databases or export them to a CSV file.

```python
import csv

header = ['position', 'title', 'place_id', 'address', 'website', 'phone']

with open('google_maps_results.csv', 'w', encoding='UTF8', newline='') as f:
    writer = csv.writer(f)

    writer.writerow(header)

    for item in results:
        print(item)
        writer.writerow([item.get('position'), item.get('title'), item.get('place_id'), item.get('address'), item.get('website'), item.get('phone')])

```

### No-code approach with SerpApi

If you don't want to code, [SerpApi](https://serpapi.com/) also has a Google Sheet Plugin, you just need to input your [SerpApi](https://serpapi.com/) api\_key and you get your results:

![](https://storage.ghost.io/c/a5/00/a5004977-0dd2-4bcd-9292-dd0e05d4c59e/content/images/2023/11/Screenshot-2023-11-27-at-15.41.03.png)

Clone this Google Sheet template: <https://docs.google.com/spreadsheets/d/1OXqATnTahjNCJ3MJ9D2If1GU5eVZiljYOIyLv72bADc/edit#gid=1524491998>

Then install our Google Sheet plugin:

[SerpApi - Search Engine Results and Ranks - Google Workspace MarketplaceGet your web site search rank or extract search results using localized searches on Google, Bing, Baidu and more.. This add-on allow advanced analysis of search engine without any programming skills.![](https://ssl.gstatic.com/apps/additnow/images/logo_marketplace_1x_48dp.png)Google Workspace Marketplace![](https://lh3.googleusercontent.com/-zq3Hhy3OD-o/XT5o85dB8wI/AAAAAAAAADM/9LSR_9GEpLoXqO9AHvFH4TqBucJ-5sEvQCLcBGAs/s400/google_rank_api_logo_128x128.png)](https://workspace.google.com/marketplace/app/serpapi%5Fsearch%5Fengine%5Fresults%5Fand%5Franks/562749385480)

Update the SerpApi "api\_key"

![](https://storage.ghost.io/c/a5/00/a5004977-0dd2-4bcd-9292-dd0e05d4c59e/content/images/2023/11/Screenshot-2023-11-27-at-15.43.17.png)

In the next blog post, I'll guide you on how to get email addresses, contact information, social media links, and extra phone numbers from here. 

If you have any questions, please feel free to [contact me](mailto:andy@serpapi.com).