Shipped

BurgerBaron Stock & Profit

A recipe-costing and stock back-office for a burger kitchen, picking a recipe and it computes a live bill of materials, margin and food-cost %, while purchases, stock and messy POS sales all reconcile behind the scenes.

Google SheetsApps Scriptn8n

Request a live demo →← Back to work

burgerbaron · recipe & stock

BurgerBaron Calculatorscreenshot pending

The challenge

Nobody knew the real cost of a burger.

Ingredient prices drift, recipes change, and POS product names never match the recipe list. Working out the actual food cost and margin of each item, and keeping stock honest, was guesswork done after closing.

What it does

The moving parts.

Live recipe costingPick a recipe and it builds a bill of materials on the spot, ingredient prices × quantities → food cost, margin, and food-cost % against the selling price.
UI-only, webhook-drivenApps Script only shows dialogs; every data write goes through an n8n webhook, a clean split between interface and logic.
Stock & sauce batchesLog purchases, audit stock, and scale sauce recipes into batches from a single menu.
POS sales → recipe mappingProduct aliases remap messy POS sales names to real recipes, so revenue finally ties back to true cost.

Technical stack

How it's built.

Google Sheets

The front end, modals for every action, recipe views, and the live costing sheet.

Apps Script

UI only: opens the dialogs and proxies every write to n8n, no business logic in the sheet.

n8n

Owns all the writes and calculations behind the webhooks, including ingredients, recipes, stock, aliases, sauce batches.

How it fits together

How the pieces connect.

The sheet is only the face, where every calculation and write happens in n8n behind a webhook. No sensitive details, just the wiring.

Google Sheetsrecipe views · costing · dialogs

the kitchen works in Sheets, picking a recipe, log a purchase, audit stock

Apps ScriptUI only · proxies every write

Apps Script shows the dialogs and forwards every write to an n8n webhook, no business logic in the sheet

n8nowns all writes + calculations

n8n does the real work, food-cost, margin, stock, POS-name mapping, and writes results back to the sheet

Ingredients · Recipeslive costing

Stock · Aliases · Sauce batchesreconciled

Who this fits for

Who it's for.

◆

Independent kitchensBurger joints and frituren that need real food-cost numbers without enterprise software.

▲

Owner-operatorsPeople who price their own menu and want margin they can trust.

●

Spreadsheet-first teamsAnyone who wants to stay in Sheets but with clean, webhook-driven data underneath.

Nobody knew the real cost of a burger.

The moving parts.

How it's built.

How the pieces connect.

Who it's for.

Curious about this build?