{"product_id":"n8n-cannabis-order-compliance-gpt-5-mini-gmail-sheets","title":"n8n Cannabis Order Compliance: GPT-5 Mini, Gmail \u0026 Sheets","description":"\u003ch3\u003eInstant cannabis order compliance review with GPT-5 Mini, Gmail alerts, and a Google Sheets audit trail\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow takes completed dispensary orders through a webhook, uses \u003cstrong\u003eGPT-5 Mini\u003c\/strong\u003e to classify recall, \u003cstrong\u003eMETRC tag\u003c\/strong\u003e, and \u003cstrong\u003equantity-limit\u003c\/strong\u003e compliance, then automatically emails the correct staff member and logs the decision in \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReceives orders via webhook:\u003c\/strong\u003e A completed dispensary order is sent as a \u003cstrong\u003ePOST request\u003c\/strong\u003e to an \u003cstrong\u003en8n webhook\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNormalizes the payload:\u003c\/strong\u003e The workflow standardizes incoming data into consistent fields (order ID, dispensary ID, customer type, state, budtender ID, prior daily grams, and line items).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReviews compliance with GPT-5 Mini:\u003c\/strong\u003e The order details are sent to \u003cstrong\u003eOpenAI (GPT-5 Mini)\u003c\/strong\u003e, which returns a structured JSON decision: \u003cem\u003eRECALL_FLAG\u003c\/em\u003e, \u003cem\u003eMETRC_TAG_MISMATCH\u003c\/em\u003e, \u003cem\u003eQUANTITY_LIMIT_BREACH\u003c\/em\u003e, or \u003cem\u003eCLEAR_TO_FULFILL\u003c\/em\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCreates a review record:\u003c\/strong\u003e It formats the decision into a single review entry including confidence, reasoning, grams remaining after the order, and a concrete corrected action.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSends the right email path:\u003c\/strong\u003e The workflow routes \u003cstrong\u003eexactly one\u003c\/strong\u003e Gmail notification based on category:\n    \u003cul\u003e\n      \u003cli\u003e\n\u003cstrong\u003eBudtender\u003c\/strong\u003e for clear orders\u003c\/li\u003e\n      \u003cli\u003e\n\u003cstrong\u003eManager\u003c\/strong\u003e for quantity-limit breaches\u003c\/li\u003e\n      \u003cli\u003e\n\u003cstrong\u003eCompliance officer\u003c\/strong\u003e for METRC mismatches or recall flags\u003c\/li\u003e\n    \u003c\/ul\u003e\n  \u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLogs to Google Sheets:\u003c\/strong\u003e Appends each compliance decision and metadata to a Google Sheets ledger named \u003cstrong\u003e“Compliance Review Log”\u003c\/strong\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eAutomate compliance checks for every completed dispensary order before fulfillment.\u003c\/li\u003e\n  \u003cli\u003eDetect METRC tag mismatches and route issues to compliance for rapid resolution.\u003c\/li\u003e\n  \u003cli\u003eEnforce daily quantity limits and notify managers when thresholds are exceeded.\u003c\/li\u003e\n  \u003cli\u003eMaintain an auditable record of decisions for operational oversight.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNodes \/ integrations:\u003c\/strong\u003e webhook, set, merge, switch, sticky note, Gmail, and OpenAI via \u003cstrong\u003eGPT-5 Mini\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCredentials required:\u003c\/strong\u003e OpenAI API credential for GPT-5 Mini, Gmail OAuth2 for notifications, and Google Sheets OAuth2 for the “Compliance Review Log”.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45938193432755,"sku":"N8N-19038","price":28.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/KLnvd5QtLLrkaHe8oFIim_S8iswm0N.png?v=1788340110","url":"https:\/\/buyflowscripts.com\/products\/n8n-cannabis-order-compliance-gpt-5-mini-gmail-sheets","provider":"N8N Commerce","version":"1.0","type":"link"}