n8n Workflow: Route Brewery Orders via Webhook, Sheets & Gmail

Route Brewery Orders Automatically—Webhook In, Smart Compliance Out

This n8n workflow receives brewery retailer orders via Webhook, checks territory and allocation rules in Google Sheets, uses OpenAI to apply three-tier compliance logic, then sends the right email via Gmail and logs every decision for audit-ready tracking.

What this workflow does

• Receives retailer orders as a POST request to a webhook endpoint.
• Normalizes order fields into consistent data points, including retailer, state, license type, SKU category, quantity, and delivery date.
• Looks up territory & allocation in a Google Sheets tab named “Territory & Allocation Map” using retailerId to find:
  • assigned territory state
  • SKU license restriction rule
  • limited-release cap remaining
• Evaluates a structured compliance decision with an OpenAI chat model, applying rules for:
  • territory exclusivity
  • license-type eligibility
  • limited-release allocation caps
  The result includes category, confidence, reasoning, and an approved quantity.
• Routes outcomes by decision and sends a Gmail notification:
  • to sales ops for approval/allocation-cap issues
  • to compliance for territory conflicts and license ineligibility
• Appends a full decision record to Google Sheets “Distribution Order Log” for audit history.

Use cases

• Automatically triage incoming retailer orders that must respect territory exclusivity and SKU license restrictions.
• Handle limited-release SKUs by validating against caps remaining before approvals are sent to sales ops.
• Create an audit trail of every compliance decision in a central Google Sheets log.

Technical details

• n8n nodes: webhook, set, merge, switch, sticky note, gmail
• Integrations: Google Sheets (Territory & Allocation Map lookup + Distribution Order Log append), Gmail notifications
• AI logic: OpenAI chat model to produce a structured decision for compliance routing