AutomationMart
Home/Browse/Real-time email RAG assistant with Gmail, OpenAI GPT, and PGVector
n8n

Real-time email RAG assistant with Gmail, OpenAI GPT, and PGVector

n8nn8n11 modulesv1.0
GmailSlackOpenAITelegram

Email real time RAG Assistant with Gmail, OpenAI & PGVector πŸ“Œ Who’s it for This workflow is ideal for: - Professionals - Project managers - Sales and support teams - Anyone managing high volumes of Gmail messages It enables fast and intelligent search through your email inbox using natural language queries. --- βš™οΈ How it works / What it does - Continuously monitors your Gmail inbox for new emails. - Extracts email content and metadata (subject, body, sender,

At a glance

Real-time email RAG assistant with Gmail, OpenAI GPT, and PGVector is a ready-made n8n workflow you import as a workflow JSON file β€” no build required. It connects Gmail, Slack, OpenAI, Telegram. It's free to download. Follow the 5-step import below to go live in minutes.

Platform
n8n
Connects
Gmail, Slack, OpenAI, Telegram
Modules
11
Price
Free
Version
v1.0
Real-time email RAG assistant with Gmail, OpenAI GPT, and PGVector workflow diagram

About this workflow

Email real time RAG Assistant with Gmail, OpenAI & PGVector πŸ“Œ Who’s it for This workflow is ideal for: - Professionals - Project managers - Sales and support teams - Anyone managing high volumes of Gmail messages It enables fast and intelligent search through your email inbox using natural language queries. --- βš™οΈ How it works / What it does - Continuously monitors your Gmail inbox for new emails. - Extracts email content and metadata (subject, body, sender, date). - Converts email content into vector embeddings using OpenAI. - Stores embeddings in a PostgreSQL database with PGVector. - A conversational AI agent performs semantic search on your stored email history. - Supports time-sensitive and context-aware responses via OpenAI Chat model. --- πŸš€ How to set up 1. Connect your Gmail account to the Gmail Trigger node (with API access enabled). 2. Configure OpenAI credentials for the Embedding and Chat nodes. 3. Set up a PostgreSQL database with the PGVector extension enabled. 4. Import the workflow into your n8n instance (Cloud or Self-hosted). 5. Customize parameters like polling frequency, embedding settings, or vector query depth. --- πŸ“‹ Requirements - βœ… n8n instance (Self-hosted or Cloud) - βœ… Gmail account with API access - βœ… OpenAI API Key - βœ… PostgreSQL database with PGVector extension installed --- πŸ› οΈ How to customize the workflow - Email Filtering: Change filters in the Gmail Trigger to watch specific labels or senders. - Text Splitting Granularity: Adjust chunkSize and chunkOverlap in the text splitter node. - Query Depth: Modify topK in the vector search node to retrieve more or fewer similar results. - Prompt Tuning: Customize the system message or agent instructions in the RAG node. - Workflow Extensions: Add notifications, error logging, Slack/Telegram alerts, or data exports.

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

Collect API user data and store in Google Sheets with CSV backup

Overview This n8n workflow automates the process of fetching user data from an API, verifying its validity, transforming the response, and then saving it to Google Sheets for team collaboration. Additionally, it generates a CSV backup file of the same data for offline access or external integrations. Perfect for developers, analysts, or teams who want an automated, no-code data ingestion and backup solution. --- βš™οΈ Key Features πŸ”Œ Fetches data from any REST API endpoint (e.g., RandomUser API) βœ…

Free

Share AI-generated content on LinkedIn from ChatGPT completions

Automatically share AI-generated content on LinkedIn by using ChatGPT to create posts, enhancing your professional presence and engagement.

Free

πŸ€–πŸ§  AI agent chatbot + LONG TERM memory + note storage + Telegram

This workflow template creates an AI agent chatbot with long-term memory and note storage using Google Docs and Telegram integration. Google Docs Integration πŸ“„ n8n Google Docs Node Setup Google Credentials Telegram Integration πŸ’¬ Telegram Setup Core Features 🌟 A

Free

AI recruiter – analyze multiple CVs vs job description using OpenAI GPT

An AI Recruiter that screens, scores, and ranks candidates in minutes β€” directly inside n8n. --- 🧠 Overview An AI-powered recruiter workflow that compares multiple candidate CVs with a single Job Description (JD). It analyzes text content, calculates fit scores, identifies strengths and weaknesses, and provides automated recommendations. --- βš™οΈ How it works πŸ”Ή Webhook Trigger – Upload one Job Description (JD) and multiple CVs (PDF or text) πŸ”Ή File Detector – Auto-identifies JD vs CV πŸ”Ή Extract &

Free

Send Wootric notifications to Telegram Bot

Every time when you have a new response in Wootric, Make will automatically send a message to the specified Telegram channel/group.

Free

Auto-generate SEO blog posts with Perplexity, GPT, Leonardo & WordPress

SEO Blog Post Automation with Perplexity, GPT, Leonardo AI & WordPress This workflow automates the creation and publishing of weekly SEO-optimized blog posts using AI and publishes them directly to WordPress β€” with featured images and tracking in Google Sheets. --- 🧠 Who is this for This automation is ideal for: - Startup platforms and tech blogs - Content creators and marketers - Solopreneurs who want consistent blog output - Spanish-speaking audiences focused on startup tren

Free

AI-powered Upwork cover letter generator – Pinecone, Groq, Google Gemin, SerpAPI

( πŸš€ Automated Upwork Cover Letter Generator with n8n + MacOS Shortcut + Pinecone Context Retrieval This n8n automation is designed to streamline the Upwork proposal process by generating highly personalized, context-aware cover letters using your own skills and project data stored in a Pinecone vector store. With the help of an AI Agent powered by Groq’s Qwen LLM, and triggered instantly via a MacOS Shortcut, this system takes job descriptions from your clipboard and returns a ready-to-use HTML

Free

Extract & transform HackerNews data to Google Docs using Gemini 2.0 flash

Description This workflow automates the process of scraping the latest discussions from HackerNews, transforming raw threads into human readable content using Google Gemini, and exporting the final content into a well-formatted Google Doc. Overview This n8n workflow is responsible for extracting trending posts from the HackerNews API. It loops through each item, performs HTTP data extraction, utilizes Google Gemini to generate human-readable insights, and then exports the enriched conte

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