Overview
Google Spreadsheet forms are an ideal way to collect information from users, like messages, comments or feedback. You don’t need to do any work on your part to store it, no databases, files or anything like that. It relies only on the fact that you have a google account, and can put together a very simple spreadsheet form.
As a very simple example, if you were making a flash site for a client and wanted to put in a contact form that users could add messages to a stored list, then this would be an ideal way to provide a solution that you wouldn’t have to maintain, and that your client would have instant access to in an easy format. They can even output it to excel.
Format
All you need to do is pass in your LoadVars or URLVariables in post format variables like this:
sender[“entry.0.single”] = “my string to add to spreadsheet”;
Where the number between entry and single is an incrementing number denoting the control in the form to mirror. So in this example the entry.0.single represents the name text field control in the google spreadsheet form.
Crossdomain and php proxy
Unfortunately the google spreadsheets crosssdomain.xml does not allow flash content to access the spreadsheets url but by using a fairly simple php proxy we can easily get round this.
So the LoadVars/URLLoader calls the local GoogleSpreadsheetProxy.php passing all the vars and the url for submitting the spreadsheet and simply proxys the request via the url passed.
Spreadsheet document the example feeds into:
http://spreadsheets.google.com/ccc?key=pyxyLmVwUP3PhX7wp6GV_SQ&hl=en
Example:
Source Code Flavours: