HumationHuman + Automation
Back to Catalog

AI email support system: Gmail, Gemini, GPT-4, Slack & Google Sheets workflow

David OlusolaDavid Olusola
188 views
2/3/2026
AirtableWebhookShopifySyncCustomers
Official Page

🚀 Transform Your Customer Support with AI Automation!

Unlock unparalleled efficiency and elevate customer satisfaction with our AI-Powered Customer Support: Email, Knowledge Base & Human Escalation Automation template. This sophisticated n8n workflow is engineered to streamline your support operations, ensuring every customer interaction is intelligent, consistent, and handled with speed.

✨ How It Works: Your Automated Support Powerhouse

Witness the magic as customer inquiries are seamlessly transformed into resolved tickets, often without human intervention:

  • 1. Effortless Email Intake: Your journey to automated excellence begins the moment a customer email lands in your Gmail inbox. Our workflow instantly captures new inquiries, ensuring no request ever falls through the cracks.
  • 2. Intelligent Inquiry Classification: Say goodbye to manual triage! An advanced AI text classifier immediately analyzes incoming emails, intelligently categorizing each inquiry into precise buckets like Technical Support, Billing Support, Urgent Escalation, or General Support. This ensures every query is sent to the right specialist—virtual or human—from the start.
  • 3. AI-Driven, Context-Rich Responses: The classified inquiry is routed to a specialized AI agent (powered by Google Gemini), which taps into your comprehensive Pinecone knowledge base. This Retrieval-Augmented Generation (RAG) ensures every response is not only fast and accurate but also deeply informed by your company's specific policies and documentation, providing personalized and expert answers.
  • 4. Instant Communication & Meticulous Logging: Once generated, the AI's professional response is automatically sent back to the customer via Gmail. Simultaneously, every detail of the interaction – from the classified service type to the full AI response and a unique ticket ID – is meticulously logged in your Google Sheet. This creates an invaluable, searchable record for unparalleled insights and accountability.
  • 5. Seamless Urgent Human Escalation: For critical or complex issues requiring a human touch, the workflow instantly escalates the ticket. Your team is notified via Slack with all pertinent details, ensuring urgent matters are always prioritized and resolved swiftly, maintaining high customer satisfaction even in challenging situations.
  • 6. Self-Updating Knowledge Base: Keep your AI agents perpetually smart! Our workflow effortlessly maintains your Pinecone knowledge base by automatically processing and ingesting new documents uploaded to a designated Google Drive folder. This ensures your AI always has the most current information, without any manual data entry from your side.

🛠️ Effortless Setup: Go Live in Under an Hour!

Getting started with this powerful automation is surprisingly simple. You can typically have your core setup ready and operational in just 30-60 minutes, freeing you to focus on strategic growth rather than tedious setup.

  • 1. Connect Your Services: Quickly link your existing accounts for Gmail, OpenAI, Google Gemini, Pinecone, Google Sheets, Slack, and Google Drive using n8n's intuitive credential management.
  • 2. Prepare Your Data Hub: Link the workflow to your Google Sheet with pre-defined columns for seamless logging of all support interactions.
  • 3. Empower Your AI with Knowledge: Simply upload your company's FAQs, policies, and documentation into a specified Google Drive folder. Our workflow handles the rest, automatically building and enriching your Pinecone knowledge base.
  • 4. Activate & Automate: With your credentials connected and data sources in place, activate the workflow in n8n, and watch your customer support transform!

For comprehensive, step-by-step guidance on advanced customization, API key configuration, and fine-tuning every aspect to your unique business needs, refer to the detailed Sticky Notes embedded directly within the n8n workflow. They are your personal setup assistant!

AI Email Support System with Gmail, Gemini/GPT-4, Slack, and Google Sheets

This n8n workflow automates the process of providing AI-powered support for incoming emails. It intelligently classifies emails, generates responses using a large language model, and logs all interactions, while also notifying a Slack channel for human oversight.

What it does

This workflow streamlines your email support by:

  1. Triggering on New Emails: Automatically starts when a new email arrives in your specified Gmail inbox.
  2. Classifying Email Intent: Uses an AI Text Classifier (powered by either Google Gemini or OpenAI GPT-4) to determine the category or intent of the incoming email.
  3. Generating AI Responses: Leverages a large language model (Google Gemini or OpenAI GPT-4) to draft a relevant and helpful response based on the email's content and classification.
  4. Storing Email Data: Saves the original email content and the AI-generated response to a Google Sheet for record-keeping and analysis.
  5. Notifying Support Team: Posts a summary of the email, its classification, and the AI-generated response to a designated Slack channel, allowing your team to monitor and intervene if necessary.
  6. Sending AI Response (Optional/Manual): The Gmail node is configured to send emails, implying that the AI-generated response can be sent back to the customer.
  7. Document Loading and Vector Storage (for context): The workflow also includes nodes for loading documents, splitting text, creating embeddings (using OpenAI), and storing them in a Pinecone Vector Store. This suggests the AI agent might be leveraging a knowledge base for more informed responses, though the direct connection to the main email flow isn't explicitly shown in the provided JSON.

Prerequisites/Requirements

To use this workflow, you will need:

  • n8n Instance: A running n8n instance.
  • Gmail Account: With credentials configured in n8n to read incoming emails and send replies.
  • Google Sheets Account: With credentials configured in n8n to log email interactions.
  • Slack Account: With credentials configured in n8n to post notifications to a channel.
  • AI Service Credentials:
    • Google Gemini API Key: If using the Google Gemini Chat Model.
    • OpenAI API Key: If using the OpenAI Chat Model and Embeddings.
  • Pinecone Account: If you intend to use the vector store for a knowledge base.

Setup/Usage

  1. Import the Workflow: Download the provided JSON and import it into your n8n instance.
  2. Configure Credentials:
    • Set up your Gmail credentials for the Gmail Trigger and Gmail nodes.
    • Configure your Google Sheets credentials for the Google Sheets node.
    • Set up your Slack credentials for the Slack node.
    • Configure your Google Gemini or OpenAI credentials for the Google Gemini Chat Model/OpenAI Chat Model, Text Classifier, and Embeddings OpenAI nodes.
    • Configure your Pinecone credentials for the Pinecone Vector Store node.
  3. Customize Nodes:
    • Gmail Trigger: Specify the email inbox, labels, or search queries to monitor for incoming support emails.
    • Text Classifier: Define the categories you want your emails to be classified into (e.g., "billing", "technical support", "feature request").
    • OpenAI Chat Model / Google Gemini Chat Model: Adjust the prompt and model parameters to fine-tune the AI's response generation.
    • Google Sheets: Specify the Spreadsheet ID and Sheet Name where email data should be logged.
    • Slack: Configure the Slack channel where notifications should be posted and customize the message content.
    • AI Agent: If utilizing the AI Agent, ensure its tools and prompt are configured correctly.
    • Document Loading/Splitting/Embedding/Vector Store: If you plan to use a knowledge base, configure these nodes to load your relevant documents and store them in Pinecone.
  4. Activate the Workflow: Once all configurations are complete, activate the workflow. It will now automatically process incoming emails according to your setup.

Related Templates

Auto-create TikTok videos with VEED.io AI avatars, ElevenLabs & GPT-4

💥 Viral TikTok Video Machine: Auto-Create Videos with Your AI Avatar --- 🎯 Who is this for? This workflow is for content creators, marketers, and agencies who want to use Veed.io’s AI avatar technology to produce short, engaging TikTok videos automatically. It’s ideal for creators who want to appear on camera without recording themselves, and for teams managing multiple brands who need to generate videos at scale. --- ⚙️ What problem this workflow solves Manually creating videos for TikTok can take hours — finding trends, writing scripts, recording, and editing. By combining Veed.io, ElevenLabs, and GPT-4, this workflow transforms a simple Telegram input into a ready-to-post TikTok video featuring your AI avatar powered by Veed.io — speaking naturally with your cloned voice. --- 🚀 What this workflow does This automation links Veed.io’s video-generation API with multiple AI tools: Analyzes TikTok trends via Perplexity AI Writes a 10-second viral script using GPT-4 Generates your voiceover via ElevenLabs Uses Veed.io (Fabric 1.0 via FAL.ai) to animate your avatar and sync the lips to the voice Creates an engaging caption + hashtags for TikTok virality Publishes the video automatically via Blotato TikTok API Logs all results to Google Sheets for tracking --- 🧩 Setup Telegram Bot Create your bot via @BotFather Configure it as the trigger for sending your photo and theme Connect Veed.io Create an account on Veed.io Get your FAL.ai API key (Veed Fabric 1.0 model) Use HTTPS image/audio URLs compatible with Veed Fabric Other APIs Add Perplexity, ElevenLabs, and Blotato TikTok keys Connect your Google Sheet for logging results --- 🛠️ How to customize this workflow Change your Avatar: Upload a new image through Telegram, and Veed.io will generate a new talking version automatically. Modify the Script Style: Adjust the GPT prompt for tone (educational, funny, storytelling). Adjust Voice Tone: Tweak ElevenLabs stability and similarity settings. Expand Platforms: Add Instagram, YouTube Shorts, or X (Twitter) posting nodes. Track Performance: Customize your Google Sheet to measure your most successful Veed.io-based videos. --- 🧠 Expected Outcome In just a few seconds after sending your photo and theme, this workflow — powered by Veed.io — creates a fully automated TikTok video featuring your AI avatar with natural lip-sync and voice. The result is a continuous stream of viral short videos, made without cameras, editing, or effort. --- ✅ Import the JSON file in n8n, add your API keys (including Veed.io via FAL.ai), and start generating viral TikTok videos starring your AI avatar today! 🎥 Watch This Tutorial --- 📄 Documentation: Notion Guide Need help customizing? Contact me for consulting and support : Linkedin / Youtube

Dr. FirasBy Dr. Firas
39510

Two-way property repair management system with Google Sheets & Drive

This workflow automates the repair request process between tenants and building managers, keeping all updates organized in a single spreadsheet. It is composed of two coordinated workflows, as two separate triggers are required — one for new repair submissions and another for repair updates. A Unique Unit ID that corresponds to individual units is attributed to each request, and timestamps are used to coordinate repair updates with specific requests. General use cases include: Property managers who manage multiple buildings or units. Building owners looking to centralize tenant repair communication. Automation builders who want to learn multi-trigger workflow design in n8n. --- ⚙️ How It Works Workflow 1 – New Repair Requests Behind the Scenes: A tenant fills out a Google Form (“Repair Request Form”), which automatically adds a new row to a linked Google Sheet. Steps: Trigger: Google Sheets rowAdded – runs when a new form entry appears. Extract & Format: Collects all relevant form data (address, unit, urgency, contacts). Generate Unit ID: Creates a standardized identifier (e.g., BUILDING-UNIT) for tracking. Email Notification: Sends the building manager a formatted email summarizing the repair details and including a link to a Repair Update Form (which activates Workflow 2). --- Workflow 2 – Repair Updates Behind the Scenes:\ Triggered when the building manager submits a follow-up form (“Repair Update Form”). Steps: Lookup by UUID: Uses the Unit ID from Workflow 1 to find the existing row in the Google Sheet. Conditional Logic: If photos are uploaded: Saves each image to a Google Drive folder, renames files consistently, and adds URLs to the sheet. If no photos: Skips the upload step and processes textual updates only. Merge & Update: Combines new data with existing repair info in the same spreadsheet row — enabling a full repair history in one place. --- 🧩 Requirements Google Account (for Forms, Sheets, and Drive) Gmail/email node connected for sending notifications n8n credentials configured for Google API access --- ⚡ Setup Instructions (see more detail in workflow) Import both workflows into n8n, then copy one into a second workflow. Change manual trigger in workflow 2 to a n8n Form node. Connect Google credentials to all nodes. Update spreadsheet and folder IDs in the corresponding nodes. Customize email text, sender name, and form links for your organization. Test each workflow with a sample repair request and a repair update submission. --- 🛠️ Customization Ideas Add Slack or Telegram notifications for urgent repairs. Auto-create folders per building or unit for photo uploads. Generate monthly repair summaries using Google Sheets triggers. Add an AI node to create summaries/extract relevant repair data from repair request that include long submissions.

Matt@VeraisonLabsBy Matt@VeraisonLabs
208

Automate Dutch Public Procurement Data Collection with TenderNed

TenderNed Public Procurement What This Workflow Does This workflow automates the collection of public procurement data from TenderNed (the official Dutch tender platform). It: Fetches the latest tender publications from the TenderNed API Retrieves detailed information in both XML and JSON formats for each tender Parses and extracts key information like organization names, titles, descriptions, and reference numbers Filters results based on your custom criteria Stores the data in a database for easy querying and analysis Setup Instructions This template comes with sticky notes providing step-by-step instructions in Dutch and various query options you can customize. Prerequisites TenderNed API Access - Register at TenderNed for API credentials Configuration Steps Set up TenderNed credentials: Add HTTP Basic Auth credentials with your TenderNed API username and password Apply these credentials to the three HTTP Request nodes: "Tenderned Publicaties" "Haal XML Details" "Haal JSON Details" Customize filters: Modify the "Filter op ..." node to match your specific requirements Examples: specific organizations, contract values, regions, etc. How It Works Step 1: Trigger The workflow can be triggered either manually for testing or automatically on a daily schedule. Step 2: Fetch Publications Makes an API call to TenderNed to retrieve a list of recent publications (up to 100 per request). Step 3: Process & Split Extracts the tender array from the response and splits it into individual items for processing. Step 4: Fetch Details For each tender, the workflow makes two parallel API calls: XML endpoint - Retrieves the complete tender documentation in XML format JSON endpoint - Fetches metadata including reference numbers and keywords Step 5: Parse & Merge Parses the XML data and merges it with the JSON metadata and batch information into a single data structure. Step 6: Extract Fields Maps the raw API data to clean, structured fields including: Publication ID and date Organization name Tender title and description Reference numbers (kenmerk, TED number) Step 7: Filter Applies your custom filter criteria to focus on relevant tenders only. Step 8: Store Inserts the processed data into your database for storage and future analysis. Customization Tips Modify API Parameters In the "Tenderned Publicaties" node, you can adjust: offset: Starting position for pagination size: Number of results per request (max 100) Add query parameters for date ranges, status filters, etc. Add More Fields Extend the "Splits Alle Velden" node to extract additional fields from the XML/JSON data, such as: Contract value estimates Deadline dates CPV codes (procurement classification) Contact information Integrate Notifications Add a Slack, Email, or Discord node after the filter to get notified about new matching tenders. Incremental Updates Modify the workflow to only fetch new tenders by: Storing the last execution timestamp Adding date filters to the API query Only processing publications newer than the last run Troubleshooting No data returned? Verify your TenderNed API credentials are correct Check that you have setup youre filter proper Need help setting this up or interested in a complete tender analysis solution? Get in touch 🔗 LinkedIn – Wessel Bulte

Wessel BulteBy Wessel Bulte
247