How Can I Log Data From Google Form In Less Annoying Crm

Google Forms is a role of Google Drive, so be certain to check out our Google Drive Overview !

An oft-overlooked part of Google Drive, Forms is a simple only powerful tool which can easily fill up a number of needs in your business. As with the other tools available in Google Bulldoze, information technology is totally gratis, and you lot tin can easily collaborate with other people. In this tutorial, we'll walk you through how to fix a survey for your customers. This is a good way to collect a lot of useful data, for case, how your customer heard well-nigh you lot, or what products they are near likely to utilise or tell their friends nearly.

Choose Form from the list in Google Drive

The Situation

Imagine, if yous volition, that nosotros are a small upshot planning company who have recently run a number of events for one of our clients. We are hoping to get some feedback on how these events were accepted by the attendees, in social club to better hereafter events.

Getting Started

Get to bulldoze.google.com to admission your Google Drive. If yous are not logged into your Google account, you will need to do and so here. Once logged in and on your primary screen, you lot will want to click the big red "CREATE" button on the left sidebar and select "Form" from the list.

(If you're interested in the other options hither, be sure to check out our other resource articles about Google Drive coming soon!)

After yous've opened up the form, you will happen upon a screen where you get to proper noun your form and choose a theme for the class. I like the color and look of the "Books" there, so nosotros'll go alee and choose that 1. I also similar to believe that the events were run in a library multipurpose room.

We'll name the form "Summer Plan Survey," every bit it'due south going to exist a summary of the source of our clients from various programs we've run over the summertime. Our first question volition simply be a question on where the form-filler had heard of our company. We just choose this to exist a multiple choice question, fill in the question, and provide some possible answers.

Google Form creating view and final view

1 nice feature you can use hither is that it is possible to ship your users to different pages based on their choices (just like a cull-your-own-risk book). In this survey nosotros volition have the user make full out a form that relates to the plan which they indicated that they attended. This power to customize the information you acquire is invaluable. This can prevent you request your customers questions which are inapplicable to them, which in turn helps to ensure that y'all will take a college completion percentage on forms.

Be sure not to enquire your users too many questions! Users are far more than probable to terminate a form with fewer than v pages. Keep information technology short and sweet.

In order to add boosted pages to your course, just choose "Folio Break" from the "Insert" dropdown carte du jour. Yous can add anything from this page. Here is a breakdown of each option:

Text A question or prompt where the answer space is a pocket-size box to enter text. Skilful for questions where the answer is a discussion or 2, or possibly an ID number.

‍Paragraph Text Expert for open up-ended, long-response mode questions. Let your users express their opinions hither

‍Multiple choice Multiple choice option (just like the SAT!), where the user can select but one pick

‍Checkboxes Multiple option, only in this case the user can select one or more than of the options

‍Choose from a list Functionally like to Multiple option, but uses a dropdown carte.

‍Scale Allows your users to rank something on a scale you define. If yous are ranking a big number of items/criteria, you should use Grid.

‍Grid Essentially but a number of scales. Expert for ranking a number of items or criteria.

‍Date Your user chooses a date from Month, Day, and Twelvemonth dropdown menus

‍Time Either a specific time of day or a duration is chosen from dropdown menus.

‍Section header A header that allows you lot to pause up sections of your course

‍Page break Lets yous make a totally separate page of your form.

‍Image Insert an image, expert for beautification of the course.

Subsequently you end creating your form, made even easier by the fact that nearly everything is drag-and-driblet, you'll want to publish your grade. Merely click "View Live Form" on the top. At present just copy the URL from this page (that'due south the address in the address bar). Information technology is mostly a agglomeration of gibberish, so you'll want to send that address in an email or a posting to your potential respondents.

For your reference, here is our sample Google Form used in this tutorial.

Getting Information

Yous've sent out the link to everyone, and yous desire to see what sort of responses are coming in. On the "Responses" dropdown menu, there are a couple options. Summary of responses is a statistical view, which should allow you to get a overnice breakdown of the data received through your grade. View responses is an choice that volition let you view your responses in spreadsheet format. This may be useful if you want to import the info into some other system (or save information technology onto your computer as an excel file.

Once your period of accepting responses is over, be sure to uncheck the option "Accepting responses" then that you don't get any new responses at that place. You don't desire new data throwing off your results!

At present you lot have the know-how to get your own Google Forms created! Just get to drive.google.com and get cracking. Get creative, have fun, and exist sure to permit us know how your company uses Google Forms on our Facebook page . Sign up for our newsletter to get more articles on Google Drive and other online apps for your small business!

‍