Triage support emails and draft AI replies with Gmail, Airtable and OpenRouter
Ready for 3.0What this workflow does
This AI workflow has 29 nodes and runs on Gmail events (plus 1 other trigger). Along the way it connects Gmail, Airtable, OpenRouter Chat Model and OpenAI Chat Model.
How it runs
Trigger: On Gmail events (plus 1 other trigger).
- Set Field Parameters (Edit Fields (Set)): sets 11 fields: systemPrompt, categories, fallbackCategory…
- Started by Gmail? (If): checks a condition and branches into true / false
- Parse Email Fields (Code): runs custom JavaScript code
- Locate Stuck Airtable Rows (Airtable): search
- Process Email Batches (Loop Over Items (Split in Batches)): loops over the items in batches
- Annotate Stuck Row as Error (Airtable): update
- Evaluate Email Relevance (If): checks a condition and branches into true / false
- Notify About Stuck Row Error (Gmail): uses Gmail
- Search Email Record in Airtable (Airtable): search
- Check for New Email (If): checks a condition and branches into true / false
…plus 11 more steps. See the full node list below.
Services it uses
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (13)
- Gmail Trigger
n8n-nodes-base.gmailTrigger - Edit Fields (Set)
n8n-nodes-base.set - Code
n8n-nodes-base.code - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - No Operation, do nothing
n8n-nodes-base.noOp - Airtable
n8n-nodes-base.airtable - If
n8n-nodes-base.if - Basic LLM Chain
@n8n/n8n-nodes-langchain.chainLlm - OpenRouter Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenRouter - Structured Output Parser
@n8n/n8n-nodes-langchain.outputParserStructured - Gmail
n8n-nodes-base.gmail - OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi - Schedule Trigger
n8n-nodes-base.scheduleTrigger
From the author
Quick overview This workflow monitors a Gmail inbox, logs new support emails to Airtable, and uses OpenRouter (with an OpenAI fallback) to categorize, summarize, and draft replies as Gmail drafts, while alerting your team via Gmail when human review is needed…