Created a pretty cool Home Bar Helper for my personal use!
I built a home-bar helper to track my wine, liquor, and cigars (I’m not a big cigar smoker, but people give them to me occasionally, so I might as well know what I have). I created a Google Sheet and trained AskSpot on it. I used SpreadSimple to create the directory and embedded it into a webpage where I have an AskSpot chatbot. I still have a lot of bottles to catalog, but for each entry, I snap a photo of the front and back (sometimes the side depending on where the labels are) of the bottle and put them into ChatGPT to get all the information (sometime the info isn't 100% so the more info you can add with the images the better). It formats the details into a row I can paste into my Google Sheet. I then add the URLs for the front and back images to the sheet, and that’s it. It isn’t perfect, but it’s already extremely helpful. I was at a football watch party this weekend and casually showed the host—he was blown away! He asked if I would sell something like this to a bar and grill, saying he knows a couple of bar managers who need it and wants to set up some meetings soon. I played it cool, said I’d consider it, and that I’m open to showing the bar managers. Lol. Check it out. https://homebar.dznblz.site Let me know if there is any ideas on how to make it better or if you are curious about how I did anything.