Draft personalized Outlook support email replies with Supabase RAG and OpenAI
Ready for 3.0What this workflow does
This AI workflow has 10 nodes and runs on Microsoft Outlook events. Along the way it connects Microsoft Outlook, Google Sheets, OpenAI Chat Model and Supabase Vector Store and 2 more.
How it runs
Trigger: On Microsoft Outlook events.
- Config Variables (Edit Fields (Set)): sets or maps fields
- Fetch Contact Info (Supabase): get
- Build AI Prompt (Code): runs custom JavaScript code
- AI Support Agent (AI Agent): runs an AI agent, with model: GPT-4o Model; 1 tool (Vector Store (Supabase))
- Draft Outlook Reply (Microsoft Outlook): work with draft
- Log to Google Sheets (Google Sheets): append or update
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 (10)
- Microsoft Outlook Trigger
n8n-nodes-base.microsoftOutlookTrigger - Edit Fields (Set)
n8n-nodes-base.set - Microsoft Outlook
n8n-nodes-base.microsoftOutlook - Google Sheets
n8n-nodes-base.googleSheets - AI Agent
@n8n/n8n-nodes-langchain.agent - OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi - Supabase Vector Store
@n8n/n8n-nodes-langchain.vectorStoreSupabase - Embeddings OpenAI
@n8n/n8n-nodes-langchain.embeddingsOpenAi - Code
n8n-nodes-base.code - Supabase
n8n-nodes-base.supabase
From the author
Description This workflow automates the first line of customer support by intelligently drafting email replies. It bridges the gap between your CRM (Supabase), your technical documentation (Vector Store), and your inbox (Outlook). By analyzing the sender's…