Build a website AI chatbot with lead capture using Gemini and Supabase RAG
Ready for 3.0What 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).
- Data Normalizer (Code): runs custom JavaScript code
- Set the fields for mapping (Edit Fields (Set)): sets 2 fields: file_id, file_name
- Support Agent (AI Agent): runs an AI agent, with model: Google Gemini Chat Model; 4 tools (Think, Code Tool, Calculator, Knowledgebase); memory: conversation buffer
- Deletes old records (Supabase): delete
- Loop Over Items (Loop Over Items (Split in Batches)): loops over the items in batches
- Download file (Google Drive): download
- Supabase Vector Store: stores documents in the Supabase vector store, with embeddings: Embeddings OpenAI; document loader: Default Data Loader
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 (17)
- Google Gemini Chat Model
@n8n/n8n-nodes-langchain.lmChatGoogleGemini - Google Drive Trigger
n8n-nodes-base.googleDriveTrigger - Google Drive
n8n-nodes-base.googleDrive - Supabase Vector Store
@n8n/n8n-nodes-langchain.vectorStoreSupabase - Default Data Loader
@n8n/n8n-nodes-langchain.documentDefaultDataLoader - Recursive Character Text Splitter
@n8n/n8n-nodes-langchain.textSplitterRecursiveCharacterTextSplitter - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - Embeddings OpenAI
@n8n/n8n-nodes-langchain.embeddingsOpenAi - Think Tool
@n8n/n8n-nodes-langchain.toolThink - Calculator
@n8n/n8n-nodes-langchain.toolCalculator - AI Agent
@n8n/n8n-nodes-langchain.agent - Simple Memory
@n8n/n8n-nodes-langchain.memoryBufferWindow - Supabase
n8n-nodes-base.supabase - Edit Fields (Set)
n8n-nodes-base.set - Chat Trigger
@n8n/n8n-nodes-langchain.chatTrigger - Code Tool
@n8n/n8n-nodes-langchain.toolCode - Code
n8n-nodes-base.code
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…