Weekly AI forecast of sales & ingredients for restauran

This automation helps restaurant owners and HoReCa operations teams forecast dish demand and ingredient requirements for the upcoming week using historical sales data. Powered by Google Gemini AI, the system runs weekly, logs predictions into Google Sheets, and emails summaries—enabling smarter procurement and reduced food waste.

## Who it´s for
- Restaurant owners looking to automate inventory planning
- Cafe chain managers aiming to reduce food waste
- HoReCa operations directors who rely on data-driven decisions

## What the automation does
- Triggers weekly via cron schedule
- Pulls historical sales and ingredient usage data from Google Sheets
- Sends data to a Google Gemini-powered AI agent for forecasting
- Parses AI output into structured JSON format
- Logs forecast results back into the same Google Sheet
- Emails a summary report to stakeholders via Gmail

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

## Requirements for setup
- n8n instance (self-hosted or cloud)
- Google Sheet with historical sales and ingredient usage data
- Active Google Gemini API key
- Google account with enabled Sheets and Gmail APIs

## Benefits and outcomes
- Reduces over-ordering and stockouts
- Lowers food waste through accurate forecasting
- Saves managers hours previously spent on manual reporting
- Maintains an auditable history of forecasts in Google Sheets
- Improves procurement planning with AI insights
- Delivers forecasts reliably every week without delays

## 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 Telegram: @gleb923.