5 Simple Steps: Using Google Docs to Create a Free & Easy-to-Use Customer Survey or Contact Form

Online surveys and contact forms give your customers access to you in a way that allows you to easily store and track the data for later use (leads, annual report data, customer satisfaction, etc.). Creating and distributing the survey can be sometimes tricky logistically and aesthetically. You might be too scared of your IT guy or web designer, you might not know how to program a website or you don’t want to spend money on a solution without knowing if people will even use it. Many people use solutions like Survey Monkey or Constant Contact to solicit feedback from their customers and clients. While they are effective, the name “Survey Monkey” and the giant logos and disclaimers that Constant Contact slaps on their emails make me cringe and if you embed them on your site they tend to just look clunky and out of place.

Don’t worry, I’ve got you covered. Below are 5 simple steps outlining how you can create a free survey or contact form using a hidden gem inside of Google’s popular online document creation service Google Docs.  Seriously, you’ll smack yourself and say, “Why didn’t I realize how to do this sooner?” Then you’ll call your web developer and say, “Why the heck did you charge me $300 to program a contact form that I just made in 2 minutes!!!” After you’ve done that, feel free to pass my information on to them so they can personally thank me.

Step 1: Create a Google Documents Account

Visit www.google.com/documents and sign up for a free Google Account. If you already have a Gmail or Google Account then you can just sign in to Google Documents using that account.

Step 2: Create a Google Form

Once you login to your new or already existing account you will be taken to your Google Docs home screen. On the top left corner of the browser, you will see a icon that says “Create New”. Click the icon and select “Form” from the dropdown menu.

Step 3: Complete Your Form

Now the fun begins. Enter a title at the top of the form and some description text explaining the form to your customers or visitors of your site. Using the “Add Item” icon on the top left of your browser; you can select the types of fields you want inside of your form (below). You can even break your form into multiple sections and pages. Use the trashcan icon on the right side of each item to delete unwanted items or save time by duplicating items and changing the names of the field.

Types of Items:

  • Text
  • Paragraph Text
  • Multiple Choice
  • Checkboxes
  • Choose from List
  • Scale
  • Grid

Note: Unless you want Google’s generic confirmation message, click the icon on the top right of your browser that says “More Actions” then select “Edit Confirmation.” Now type in whatever you want to say to those customers who complete the form.

Step 4: Publish and Test Your Form

There are two ways you can send your nifty little form to the world.

Email
The first method is using “Email this form” icon, on the top left area of your browser. This will email a link to your form directly from Google Docs. While that is a cool feature, the likelihood that you will actually email all of your customers using this is slim. Enter YOUR email in the box and use the link in that email in whatever emails, tweets, or Facebook posts you plan on using to publicize your new complaint contact form or customer dissatisfaction.

Embed on Your Website
This is a little more advanced and requires access to the files of your website and the ability to update them on your web host. If you utilize a Content Management System (CMS) or have HTML experience then you should be embed the code very easily. Click the icon on the top right of your browser that says “More Actions” then select “Embed.” Copy the code in the box which appears in the center of your screen and paste it into the source code or CMS on the desired page and area of your website. Adjust the <iframe> settings to your liking. Now test your masterpiece.

Step 5: Reviewing Your Data & Setting Notifications

When a customer uses the form, all of the results will be entered into a Google Spreadsheet. You can access that spread sheet now by clicking the “See Responses” icon on the top right area of your browser and select “Spreadsheet.” The document you see now can also be accessed later from your Google Docs home page. If you followed all the steps correctly you should see the results from your test submission(s).

To schedule a notification of responses click the “Share” icon on the top right of your browser and select “Notification rules”.  You can select a variety of options from this screen, but the most useful one is to check “Email – right away” at the bottom of the screen, which will send an email to you anytime someone completes the form.

Note: The notifications will be sent to the email address your Google Account is setup as.

Here is a sample form for you to check out.

Good Resources & Reads

Not Everything Tastes Like “Chikin”: Creating a Superior Customer Service Experience

Full disclosure, I have recently become addicted to Sonic’s new Chicago-style hot dogs. I think they are amazing and I will occasionally stop by the drive thru to treat myself. This past week I stopped to dine on one of these awesome culinary treats. After I ordered one, I pulled up to the carhop area and waited for my delicatessen. Now I know Sonic is technically “fast food” and the standards, or lack there of, are not the highest in the customer service world. With that said, there are certain things you just expect not to see at any restaurant. As I sat there, I saw an employee who was wearing the traditional Sonic roller skate costume, which is always cool. She was attempting to sweep under a table with one hand while the other hand was helping her smoke a cigarette. Besides being impressed with her ability to multitask (skate, sweep, and smoke), I was kind of confused that she would be smoking while on the job, especially with a customer right there. I mean, does she think she works at Sterling Cooper? Anyways, she looked over at me, and I’m sure I had a confused stare on my face as I looked right at her. She didn’t care, she just kept going about her business. The parking lot was empty and I was the only customer they were serving, but it still took forever for them to bring out my order. It made me ask myself, “Are they acting like this because no one is here or is no one here because they act like this?” This chicken-and-the-egg-type conundrum really made me think, and thinking always makes me hungry, so I tossed my Chicago-dog and went to one of the happiest places to eat—Chick-fil-A. (Note to self, lay off the fast food.)

eat mor chikin... then have fresh breath.

I know that most Sonic restaurants are not going to have smoking carhops (let’s hope not anyways), but do a test and drive by your local Sonic. Usually you will see an empty parking lot and sometimes the occasional Chicago-dog addict looking for his fix (probably me). Now drive by your local Chick-fil-A and you will almost always see a line of cars wrapping around the parking lot. Chick-fil-A and Sonic essentially provide the same product, but they could not be more different in service and experience in which that product is served. Generally, the employees at Chick-fil-A are always “on” and operate in a polite and friendly manner. They say things like, “I’m looking forward to serving you at the window” and “My pleasure.” Chick-fil-A locations are ridiculously clean and operate efficiently. I guarantee you also won’t see employees smoking while they are sweeping either. The icing on the cake for me was a few months ago when I walked into a local Chick-fil-A and they had a mouthwash dispenser in the bathroom with flowers sitting beside it. My only complaint is that they didn’t have a bathroom attendant to hand me a clean towel… kidding.

Does it really matter if you or your employees provide a good customer service experience?
Well, according to the 2010 North American Customer Experience Report, conducted by RightNow and Harris Interactive, 82% of the more than 2,200 adult consumers surveyed said that they stopped doing business with an organization due to a bad customer service experience.

Is it difficult or expensive to create that experience or culture?
It might cost a little extra to take the time to train your people more effectively, but according to the RightNow report, 85% of consumers said they would be willing to pay more in order to ensure a superior customer experience. Your customers and clients want a better experience and are willing to pay for it. Seems like a no-brainer to me.

The truth is, if you aren’t being intentional in your interaction with customers and clients, you are probably uninterested in their satisfaction, and that’s just plain lazy. Your customers and clients are ALWAYS watching you. The good news is they aren’t just watching and waiting for you to screw up or give them bad service, but they are waiting for you to amaze them and show them how much you care. You would be surprised how the smallest things make the largest impact and how many or their friends and family will become your customers too.

Good Reads & Resources