How to Use Google Forms, Sheets, & Maps to Survey Your Community (For Free)

Every church needs to know the community around them. Many churches today knew their community at one time, but things change. When it comes to communities here in the US, that transition has happened quickly and everywhere.

Many (I would guess most) neighborhoods look different today than they did 10-15 years ago. In many places immigration has brought the nations into our neighborhoods. Today your new neighbor is as likely to come from Dehli as from Delaware. Nowadays, we have Hindu neighbors, Buddhist neighbors, Muslim neighbors, and all kinds of things in between.

And for those few neighborhoods that are not seeing international influx, they are nevertheless in transition. Gentrification is redrawing boundary lines for neighborhoods and there is a likely chance your community has different culture and values than it did before. If you ever plan to do effective ministry where you sit, then you need to know.

When I speak and teach on these transitions, it is most often met with wholehearted agreement and confused looks concerning where to start.

Every Church Can Research Their Neighborhood

At this point, it is too common to number. Virtually everywhere I go to work with churches or conventions, I meet people who feel they lack the expertise to do people group discovery in their community. This is simply not true. We do not need cultural expertise to start the mission; we simply need to be learners.

We have done ourselves as disservice in Evangelical denominations by convincing ourselves that ministry requires “ministry specialists.” This is not true for evangelism. It is not true for discipleship. It is not true for missions. And it is not true for people group discovery around your church. While special research from agencies or institutions can be helpful from time to time, what a church really needs to do is go out into their own community and collect their own information. And honestly, it is not hard to do.

When your local church gathers its own research on your community, it is your church members who have developed the relationships necessary to get that info. That is huge when it comes to missions. Instead of being handed a spreadsheet full of numbers that make little more than sermon talking points, your church members have walked into businesses and met real neighbors. They know real names and real locations.

Furthermore, compiling this information to get a clearer picture of your community is not hard either. In fact, there are a number of easy, free tools nowadays that basically compile that information for you. Here is one simple method.

One Simple Method for Surveying Your Community

When local churches come to wanting to map out their neighborhood, I do not send them to some fancy mapping software and census data. I send them to Google Maps.

By this point, most people have used Google maps, and many have used their productivity suite for documents, spreadsheets, and online forms. These tools are specifically designed to be easy on new users, and they are basically ubiquitous at this point. And of course, they are free to anyone with a Gmail account. It is entirely possible to collect a great deal of helpful information on your community and visualize it using nothing but Google.

Google Forms

imgresGoogle’s online form creator is the starting point for creating a community survey system. It is easy to set up a form with a number of questions that provide insight. Just remember, less is more. The fewer questions you ask, the more likely your church members will get all the information.

When attempting to discover people groups, it is important to ask three specific questions. First, you will need to find out their country of origin. Second, you will want to ask what language they speak in the home. Finally, try and find out their religion. These three pieces of information together will usually identify an ethnolinguistic people group.

In addition, you will need to take down basic information on the establishment you visit. Have spots on the form for the name and address of the establishment. It is also good to note the type of establishment, whether it is a restaurant, hair braiding salon, international market, etc.

After the form is complete, you will have a link to distribute to church members. Google Forms are responsive, and so they will pull up nice and easy on a smartphone. In fact, with most smart phones, you can pin the form directly to the home screen of the phone like it is an app. That way, your church members are one tap away from filling out information on a new place they visit.

Of course, it should go without saying that walking into any establishment with your phone in your hand filling out the form as you talk would be rude. People are much more likely to be curious (and not in a good way) if they feel like they are being monitored. That is not the purpose or spirit of gathering this kind of information, so have church members hold off on the form until after they leave.

Finally, after creating the form and using it, there is a responses tab that provides aggregated information on all of your submissions. How many Indian restaurants have you found? Well, this tab can show you. It will show you the percentages of nationalities or pie chart of languages depending on how you build the form. The more information that is entered, the clearer the picture becomes. However, the good stuff is still to come.

Google Sheets

imgresThis is where this whole process gets cool. Every Google form automatically builds a Google spreadsheet. It is built right into the Google Drive account where the form was created.

Every time someone fills out the form, a new line of information is automatically entered into the same spreadsheet. This becomes your community database without any effort. As your members use the form, the amount of information you gather on the community grows and this spreadsheet becomes more valuable.

You can use the responses tab mentioned above to see certain visualizations of the information. It will automatically create pie charts and other relevant information from the data you collect. However, to really visualize this process, you need the spreadsheet.

My Maps (Google Maps)

