AI-powered knowledge assistant using Google Sheets, OpenAI, and Supabase Vector Search
Description An intelligent conversational AI system that provides contextual responses by combining chat history, vector database knowledge retrieval, and web search capabilities. How it Works (High-level steps) Message Detection: Google Sheets trigger monitors for new user messages and filters out already-processed entries Context Preparation: Extracts user message, retrieves chat history, and formats conversation context with system prompt Knowledge Retrieval: AI agent searches vector database
At a glance
AI-powered knowledge assistant using Google Sheets, OpenAI, and Supabase Vector Search is a ready-made n8n workflow you import as a workflow JSON file — no build required. It connects Google Sheets, OpenAI. It's free to download. Follow the 5-step import below to go live in minutes.
- Platform
- n8n
- Connects
- Google Sheets, OpenAI
- Modules
- 16
- Price
- Free
- Version
- v1.0

About this workflow
Description An intelligent conversational AI system that provides contextual responses by combining chat history, vector database knowledge retrieval, and web search capabilities. How it Works (High-level steps) Message Detection: Google Sheets trigger monitors for new user messages and filters out already-processed entries Context Preparation: Extracts user message, retrieves chat history, and formats conversation context with system prompt Knowledge Retrieval: AI agent searches vector database for relevant context using Supabase + OpenAI embeddings Response Generation: LangChain agent processes the request using: OpenAI GPT-4 language model Vector store tool for knowledge base queries SerpAPI tool for web search when needed Buffer memory for conversation continuity Response Storage: Updates Google Sheets with AI response and assigns unique timestamp ID Setup Steps Configure Google Sheets with columns: usermessage, airespond, id Set up Supabase vector store with OpenAI embeddings Connect OpenAI API credentials (GPT-4 + embeddings) Configure SerpAPI for web search functionality Set up Google Sheets trigger and update permissions
How to import this n8n workflow
- 1
Download the workflow JSON file after purchase.
- 2
Open n8n → click the menu → Import from File.
- 3
Select the downloaded JSON and import.
- 4
Set up credentials for each node that requires them.
- 5
Click Execute Workflow to test, then activate.
Setup guide
Setup guide included
Purchase to unlock the full step-by-step guide
Related N8n workflows
Save Bidsketch clients to a Google Sheets spreadsheet
LinkedIn scraping, structuring, and messaging using PhantomBuster and GPT-4
LinkedIn engagement automator with GPT-4o/Claude, human review & multilingual comments
Send AI interview briefs from resumes with GPT-4o-mini, Google Sheets and Gmail
Export Google My Business reviews to Google Sheets
Generate AI videos from text or images with Sora 2/Pro & GPT-5 enhancement
Send real-time Kubernetes(EKS/GKE/AKS) CPU spike alerts from Prometheus to Slack
Automated SEO performance collection from Google Search Console to NocoDB
Reviews
No reviews yet
Be the first to buy and share your experience.
Leave a review
Sign in to share your experience with this workflow.
Create a free account to purchase workflows.
- JSON blueprint — instant download
- Setup guide PDF included
- 5 downloads · valid 30 days
- Works with n8n
Need help setting this up?
Book a 3-hour live setup session with an Agility consultant.
- Configure live on Google Meet / Zoom
- Free follow-up if workflow has defects
- Platform expert assigned to you