8d • 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 🙏
5
0 comments
🍕 Restaurant Stock Management System - Looking for Feedback!
powered by
skool.com/ai-first-client-formula-8589
From zero to first $1k/month with AI automation in 30 days. Get the exact formula + templates that landed 100+ their first client.
Suggested communities
Powered by