I use Google Sheets as well to track stuff like finances, calories, workout stats. And I too have wondered about a nicer way of inputting data.

Have you looked into Google Forms? I really wish it supported custom types like list of items from named ranges. A custom UI app (in Haskell/reflex!) is what I may end up writing too.