Google as having a bunch of great APIs that let you do all sorts of fantastic things, but stuff that would have been absolutely trivial to do in MS Office 15 or 20 years ago using VBA (minus the web part, which was barely around) were hard to impossible to make happen.
Want that input form to look nice? Want the submitter to be able to preview it or edit what was on it later? Good luck doing that without building a whole different front-end. Google docs lets you use a form to add lines to a spreadsheet, but that's pretty much where the magic ends. I hacked in editing the thing by sending out links that pre-populate fields in a second spreadsheet which Google docs copies over to the first spreadsheet. Yes, it's stupid. No, it's not me. It's Google.
If you're a developer on Google docs and reading this... thanks for making it possible to add a line to a spreadsheet from an ugly form. I am so sorry that they make you do these crappy "20%" effort projects that you're not really proud of and that aren't good enough to help anyone. I know you probably want to put in the time to make a great HTML5 form builder or make it easy to manage an entry using a unique key or validate input in some way, but it's so difficult to focus on those Friday afternoons. So, don't worry about it. Those charities didn't need that technology anyway. Right?