Automated Email Ingestion and AI-Powered Search Workflow

This n8n workflow automates the process of ingesting emails from Gmail, storing their content in a vector database, and enabling AI-powered semantic search and retrieval. It starts with a Gmail trigger to detect new emails, fetches full email details, and processes the email content with a language model. The email text is split into manageable chunks, embedded into vector representations using OpenAI embeddings, and stored in a Postgres vector database. For queries, a chat trigger initiates an AI-driven agent that retrieves relevant email data from the vector store and generates human-like responses. This system is ideal for building intelligent email search solutions, customer support assistants, or knowledge management tools that require real-time, semantic understanding of email content.