Daily AI Restaurant Report: Sales, Waste, Feedback

# Daily AI restaurant report: sales, waste, feedback — delivered via Gmail

This automation collects key restaurant metrics — sales, food waste, and customer feedback — from Google Sheets, analyzes them using AI (Google Gemini), and compiles a plain-text summary automatically sent via Gmail at a scheduled time. Enables data-driven management without manual reporting.

## Who it´s for
- Restaurant owners needing a daily analytical summary
- Café chain managers seeking centralized control
- HoReCa operations directors optimizing costs and service
- Franchise operators scaling quality standards through automation

## What the automation does
- Triggered by a cron schedule
- Pulls sales, waste, and feedback data from separate Google Sheets
- Processes each dataset with a dedicated AI agent powered by Google Gemini
- Identifies patterns, anomalies, and generates actionable recommendations
- Merges insights into a single text-based report
- Sends the summary via Gmail at a predefined time

## What´s included
- Ready-to-use n8n workflow
- Cron-based trigger and processing logic
- Integrations with Google Sheets API, Gmail API, and Google Gemini (PaLM)
- Basic setup and adaptation guide

## Requirements for setup
- n8n account (cloud or self-hosted)
- Access to Google Sheets containing sales, waste, and feedback data
- Google Cloud project with enabled Gemini API access
- Configured OAuth credentials for Google Sheets and Gmail

## Benefits and outcomes
- Saves time on daily reporting and analysis
- Early detection of issues like rising waste or declining ratings
- Receives AI-generated suggestions for menu optimization and staff training
- Identifies external impact factors (e.g., weather affecting dessert sales)
- Centralized oversight for multi-location operations
- Data-backed decision-making instead of intuition

## 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