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)
π 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
- **Trigger**
- - 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
- **Connect Gmail + Google Sheets + Gemini AI**
- - 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:
- Click the Direct Download JSON button above to save
_Automated_email_sorting_drafting_for_customer_support_wit.json. - Log in to your n8n Cloud or self-hosted n8n instance.
- In your workflow canvas, click the menu in top-right and select Import from File (or paste the JSON directly).
- Configure your credentials (e.g. API keys, database URLs) in the corresponding node settings.
- Click Execute Workflow to test and switch to Active!
Related AI Agents Workflows
View All in AI Agents β5 ways to process images PDFs with Gemini AI in n8n
How it works Many users have asked in the support forum about different methods to analyze images and PDF documents with Google Gemini AI in n8n. This workfl...
7 AI Sales Assistant
Production-ready n8n automation template for 7 AI Sales Assistant built by AhiXLight. Seamlessly connects Airtop Tool, Slack, Airtop with 24 configured nodes.
AAVE portfolio professional AI agent Telegram Email GPT 4o
A next-generation AI-powered DeFi health monitor that tracks wallet positions across Aave V3 using GPT-4o and LangChain. It delivers human-readable reports v...
Access control for AI agents RBAC using Airtable and Telegram
Purpose This workflow allows granular control over the access to tools connected to AI Agents (including Multi-Agent setups) using Role Based Access Control....