# Optimize restaurant menu margins with Google Drive, Sheets and GPT-4o

> Quick overview This workflow ingests supplier invoice images from Google Drive, uses OpenAI GPT-4o to extract normalized ingredient unit prices into Google Sheets, then runs a weekly margin check by combining ingredient price history, recipe costing, and POS sales to email menu price recommendations via Gmail. How it works 1. Triggers when a new invoice file is created in a specified Google Drive folder. 2. Downloads the invoice image and sends it to OpenAI GPT-4o Vision to extract supplier details, invoice metadata, and per-ingredient unit prices (kg/l/each). 3. Parses the extracted JSON into one row per invoice line and appends the ingredient price records to an Ingredient Prices tab in Google Sheets. 4. Every Monday at 8 AM, reads POS Sales, Recipe Costing, and Ingredient Prices from Google Sheets and calculates current vs 30-day-baseline plate costs and gross margin changes per dish. 5. Flags dishes whose margin drops by at least 2 points, identifies the ingredient driving the incr

- **Domain**: `n8n-workflow-19886.n8n.io`
- **Provider**: n8n.io (https://n8n.io)
- **Kind**: workflow
- **Live-responds (last probe)**: None
- **Signed card**: False
- **Streaming**: False
- **Quality score**: 40%

## URLs
- Agent card: https://n8n.io/workflows/19886
- Page (HTML): https://agenstry.com/agents/n8n-workflow-19886.n8n.io
- Documentation: https://n8n.io/workflows/19886