Select Page

GLeads

Step 1

Install Python locally or use a cloud IDE then copy and paste the GLeads code

 

Step 2

Create Google Sheet, get API credentials for Google Drive, Sheets, and Maps

 

Step 3

Enter a city and keyword and the results will be pulled from Google’s local business listings 

Get updated on new features

Support for lists of keywords and locations will be added soon

 

Subscribe to Youtube

Getting Started

Requirements

Google Cloud Account – GLeads requires a Google Cloud account with the Maps Places, Maps Geocoding, Google Drive, and Google Sheets APIs enabled.

Python Environment

The first thing you need is an environment capable of running a python program. The easiest way to accomplish this is to create an account on coder.com, this will give you a live VS code IDE running on the cloud where you can run your code without having to install anything locally on your computer.

CODER IS CURRENTLY NOT TAKING NEW ACCOUNT SIGNUPS, FOR NOW YOU WILL HAVE TO INSTALL PYTHON LOCALLY ON YOUR COMPUTER IF YOU DON’T ALREADY HAVE AN ACCOUNT

The other option is to install Python locally on your computer. This will take more time up front but is probably worth it in the long run. 

Create Google Sheet and enable Google APIs

Next you’ll need to create the Google Sheet that you want to receive your data. Once you’ve got that sheet made you need to go to console.developers.google.com and create a project. Then click on “Enable API and services” button at the top of your screen. 

Once you’re in the API Library you’ll want to enable the Google Sheets and Google Drive APIs. The last thing we need to do now is create a Service Account that allows us to use these now enabled APIs. Go back to the “APIs and Services” dashboard and click the “Credentials” tab and create a “Service Account Key” from the drop down option

Name the service account whatever you want but make sure you set the role as “project owner” and then download the JSON file containing your credentials. 

You also need to enable the Google Maps Geocoding and Places APIs. Once you’ve done that you’ll want to create an API key and copy it so you can paste it into your code later.

 

G-Leads Tutorial Video

Now you need to create an empty folder for where we are going to store our code. Inside that folder you will want to create 2 files, main.py and utils.py. You will also need to copy the JSON file you downloaded from Google into the folder. The video below will go over the different variables you can customize and how to connect your Google Sheet to GLeads.

 



General Info

Result limit – Google limits the results to 60 for queries. For larger cities you will want to target specific neighborhoods to increase the number of results you get.

Free Credits – Google gives you $200 in free API credits every month. You also get an additional $300 in credits when you create your Google Cloud account, so you have some buffer in case you go over your monthly limit. This is enough for around 4,000 leads a month.

 

 

Share This