Formula One Gather data from anyone using Forms on Google Docs

Posted by tom klein February 7, 2008

When you need to get a lot of people to provide input (sales forecasts, marketing plans, customer feedback), your options are pretty limited. You have to send files around or invite people to add something to an online, shared spreadsheet, like Google Docs (as we introduced in Close the loop).

Things just got easier. Google docs (a free online spreadsheet), has just added the ability to create forms. These forms let you turn their online spreadsheets into an easy way to reach out to others for the information you need. Here’s how it works. First, open up a regular Google doc spreadsheet. Choose to share the document and then indicate that you want to create a form. Fill out the different sections using tools similar to those you’ll find when creating an online survey. Then, you can automatically send an email to anyone from whom you would like to gather information. Your recipient will receive a simple request and be directed to a web page.

As people fill out the form and provide data, you can track the data as it comes in … on your spreadsheet. Where else? Why are you still sending around spreadsheets for people to complete?

When you move applications to the web, this is the sort of next generation capability that becomes available. Shared spreadsheets are a natural vehicle for gathering information - it’s just that we’ve been completing them the same way for more than 20 years.

If you can send an email, you can gather information from an almost unlimited number of people. Want to know what your customers or prospects are thinking? You don’t have to wait around or guess - just ask.


no comment

Leave a Reply

You must be logged in to post a comment.

Top 5 Internet Marketing Tools Internet Marketing Tools & Categories


  • No bookmarks avaliable.
more »