{"product_id":"automate-menu-food-cost-tracking-in-n8n-google-sheets-gmail","title":"Automate Menu Food Cost Tracking in n8n + Google Sheets + Gmail","description":"\u003ch3\u003eStop food cost creep—automatically update recipe costs and alert you the moment targets are exceeded\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow keeps your menu pricing honest by ingesting supplier price updates, recomputing every recipe’s food cost from the latest ingredient prices, and emailing you immediately when any menu item passes its target food cost.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cb\u003eReceives supplier price updates\u003c\/b\u003e via the \u003ci\u003eWhen Price Update Received\u003c\/i\u003e \u003ca href=\"https:\/\/n8n.partnerlinks.io\/creator-khmuhtadin\"\u003en8n webhook\u003c\/a\u003e (POST path \u003cb\u003emenu-cost-intake-0926\u003c\/b\u003e), normalizing fields like ingredient, unit_price, unit, supplier, submitted_by, and owner_email. It stamps an \u003cb\u003eupdate_id\u003c\/b\u003e and a received timestamp.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eValidates incoming data\u003c\/b\u003e: if \u003cb\u003eingredient\u003c\/b\u003e or \u003cb\u003eunit_price\u003c\/b\u003e is missing, the update is rejected and a \u003cb\u003erejection email\u003c\/b\u003e is sent listing the required fields and the received payload.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eLogs prices to Google Sheets\u003c\/b\u003e: valid updates are appended to the \u003cb\u003ePrices\u003c\/b\u003e tab in your Google Sheets tracker.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eRecomputes recipe and menu item costs\u003c\/b\u003e using the latest ingredient prices.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eFlags overshoots daily at 06:00\u003c\/b\u003e: a sweep at \u003cb\u003e06:00\u003c\/b\u003e checks menu item food cost against its target, logs results to \u003cb\u003eCostAlerts\u003c\/b\u003e, and emails an alert listing each flagged recipe with its \u003cb\u003eportion cost\u003c\/b\u003e and \u003cb\u003epercentage\u003c\/b\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eSends a weekly digest\u003c\/b\u003e every Monday at \u003cb\u003e07:00\u003c\/b\u003e: \u003cb\u003egpt-6-luna\u003c\/b\u003e reads the week’s cost stats and writes a plain-text digest highlighting the worst items and the menu prices needed to bring them back in line.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eYour supplier raises chicken prices—immediately update ingredient pricing and detect which menu items now exceed target food cost.\u003c\/li\u003e\n  \u003cli\u003eAutomate food cost monitoring for multiple ownership emails using the workflow’s owner_email normalization and alerting.\u003c\/li\u003e\n  \u003cli\u003eGet fewer surprises at month-end by turning cost creep into same-day email alerts and weekly summaries.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cb\u003eIntegrations \/ nodes:\u003c\/b\u003e n8n \u003ci\u003ewebhook\u003c\/i\u003e, \u003ci\u003eif\u003c\/i\u003e, \u003ci\u003eset\u003c\/i\u003e, \u003ci\u003ecode\u003c\/i\u003e, \u003ci\u003egmail\u003c\/i\u003e, \u003ci\u003esticky note\u003c\/i\u003e\n\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eData store:\u003c\/b\u003e Google Sheets (writes to \u003cb\u003ePrices\u003c\/b\u003e and \u003cb\u003eCostAlerts\u003c\/b\u003e tabs)\u003c\/li\u003e\n  \u003cli\u003e\n\u003cb\u003eNotifications:\u003c\/b\u003e Gmail emails for rejection cases, daily alerts, and weekly digests\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003cp\u003e\u003cb\u003eLast updated:\u003c\/b\u003e October 2026.\u003c\/p\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46192879501491,"sku":"N8N-20442","price":16.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/e_uyNAlkgCn_zpp-Xu80u_08kAa1sy.png?v=1791538250","url":"https:\/\/buyflowscripts.com\/products\/automate-menu-food-cost-tracking-in-n8n-google-sheets-gmail","provider":"N8N Commerce","version":"1.0","type":"link"}