{"product_id":"n8n-workflow-track-menu-cost-ratios-from-delivery-notes","title":"n8n Workflow: Track Menu Cost Ratios from Delivery Notes","description":"\u003ch3\u003eAutomatically track menu cost ratios from delivery note photos—so you spot loss weeks earlier\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow monitors delivery notes, extracts supplier pricing with Google Gemini, keeps your Google Sheets ingredient prices up to date, and calculates each menu item’s current cost ratio against its target. If any dishes run over target, it generates \u003cb\u003eexactly three practical actions per dish\u003c\/b\u003e and emails them to you—no guesswork.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cb\u003eTriggers daily at 8:00\u003c\/b\u003e or when a \u003cb\u003enew delivery-note photo\u003c\/b\u003e is created in a specified \u003cb\u003eGoogle Drive\u003c\/b\u003e folder.\u003c\/li\u003e\n  \u003cli\u003eWhen a new photo is detected, it \u003cb\u003edownloads the image\u003c\/b\u003e and uses \u003cb\u003eGoogle Gemini\u003c\/b\u003e to extract supplier, date, totals, and line items as \u003cb\u003estructured JSON\u003c\/b\u003e.\u003c\/li\u003e\n  \u003cli\u003eIt converts invoice quantities into \u003cb\u003ebase units\u003c\/b\u003e (per gram\/ml\/piece), then \u003cb\u003everifies line items\u003c\/b\u003e against the printed subtotal\/total. If totals don’t match, it either updates automatically or \u003cb\u003eemails you to manually check the photo\u003c\/b\u003e.\u003c\/li\u003e\n  \u003cli\u003eOn the daily run, it reads your \u003cb\u003eIngredients\u003c\/b\u003e, \u003cb\u003eRecipes\u003c\/b\u003e, and \u003cb\u003eMenu\u003c\/b\u003e tabs in \u003cb\u003eGoogle Sheets\u003c\/b\u003e, calculates each dish’s \u003cb\u003etheoretical cost\u003c\/b\u003e, \u003cb\u003ecurrent cost ratio\u003c\/b\u003e, and \u003cb\u003estatus vs target\u003c\/b\u003e, and writes the latest values back to the \u003cb\u003eMenu\u003c\/b\u003e tab.\u003c\/li\u003e\n  \u003cli\u003eIf any dishes are over target, it sends the over-target facts to \u003cb\u003eGoogle Gemini\u003c\/b\u003e, generates \u003cb\u003ethree concise actions per dish\u003c\/b\u003e, and emails the results via \u003cb\u003eGmail\u003c\/b\u003e. If nothing is over target, it sends no email.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eRestaurants and meal services tracking margin drift as ingredient prices creep up.\u003c\/li\u003e\n  \u003cli\u003eSaaS operators or ops teams validating menu costing and cost ratio targets without manual spreadsheet updates.\u003c\/li\u003e\n  \u003cli\u003eAutomation engineers building a reliable invoice\/photo-to-costing pipeline with Google Sheets reporting.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003en8n logic uses: \u003cb\u003eif\u003c\/b\u003e, \u003cb\u003eset\u003c\/b\u003e, \u003cb\u003ecode\u003c\/b\u003e, \u003cb\u003eswitch\u003c\/b\u003e, and \u003cb\u003eno op\u003c\/b\u003e, plus \u003cb\u003eGmail\u003c\/b\u003e for notifications.\u003c\/li\u003e\n  \u003cli\u003eIntegrations: \u003cb\u003eGoogle Drive\u003c\/b\u003e (delivery-note photos), \u003cb\u003eGoogle Gemini\u003c\/b\u003e (extraction + actions), and \u003cb\u003eGoogle Sheets\u003c\/b\u003e (Ingredients\/Recipes\/Menu tabs, including target_cost_rati… fields).\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45962012328115,"sku":"N8N-19226","price":16.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/MiAAuT0AH5XnsjNExdcJs_tZ4qPap6.png?v=1788599135","url":"https:\/\/buyflowscripts.com\/products\/n8n-workflow-track-menu-cost-ratios-from-delivery-notes","provider":"N8N Commerce","version":"1.0","type":"link"}