Draft and send AI customer support email replies with Gmail and Google Sheets
Ready for 3.0What this workflow does
This AI workflow has 11 nodes and runs on Gmail events (plus 1 other trigger). Along the way it connects Gmail, OpenRouter Chat Model and Google Sheets.
How it runs
Trigger: On Gmail events (plus 1 other trigger).
- Filter Unwanted Emails (If): checks a condition and branches into true / false
- Get Approved Replies (Google Sheets): uses Google Sheets
- Draft AI Reply (Basic LLM Chain): sends a prompt to an LLM, with model: OpenRouter Model
- Is Approved to Send? (If): checks a condition and branches into true / false
- Mark Email as Read (Gmail): mark as read
- Send Reply to Customer (Gmail): uses Gmail
- Log to Google Sheets (Google Sheets): append
- Update Status to Replied (Google Sheets): append or update
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.
- Still check Gmail Trigger below v1.4 runs as v1.4 (drafts skipped, max emails per poll) (Receive Customer Emails).
Nodes used (7)
- Gmail Trigger
n8n-nodes-base.gmailTrigger - If
n8n-nodes-base.if - Basic LLM Chain
@n8n/n8n-nodes-langchain.chainLlm - OpenRouter Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenRouter - Gmail
n8n-nodes-base.gmail - Google Sheets
n8n-nodes-base.googleSheets - Schedule Trigger
n8n-nodes-base.scheduleTrigger
From the author
How it works 1. Gmail is monitored every minute for new incoming emails 2. Automated and irrelevant emails are filtered out (newsletters, noreply senders, out-of-office replies, bounce notifications) 3. AI reads the email and drafts a reply based on your…