imgres-1Google Maps has a section called My Maps and here you can build your own, editable maps. It is possible to place points one at a time in a map and fill in information on them, or you can bulk import information directly from a Google spreadsheet. See where this is going?

As your Google sheet gets big enough, you can go to My Maps and import that Google sheet straight from the Drive account and it will geocode all of your data. Geocoding is the fancy way of saying that it will place all of the points of interest that you gathered on one map together. Of course, you must have the addresses built in as a question on that form, or it will not have the information necessary to map your community.

After importing the sheet, it will ask you which column of data to use in order to plot the points, and it will ask you which column of data to use for naming the points. This is why you need to know the name and address of every establishment. Once the points are plotted, it is possible to change the styles on them and color code them by either type of establishment or even nationality, language, or religion.

The result is a map full of places that are connected to different nationalities or people groups. This allows you to see who is now in your neighborhood, and it also shows you where they are. Add this knowledge to all the personal relationship development that occurred by having your own members find out the information, and you have some valuable missions research.

screen-shot-2016-09-14-at-8-33-04-am

I encourage you to play with these features in Google Drive. After all, they are free, and pretty easy to use. Shoot me an email or a comment if you have any questions, and I would be happy to help your church start thinking through ways they can discover and engage the community around them.

 

13 Comments

  1. Brad W. said:

    Hey Keegan, you might also connect folks to Pray4EveryHome.com where they can input their home address and start receiving the names of the 100 closest neighbors (5/day) in a daily email to pray for. A great resource working in collaboration to the surveying you outline here.

    September 14, 2016
    Reply
    • Keelan Cook said:

      An excellent resource as well! Thanks for mentioning that one in the comments thread. May need its own post, in fact.

      September 14, 2016
      Reply
  2. This was super helpful, KC. King’s Church has a mission team coming up in a month, and I plan on putting them to work using this very process!

    September 14, 2016
    Reply
    • Keelan Cook said:

      Great! Let me know if you have any specific questions as you’re putting it together.

      September 15, 2016
      Reply
  3. Justin Bouldin said:

    Thank you for sharing this info. We will definitely be incorporating these tools into our outreach strategy for our church!

    September 21, 2016
    Reply
    • Keelan Cook said:

      So glad to hear it, Justin! Let me know if you guys have any questions about particulars, and I will be happy to help.

      September 22, 2016
      Reply
  4. Philip Martin said:

    I find this very interesting and see it as very useful, especially for a church in a city. My problem and question is the church where I am pastor is a rural churcj betweent two cities, how could I use this in a rural setting where our members are spread out over a vast geographic area? By vast I mean we have members who are drive 30 minutes to church and some who walk across their yard to church.
    There isn’t a lot of establishments in our direct neighborhood, so I am interested in how this could work for a rural setting.

    September 21, 2016
    Reply
    • Keelan Cook said:

      Philip, that’s a great question. Using forms to source data is a real flexible process, and I do think it can be helpful for a church in a rural setting. The use case is definitely different, but I still believe there are possibilities.

      The benefit to using Forms is that you set the questions. If establishments are not what you are after, you can focus your form on collecting data on individual people. For instance, our church uses a Google form at our new visitor table instead of having them fill out cards. This way, it automatically creates a spreadsheet for followup with the questions we’ve asked and info we’ve gathered. We have a gift bag for all new guests and have them fill out the form on a laptop right there at the table. It only takes a minute.

      In addition, you can do discovery by focusing on neighborhoods or subdivisions and “third places.” A third place is any establishment that is not home or work, but allows people to socialize. These are more rare in a rural setting, but most towns have a few places where people gather.

      Get into conversations with individuals and craft a form that gauges gospel interest. Of course, I wouldn’t have the people I’m talking to fill out the form, but equip your members with it, and have them quickly fill out the form after talking to people. Before long, you may start to see certain subdivisions that are more receptive to the gospel.

      Finally, I just posted a follow-up on using Google Sheets and Maps to map our your membership. This can show you certain areas where you might want to focus because of a concentration of members or the reverse, an area where you have no one living.

      Those are just a few things I can think of off the top of my head. Feel free to email me and we can talk through ideas in detail, if you’d like.

      September 22, 2016
      Reply
  5. WOW! What an amazing tool this is and it’s fairly simple to use too. Keelan, thank you for discovering this and sharing this here on your website. We’ll continue to gather data and learn how to use it strategically, to serve more people in the community, keeping them informed about what’s happening at the church and inviting them to any upcoming church services.

    Thank you again for your time this afternoon to talk to me about this too.

    June 26, 2017
    Reply

Leave a Reply