Recipes live in screenshots, bookmarks, a notes app, and one stained index card from a grandmother. When it is time to cook, none of them are where you are looking.
And even when you find the recipe, it is written for four people and you are cooking for six, so you do the math on your phone with wet hands.
The idea: an interactive recipe list in Google Sheets that organizes recipes, scales them, tracks your progress while cooking, and can be shared with the whole household. It is one of the 100 business ideas in Google Sheets on my list, and one of the easiest to sell because everyone eats.
The idea
Build a template that lets users create and organize their recipe lists, making it easier to plan and cook meals. The word that matters is interactive. A list of recipes is a document. A sheet where you can tick off steps, swap ingredients, and change the serving size is a tool.
The interactive part comes from three features Google Sheets already has. Checkboxes let a user track their progress through a recipe while they cook. Dropdown menus let them pick an ingredient substitution without leaving the sheet. Conditional formatting shows what is done, what is next, and what is missing from the pantry.
Serving size is the feature people will thank you for. One input cell for how many people are eating, and every quantity in the ingredient list adjusts. No mental math, no wet phone.
Users can also add notes and comments to recipes. "Less salt next time." "Kids hated the mushrooms." Those notes are the difference between a recipe you found and a recipe you own.
Then there is sharing. A household can share the list, and a group of friends or a family spread across cities can collaborate on a master recipe list. Everyone adds their best three, everyone benefits. That collaborative version is the one that spreads on its own, because the person who receives it wants to add to it.
How to build it in Google Sheets
- Recipes tab. One row per recipe: Name, Cuisine, Meal Type, Prep Time, Cook Time, Base Servings, Tags, Rating, Notes, Source.
- Ingredients tab. One row per ingredient per recipe: Recipe, Ingredient, Quantity, Unit, Optional (checkbox), Substitute.
- Cook Mode tab. A dropdown to pick the recipe, an input cell for servings, the scaled ingredient list, and the steps with a checkbox next to each.
- Substitutions tab. Ingredient, Substitute, Ratio, Notes. This feeds the dropdowns.
- Grocery tab. Check the recipes you plan to cook this week and the ingredients roll up into one list.
Features that earn their place:
- Checkboxes next to every step in Cook Mode, and next to every recipe on the Grocery tab.
- Conditional formatting that strikes through a step when its checkbox is ticked, and highlights the next unchecked step so the cook always knows where they are.
- Data validation dropdowns for the recipe picker, Cuisine, Meal Type, and the substitute for each ingredient, sourced from the Substitutions tab.
-
FILTER to pull one recipe's ingredients into Cook Mode. The scaling formula on each row is then just
=C5*($B$2/$B$1), where B1 is base servings and B2 is the number the user typed. -
XLOOKUP to show the substitution ratio next to whichever swap the user picked:
=XLOOKUP(F5, Substitutions!A:A, Substitutions!C:C, ""). - QUERY on the Grocery tab to sum quantities across the checked recipes, grouped by ingredient, so two recipes that both need onions produce one line.
Test Cook Mode on a phone. That is where it will be used, and a layout that looks fine on a laptop can be unusable over a stove.
Who pays for it, and how to sell it
Home cooks who are organized enough to want this and busy enough not to build it. Meal preppers, who care most about the scaler and the grocery roll-up. Families who want one shared list. And food creators, who will buy it to give their audience as a bonus with their own recipes loaded in.
The individual buyer is paying for convenience and a tidy design, so keep the price low and expect volume. The food creator is paying for a product they can resell or bundle, so charge more for that license and consider pre-loading it with a few of their recipes as a service.
A one-time template is the natural fit. If you build themed recipe packs (weeknight dinners, high protein, one pot), each pack is a new product for the same buyer, and a subscription that adds a pack every month is reasonable.
Gumroad handles the one-time sale. If you go with packs or a subscription, OnlySheets sells access to the live Google Sheet and shares it automatically with each buyer, so new recipes appear in everyone's copy without you sending anything.
First 10 customers: pick one narrow eating style and build the demo around it. Post a short screen recording of Cook Mode scaling a recipe and ticking off steps, in a community for that style of eating. A sheet that does something visibly clever on screen sells better than any description of it.
Related ideas from the list
- Closet Storage Organizer, another shared household sheet built on the same dropdowns and checkboxes.
- Fitness Planner, which sells to the same meal-prepping buyer and pairs naturally with a recipe list.
- Coffee Reviews and Ratings, a food-and-drink sheet that shows how ratings and notes make a list feel personal.
Want the other 99? This is one idea from my list of 100 business ideas you can build in Google Sheets. Get all 100 business ideas as a free Google Sheet.
And if you want to learn how to package and sell spreadsheets, my course Selling Spreadsheets walks through exactly that.
