Collect Data into Google Sheets | Forms, Quizzes, Surveys

By effectively utilizing Google Forms, you can sort, manipulate, and track a detailed database of information gathered from a number of sources. This tutorial will show you how to create a Google Form, how to send it to as many people as you would like, and how to manipulate the data afterward in Google Sheets. This tutorial is also in a video on YouTube.

Creating the Form

Begin by opening the main dashboard of Google Drive, and by clicking the “new” button and selecting “Form.” You can also right-click the dashboard, navigate the cursor to “More,” and create a new form.

create a new form

The form menu will appear, and you can begin filling in the questions you would like to be answered. Start by adding a title to your form, then fill in the questions below.

Give your form a title

For our example, we will be taking the names, emails, and other information from the recipient.

Question Types

The first type of question will be short answer – the first field, ‘First Name’, has a selection box to the right. This allows the report creator to decide how the recipient will answer the question. You may choose between a variety of options, but most reports utilize common question types like short answer or multiple choice.

Short answer question type

The ‘First Name’ field will be left as short answer, but we will make it a required field as well. Making a field required will place a red asterisk next to the question for the recipient, and they will not be able to submit the form without answering this question. This option is a toggle on the bottom right of the question box. We will do the same process with the next two fields, ‘Last Name’ and ‘email address.’

Name fields

To ensure the recipients enter valid dates, we will choose the “Date” option in the question type selection box. This ensures that the data we receive from the form recipients will be uniform and in a valid format. The specific date format (whether month/day/year, day/month/year, or other variation) can be modified as well.

date field question type

For questions with a specific answer out of a list, we will use the multiple-choice option.  We will create the “What time should we contact you?” field this way, allowing three options for recipients to answer. The number of choices can be added with the “Add Option” button, or subtracted with the “X” button on the right side.

Multiple choice question type

Additionally, multiple-choice questions can have multiple answers. The “Do you own a car?” field will use a check-mark multiple choice option, which allows users to select as many options as are applicable.

Check mark

Sending the Form

With a paid G Suite account, you have the option of clicking a box at the top of the “Send Form” window to automatically collect email addresses within your organization. Otherwise, there are multiple ways to send the form to recipients.

If you contact me here or email me at [email protected], you will receive a code for 20% off of your first year of G-Suite. If you sign up for G Suite using this link and apply the code during checkout, the discount will be applied.

Option to collect email addresses

You can email a notice to your list about the form. This notifies the users about the form itself, and you can also choose to include the form itself inside the email so that recipients can immediately fill it out upon receiving the notice.

Include the form in the email

Google Forms can also produce a link that you can send via a variety of forms. This gives your users a clickable option that doesn’t use their email (for sending through text messages, for instance).

Send form as link

Lastly, you can embed the form as HTML directly into your website. Using this option keeps the form directly onto your webpage so your users don’t have to leave.

embed the form in html

Analyzing the Data

To analyze the responses received, you can go back to the main page of the form and click the “Reponses” tab next to the “Questions” tab. This allows you to graph the data received from the form.

See responses to form

On the upper-right side of this menu, you can see the database itself. This holds all the raw data you have received.

Option to review responses in Sheets

Now that you have the data in Google Sheets, you can manually sort and analyze everything at a glance! Learn more about how to sort and analyze data in online training courses that Prolific Oaktree offers with videos, linked Google Sheets, notes, and quizes.

View entries in Sheets