Collect Google Spreadsheet Data With a Form
February 28, 2008 by Brett
You can now collect data from people via a form in a Google Docs spreadsheet. Instead of sharing out a spreadsheet and asking people to add their information, you can share a form that you can send via email, link, or an iframe. Data is collected via the form and dumped into the spreadsheet. And it’s in real time, so you can sit there watching your spreadsheet automatically filling up with data.
It’s still pretty basic and missing some much-needed functionality. There should be some data validation (at least a “required” option for a form field), and it would be great to have some embed code to embed this into a web page.
There are more full-featured options for collecting data out there, but Google’s products are always evolving and I’m sure this one will too.
Official Google Docs Blog: Stop sharing spreadsheets, start collecting information
There is embed code. It is just an iframe link back the form though. In order to get it click Embed in the top right hand corner during the “Preview and send” phase of creating the form