Automated email responses with GPT-4O & Supabase conversation memory
Ready for 3.0What this workflow does
This AI workflow has 27 nodes and runs on Microsoft Outlook events (plus 1 other trigger). Along the way it connects Embeddings OpenAI, Microsoft Outlook, OpenAI and OpenAI Chat Model and 3 more.
How it runs
Trigger: On Microsoft Outlook events (plus 1 other trigger).
- Loop Over Items (Loop Over Items (Split in Batches)): loops over the items in batches
- Supabase Vector Store: stores documents in the Supabase vector store, with embeddings: Embeddings OpenAI; document loader: Default Data Loader
- Clean HTML (Code): runs custom JavaScript code
- Update a row (Supabase): update
- Retrieve Categories (Postgres): run a query
- Aggregate: combines items into one
- Categorize (OpenAI): uses OpenAI
- Spam Filter (If): checks a condition and branches into true / false
- Conversation Retrieval (Postgres): run a query
- Format (Code): runs custom JavaScript code
…plus 6 more steps. See the full node list below.
Services it uses
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (19)
- Embeddings OpenAI
@n8n/n8n-nodes-langchain.embeddingsOpenAi - Microsoft Outlook Trigger
n8n-nodes-base.microsoftOutlookTrigger - Code
n8n-nodes-base.code - OpenAI
@n8n/n8n-nodes-langchain.openAi - Structured Output Parser
@n8n/n8n-nodes-langchain.outputParserStructured - OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi - Postgres
n8n-nodes-base.postgres - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - Aggregate
n8n-nodes-base.aggregate - If
n8n-nodes-base.if - AI Agent
@n8n/n8n-nodes-langchain.agent - Supabase Vector Store
@n8n/n8n-nodes-langchain.vectorStoreSupabase - Microsoft Outlook
n8n-nodes-base.microsoftOutlook - Execute Sub-workflow
n8n-nodes-base.executeWorkflow - HTTP Request
n8n-nodes-base.httpRequest - Execute Workflow Trigger
n8n-nodes-base.executeWorkflowTrigger - Default Data Loader
@n8n/n8n-nodes-langchain.documentDefaultDataLoader - Recursive Character Text Splitter
@n8n/n8n-nodes-langchain.textSplitterRecursiveCharacterTextSplitter - Supabase
n8n-nodes-base.supabase
From the author
This n8n workflow lets you delegate inbox management to an AI agent. It automatically replies to emails when a suitable response is found in your knowledge base. If no match is found, the message is forwarded to a human for review. This ensures all replies…