AI Sales & Ingredient Forecast for Restaurants

# Weekly AI sales and ingredient demand forecast for restaurants from Google Sheets

This automation template solves the challenge of accurate procurement planning and food waste reduction in restaurants by leveraging AI analysis of historical sales and ingredient usage data. The system runs autonomously every week, generating structured forecasts and notifying stakeholders.

## Who it´s for
- Restaurant owners aiming to optimize ingredient procurement
- Restaurant managers responsible for weekly planning
- Operations directors of restaurant chains using Google Sheets for tracking
- Business analysts in the HoReCa sector implementing AI forecasting

## What the automation does
- Triggered on a weekly schedule (cron)
- Pulls historical sales and ingredient usage data from Google Sheets
- Sends data to a Google Gemini-powered AI agent via LangChain for analysis and forecasting
- Parses the AI response into structured JSON with demand predictions
- Logs forecast results back into the same Google Sheet
- Emails a summary report to managers and stakeholders

## What´s included
- Ready-to-use n8n workflow
- Pre-configured trigger and handler logic
- Integrations with Google Sheets API, Gmail API, and Google Gemini via LangChain
- Basic text instructions for setup and adaptation

## Requirements for setup
- n8n account with workflow editing access
- Google Sheets file containing historical sales and ingredient usage data
- Active Google account with Google Gemini API access enabled
- Configured OAuth or API keys for Google Sheets and Gmail

## Benefits and outcomes
- 15–20% reduction in food waste through accurate demand prediction
- Lower risk of over-ordering perishable ingredients
- Time savings for managers — automated purchase planning
- Centralized forecast management across multiple locations
- Ability to analyze seasonal trends and adjust business strategy
- Improved staffing and logistics planning

## Important: template only
Important: you are purchasing a ready-made automation workflow template only. Rollout into your infrastructure, connecting specific accounts and services, 1:1 setup help, custom adjustments for non-standard stacks and any consulting support are provided as a separate paid service at an individual rate. To discuss custom work or 1:1 help, contact via chat