If you are not already familiar with the free but powerful Google Forms tool, now is the time to do so.

Google Forms is a quick and easy way to collect information from your users through online forms. All you need to use them is Email Google, and it's very easy to add them to your site. Google Forms can be used to create a simple contact form, customer survey form, or something more complex. And in this article, we will provide you with all the information you need to add a Google Form to your site.

What is Google Forms?

Google Forms is one of many free apps from Google. The forms tool can be used to survey, collect contact information, take an exam, take orders, transfer files, and more.

Results and form information are easily accessible and stored in the cloud as part of your account. google records Disk. There is a large selection of ready-made templates for creating forms, and their editing has an intuitive interface.

If you need to collect information online, such as customer questions, inquiries technical support or ordering goods / services, Google Forms are effective for this. Let's create our first form and add it to our site.

How to create a Google form

The first step in this process is to create Google account(if you don't already have it). After that, you can go directly to Google Forms.

You will immediately be presented with ready-to-use Google Forms templates that can serve as the basis for your own form. If you decide to start with an empty form, just click on the big block with a plus sign (+).

In addition to common form elements such as fields and buttons, you can easily add a number of other elements to your forms. These additional elements can include YouTube videos, Google Photos images, questions, and plain text.

Change the look of Google Forms

You can preview your shape at any time, and you can easily change the color palette of the design. With a few tweaks, you can customize access to it and how the form will work. These settings include the ability to enter multiple responses from a single user, the order in which the questions are displayed, the mandatory user authorization, and a confirmation message.

Publishing a Google Form

Once you are happy with the created form, you can make it available by clicking the button Send message in the upper right corner of the screen. The form can be shared via email, using a link, or by embedding it on a website page. There is also the option to share the form on social media.

Viewing Google Forms Results

Once you have made your form available to an audience, either through a link or through your website, you can start monitoring the results of filling out the form. This happens through the " Answers»In the form designer.

One of the great features of Google Forms is the ability to easily view responses in real time, either individually or as a summary. You can also view the responses in a Google Sheets spreadsheet, which you can use to filter the results in many different ways.

Enabling email notifications when form responses are received is another useful feature to help you track user interactions.

How to add a Google form to your site

The most fast way Adding a google form to a site is to copy and paste the iframe code into the page code on your site.

An example of the code for insertion:

ID-FORMS for a real form will be replaced with a unique identifier.

After you insert this short form code into the page code, it will be replaced on the site with the corresponding Google form, which will already be ready to interact with your site visitors.

Quite often the task arises when it is necessary to conduct a survey of site visitors. Standard tools are usually a simple multiple choice survey and almost never provide a useful analytics tool (especially when you want to publish analytics in real time).

This article describes the basic steps for creating and integrating a survey form into a site page, as well as basic analytics tools and the possibility of embedding it into site pages.

The survey, you guessed it, will be conducted using Google Forms

Step one. Creating a survey form

We will not consider how to correctly formulate questions and how to group them - this is not the purpose of our article, but we will consider the process of creating a form itself.

1 Form creation

After that, a new form immediately comes off to us:

Do not forget to give a nice and understandable name.

2 Forming questions

I will not describe in detail the process of creating questions and posting them, since this is worthy of a separate article. (there will be a link to the article). Let's just look at the types of questions and how best to use them.

Text - can be configured to contain a number, e-mail or URL, the former is convenient to use in processing, the rest is mainly for identification and communication with the respondent, we are not interested.

Text (paragraph)- not the most convenient type of question for automatic processing

One of the list- a good option for a definite answer (the main thing is not to add the option "other")

Several from the list- if the answer does not contain commas, then it can be processed, but it is still quite difficult: try to refrain from such questions

Drop-down list- essentially similar to one of the list

Scale- a convenient way to get some kind of assessment, just as easily processed

Grid- in fact, an array of scales, but the answer is not in the form of a number, but in the form of a column heading, hence the more complex processing of answers

date- very convenient way to get date or date + time, easily handled

Time- similar to the date, you can also get the duration, easily processed

Based on how familiar you are with data processing methods (especially textual ones), you should form a list of questions and their correspondence to types.

If you want to embed the survey directly into the page of the site, then use File -> Embed in Web Page

Width and height can be specified as a percentage, below is embedded with a width of 95%

For HTML gurus who want to integrate the survey form specifically into their site, you can copy the tag from the form page

with all the content and customize the styles yourself.

Step two. Collecting answers and analyzing them

To do this, go to the automatically created table with responses to the form

A table with answers will open.

But we are not very interested in this, since we need to visualize the data.

For visualization, we will use diagrams, and for each selection table, it is necessary to create a separate sheet.

1. We process numerical data on all issues

Processing numbers across the entire table is not a big problem, since it is done using standard formulas in a spreadsheet editor.
For example:
Average age: = AVERAGE ( "Answers to Form (1)"! B: B)
Median age: = MEDIAN ( "Answers to Form (1)"! B: B)
A complete list of functions can be found there are a huge number of them.

2. Counting the number of text responses

In our case, it will be interesting to calculate the number of respondents by country:
= COUNTIF ( "Responses to form (1)"! C: C; "= Russia")
And so for each answer.

3. Get a part of the table

Sometimes it becomes necessary to get some data from some of the answers, for example, the average sleep duration of respondents from Russia.

To do this, we will use a more powerful tool that brings Google Sheets closer to full-fledged databases - SQL queries.

QUERY ()

It is unrealistic to consider all the query options here, but we will consider the most basic one.

Problem with formatted cells: data from cells with formats other than numbers and text is not always readable: force the format to be set to "Plain text" on the source table

With the help of such a query, we received all the answers of respondents from Russia, similarly, you can filter by any column.

ATTENTION! You cannot make changes in the table obtained as a result of the query, and it is also impossible for the table to fall on filled cells.

The received data can be processed in the same way as in paragraphs 1 and 2

Step three. Visualization

The most important part is to prepare data visualization, for this you can use charts, we will not consider standard charts, but follow in the footsteps of the last article

Diagrams, for the sake of order, are best kept on separate sheets.

If you have already appreciated the effectiveness of a tool such as a form feedback on your site - this post is for you. Today we will tell you how, without much effort and knowledge in web design and programming, to make an exact copy of a beautiful form on your website from a regular Google form and collect requests, requests, contacts and email database - directly into the Google Sheets!


First, let's define what we need:

  1. Google account
  2. Access to your site code
  3. 20 minutes of total concentration

Suppose we have all this in stock and let's get down to business - step by step guide how to change google form style.

  1. Name (text box)
  2. Phone (text box)
  3. Email (text field)

We will not stylize the form (change fonts, colors and add pictures) yet. We are only interested in the structure itself. As a result, the form should look like this:



As will be noted, we have not added data validation. Data verification is a useful thing, because it will allow you to track that you will not be sent instead of an email, for example, the word test. The check is added like this:

We open the form and make sure that it is working. To do this, fill in with test data and click Done:


After creating the form, we need to make sure that it is correctly bound to the table (or re-bound). Thus, we will make sure that all the data that will be entered into the form will not go anywhere, but will go straight to the table. To do this, return to the form editor and select from the menu Answers-- Save Answers:

We can proceed to the next step.

Copying the form code

And this is where hardcore begins for many. But do not rush to give up everything - we are with you!
So - in the form editor, click on the button .
Anywhere on the page with the opened form, right-click and select:

  • Google Chrome - Check item
  • Mozilla Firefox - Source code of the page
The entire code of the form will open before your eyes. For an unprepared person, this is a code hell with a bunch of incomprehensible and, at first glance, unnecessary lines. Exhale. We copy all the code that is between the tags
and
... The easiest way to do this is by opening source pages, press the key combination Ctrl + F and by entering the required tag in the search field. After that, right-click on the selected code and Copy.

Congratulations - you can already paste this code into your site and apply your CSS to it. But that's not all - the form submission confirmation page still links to the standard one from Google. To change the confirmation page - we need to change the following code:

Replacing it with:

All is ready! The form works, the data is entered into the table. There is only one trick left - a small but important one. This trick is called - table change notifications.
To set up notifications, open the table where data from the form is entered (we set it up at the very beginning of the path). In the table menu, go along the path Instruments -- Notifications... In the dialog box that opens, select the following items:

  • Notify (YOUR-E-MAIL-ADDRESS) of the following actions: choose Submitting the form
  • Notification method ... choose Email message - instant
Thus, every time someone fills in and submits the form, you will receive a notification that the table has been changed. Conveniently? Certainly!

Outcomes

It will not be superfluous to recall that this method allows not only using a form for contacts with clients / partners / subscribers, but also effectively collecting a subscriber base, structuring it, and automating the process of its creation. Just calculate how long it takes you to transfer the contacts that came to you from the feedback form to the contact database! At the same time, for sure, many contacts are lost. Our method will allow you to reduce the loss of contacts (or eliminate them altogether).

Write in the comments how you use Google Forms on your site and in general.

By the way - we have prepared a demonstration of work, just click on the button.

Write to an expert!

Hr business partner, coach consultant, business coach. IP Syrykh Oksana Mikhailovna

Experience of using Google Forms to survey new employees

Write to an expert!

Google Forms is an online service for creating feedback forms, testing and surveys that can be successfully used in the work of HR departments ... I am firmly convinced that for the adaptation period to be effective both for the organization and for employees, it is necessary to use modern tools to make the processes easy, informative and convenient for all participants.

Description of the situation

In the Customer's company, there was a need to make changes to the survey of new employees when two structural divisions were opened, located in different parts of Moscow. The assessment of the motivation of young specialists, in the process of adaptation in the company, was carried out as follows:

The HR manager printed out the questionnaire template, then invited a new employee who filled out the questionnaire in her presence, then the results of the questionnaire were entered into an Excel spreadsheet and processed.The whole process took a lot of time and was inconvenient for all participants..

As a result of the discussion, a decision was made to optimize the process of questioning new employees and transfer it to a remote format.Google Forms became the main tool of work.

How the process of questioning new employees was optimized

  1. A Google account has been created. The account name is worded as follows - hr.companyname (company name) @ gmail.com
  2. The questionnaire has been developed and configured to survey new employees
  3. Recorded video appeal HR directors
  4. Design and style selected registration of the questionnaire
  5. Sending configured email alerts
  6. Google spreadsheet set up for processing the received data and collecting statistics

The new questionnaire had to be not only informativeas well as attract the attention of new employees and encourage them to answer questions at the set time.

For this, the following functions of Google Forms were used:

2. T terms for registration. We wanted to make the survey form more attractive and always in a corporate style. To do this, we chose a ready-made style in Google Forms and uploaded our own image. You can do the same: customize corporate colors, as well as place any image and company logo.

3. RPlacement of video calls for new employees... Google Forms supports the ability to embed videos or images. Such opportunities allow you to "revive" your profile for employees and make it more attractive and interesting. We decided that text message does not evoke a positive response from new employees, most often they do not pay attention to the instructions posted at the beginning of the questionnaire. Therefore, we recorded a short video on behalf of the HR Director, posted on youtube channel and included this video at the beginning of the questionnaire.

4. Customization different types questions. All questions were required by default. To do this, there is a convenient "mandatory question" function. It is enough just to move the slider to the right and this mode will be activated for each item.
Types of questions that were used in the questionnaire:

  • selection of the date of filling out the questionnaire
  • choice from several options
  • selection of one answer from the list of presented
  • rating scale from 1 to 10 points
  • text (paragraph) where you can give a detailed answer in free form.

Examples of filling out questions when questioning using Google Forms:

Choice of answer options

Rating scale

Free-form detailed answer

5. Configured to send notifications upon filling out a questionnaire to an employee HR service by complementing "Email notifications for Forms". This simple feature will save your employees time and inform them about the respondents' answers in time.

5.1. To install the extension, in the upper right corner of the form, click on three dots. You will see a drop down list. Select "Add-ons". A window for installing extensions will open. In the search bar, type the phrase"Email notifications for Forms"and install the extension.


- select the Create Email Notification command
- a window for configuring the rules (Configure Form Rule) will open

5.3. After selection Create Email Notification the Configure Form Rule window will open

  • name the rule(Form rule name), for example "Notification of filling out the questionnaire"
  • enter your email address to which notifications will be sent (Email address to notify). Print the employee's corporate email address or department mailbox
  • check the checkbox " Notify form submitter?
  • select from the dropdown list notifications from the submitter email address
  • click the continue button

5.4. Design the text of the letter for the employee (Email Template)... You can choose html format and place your html-code in it or choose Visual - window text editor similar to MS Word.

Be sure to customize the fields: Sender "s Full Name and Email Subject. In our project, these fields are called" Questionnaire for a new employee "and" You have received a new answer. "

In the body of the letter, formulate the text. For example, “Dear Colleague! The application form was completed by a new employee. Look at his answers. "
Include variables in the body of the email((Response Date)) as well as ((Form Name)), then you will know the date of filling the form and its name.

  • Left-click on the "Settings" gear icon and set the "Collect email addresses" in the form parameters. Activating it automatically adds the required "Email" field at the beginning of the form.
  • In settings select the item "Submit the form no more than once"
  • "Presentation" tab ... Specify "show progress"
  • Provide an opportunity for respondents " Change responses after form submission. ”There are often times when new employees want to change their responses
  • In the confirmation text about submitting the form, write a phrase of gratitude.
  • Actions with the form.Left-click on the icon after the submit button to open a menu of actions with the form: you can create a sample form filling, set up sharing for editing the form.
  • Copy functions are available for all types of questions; it is convenient to use if you create questions of the same type.
  • Activate the "Accept replies" function in the "Answers" tab

As a result, after all the settings, we got a convenient way to survey employees when Google help Forms:

  • a professionally designed questionnaire to assess the motivation of new employees after the first month of work;
  • online testing format convenient for all company specialists;
  • the ability to analyze the results, relying on a general summary of answers, statistics on specific answers and answers of an individual respondent;
  • e-mail notifications informing HR service about filling out the questionnaire.

Write to an expert!

Still writing briefs in Word? Terrible awkward tables that need to be sent back and forth 5 times. The customer wrote to you - you send him a brief. He filled in wrong - send again. After all, he has already deleted it from the computer. This can take an entire day, wasting you and your clients' time.

In this article, I want to tell you about Google forms... It is an online service for creating feedback forms, testing and polling. He can be of great help to anyone who works with clients over the Internet. Especially copywriters.

Many customers are afraid of the brief like plague. It is long and difficult to fill it. If you reduce their discomfort a little, they will be grateful to you.

By the way, this is not only a brief guide. I have described in some detail the principles of working with the service. You can create anything in it.

So that you don't get lost in the manual, I made a small table of contents:

Benefits of a Google Forms brief

  • This is original. You stand out from the competition.
  • You don't need to download it... You send the link to the customer. He fills out the brief and presses the button. You get answers.
  • He will not get lost. The brief is stored in the cloud. Even if your HDD will burn out - the questionnaire remains and will work.
  • No additional software required. What if your client doesn't have Word installed? With Google Forms, you don't care.
  • Looks stylish. Everyone pays attention to the design. Customers will appreciate it if you send a nice and convenient brief instead of a curve table.
  • Partially automates the process of receiving orders. You post the brief on your site. The client comes in, fills it in and places an order.
  • Easy to create. Slightly more complicated than tables in Word.
  • Free. You don't have to pay to work with the service.

Still in doubt that an online brief is cool? Just look at this example.

And then this one.


Which one would you like to fill more if you were a customer?

What is Google Forms

Forms is one of the services tied to the Google Drive cloud storage. To work with it, you only need a postal Gmail inbox... Create now if you haven't already, and let's move on.

The application works through the browser. In it you can is free create any number of shapes. What is a form? In fact, it is a separate web page that hosts a survey or questionnaire. With its help you can do:

  • Convenient brief for clients;
  • Feedback form;
  • A page for collecting email addresses;
  • Voting for subscribers. This is especially true if you work on multiple social networks.

Google Forms Basics

The system will offer to create a new file or use an existing one. It is unlikely that you have a prepared template for this plugin, so it is easier to choose "No, create one".

The service will create a new file directly on your Google Drive. If you rename or move it, do not forget to specify the new path. The file contains a template for drawing up a report based on questions. If you need to tweak something, this is done in the document, not in the plugin window. To do this, just click on the link to it.

Everything is simple here. IN <<скобках>> the name of the question is indicated. No links. What you have in your question is written in brackets and needs to be placed. Everything else is plain text for your convenience. Edit it however you like.

You can format the document for yourself. Add paragraphs, separators. Anything, even graphics. I personally recommend adding blank lines between questions to start. It's much easier to read that way.

When you're done editing, go back to Google Forms and click "Next".

At stage 3, you need to select a folder where the reports created using the template will be saved. Specify an existing one or create a new one.

By default, the folder will be named "Form Publisher Output's Folder". If you rename - do not forget to indicate this in the plugin window.

Now you need to specify how to name the generated reports. By default, they will receive names like "Your Form Name - Number". In my opinion, this is convenient and there is no need to touch anything here. But if you are not satisfied, write something of your own.

The last step allows you to add the Email of people who need to send notifications when a new report appears. Enter your address so you know when someone has completed the brief.

If you need not only a document, but also a PDF file (you never know), click on the link "pdf recipients" and put a tick in front of "Keep a copy of PDF in Drive".

Everything. Now, when the client fills out your brief, a file will be created with answers to all questions. And you will receive a notification by Email.

Form Publisher gives you 100 free positives per month. If you get more orders, buy an annual subscription for $ 24. It's not that much.

Collecting reviews

What feedback would you like more? "Thank you, everything is cool!" or detailed, describing the results of your work?

I've often met customers who just don't know how to write reviews. From this we get the useless "I liked everything, I recommend it to everyone." Therefore, customers should be nudged a little in the right direction. How? Ask them questions, of course!

Once again, Google Form comes to the rescue. Make a simple questionnaire:

  • Position:
  • Organization;
  • Website;
  • What they ordered;
  • Text efficiency (conversion, reposts, likes);
  • Rate the work on a 5-point scale;
  • The text of the review itself.

It is much easier to answer a few clearly posed questions than to think over a plan yourself and write something intelligible. With your questionnaire, you make life easier for the client, save his time. And you increase the likelihood of getting a cool review, not outright junk.

Additionally, you can ask how the client found you. For statistics.

conclusions

All people appreciate good service... Emailing a document with questions is a "not-so-so" service. A well-designed online questionnaire immediately catches the eye. It sets you apart from the same competing copywriters. Saves time. Doesn't get lost in endless spaces hard disk... It is remembered in the end.

Try moving your brief to Google Forms. It won't take a lot of time, but it will make life much easier for you and your clients. Or maybe it will become the missing item that will induce you to place an order, and not someone else.