Analyze, classify, and summarize Gmail with OpenAI RAG and Google Sheets

<h2📧 Analyze, classify, and summarize emails using RAG (automatic taxonomy learning)</h2

<p This workflow automatically reads incoming Gmail messages, analyzes them using AI with a retrieval-augmented classification system (RAG), organizes emails into structured categories, stores results in Google Sheets, and even generates an audio summary sent directly to Telegram. </p

<hr

<h2⚙️ How It Works</h2

<p The workflow creates an intelligent email processing pipeline combining Gmail, OpenAI, vector embeddings, and Google Sheets to continuously learn and improve email categorization accuracy. </p

<ol <li <strongEmail Trigger</strong<br The workflow starts automatically whenever a new email arrives in Gmail using the Gmail Trigger node. </li

<li <strongEmail Extraction & Cleaning</strong<br The full email content, sender information, subject, and timestamp are retrieved and normalized. HTML formatting is removed so the AI receives clean text data. </li

<li <strongKnowledge Base Loading (RAG)</strong<br Email tagging examples stored in a Google Sheets document are loaded and converted into embeddings. These examples act as the official taxonomy for categories and subcategories. </li