Templates / Build a website AI chatbot with lead capture using Gemini and Supabase RAG

Build a website AI chatbot with lead capture using Gemini and Supabase RAG

Ready for 3.0

by Shadrack ✓ · 1,218 views · created 2025-10-30 · 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 19 nodes and runs when a chat message arrives (plus 2 other triggers). Along the way it connects Google Gemini Chat Model, Google Drive, Supabase Vector Store and Embeddings OpenAI and 1 more.

How it runs

Trigger: When a chat message arrives (plus 2 other triggers).

  1. Data Normalizer (Code): runs custom JavaScript code
  2. Set the fields for mapping (Edit Fields (Set)): sets 2 fields: file_id, file_name
  3. Support Agent (AI Agent): runs an AI agent, with model: Google Gemini Chat Model; 4 tools (Think, Code Tool, Calculator, Knowledgebase); memory: conversation buffer
  4. Deletes old records (Supabase): delete
  5. Loop Over Items (Loop Over Items (Split in Batches)): loops over the items in batches
  6. Download file (Google Drive): download
  7. Supabase Vector Store: stores documents in the Supabase vector store, with embeddings: Embeddings OpenAI; document loader: Default Data Loader

Services it uses

Google Gemini Chat ModelGoogle DriveSupabase Vector StoreEmbeddings OpenAISupabase

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 (17)

From the author

This workflow deploys a fully customizable AI chatbot that can be embedded on any website, from custom-coded sites to platforms like WordPress. The chatbot is powered by n8n, uses Supabase for memory and RAG, and integrates SerpAPI, Google Calendar, SMTP, and…

Excerpt from Shadrack'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.