We're glad you're here. When you get a chance, please introduce yourself on this forum thread.
Do you get exactly the same error message? If so the problem is already solved and there are two options:
- you are using a wrong url (copied from your browser) Error 400 Bad Request "failed_precondition" on Collect to Google sheets - #3 by Grzesiek2010
- you are using a spreadsheet that is not created by Google Sheets Error 400 Bad Request "failed_precondition" on Collect to Google sheets - #5 by Grzesiek2010
or maybe it's something else? Can you confirm it's not caused by any of those two options I mentioned?