Have you created this spreadsheet using Excel or something like that and uploaded to Google Drive? If so it won't work please take a look here: Error 400 Bad Request "failed_precondition" on Collect to Google sheets
It's the same issue. You need to create such a spreadsheet suing Google Sheets.