Hey everyone! I’m curious about what interesting stuff people have built in Google Sheets beyond the usual spreadsheet work.
I’ve created some practical things like expense tracking and car maintenance logs, but I also tried making some entertaining projects:
A complete baseball scorecard with player statistics
Fantasy football league manager
Two-player Battleship with working grid system
Multiplayer UNO card game simulation
Currently developing another multiplayer game concept
Most of these rely mainly on formulas with minimal scripting, though my newest project might require more advanced Google Apps Script features.
What creative or unusual things have you built in Sheets? I keep seeing amazing projects in this community and would love to discover more innovative ideas. Please share your coolest creations!
My favorite project was building a complete inventory system for my small business. It tracks stock levels, calculates reorder points automatically, and generates purchase orders when items run low. The coolest part is the barcode scanning through a mobile app that updates everything in real-time. I also built a shift scheduling system that handles employee availability, overtime calculations, and labor cost projections. It manages vacation requests and automatically spots coverage gaps. The trickiest part was the conflict resolution logic using nested IF statements and array formulas. Just finished a tournament bracket generator that does single and double elimination with automatic seeding based on player rankings. The conditional formatting creates a visual bracket that updates as you enter results, plus it calculates win percentages and performance trends throughout the tournament.
I built a home workout tracker that auto-adjusts difficulty based on how you’re performing. It calculates progressive overload recommendations and tracks recovery time between sessions. The coolest part? Conditional formatting that changes cell colors based on your workout intensity zones. Another project I’m really proud of - a budget forecasting tool that pulls data straight from bank statements using ImportXML functions. It auto-categorizes expenses and predicts monthly spending with weighted moving averages. The best part is when it sends automated alerts through Apps Script if you go over your spending limits. Right now I’m working on a recipe scaling calculator that adjusts ingredient amounts based on what’s in your pantry and how many people you’re feeding. Way more complex than expected once you factor in cooking time changes and equipment constraints.
i made a habit tracker that turns daily tasks into a game - you get xp for completing stuff and streak bonuses. also created a meal planner that auto-generates shopping lists from the recipes i choose. pretty neat!