Answer support FAQs with Google Gemini, Supabase, Google Sheets and WhatsApp
Ready for 3.0What this workflow does
This AI workflow has 16 nodes and runs manually, when you click “Execute workflow” (plus 1 other trigger). Along the way it connects Google Gemini Chat Model, Supabase Vector Store, Embeddings Google Gemini and Google Sheets.
How it runs
Trigger: Manually, when you click “Execute workflow” (plus 1 other trigger).
- Get row(s) in sheet (Google Sheets): uses Google Sheets
- AI Agent: runs an AI agent, with model: Google Gemini Chat Model; 1 tool (Supabase Vector Store); memory: Simple Memory
- Code: runs custom JavaScript code
- If: checks a condition and branches into true / false
- Supabase Vector Store: stores documents in the Supabase vector store, with embeddings: Embeddings Google Gemini; document loader: Default Data Loader
- HTTP Request: calls an HTTP API (POST)
- Respond to Webhook: sends the response back to the webhook caller
- Respond to Webhook: sends the response back to the webhook caller
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 (13)
- AI Agent
@n8n/n8n-nodes-langchain.agent - Google Gemini Chat Model
@n8n/n8n-nodes-langchain.lmChatGoogleGemini - Supabase Vector Store
@n8n/n8n-nodes-langchain.vectorStoreSupabase - Embeddings Google Gemini
@n8n/n8n-nodes-langchain.embeddingsGoogleGemini - Webhook
n8n-nodes-base.webhook - If
n8n-nodes-base.if - HTTP Request
n8n-nodes-base.httpRequest - Respond to Webhook
n8n-nodes-base.respondToWebhook - Simple Memory
@n8n/n8n-nodes-langchain.memoryBufferWindow - Manual Trigger
n8n-nodes-base.manualTrigger - Google Sheets
n8n-nodes-base.googleSheets - Code
n8n-nodes-base.code - Default Data Loader
@n8n/n8n-nodes-langchain.documentDefaultDataLoader
From the author
Quick overview This workflow ingests FAQs from Google Sheets into a Supabase vector table using Google Gemini embeddings, then serves a webhook-based support chatbot that answers only from that FAQ knowledge base and escalates unanswered questions to a human…