Jan 11 • General Discussion 💬
🍕 Restaurant Stock Management System - Looking for Feedback!
Hey! I've built an automated stock management workflow for a restaurant and would love your feedback and ideas for improvement.
What It Does
📦 Stock Addition (4x Daily)
- Scheduled trigger at 7:00, 10:30, 15:30, 20:30
- Staff selects product type (Burger/Pizza) via form
- Adds quantities directly to Google Sheets stock
- Sends Telegram confirmation to stock manager
📧 Automated Reports (3x Daily)
- Runs at 10:00, 15:00, 20:00
- Calculates ingredients needed for 100 burgers + 100 pizzas
- Compares requirements with current stock
- Identifies shortages for each ingredient
- Sends formatted HTML email with all details
- Auto-labels emails as IMPORTANT in Gmail
Current Features
âś… Real-time stock updates via forms âś… Fuzzy matching for ingredient names (handles typos) âś… Dual product support (Burgers & Pizzas) âś… Recipe-based calculations from Google Sheets âś… Automated shortage detection âś… Professional email reports with timestamps
Tech Stack
- Trigger: Schedule + Form
- Storage: Google Sheets (Big Stock, Recipes, Small Stock)
- Notifications: Telegram + Gmail
- Processing: JavaScript for calculations & fuzzy matching
Questions
- Has anyone built something similar?
- Are there better ways to structure the Google Sheets data?
- Any n8n nodes I'm missing that could simplify this?
Drop your thoughts, suggestions, or questions below! All feedback welcome 🙏
12
11 comments
🍕 Restaurant Stock Management System - Looking for Feedback!
skool.com/ai-automation-society
Learn to get paid for AI solutions, regardless of your background.
Leaderboard (30-day)
1
🔥
+7213
2
🔥
+5001
3
+3344
4
🔥
+3293
5
+1307
Powered by