Microsoft Outlook and Postgres integration

Automate Microsoft Teams Meeting Analysis with GPT-4.1, Outlook & Mem.ai Watch the YouTube video to get started Follow along with the blog post Template Overview This advanced n8n template automates Microsoft Teams meeting analysis, knowledge base creation, and email drafting directly from meeting recordings and transcripts. It provides end-to-end automation for the following use cases: Meeting Analysis Connects to Microsoft Graph to retrieve meeting recordings, chat messages, and transcripts. Analyses meeting content using AI models. Extracts key points, action items, questions, and themes from meetings automatically. AI-Powered Web App Automatically creates a detailed report from past meetings. Stores meeting summaries, metadata, and insights into an easy-to-browse frontend. New meetings are added dynamically without manual work. ** Knowledge Base Indexing (via Mem.ai)** Uploads extracted meeting data into a structured knowledge base. Supports categorisation, search and chat functionality across meetings. Draft Follow-Up Emails** Draft personalised follow-up emails for meeting participants. Email drafts include: Meeting summary Key decisions Action items Emails can be sent manually with a human in the loop context via Microsoft Outlook integration. Core Components Microsoft Graph API for accessing meetings, chats, files, and user profiles. SharePoint API for file storage and search. n8n Webhooks to trigger processes dynamically. Generic OAuth2 authentication for seamless Microsoft access. JavaScript Code Nodes for flexible, intelligent parsing and structuring of meeting data. AI/LLM nodes for summarisation and content creation. Designed to be scalable, modular, and easily customisable for different organisation sizes and industries. 🛡️ Note Failure to correctly configure Azure permissions will prevent the template from functioning. Ensure admin approval is fully completed during setup. Important Prerequisites ⚠️ Administrator consent is required This template requires a Microsoft 365 Global Administrator or Application Administrator to grant admin consent to a set of Microsoft Graph and SharePoint API scopes. Basic Azure App Registration knowledge is required: You need to set up an Azure App Registration manually, configure OAuth2 authentication, and assign specific API permissions. A setup guide is included, but familiarity with: App registrations API permissions Client secrets OAuth2 flows is highly recommended. Knowledge of Postgres is required The template includes a SQL script to create the required Postgres table (see blog post). You are responsible for hosting your own database (You can use Supabase with the Postgres connection string).

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