Templates / ✉️ Automated email sorting & drafting for customer support - with AI 🤖

✉️ Automated email sorting & drafting for customer support - with AI 🤖

Needs changes

by Louis ✓ · 326 views · created 2025-05-21 · Ticket Management, AI RAG

Needs changes. This template uses 1 thing(s) that n8n 3.0 removes: AI Agent v1 (old agent modes). 1 breaking item(s) found. Static check, last run 2026-10-19.

What this workflow does

This AI workflow has 26 nodes and runs on a schedule (every day) (plus 1 other trigger). Along the way it connects Google Gemini Chat Model, Google Sheets and Gmail.

How it runs

Trigger: On a schedule (every day) (plus 1 other trigger).

  1. Read inbox messages (Gmail): uses Gmail
  2. Read messages from FAQ Waiting folder (Gmail): uses Gmail
  3. Loop Over Items (Loop Over Items (Split in Batches)): loops over the items in batches
  4. Loop Over Items (Loop Over Items (Split in Batches)): loops over the items in batches
  5. Html to Markdown (Markdown): converts between Markdown and HTML
  6. Markdown: converts between Markdown and HTML
  7. AI Agent: runs an AI agent, with model: Google Gemini Chat Model; 1 tool (Google Sheets)
  8. AI Agent: runs an AI agent, with model: Google Gemini Chat Model; 1 tool (Q&A table as a resource)
  9. Q&A e-mail ? (If): checks a condition and branches into true / false
  10. Remove from FAQ Waiting (Gmail): uses Gmail

…plus 9 more steps. See the full node list below.

Services it uses

Google Gemini Chat ModelGoogle SheetsGmail

Before you upgrade to n8n 3.0

1 thing in this workflow is removed in n8n 3.0. Fix it before you upgrade:

  • AI Agent v1 (old agent modes) in AI Agent - checks if e mail is FAQ related (v1.9), AI Agent - checks if e-mail is Inbound related (v1.9), AI Agent - draft a reply to FAQ Question (v1.9): replace with Latest AI Agent node (Tools Agent). For SQL Agent, use a Postgres or MySQL tool with a recent AI Agent.

Rather not rewrite it? Many of these flows can be rebuilt in Make (free plan).

Removed in 3.0Replace with
AI Agent v1 (old agent modes)
AI Agent - checks if e mail is FAQ related (v1.9), AI Agent - checks if e-mail is Inbound related (v1.9), AI Agent - draft a reply to FAQ Question (v1.9)
Latest AI Agent node (Tools Agent). For SQL Agent, use a Postgres or MySQL tool with a recent AI Agent.

Nodes used (9)

From the author

🤖 Automated Email Sorting & FAQ Reply Assistant (n8n + Gemini AI) 🔍 Overview This n8n workflow automates email triage and FAQ responses using Google Sheets and Gemini AI. It’s designed to: - Automatically sort incoming emails into categories (e.g., FAQ,…

Excerpt from Louis's description on n8n.io.

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

Get the weekly “what broke” email

New templates, newly broken ones, and n8n release changes. One short email a week.

Form not loading? Subscribe here.