Google sheets data source stopped working

I connected my google sheet file as a data source and it worked for a while, I kept making changes to that file but I faced no problems
today when I tried to sync the table after I had added tow new columns it gave me the error: GraphQL error: DataSource validation failed: collections.1.fields.6.type: TEXT is not a valid enum value for path type.
so I deleted the columns that I added and tried to sync it again but it gave me the same error, I made a copy of the file and tried to connect it but it didn’t load, it gave me no error, just nothing showed up

side note: I did make some apps script functions for that file and used them in it but I did that before and the data source was working just fine, so I doubt that could be the issue

so how do I fix this?