Supabase Insertion & Upsertion & Retrieval

INSERTING - it's important to use the same embedding model when for any interaction with your vector database (inserting, upserting and retrieval)

Workflow Structure (16 nodes)
100%
Google Drive
Google Drive
Langchain.embeddings Open Ai
Embeddings OpenAI Insertion
Langchain.vector Store Supabase
Insert Documents
Langchain.document Default Data Loader
Default Data Loader
Langchain.text Splitter Recursive Character Text Splitter
Recursive Character Text Splitter1
Langchain.chat Trigger
When chat message received
Langchain.lm Chat Open Ai
OpenAI Chat Model
Langchain.chain Retrieval Qa
Question and Answer Chain
Langchain.vector Store Supabase
Retrieve by Query
Langchain.retriever Vector Store
Vector Store Retriever
Set
Customize Response
Set
Placeholder (File/Content to Upsert)
Langchain.vector Store Supabase
Update Documents
Langchain.embeddings Open Ai
Embeddings OpenAI Upserting
Langchain.embeddings Open Ai
Embeddings OpenAI Retrieval
Supabase
Retrieve Rows from Table
Node Types:
action
default
logic
transform
trigger
Requires credentials

Prerequisites

No credentials required!

This workflow can be imported and used immediately.

Complexity

Moderate

Some experience helpful. Multiple integrations or logic.

Setup time: ~15 min
Score: 34/100

When to Use This Workflow

Real-time Response

React instantly when events happen - new orders, form submissions, or API calls.

Zero delay between trigger and action for time-sensitive workflows.

Time Savings

Replace repetitive manual tasks with reliable automation.

Reclaim hours every week for higher-value work.

Error Reduction

Eliminate human error from routine processes with consistent automation.

Improve accuracy and reliability across your workflows.

workflow.json
{
  "meta": {
    "instanceId": "1a23006df50de49624f69e85993be557d137b6efe723a867a7d68a84e0b32704"
  },
  "nodes": [
    {
      "id": "54065cc9-047c-4741-95f6-cec3e352abd7",
      "name": "Google Drive",
      "type": "n8n-nodes-base.googleDrive",
      "position": [
        2700,
        -1840
      ],
      "parameters": {
        "fileId": {
          "__rl": true,
          "mode": "url",
          "value": "https://drive.google.com/file/d/xxxxxxxxxxxxxxx/view"
        },
        "options": {},
...

Workflow Details

Nodes
21
Trigger
Event
Source
awesome
Added
Dec 4, 2025

Need Help?

Check out the official n8n documentation for detailed guides.

Related Workflows

Ask questions about a PDF using AI

Load data into database Fetch file from Google Drive, split it into chunks and insert into Pinecone index

Google-drive
Textsplitterrecursivecharactertextsplitter
Embeddingsopenai
Documentdefaultdataloader
16 nodesEvent
Curated

RAG on living data

Switch trigger (optional) If you are on the cloud plan, consider switching to the Notion Trigger Node instead, to save o...

Embeddingsopenai
Textsplittertokensplitter
Chainretrievalqa
Retrievervectorstore
34 nodesEvent
Curated

Chat with PDF docs using AI (quoting sources)

1. Setup: Fetch file from Google Drive, split it into chunks and insert into a vector database Note that running this pa...

Embeddingsopenai
Documentdefaultdataloader
Google-drive
Chat
22 nodesEvent
Curated

AI Agent To Chat With Files In Supabase Storage

Replace Storage name, database ID and credentials.

Http-request
Documentdefaultdataloader
Textsplitterrecursivecharactertextsplitter
Embeddingsopenai
33 nodesEvent
Curated

Advanced AI Demo (Presented at AI Developers #14 meetup)

![h](https://i.postimg.cc/9XLvL5dL/slide-sf-talk.pngfull-width)

Slack
Textsplitterrecursivecharactertextsplitter
Embeddingsopenai
Documentdefaultdataloader
39 nodesEvent
Curated

BambooHR AI-Powered Company Policies and Benefits Chatbot

STEP 1: Retrieve company policies and load them into a vector store

Documentdefaultdataloader
Embeddingsopenai
Textsplitterrecursivecharactertextsplitter
Memorybufferwindow
50 nodesEvent
Curated