i'm aware of a number of toolkits like sheety, sheets2api... that can create API endpoints very conveniently from spreadsheet, but is there any alternatives which are open source and can be self-hosted?
Have you tried searching on GitHub? A quick search lead me to Stein which looks like it could work for you.