AutomationMart
Home/Browse/AI-powered knowledge assistant using Google Sheets, OpenAI, and Supabase Vector Search
n8n

AI-powered knowledge assistant using Google Sheets, OpenAI, and Supabase Vector Search

n8nn8n16 modulesv1.0
Google SheetsOpenAI

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
AI-powered knowledge assistant using Google Sheets, OpenAI, and Supabase Vector Search workflow diagram

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

n8n

How to import this n8n workflow

  1. 1

    Download the workflow JSON file after purchase.

  2. 2

    Open n8n → click the menu → Import from File.

  3. 3

    Select the downloaded JSON and import.

  4. 4

    Set up credentials for each node that requires them.

  5. 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

Every time a new client is created in Bidsketch, Make will automatically add that client to your Google Sheets spreadsheet as a new row. The template uses this [example spreadsheet](https://docs.google.com/spreadsheets/d/11PjS78CSImia-k1QBV9rzABZwplDfG_DHuN6XzY0eFw/edit?usp=sharing).

Free

LinkedIn scraping, structuring, and messaging using PhantomBuster and GPT-4

Description This template automates the end-to-end process of extracting professional data from LinkedIn and converting it into a usable format—ideal for recruiters, SDRs, marketers, and growth teams. With a few simple configurations, you’ll be able to trigger the flow, scrape profiles, and use AI to extract name, headline, company, role, industry, and more—without writing a single line of code. Key Features 🔗 Launch PhantomBuster Agent using a profile URL ⏳ Wait 45 seconds for Phanto

Free

LinkedIn engagement automator with GPT-4o/Claude, human review & multilingual comments

Automate LinkedIn engagement without sounding like a bot. This workflow: 🌍 Detects language & tone (German / English) 👍 Chooses the right reaction (like / celebrate / support …) 🗣 Generates a personalised comment in your voice and mentions the author 📲 Optional Telegram review – approve ✅ or regenerate ❌ before posting 💸 Runs on cost-efficient GPT-4o mini or Claude 3.5 Haiku ☁️ Publishes comment + reaction via the Unipile API Setup (≈ 15-30 min) Unipile – connect LinkedIn → copy accountid, dsn,

Free

Send AI interview briefs from resumes with GPT-4o-mini, Google Sheets and Gmail

Quick Overview This workflow runs every 15 minutes to read candidate rows from Google Sheets, download each resume PDF from Google Drive, extract text, generate an HTML interview brief using OpenAI GPT-4o-mini, email it via Gmail to the interviewer, and mark the row as Processed to avoid duplicates. How it works 1. Runs on a schedule trigger every 15 minutes. 2. Reads all candidate rows from the “Candidates” tab in Google Sheets and processes them one at a time. 3. Skips any rows where the Statu

Free

Export Google My Business reviews to Google Sheets

Every time a new review is added to your Google My Business location, Make will automatically store it in Google Sheets. The template uses this [example spreadsheet](https://docs.google.com/spreadsheets/d/1yxB_P2opiY5oS5kK_gqQzIlBR_eBQgJ78jI9ESChT3w/edit?usp=sharing).

Free

Generate AI videos from text or images with Sora 2/Pro & GPT-5 enhancement

Harness OpenAI's Sora 2 for instant video creation from text or images using fal.ai's API—powered by GPT-5 for refined prompts that ensure cinematic quality. This template processes form submissions, intelligently routes to text-to-video (with mandatory prompt enhancement) or image-to-video modes, and polls for completion before redirecting to your generated clip. 📋 What This Template Does Users submit prompts, aspect ratios (9:16 or 16:9), models (sora-2 or pro), durations (4s, 8s, or 12s),

Free

Send real-time Kubernetes(EKS/GKE/AKS) CPU spike alerts from Prometheus to Slack

Summary This workflow monitors Kubernetes pod CPU usage using Prometheus, and sends real-time Slack alerts when CPU consumption crosses a threshold (e.g., 0.8 cores). It groups pods by application name to reduce noise and improve clarity, making it ideal for observability across multi-pod deployments like Argo CD, Loki, Promtail, applications etc. 👥 Who’s it for Designed for DevOps and SRE teams and platform teams, this workflow is 100% no-code, plug-and-play, and can be easily extended

Free

Automated SEO performance collection from Google Search Console to NocoDB

Problem Monitoring SEO performance from Google Search Console (GSC) manually is repetitive and prone to human error. For marketers or analysts managing multiple domains, checking reports manually and copying data into spreadsheets or databases is time-consuming. There is a strong need for an automated solution that collects, stores, and updates SEO metrics regularly for easier analysis and dashboarding. Solution This workflow automatically pulls performance metrics from Google Search

Free

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.

Log in to review
Free
No ratings yet

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.

₹2,499/ session
3 hrs · video call
  • Configure live on Google Meet / Zoom
  • Free follow-up if workflow has defects
  • Platform expert assigned to you
Book installation session
Free