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:


Must be converted to resemble:


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