How to Create and Use a Google Form – Part 2

How to Create and Use a Google Form – Part 2

In Part 1 of this article, I covered how to create and customize a Google Form, and embed it on your website. Here in Part 2, I’m going to give you the steps to set up response collection, and notification so that you know when someone submits a response.

First, scroll up to the top of your Google Drive window, above your form. Click on “Choose a response destination.”

Collect Responses from a Google Form

Typically you want to create a new spreadsheet that corresponds to your new survey. I leave the default name as-is so that it matches the name of my survey. When you’re satisfied, click “Create.”

Google form response destination

Now that we’ve created the spreadsheet where the responses will get stored, let’s go and view the live form so that we can add a test response. Go back to the top, and this time, choose “View live form.”

View LIve Google Form

Here’s our live form. I’ve entered some sample answers, and then I’ll submit.

Example Google Form

After I submit, I see the confirmation message that we configured earlier.

Google Form submit confirmation message

Now let’s go back to Google Drive, and take a look at our response spreadsheet. It should now contain my response.

View Google Form responses

Notice that where it used to say “Choose response destination,” it now says “View responses” because we have set up our spreadsheet. Go ahead and click on that. You’ll see a spreadsheet of responses, with a row that is the response I just added.

As users submit new responses, they will be added as new rows in the spreadsheet. The newest rows are at the bottom.

Google Form responses spreadsheet

Wouldn’t it be nice if you could be automatically notified when someone completed your form? Well, you can! From the responses window where you are now, look under the “Tools” menu, and select “Notification rules…” You must remember that you can only find this option from the responses window, and not from your main Google Drive menu.

Getting notified of Google Form responses

I’ve chosen to get a notification whenever someone submits the form. You can also choose to be notified if anything in the results spreadsheet is modified. I’ve also chosen to get my notification immediately by email. The email address used will be the one that is associated with your Google Drive account.

Get notified of Google Form responses by email

I hope you found this tutorial helpful! Google forms can be used for a huge variety of tasks. I’ve used them to create a work request form for my clients to submit new job requests, and I’ve used them to collect RSVPs for my wedding! Please leave me a comment below, and let me know what uses you come up with for Google Forms. We can all inspire one another!


Leave a Comment