It's probably the same issue Error 400 Bad Request "failed_precondition" on Collect to Google sheets - #5 by Grzesiek2010 and the same solution would solve it.
Here is the answer Error 400 Bad Request "failed_precondition" on Collect to Google sheets - #5 by Grzesiek2010
and one post below.