How to Map Your Members in Google for Local Outreach

Last week, I shared a simple method for using Google’s free services for neighborhood discovery. Today, I want to extend that idea to the next level. Many churches never consider mapping out their own membership, but they should.

Our homes are staging grounds for the Great Commission.

We talk a lot about hospitality today. There is no end lately to the blog posts and articles circulating the internet concerning the importance of hospitality in outreach and missions. I have several on this site.

Hospitality is an important aspect of ministry that Western Christians often struggle to incorporate into their lives. Compared to other areas of the world, we love our privacy, and  our home easily becomes our fortress of solitude. While homes should be a place for rest, the Bible challenges us to view them as tools for ministry. Can we honestly say we are stewarding God’s gifts well when our single, biggest purchase is never used for outreach?

We should change this paradigm in our churches. Homes are not caves. They are not fortresses to protect us from the hectic world outside. They are gracious gifts from our Heavenly Father to be used, in turn, for his glory. This means opening your home up to others. Yes, it means having others from your church over, but it means even more than that. Use it as a staging ground for the Great Commission.

When was the last time you invited unbelieving neighbors into your home?

Seeing your church’s geographic footprint.

As we encourage church members to open their homes up as a mission point in the community, it does something incredible. Suddenly, local church ministry shifts from having one central point of contact to dozens, or hundreds, scattered throughout neighborhoods all over the city.

A church, as with any group, has different types of footprints. There are social footprints, or the web of relationships connected to your church. There are missions footprints, or all the places hearing the gospel because of your church’s labor. And there are geographic footprints, or all the places membership reside around the city. Every one of these serves as a touch point into a community.

Often, churches have no idea where their membership lives. Sure, the information is on a roll somewhere, or stuck in a mailing list. Unfortunately, addresses in a list do little to capture a church’s geographic footprint. Has your church ever looked at its geographic footprint?

Step-by-step instructions for mapping membership in Google:

You may want to refer to last week’s post about mapping your community in Google, as I am basing this short guide on that post.

Import spreadsheet to Google.

The first step is getting your membership addresses all into the same spreadsheet and uploading that to Google Drive. Most churches have a spreadsheet of their membership laying around somewhere. If your church is large enough to have database software, then it is most likely as simple as exporting the membership directory as a CSV or XLS file.

Uploading to Google Drive is very easy. Using the same Google account where you are gathering mapping information on your community, open drive.google.com on any modern web browser. You can simply drag the file into the drive and it should upload.

Convert it to a Sheets file.

This next step makes using the data easier in Google Drive. It is possible to set Drive up to automatically convert any files you import to the corresponding Google file type. If you have not done so, simply right click on the file in Drive, hover over “Open with” and select Google Sheets. This will create a Google Sheets copy of the file.

Import as My Maps layer.

If you will remember from last week, Google Maps has an area called “My Maps” and you can build your own customs maps in this section. If you have not already done so, create a new map in My Maps. If you have started a map for community discovery open that map.

On the left side of the screen is the map legend. Click on the “Add layer” button in that legend, and it will create an untitled layer at the bottom of the map legend. Two things will need to happen next. First, rename the layer to “Church Members.” Second, click the import button in that layer to import the membership directory spreadsheet you just created. Select upload from Google Drive and locate the membership sheet. The maps engine will give you a couple of prompts to make sure it is mapping based off the address column and naming the points correctly, and then it is finished!

screen-shot-2016-09-21-at-9-29-54-am

Compare with data from community discovery.

If you create this layer inside an existing map for community discovery, some really neat things can happen. By making them separate layers, you can cut them on and off. This will allow you to see all of the points of discovery for local outreach by themselves, or you can just visualize your membership. The cool part, though, is putting them both up at once. By seeing your points from community discovery plotted on top of your church’s geographic footprint,  you are able to make all kinds of interesting connections. Do your church members live anywhere near the areas you want to reach? You may find that you have neighborhoods full of church members and other neighborhoods where there are none. Finally, you can help members think through ministering to unbelievers in their own areas of the city.

screen-shot-2016-09-21-at-9-30-07-am

This exercise only takes a few minutes, and it can really help a church begin the process of strategic local outreach. Feel free to shoot me any questions in a comment or email, and I would be happy to help you think through the ways your church can use this tool.

 

8 Comments

  1. […] Keelan Cook – How to Map Your Members in Google for Local Outreach. For church leaders, here’s a smart way to use technology to the advantage of our […]

    September 30, 2016
    Reply
  2. Love this. What would you suggest for a “next step” after mapping this out?

    October 1, 2016
    Reply
    • Keelan Cook said:

      John, great question!

      There are a number of ways to use this data. Of course, the previous post on people group discovery is one way. By mapping not just your membership but also different people groups in your area (or another type of group that needs the gospel), you can compare where your membership lives with some of these groups. There may be areas of overlap, and you can help the members that live in areas of interest see how to engage those areas.

      In addition, you could use this data to see where your membership is clustered around the city. That could point out areas where you should be more intentional about doing ministry. There are two ways to look at that: (1) areas where you have “holes” may be areas of the city you are missing in outreach or (2) areas where your members live in higher numbers could be great places to base ministry to a specific neighborhood.

      Let me know if you have other questions past those ideas. If you are more interested in what kind of outreach to do in those areas, that is another conversation worth having, as well.

      October 3, 2016
      Reply
  3. Calvin Ho said:

    This is great as a free resource. An application such as Tableau is far superior. However, there is a cost ($1500) and you need someone trained in the program. Thanks for sharing this!

    October 7, 2016
    Reply
    • Keelan Cook said:

      Calvin, you’re definitely right on both accounts. There are several tools out there that do a more thorough and impressive job of compiling and visualizing this data. For some, those are a great option. But, as you point out, they come with a cost and a steep learning curve. In my estimation, those exceed the use case of most churches… at least when they are getting started. Appreciate your comments!

      October 10, 2016
      Reply
  4. davidwchase said:

    Keelan…I have been saving this link for a year, distributed it a few times, but used it today for the first time. Love it! Our church is doing some follow up with recent visitors and grouping out to distribute at the time of visitation. Printing is my next challenge…have you had any experience/success printing Google maps (plotter or a much smaller callout) and do you have any advice?

    I will say that your sharing this free idea is gold!

    Thank you Keelan!
    David

    April 26, 2017
    Reply
    • Keelan Cook said:

      Thanks for the kind words friend. I’m happy to see if I can help you work out a specific solution. Let’s take this to email so we can chat about some specifics. Send me an email at keelan@ubahouston.org, and we can tackle it there!

      April 27, 2017
      Reply

Leave a Reply