AI-powered RAG Q&A chatbot with OpenAI, Google Sheets, Glide & Supabase
Needs changesWhat this workflow does
This AI workflow has 28 nodes and runs when an HTTP GET request hits its webhook URL (plus 3 other triggers). Along the way it connects Google Calendar, OpenAI Chat Model, Qdrant Vector Store and Embeddings OpenAI and 2 more.
How it runs
Trigger: When an HTTP GET request hits its webhook URL (plus 3 other triggers).
- Retrive Agent (AI Agent): runs an AI agent, with model: OpenAI Chat Model; 1 tool (RAG)
- Create collection (HTTP Request): calls an HTTP API
- Refresh collection (HTTP Request): calls an HTTP API
- Concert start date (Basic LLM Chain): sends a prompt to an LLM, with model: OpenAI Chat Model; output parser: Structured Output Parser
- API URL Tracking (HTTP Request): calls an HTTP API
- Webhook RAG response (Respond to Webhook): sends the response back to the webhook caller
- Get folder (Google Drive): uses Google Drive
- Google Calendar: uses Google Calendar
- Tracking response (Edit Fields (Set)): sets or maps fields
- Download Files (Google Drive): uses Google Drive
…plus 4 more steps. See the full node list below.
Services it uses
Before you upgrade to n8n 3.0
1 thing in this workflow is removed in n8n 3.0. Fix it before you upgrade:
- AI Agent v1 (old agent modes) in Retrive Agent (v1.7): replace with Latest AI Agent node (Tools Agent). For SQL Agent, use a Postgres or MySQL tool with a recent AI Agent.
Rather not rewrite it? Many of these flows can be rebuilt in Make (free plan).
| Removed in 3.0 | Replace with |
|---|---|
| AI Agent v1 (old agent modes) Retrive Agent (v1.7) | Latest AI Agent node (Tools Agent). For SQL Agent, use a Postgres or MySQL tool with a recent AI Agent. |
Nodes used (16)
- Webhook
n8n-nodes-base.webhook - Google Calendar
n8n-nodes-base.googleCalendar - OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi - Basic LLM Chain
@n8n/n8n-nodes-langchain.chainLlm - Qdrant Vector Store
@n8n/n8n-nodes-langchain.vectorStoreQdrant - Embeddings OpenAI
@n8n/n8n-nodes-langchain.embeddingsOpenAi - Vector Store Question Answer Tool
@n8n/n8n-nodes-langchain.toolVectorStore - AI Agent
@n8n/n8n-nodes-langchain.agent - Edit Fields (Set)
n8n-nodes-base.set - Respond to Webhook
n8n-nodes-base.respondToWebhook - HTTP Request
n8n-nodes-base.httpRequest - Structured Output Parser
@n8n/n8n-nodes-langchain.outputParserStructured - Manual Trigger
n8n-nodes-base.manualTrigger - Google Drive
n8n-nodes-base.googleDrive - Default Data Loader
@n8n/n8n-nodes-langchain.documentDefaultDataLoader - Token Splitter
@n8n/n8n-nodes-langchain.textSplitterTokenSplitter
From the author
Automate AI-Powered RAG System with Contextual Q&A, Google Sheets Integration, and Glide Frontend—Powered by n8n, OpenAI, Supabase, and Google Apps Script. Tools & Services Used Glide (Frontend for user interactions) Google Sheets (Stores questions and…