Microsoft Outlook and Supabase integration

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 identity and the technical content of the query, it ensures that every draft reply is personalized, accurate, and follows strict business rules. How It Works Trigger: Monitors a Microsoft Outlook inbox for new incoming messages. Contact Enrichment: Queries a Supabase contacts table using the sender's email to retrieve their name, organization, and department. Context Construction: A Code node prepares a "Chat Input" that includes the email body, sender metadata, and specific brand "Business Rules." AI Intelligence (RAG): An AI Agent (GPT-4o) analyzes the request. If technical details are required, the Agent uses a Supabase Vector Store tool to retrieve semantic matches from your product manuals. Draft Creation: The AI generates an HTML-formatted reply which is saved as a Draft in Outlook for manual review. Audit Trail: Logs the intent, urgency, and outcome into a Google Sheet for performance tracking. Requirements Microsoft Outlook:** Business/Office 365 account. Supabase:** * A table for contact lookups. A vector-enabled database containing document embeddings. OpenAI API:** For the GPT-4o model and embeddings. Google Sheets:** To maintain an execution summary log. Setup Instructions Import: Paste the workflow JSON into your n8n canvas. Credentials: Set up and select credentials for Outlook, OpenAI, Supabase, and Google Sheets. Placeholder Updates: Fetch Contact Info: Set the table name to your specific CRM table. Vector Store: Update the table name and query function to match your Supabase Vector Store setup. Log to Google Sheets: Replace the Document ID and Sheet Name with your specific spreadsheet details. Persona Tuning: Open the AI Support Agent node and the Build AI Prompt code node to replace the [YOUR_COMPANY] and [YOUR_NAME] placeholders with your actual brand identity. Customization Ideas Urgency Routing:** Add an If node after the Agent to send a Slack or Teams notification if the AI detects the urgency is "high." Attachments:** Modify the Outlook node to include specific PDF brochures based on the primary_product_codes identified by the AI. Human-in-the-loop:** Use n8n "Wait for Webhook" or "Manual Approval" nodes if you want to approve the draft within the n8n UI before it hits the Outlook drafts folder.

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 follow company guidelines and prevent misinformation or misrepresentation. Use Case Ideal for businesses that receive frequent inquiries about products or services and want to automate responses, freeing up time to focus on core operations. How It Works Polls your inbox for new incoming emails Cleans HTML to reduce token usage and filters spam Categorizes emails for better organization Retrieves conversation history from Supabase (if available) to give the AI proper context Uses the AI agent to query your FAQ database for relevant answers Replies automatically if a suitable answer is found Sends a placeholder email and forwards to a human if no accurate answer exists Ingests all processed emails into Supabase to retain conversation history and improve future AI accuracy Customization You can connect any email provider or LLM model. The workflow can also be expanded to let the AI schedule meetings, answer availability questions, or handle other inbox tasks. If you'd like help tailoring this workflow to your business, feel free to reach out: Upwork Profile