Unknown error occurred creating collections


I am unable to create a collection connecting to 3rd party APIs. My data is stored in a google sheet file.
As you can see at the screenshot the data is retrieved but once I press “Create collection” I get the pop up “An unknown error occurred”. Any help will be appreciated.

Solved the problem using sheetdb.io instead of sheety to create the API