{"product_id":"n8n-workflow-invoice-ocr-to-google-sheets-margin-pricing","title":"n8n Workflow: Invoice OCR to Google Sheets Margin Pricing","description":"\u003ch3\u003eTurn Supplier Invoices into Margin-Safe Menu Prices (Automatically)\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow watches a Google Drive folder for new supplier invoice images, uses \u003cstrong\u003eOpenAI GPT-4o Vision\u003c\/strong\u003e to extract normalized ingredient unit prices, stores them in \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e, and then runs a weekly margin check to email the owner recommended \u003cstrong\u003emenu price adjustments\u003c\/strong\u003e via \u003cstrong\u003eGmail\u003c\/strong\u003e.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eInvoice ingestion from Google Drive:\u003c\/strong\u003e When a new invoice file is created in a specified Drive folder, the workflow downloads the image.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eInvoice OCR with OpenAI GPT-4o:\u003c\/strong\u003e The image is sent to \u003cstrong\u003eOpenAI GPT-4o\u003c\/strong\u003e (Vision) to extract supplier details, invoice metadata, and per-ingredient unit prices (kg\/l\/each) as structured JSON.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNormalize \u0026amp; record in Google Sheets:\u003c\/strong\u003e The extracted JSON is parsed into one row per invoice line and appended to an \u003cstrong\u003eIngredient Prices\u003c\/strong\u003e tab.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWeekly margin monitoring (Mondays 8 AM):\u003c\/strong\u003e Every week, it reads \u003cstrong\u003ePOS Sales\u003c\/strong\u003e, \u003cstrong\u003eRecipe Costing\u003c\/strong\u003e, and \u003cstrong\u003eIngredient Prices\u003c\/strong\u003e from Google Sheets.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eDetect margin drops \u0026amp; recommend pricing:\u003c\/strong\u003e It calculates current vs a 30-day baseline plate cost and identifies dishes where gross margin drops by \u003cstrong\u003eat least 2 points\u003c\/strong\u003e. It flags the ingredient driving the increase, estimates the last-7-days profit leak, and generates a capped (+10%) rounded price suggestion.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eOwner-ready reporting:\u003c\/strong\u003e Flagged dishes are logged to a \u003cstrong\u003eMargin Alerts\u003c\/strong\u003e tab, and \u003cstrong\u003egpt-4o-mini\u003c\/strong\u003e drafts a short owner-friendly summary.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eEmail the pricing report:\u003c\/strong\u003e The workflow sends the weekly update to the owner using \u003cstrong\u003eGmail\u003c\/strong\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eRestaurants and food operators who want \u003cstrong\u003eautomated invoice OCR\u003c\/strong\u003e and \u003cstrong\u003emargin-based menu price recommendations\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eSaaS operators or automation engineers building a reliable \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e costing + POS reporting pipeline in n8n.\u003c\/li\u003e\n  \u003cli\u003eTeams who need weekly alerts when ingredient costs shift and margins erode.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eTriggers:\u003c\/strong\u003e Google Drive new file created event\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegrations:\u003c\/strong\u003e OpenAI (GPT-4o Vision + gpt-4o-mini), Google Drive, Google Sheets, Gmail\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n nodes used (from workflow):\u003c\/strong\u003e \u003cem\u003ecode\u003c\/em\u003e, \u003cem\u003egmail\u003c\/em\u003e, \u003cem\u003esplit out\u003c\/em\u003e, \u003cem\u003esticky note\u003c\/em\u003e, \u003cem\u003egoogle drive\u003c\/em\u003e, \u003cem\u003egoogle sheets\u003c\/em\u003e\n\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eScheduling:\u003c\/strong\u003e Weekly run every Monday at 8 AM\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46081388970163,"sku":"N8N-19886","price":70.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/FHoPPqvcgFkWO1-kLWoHT_lu9xhZ33.png?v=1790240698","url":"https:\/\/buyflowscripts.com\/products\/n8n-workflow-invoice-ocr-to-google-sheets-margin-pricing","provider":"N8N Commerce","version":"1.0","type":"link"}