AutomationMart
Home/Browse/βœ‰οΈ Automated email sorting & drafting for customer support - with AI πŸ€–
n8n

βœ‰οΈ Automated email sorting & drafting for customer support - with AI πŸ€–

n8nn8n26 modulesv1.0
GmailGoogle SheetsGemini

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

At a glance

βœ‰οΈ Automated email sorting & drafting for customer support - with AI πŸ€– is a ready-made n8n workflow you import as a workflow JSON file β€” no build required. It connects Gmail, Google Sheets, Gemini. It's free to download. Follow the 5-step import below to go live in minutes.

Platform
n8n
Connects
Gmail, Google Sheets, Gemini
Modules
26
Price
Free
Version
v1.0
βœ‰οΈ Automated email sorting & drafting for customer support - with AI πŸ€– workflow diagram

About this workflow

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 ---

n8n

How to import this n8n workflow

  1. 1

    Download the workflow JSON file after purchase.

  2. 2

    Open n8n β†’ click the menu β†’ Import from File.

  3. 3

    Select the downloaded JSON and import.

  4. 4

    Set up credentials for each node that requires them.

  5. 5

    Click Execute Workflow to test, then activate.

Setup guide

Setup guide included

Purchase to unlock the full step-by-step guide

Related N8n workflows

Auto-send WooCommerce invoices via WhatsApp with Rapiwa API

Who is this for? This workflow listens for new or updated WooCommerce orders, cleans and structures the order data, processes orders in batches, and standardizes WhatsApp phone numbers. It verifies phone numbers via the Rapiwa API, sends invoice links or messages to verified numbers, and logs results into separate Google Sheets tabs for verified and unverified numbers. Throttling and looping are managed using batch processing and wait delays. What this Workflow Does - Receives order events (e.g.

Free

πŸ€– Self Improving Email AI Support with Human-in-the-Loop

How it works This workflow creates a sophisticated, self-improving customer support system that automatically handles incoming emails. It's designed to answer common questions using an AI-powered knowledge base and, crucially, to learn from human experts when new or complex questions arise, continuously expanding its capabilities. Think of it like having an AI assistant with a smart memory and a human mentor. Here's the step-by-step process: 1. New Email Received: The workflow is triggered whene

Free

Save submitted form in Landingi to a Google Sheets spreadsheet

Every time a new form Submitted in Landingi, Make will automatically add it to a new row in a Google Sheet spreadsheet. The template uses this [example spreadsheet.](https://docs.google.com/spreadsheets/d/1a3y1ssho2eoTmX8hbOGM4G--JwxBcTL0V_lB483TdZQ/edit?usp=sharing)

Free

Create a new Google Sheets row for every new Asana task

Automatically log every new Asana task into Google Sheets. Keep track of tasks effortlessly by adding a new row for each task.

Free

Generate PDFs via PDF Generation API from new rows in Google Sheets and save the PDFs to Google Drive

This template periodically retrieves new rows from a Google Sheets spreadsheet and uses the information for generating PDF documents via PDF Generator API. The final PDF documents are then saved to a folder in Google Drive. The template is using this sample Google Sheets spreadsheet. You should make a copy of it before configuring the template. The template also expects your PDF Generator AP

Free

Create Notion database items from new Google Sheets rows

Automatically generate new Notion database items each time a row is added to your Google Sheets spreadsheet

Free

🎨 Interactive image editor with FLUX.1 fill tool for inpainting

gt; Like this template? Connect with Eduard via LinkedIn. This workflow is a prototype of an AI-powered image editing interface, similar to Photoshop's Generative Fill feature, but running entirely in the browser. It provides a web-based editor that allows users to: Select areas in images using an adjustable brush tool Input text prompts to guide the AI generation Compare original and generated images side by side Iterate on edits with different prompts and settings Save or reuse generated

Free

WordPress blog generation with AI Research, Image Creation & Auto Publishing

How This N8n Workflow Works This is an automated blog post generation system that: 1. Researches topics using AI agents and web search tools 2. Writes complete blog posts with proper SEO structure 3. Generates custom images for each post 4. Publishes directly to WordPress with images embedded Setup Steps 1. API Keys & Credentials - Set in "API Keys" node: - tavily: Get from tavily.com (free tier available) - wavespeed: Get from wavespeed.ai for image generation - wordpress-website-url: Your W

Free

Reviews

No reviews yet

Be the first to buy and share your experience.

Leave a review

Sign in to share your experience with this workflow.

Log in to review
Free
No ratings yet

Create a free account to purchase workflows.

  • JSON blueprint β€” instant download
  • Setup guide PDF included
  • 5 downloads Β· valid 30 days
  • Works with n8n

Need help setting this up?

Book a 3-hour live setup session with an Agility consultant.

β‚Ή2,499/ session
3 hrs Β· video call
  • Configure live on Google Meet / Zoom
  • Free follow-up if workflow has defects
  • Platform expert assigned to you
Book installation session
Free