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 see

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 - 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 - 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 ---
Download the workflow JSON file after purchase.
Open n8n β click the menu β Import from File.
Select the downloaded JSON and import.
Set up credentials for each node that requires them.
Click Execute Workflow to test, then activate.
Setup guide included
Purchase to unlock the full step-by-step guide
No reviews yet
Be the first to buy and share your experience.
Leave a review
Sign in to share your experience with this workflow.
Create a free account to purchase workflows.
Need help setting this up?
Book a 3-hour live setup session with an Agility consultant.