Files & Documents

Extract Google Drive Documents and Answer Questions Intelligently

17 nodes 116 85 Automatic trigger
Download

Workflow Description

Automation that loads documents from Google Drive, splits them into chunks, stores them in a vector database, and answers user questions using OpenAI models with high accuracy. Perfect for organizations needing intelligent document retrieval and question-answering.

How it works

  1. 1.Trigger automation when receiving a query through the interface or webhook
  2. 2.Load documents from specified Google Drive folders automatically
  3. 3.Split document content into small, processable text chunks
  4. 4.Convert chunks to vectors and store them in Qdrant database
  5. 5.Search vectors to find content most relevant to the question
  6. 6.Send results with the question to OpenAI model and deliver the answer

Use cases

  • Answer employee questions about company policies and instructions stored in Drive
  • Analyze project reports and extract required information without manual reading
  • Provide customer self-service support through intelligent knowledge base search
  • Automate large document review and answer specific inquiries

Requirements

  • Google Drive account containing documents to analyze
  • OpenAI API keys for accessing language models and embeddings
  • Qdrant configuration for efficient vector storage and retrieval

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 Text Splitter Vector Store Chat Trigger LLM Chain OpenAI

Details

Trigger Automatic trigger
Nodes 17
Apps 7
Views 116
Downloads 85

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 (17)

/

Sticky Note1

Sticky Note

#1

When clicking "Execute Workflow"

Manual Trigger

#2

Google Drive

Google Drive

#3

Sticky Note

Sticky Note

#4

Sticky Note2

Sticky Note

#5

Default Data Loader

Document Default Data Loader

#6

Recursive Character Text Splitter1

Text Splitter Recursive Character Text Splitter

#7

Qdrant Vector Store

Vector Store Qdrant

#8

When chat message received

Chat Trigger

#9

Webhook

Webhook

#10

Retrieval QA Chain

Chain Retrieval Qa

#11

Vector Store Retriever

Retriever Vector Store

#12

Qdrant Vector Store1

Vector Store Qdrant

#13

OpenAI Chat Model

OpenAI

#14

Embeddings OpenAI1

OpenAI

#15

Embeddings OpenAI

OpenAI

#16

Respond to Webhook

Webhook

#17