Templates / Automated email responses with GPT-4O & Supabase conversation memory

Automated email responses with GPT-4O & Supabase conversation memory

Ready for 3.0

by Lukman · 746 views · created 2025-10-21 · Support Chatbot, AI Chatbot

Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.

What 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).

  1. Loop Over Items (Loop Over Items (Split in Batches)): loops over the items in batches
  2. Supabase Vector Store: stores documents in the Supabase vector store, with embeddings: Embeddings OpenAI; document loader: Default Data Loader
  3. Clean HTML (Code): runs custom JavaScript code
  4. Update a row (Supabase): update
  5. Retrieve Categories (Postgres): run a query
  6. Aggregate: combines items into one
  7. Categorize (OpenAI): uses OpenAI
  8. Spam Filter (If): checks a condition and branches into true / false
  9. Conversation Retrieval (Postgres): run a query
  10. Format (Code): runs custom JavaScript code

…plus 6 more steps. See the full node list below.

Services it uses

Embeddings OpenAIMicrosoft OutlookOpenAIOpenAI Chat ModelPostgresSupabase Vector StoreSupabase

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)

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…

Excerpt from Lukman's description on n8n.io.

View the original on n8n.io → Check your own copy

Get the weekly “what broke” email

New templates, newly broken ones, and n8n release changes. One short email a week.

Form not loading? Subscribe here.