Zend GData Google Spreadsheets Error – The Dreaded 400 Error ‘We’re sorry, a server error occurred’!

Finally Found a solution to the following Error Message when inserting a new Row into a worksheet:

Expected response code 200, got 400 We’re sorry, a server error occurred. Please wait a bit and try again.

The Fix: Your column header values must be lower case, they can’t be Capitalized!

so this:

array("Name"=>"YOURNAME",
      "Email"=>"youremail@fakeemail.com");

Must be converted to resemble:

array("name"=>"YOURNAME",
      "email"=>"youremail@fakeemail.com");

I hope this helps. Took me a day of researching to find this fix.

h/t: http://www.ayasoftware.com/content/magento-how-work-google-spreadsheets