Capture and score website leads with Gemini RAG, Supabase, Google Sheets and Slack alerts
Ready for 3.0Ready 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 22 nodes and runs when a chat message arrives (plus 1 other trigger). Along the way it connects Supabase Vector Store, Embeddings Google Gemini, Reranker Cohere and HTTP Request and 5 more.
How it runs
Trigger: When a chat message arrives (plus 1 other trigger).
- Check Identity In DB (Supabase): get many
- Get All Leads (Google Sheets): uses Google Sheets
- AI Support Specialist (AI Agent): runs an AI agent, with model: Google Gemini Chat Model; 6 tools (Vector Store, Check if Lead Exists in CRM, Append row in Google Sheets CRM, Update row in Google Sheets CRM…); memory: Postgres Chat Memory
- Filter: keeps only the items that match a condition
- Respond to Chat (Chat): uses Chat
- If: checks a condition and branches into true / false
- AI Leader Scorer (AI Agent): runs an AI agent, with model: Google Gemini Chat Model; 1 tool (Update row in Google Sheets CRM (2))
- Mark as Scored (Google Sheets): append or update
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 (16)
- Chat Trigger
@n8n/n8n-nodes-langchain.chatTrigger - Supabase Vector Store
@n8n/n8n-nodes-langchain.vectorStoreSupabase - Embeddings Google Gemini
@n8n/n8n-nodes-langchain.embeddingsGoogleGemini - Reranker Cohere
@n8n/n8n-nodes-langchain.rerankerCohere - Http Request Tool
n8n-nodes-base.httpRequestTool - Supabase
n8n-nodes-base.supabase - Chat
@n8n/n8n-nodes-langchain.chat - Schedule Trigger
n8n-nodes-base.scheduleTrigger - If
n8n-nodes-base.if - Filter
n8n-nodes-base.filter - Google Gemini Chat Model
@n8n/n8n-nodes-langchain.lmChatGoogleGemini - Postgres Chat Memory
@n8n/n8n-nodes-langchain.memoryPostgresChat - Google Sheets
n8n-nodes-base.googleSheets - Google Sheets Tool
n8n-nodes-base.googleSheetsTool - AI Agent
@n8n/n8n-nodes-langchain.agent - Slack Tool
n8n-nodes-base.slackTool
From the author
Turn your website chat into a lead-generating machine. Visitors chat with an AI that answers questions from your knowledge base, captures their contact info, syncs everything to Google Sheets, and automatically scores leads based on buying signals - all…