New From Google Docs: Email Forms

Written by: Peter Jalbert on Tuesday, March 11th, 2008
Posted to: Spreadsheets
6 comments, add yours!

Here’s a new quick tip for Google Docs. If you want to get instant results from surveys or polls, you can use Google Docs and Spreadsheets to send out emails with checkboxes or radioboxes, text boxes, and then whenever recipients send in their answers, your Google spreadsheet is automatically updated.

So first you need a spreadsheet that you can use for sharing or collaboration. Click on the Share tab to start.

gt-poll0.png

Then under “invite people” choose “to fill out a form“.

gt-poll1.png

You will then be led automatically the the online form generator

gt-poll2.png

Here we will have to fill in the information we would have to include in the poll. This includes the form title, the form question or description, and items you want to ask your respondents to answer. You have a choice of question types, from text, to check boxes, to radio buttons.

We can include as many questions or items as needed, and as many types as needed.

Then once we hit the “choose recipients” button, we then add the email addresses of the form respondents. As with Gmail, just keying in the first few characters of the name or email address of recipients in your address book, and you’ll be given a choice. Otherwise, you can input any valid email address.

gt-poll3.png

You can include a custom message, where you can explain to the respondents what they have to do. Then when all is good, you send your questionnaire, and wait for people to answer.

As they send in their responses, your Spreadsheet will be automatically updated, with timestamp and with the responses. You will notice that Google will automatically add the questions you put in the form as headings/columns.

gt-poll4.png

I can think of many uses for thihs, such as for surveys, questionnaires, for school projects, and the like.

Don't miss another post! Subscribe by RSS feed or by email today!

Share This   6 comments, add yours!

6 Responses to “New From Google Docs: Email Forms”

  1. Troyon 14 Mar 2008 at 5:23 pm

    That’s quite an amazing discovery, I wonder if Google has a service to create your own newsletter hidden somewhere. They do tend to bury these features, don’t they?

  2. Terenceon 02 Apr 2008 at 5:09 pm

    Since the forms are created on spreadsheets, there msut also be the possibility the sum up the the amount of marked dates.

    To see what I mean; have a look at a nice helpful tool:

    http://www.doodle.ch

    Terence

  3. Gigion 03 Apr 2008 at 10:04 am

    Is there a way to see who answered what? Or are the answers alway anonymous?

  4. adityaon 17 Apr 2008 at 12:43 pm

    i dont see anything like this…
    my googledocs look completely diff and on top of tht i dont get the option to fill out any form for inviting :(

  5. Shawnon 21 Apr 2008 at 9:05 pm

    Is there a way to post the form on a webpage, and have folks visit the page to fill it out (so you can send a link to the page, rather than sending to each email address?)

  6. J. Philon 30 May 2008 at 5:20 pm

    I found a nice video of creating a form in Youtube:
    httpv://www.youtube.com/watch?v=YxYZKkusg-Y