AI Agents

Connect Google Drive with Supabase

21 nodes 234 156 Automatic trigger
Download

Workflow Description

An automation template that links Google Drive documents to Supabase database, extracting text content and converting it into vector embeddings for intelligent search and retrieval through an OpenAI language model.

How it works

  1. 1.Receive documents from Google Drive or trigger queries via chat interface
  2. 2.Split document content into indexable text chunks using a recursive text splitter
  3. 3.Convert text chunks into vector embeddings via OpenAI and store them in Supabase
  4. 4.Retrieve the most relevant chunks from the database based on query similarity
  5. 5.Process the query and retrieved chunks through an LLM chain to generate evidence-backed answers

Use cases

  • Build an intelligent search system for documents stored in Google Drive with instant answers to questions
  • Create a smart assistant that understands large collections of files, contracts, and reports and responds efficiently
  • Automate processing of massive documents and organize them in a searchable and rapidly retrievable format

Requirements

  • Active Google Drive account with access to the files you want to process
  • Supabase account with a database and vector store capability enabled
  • OpenAI API key for embeddings and natural language processing

Service Value

Ideal as a smart automation service combining integrations and AI to produce ready-to-use results.

Apps Used

Google Drive Document Default Data Loader LLM Chain OpenAI Vector Store Text Splitter Chat Trigger Supabase

Details

Trigger Automatic trigger
Nodes 21
Apps 8
Views 234
Downloads 156

How to Use

  1. 1.Click "Download Template"
  2. 2.Open your n8n dashboard
  3. 3.Go to Workflows > Import from File
  4. 4.Select downloaded file and configure credentials

Nodes Used (21)

/

Google Drive

Google Drive

#1

Default Data Loader

Document Default Data Loader

#2

Sticky Note

Sticky Note

#3

Sticky Note1

Sticky Note

#4

Sticky Note2

Sticky Note

#5

Sticky Note3

Sticky Note

#6

Question and Answer Chain

Chain Retrieval Qa

#7

OpenAI Chat Model

OpenAI

#8

Vector Store Retriever

Retriever Vector Store

#9

Recursive Character Text Splitter1

Text Splitter Recursive Character Text Splitter

#10

Customize Response

Set

#11

When chat message received

Chat Trigger

#12

Retrieve by Query

Vector Store Supabase

#13

Embeddings OpenAI Retrieval

OpenAI

#14

Embeddings OpenAI Insertion

OpenAI

#15

Placeholder (File/Content to Upsert)

Set

#16

Embeddings OpenAI Upserting

OpenAI

#17

Insert Documents

Vector Store Supabase

#18

Retrieve Rows from Table

Supabase

#19

Sticky Note4

Sticky Note

#20

Update Documents

Vector Store Supabase

#21