Route craft brewery orders with OpenAI, Google Sheets, and Gmail

by Swapnil Mandloi ✓ · 2 views · created 2026-09-02 · CRM, AI Summarization

What this workflow does

This AI workflow has 14 nodes and runs when an HTTP GET request hits its webhook URL. Along the way it connects Google Sheets, OpenAI Chat Model and Gmail.

How it runs

Trigger: When an HTTP GET request hits its webhook URL.

1. Normalize Order Intake (Edit Fields (Set)): sets or maps fields
2. Look Up Territory & Allocation Map (Google Sheets): uses Google Sheets
3. Validate Territory & Compliance (AI Agent): runs an AI agent, with model: Territory Compliance Model; output parser: Parse Territory Decision
4. Shape Territory Decision (Edit Fields (Set)): sets or maps fields
5. Route Order Decision (Switch): routes items into branches
6. Send Order Approval Confirmation (Gmail): uses Gmail
7. Flag Territory Conflict to Compliance (Gmail): uses Gmail
8. Flag License Ineligibility to Compliance (Gmail): uses Gmail
9. Flag Allocation Cap Breach to Sales Ops (Gmail): uses Gmail
10. Combine Routing Branches (Merge): merges the data from its input branches

…plus 1 more step. See the full node list below.

Services it uses

Google SheetsOpenAI Chat ModelGmail

Before you upgrade to n8n 3.0

Nodes used (9)

• Webhookn8n-nodes-base.webhook
• Edit Fields (Set)n8n-nodes-base.set
• Google Sheetsn8n-nodes-base.googleSheets
• AI Agent@n8n/n8n-nodes-langchain.agent
• OpenAI Chat Model@n8n/n8n-nodes-langchain.lmChatOpenAi
• Structured Output Parser@n8n/n8n-nodes-langchain.outputParserStructured
• Switchn8n-nodes-base.switch
• Gmailn8n-nodes-base.gmail
• Mergen8n-nodes-base.merge

From the author

Quick overview This workflow receives retailer orders via webhook, looks up territory and allocation data in Google Sheets, uses OpenAI to apply three-tier compliance rules, then emails sales ops or compliance via Gmail and logs the decision back to Google…

View the original on n8n.io → Check your own copy