Shipped this project!
I built a badminton tracker hardest part was to use google sheet as backend while convex and workos handle users (as the basic version used google sheet) i then figured it out by giving each user a group id and a user id along with their name and submitting this to google sheet and while pulling from google sheet querying the data using a sql injection type query (querying via the url to get teh data) google map visualization function does this) and get teh matches data for each group back. another one was to add realtime feature so that scores for all devices get instantly updated which i used convex again using last add feature (if that changes we use useeffect hook to fetch the latest match) one more hard part was to figure out inviting and adding user to a particular group and not into a random one.