I spent a fair amount of time building things like this until I discovered Airtable and gained many, many valuable hours of my life back.

Airtable is basically Google Sheets with with all of the things a smart developer would say “why can’t they just add” and it has the most well documented API that I’ve ever seen and it’s free or close to free for small scale applications like this.