Automated Food Waste Prediction for Restaurants

This n8n workflow automates the daily process of predicting food waste in a restaurant setting by analyzing historical sales data, forecasting future demand with AI, and optimizing raw material procurement. Starting with a scheduled trigger each night, it extracts sales and inventory data from Google Sheets, processes and formats this data for AI analysis, and uses a language model-powered AI to forecast next-day dish sales, raw material use, and waste reduction. The predictions are then structured into a clear report stored back into Google Sheets and summarized in a professional email sent to management. This automation helps restaurants minimize food waste, improve inventory management, and reduce costs by making data-driven procurement decisions.