Pricing and supply sync that watches farmer availability submissions, validates unit price, compares it to last week’s price, and routes limited supply or price-spike items into kitchen alerts with Trello cards and emails, while logging all ingredients into a master inventory sheet.
Make · workflow canvasproduction build
Context
Farm‑to‑table kitchens needed a way to react quickly to changing ingredient availability and prices without manually checking spreadsheets, recalculating variance, or chasing staff with informal messages.
Approach
Built a single Make.com scenario that watches farmer availability forms, validates unit price, looks up last week’s price, computes variance and contribution margin, and routes each submission into LIMITED SUPPLY, PRICE SPIKE, or STANDARD paths, each with its own Trello labeling, alerts, and inventory logging, plus error handling for missing prices.
Architecture
Watch Farmer Availability Submission
Validation Route
Handle Form Error
Log Error - Missing Unit Price
Valid
Lookup Last Week’s Price
Set Current Price
Set Lastweek Price
Calculate Variance Percentage
Calculate Contribution Margin
Supply Router
LIMITED SUPPLY: Create Kitchen Alert Card + Red Label + Email Manager & Chef
PRICE SPIKE
Apply Yellow Label + Send Price Spike Alert
STANDARD
Log Ingredient Submission to Master Inventory + Update Price History Reference
Results
~3 hrs/weekPrice-check admin time saved
Minutes, down from next-day reviewPrice spike alert time
