n8n Cannabis Order Compliance: GPT-5 Mini, Gmail & Sheets

Instant cannabis order compliance review with GPT-5 Mini, Gmail alerts, and a Google Sheets audit trail

This n8n workflow takes completed dispensary orders through a webhook, uses GPT-5 Mini to classify recall, METRC tag, and quantity-limit compliance, then automatically emails the correct staff member and logs the decision in Google Sheets.

What this workflow does

• Receives orders via webhook: A completed dispensary order is sent as a POST request to an n8n webhook.
• Normalizes the payload: The workflow standardizes incoming data into consistent fields (order ID, dispensary ID, customer type, state, budtender ID, prior daily grams, and line items).
• Reviews compliance with GPT-5 Mini: The order details are sent to OpenAI (GPT-5 Mini), which returns a structured JSON decision: RECALL_FLAG, METRC_TAG_MISMATCH, QUANTITY_LIMIT_BREACH, or CLEAR_TO_FULFILL.
• Creates a review record: It formats the decision into a single review entry including confidence, reasoning, grams remaining after the order, and a concrete corrected action.
• Sends the right email path: The workflow routes exactly one Gmail notification based on category:
  • Budtender for clear orders
  • Manager for quantity-limit breaches
  • Compliance officer for METRC mismatches or recall flags
• Logs to Google Sheets: Appends each compliance decision and metadata to a Google Sheets ledger named “Compliance Review Log”.

Use cases

• Automate compliance checks for every completed dispensary order before fulfillment.
• Detect METRC tag mismatches and route issues to compliance for rapid resolution.
• Enforce daily quantity limits and notify managers when thresholds are exceeded.
• Maintain an auditable record of decisions for operational oversight.

Technical details

• Nodes / integrations: webhook, set, merge, switch, sticky note, Gmail, and OpenAI via GPT-5 Mini.
• Credentials required: OpenAI API credential for GPT-5 Mini, Gmail OAuth2 for notifications, and Google Sheets OAuth2 for the “Compliance Review Log”.