Keeping a Church Prayer List

Although many of us rebel against the notion of keeping an organized list of something as personal, spiritual, and intimate as prayer needs, faithful congregational ministry often requires administrative effort to bring cosmos out of the chaos. In an effort to help churches begin keeping an organized prayer list (or to move to a new format if their old version isn’t quite doing it), I am sharing the following tutorial for using Google Docs (a totally free resource that allows you to give access to documents to only the people who should have it) to create such a  list.


Creating Your Google Docs Spreadsheet Prayer List:

1. You will need a Gmail account. If you do not have one, you will be glad that you need one for this, as Gmail will blow away whatever e-mail service you are currently using. If you need an account (they are free), sign up for one at Gmail.com

2. Use the Prayer List Template. If that link does not work, search for “Prayer List Template” here.

3. Be sure to Save the spreadsheet to your account.

4. Start filling in information as you get it. Please note, on the bottom of the spreadsheet you will find the tabs for all the sheets in this template, where you can also record information about prayers for Evangelism, Records of Deaths, and Answered Prayers.

Where to find the tabs

5. Once you have entered your data, you will probably find it useful to sort it. Although you can easily sort it by any of the columns, I recommend sorting by Date. To do this:

  • Select the empty square to the left of A and above 1.

The empty square next to A and 1

  • Click Data and select Sort Range
  • Select Data has header row checkbox (this tells it that you have titles in Row 1 that you don’t want sorted)
  • In the Sort By drop-down menu, select Date Requested (note: your Date Requested data should be imported consistently in the m/d/yr format)
  • If you want it to sort by more conditions, click +Add another sort option and select the item you would like to sort by secondarily
  • Click the Sort button
  • Unfortunately, you will need to do this individually for each of the tabs in the template, and you will will need to use this sorting command every time you want to sort your list, as Google Docs does not make it easy to autosort. On the bright side, if you sort by date descending as suggested, you can simply add new requests at the bottom of your list as they are made and they will already be in chronological order.

6. Assuming that you would like this prayer list to be available to multiple church members, staff members, elders, prayer team members, etc., you will want to use the sharing function.

  • Click File then Share
  • Enter the e-mail addresses of whomever you would like to have access to the file (note: You will want to remember that there will be personal information in the list that probably should not be made available to the whole world or even the whole congregation, so it is best to grant permissions sparingly. You can always use this database to provide the information for a public prayer list that doesn’t go into all the details)
  • You can grant these people permission either to simply see the document or to edit it.
  • Click Close when you are done

7. Just like that, you are on your way to having an organized, shared database of prayer needs and answers to prayer.

If you have any questions or suggestions, please comment below.

About these ads

~ by Samuel on July 27, 2011.

2 Responses to “Keeping a Church Prayer List”

  1. [...] you may have begun to learn in my previous post on Keeping a Church Prayer List, I am a firm believer that the tools developed by Google can be a great benefit to churches, [...]

  2. [...] you may have begun to learn in my previous post on Keeping a Church Prayer List, I am a firm believer that the tools developed by Google can be a great benefit to churches, [...]

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
Follow

Get every new post delivered to your Inbox.

%d bloggers like this: