Classify and auto-reply to Gmail with OpenAI, Google Sheets RAG and Telegram

Description

📨 Gmail Classifier —Classify emails using AI and automate responses

This workflow delivers a complete, enterprise-grade Gmail automation system designed for high-volume teams. It classifies incoming emails, applies labels, generates AI-powered responses, and routes messages to the right department. It also includes optional demo email generation and an inbox cleanup utility so teams can test the workflow instantly.

🚀 What This Workflow Does
Classifies Gmail messages into High Priority, Customer Support, Promotions, or Finance/Billing
Generates AI-written replies or drafts based on category
Applies Gmail labels automatically
Uses RAG from Google Sheets for Support queries
Sends real-time internal notifications (Telegram)
Includes tools to generate & delete test emails for repeatable QA

🏢 Who This Is For
Teams that want reliable, automated inbox management:
Customer Support
Sales
Billing & Finance
Operations
Solo founders who need executive inbox automation
AI-powered enterprise workflows using Gmail

🧩 Internal Workflow Overview
Gmail Trigger pulls unread emails from the inbox
Email Classifier Agent (OpenAI) cleans + classifies the email
Switch Node routes to the correct workflow lane
Labels are added → AI responders generate the message → internal teams get notified
Optional: Demo email generator + inbox cleanup for testing

🛠️ How to Set Up
Add credentials:
Gmail OAuth2
OpenAI / Gemini
Google Sheets OAuth2
Copy the demo sheet:
https://docs.google.com/spreadsheets/d/1A959skQt0a7RbdsD0IGaCbPxMv4a-HjmQL4hwB9TcXc/edit?usp=sharing
Update the Google Sheets nodes with your Document ID + Sheet Name
Enable Gmail Trigger (UNREAD filter recommended)
Use “Send Demo Emails” → test end-to-end behavior
Run the Gmail Classifier workflow live

📦 Requirements
Gmail API access
OpenAI/Gemini API key
Google Sheets OAuth (for RAG/lookup)
n8n (latest recommended version)

🎯 Ideal Enterprise Use Cases
Automated customer support with AI-written replies
High-priority routing for executives
Finance & billing summarization for operations
Filtering promotions/marketing noise from shared inboxes
AI-augmented helpdesk workflows

🧪 Test Data Included
Use the Demo Sheet tabs:
Sample_Emails** → pre-written emails for every category
Demo_Emails** → rows sent as live test emails

Copy → paste → run.

🔖 Tags
Gmail, AI, Inbox Automation, Support Automation, Enterprise, Email Classification, OpenAI, RAG, Google Sheets

Template Author: Sandeep Patharkar
LinkedIn: https://www.linkedin.com/in/sandeeppatharkar
Skool: https://www.skool.com/aic-plus