FM
FlowMarket
AI Agents Advanced ⚑ 31 n8n Nodes

Automated email sorting drafting for customer support wit

πŸ€– Automated Email Sorting & FAQ Reply Assistant (n8n + Gemini AI) πŸ” Overview This n8n workflow automates email triage and FAQ responses using Google Sheets...

πŸ”Œ Nodes & Integrations Used (5)

Lm Chat Google Gemini Google Sheets Tool Markdown Gmail Agent

πŸ“– Implementation & Setup Guide

πŸ€– 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, Billing, Tech Support).
  • **Draft polite, relevant replies** for FAQ emails using **AI**, grounded in your pre-approved content.
  • Maintain a **human-in-the-loop** process by saving responses as Gmail drafts for manual review.

Perfect for startups or teams seeking to reduce support workload while ensuring consistent, helpful responses.

---

βš™οΈ Pre-conditions / Requirements

Before using this workflow, make sure you have:

  • βœ… A **Google account** with access to:
  • - Gmail (with custom labels like `FAQ-Waiting`, `FAQ-Draft`)
  • - Google Sheets (used as your FAQ source)
  • βœ… A **Gemini API key** (to generate AI replies)
  • βœ… A **dedicated Gmail label** to collect emails needing draft replies (e.g., `FAQ-Waiting`)
  • βœ… A **dedicated Gmail label** to store drafted replies for manual sending (e.g., `FAQ-Draft`)
  • βœ… A **Google Sheet with two columns**:
  • - `Question` β€” common user inquiries
  • - `Answer` β€” the matching, approved reply text

---

🧠 How It Works

  1. **Trigger**
  2. - Scheduled workflow run (e.g., every 15 minutes)

2. **Fetch Emails** - Grabs Gmail messages under a specific label like `FAQ-Waiting`

3. **Process & Clean** - Loops through each email - Cleans content (removes signatures/HTML) - Sends it to Gemini AI

4. **AI Reply Drafting** - AI matches email intent against your FAQ from Google Sheets - Generates a **friendly, accurate draft reply**, grounded **only** in your predefined Q&A

5. **Update Gmail** - Removes `FAQ-Waiting` label - Adds `FAQ-Draft` label - Saves draft reply in Gmail for manual review and sending

6. **Fallback Routing** - If email doesn’t match FAQ criteria, it follows a `FALSE` path - You can implement further logic here (e.g., route to Billing, escalate to a human agent, log as feedback)

---

πŸ› οΈ Setup Instructions

  1. **Connect Gmail + Google Sheets + Gemini AI**
  2. - Set up credentials in n8n for Gmail, Google Sheets, and Gemini AI

2. **Prepare Labels in Gmail** - Create: `FAQ-Waiting` (input folder), `FAQ-Draft` (drafts ready to send) - Optionally, create other labels (e.g., `Billing`, `Tech Support`)

3. **Build your FAQ Sheet** - Create a new Google Sheet with: - Column A: `Question` - Column B: `Answer` - Add rows with typical user questions and the matching replies

4. **Configure AI Agent** - In the **AI agent node**, edit the prompt to fit your tone of voice (friendly, professional, concise, etc.) - Ensure the AI is instructed to only use answers from the sheet, and not hallucinate

5. **Adjust Schedule** - Modify the trigger interval to match your needs (e.g., every X minutes)

---

🧩 Customization Tips

  • **Custom Prompts**: Tailor the Gemini AI prompt in the node to change tone, length, or structure of replies
  • **Add New Categories**: Use the `FALSE` path in the `IF` node to handle non-FAQ emails (e.g., route to Billing, escalate to human agent, log feedback)
  • **Multiple Sheets**: You can expand the system by using different sheets for different topics
  • **Tone Matching**: Adjust AI output by providing sample reply templates or tone instructions directly in the AI node

---

βœ… Use Cases

  • SaaS startups triaging customer support
  • Solo founders who want consistent replies with minimal effort
  • Teams managing growing inbox volumes while maintaining quality support

---

⚑ How to import this workflow into n8n:

  1. Click the Direct Download JSON button above to save _Automated_email_sorting_drafting_for_customer_support_wit.json.
  2. Log in to your n8n Cloud or self-hosted n8n instance.
  3. In your workflow canvas, click the menu in top-right and select Import from File (or paste the JSON directly).
  4. Configure your credentials (e.g. API keys, database URLs) in the corresponding node settings.
  5. Click Execute Workflow to test and switch to Active!

Related AI Agents Workflows

View All in AI Agents β†’