Restaurant & Food Business

Restaurant Sales & Inventory Forecaster

Stop guessing on Monday morning orders. Every Sunday night, AI analyses your 8-week sales history, forecasts exactly what you need next week, and emails a prioritised purchasing report with stockout risk ratings.

Restaurants waste 4–10% of food cost over-ordering
Cuts weekly ordering prep from 2 hours to 5 minutes
$69 one-time
Get Instant Access

Secure checkout via Gumroad • Instant download

Restaurant Sales Forecaster workflow preview
The Problem

Weekly ordering is still guesswork for most restaurants

Without a data-driven forecast, you either over-order and throw food away, or under-order and disappoint customers. Both cost money.

Over-ordering wastes cash

Ordering too much because you "played it safe" drains margins. Industry average food waste is 4–10% of cost of goods.

Unexpected stockouts

Running out of a key ingredient mid-service forces 86s and damages your reputation with regular guests.

Hours spent on ordering prep

Reviewing last week's numbers, checking stock, estimating quantities — it takes hours of your most productive morning time.

What You Get

AI-powered forecasts, delivered before Monday orders

An n8n + Make.com workflow that turns your Google Sheets sales history into actionable weekly purchasing recommendations.

8-Week Trend Analysis

The workflow reads your last 56 days of sales, calculates per-item weekly averages, and identifies whether demand is rising, stable, or declining.

Per-Item Order Recommendations

Each item gets a recommended purchase quantity with a safety buffer automatically applied to high-volatility items — no manual calculation needed.

Stockout Risk Rating

Every item is rated HIGH, MEDIUM, or LOW stockout risk. High-risk items are highlighted at the top of the report so you prioritise the right orders first.

Sunday Night Email Report

The HTML report lands in your inbox every Sunday at 8pm — formatted and ready to use as your Monday morning order sheet.

Forecast History Log

Every forecast is logged to a Google Sheets history tab so you can track how your inventory risk profile changes over time.

Fully Customisable

Track any items you choose. Add or remove ingredients from your Google Sheet at any time — the next forecast automatically reflects your current inventory list.

What's Included

Everything you need to start forecasting this Sunday

n8n Workflow JSONImport in one click. Schedule trigger, Google Sheets, OpenAI, and Gmail all pre-wired.
Make.com BlueprintIdentical functionality in Make.com scenario format.
PDF Setup GuideStep-by-step setup in plain English. No coding needed.
Google Sheets Template StructureExact column headers and tab layout documented in the guide.
Commercial LicenceUse for any restaurant or food business you own or operate.
How It Works

Automated from data to inbox every Sunday

1

Sales data lives in Google Sheets

Log daily sales per item as you normally would. Any format works — the guide shows you the exact column structure.

2

Workflow runs every Sunday 8pm

Schedule trigger fires automatically. No manual action needed from you.

3

AI analyses 8 weeks of history

OpenAI forecasts next-week quantities per item, flags risks, and writes a plain-English summary.

4

Report lands in your inbox

Formatted HTML email with risk ratings and order quantities — ready to act on Monday morning.

FAQ

Common questions

How does the AI know what to forecast?

The workflow calculates average weekly demand per item from your last 8 weeks of sales data, then sends that to OpenAI GPT-4o-mini. The AI factors in demand trends, applies safety buffers to volatile items, and outputs recommended purchase quantities with stockout risk ratings.

Does this work for any type of food business?

Yes — restaurants, cafes, bars, food trucks, catering companies, and bakeries. You define the items you track in Google Sheets, so it adapts to any inventory list.

How much historical data do I need to start?

A minimum of 4 weeks of data produces a basic forecast. Accuracy improves significantly with 6–8 weeks. The workflow automatically uses the most recent 56 days.

When does the report arrive?

By default every Sunday at 8pm. You can change the schedule to any day and time by editing the cron expression in the Schedule Trigger node — no coding required.

What does HIGH stockout risk mean?

The AI flags items as HIGH risk when demand is trending upward or highly variable week-to-week. For these items, the recommended order quantity includes a larger safety buffer automatically.

How much does it cost to run each week?

Each Sunday run uses approximately 2,000–4,000 OpenAI tokens — around $0.02–$0.05 per forecast. A $10 OpenAI credit covers 6+ months of weekly runs.

Know exactly what to order every Monday morning.

One-time purchase. Instant download. First forecast this Sunday.

Get Restaurant Forecaster — $69