AI Agents

Extract document insights using Qdrant and AI processing

42 nodes 386 172 Automatic trigger
Download

Workflow Description

Advanced automation that analyzes documents and text using OpenAI models, splits content into manageable chunks, stores them in a Qdrant vector database for intelligent retrieval, extracts key insights automatically, and publishes results to Google Sheets and X (Twitter).

How it works

  1. 1.Load documents and text content from multiple sources
  2. 2.Split content into smaller, processable segments
  3. 3.Convert segments into vector embeddings using OpenAI
  4. 4.Store vectors in Qdrant database for semantic search capability
  5. 5.Extract key information and insights using Information Extractor
  6. 6.Publish extracted insights to Google Sheets and X

Use cases

  • Analyze comprehensive reports and automatically extract essential data points
  • Process large document volumes with intelligent semantic search
  • Publish insights and summaries to social media and tracking spreadsheets
  • Build intelligent systems for automatic content classification and analysis

Requirements

  • OpenAI API key for embeddings and language model processing
  • Qdrant account and connection details for vector storage
  • Google Sheets credentials with write and update permissions
  • X (Twitter) account and API credentials for publishing

Service Value

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

Apps Used

OpenAI Document Default Data Loader Text Splitter Google Sheets Split In Batches Twitter/X Vector Store

Details

Trigger Automatic trigger
Nodes 42
Apps 7
Views 386
Downloads 172

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

/

Embeddings OpenAI

OpenAI

#1

Default Data Loader

Document Default Data Loader

#2

Convert to Question Answer Pairs

Set

#3

Recursive Character Text Splitter

Text Splitter Recursive Character Text Splitter

#4

Get Survey Results

Google Sheets

#5

Get Survey Headers

Google Sheets

#6

Extract Questions

Set

#7

Questions to List

Split Out

#8

Find All Answers

HTTP Request

#9

Get Payload of Points

HTTP Request

#10

Clusters To List

Split Out

#11

Set Variables

Set

#12

OpenAI Chat Model

OpenAI

#13

Prep Output For Export

Set

#14

Export To Sheets

Google Sheets

#15

Export To Sheets1

Google Sheets

#16

For Each Question...

Split In Batches

#17

Trigger Insights

Execute Workflow

#18

Prep Values For Trigger

Set

#19

Execute Workflow Trigger

Execute Workflow Trigger

#20

Create Insights Sheet

Google Sheets

#21

Prep Values For Export

Set

#22

Sticky Note

Sticky Note

#23

QA Pairs to List

Split Out

#24

Sticky Note1

Sticky Note

#25

Sticky Note2

Sticky Note

#26

Sticky Note3

Sticky Note

#27

Sticky Note4

Sticky Note

#28

Sticky Note5

Sticky Note

#29

Sticky Note6

Sticky Note

#30

Sticky Note7

Sticky Note

#31

Sticky Note8

Sticky Note

#32

Sticky Note9

Sticky Note

#33

Has Clusters?

If

#34

Sticky Note10

Sticky Note

#35

Sticky Note11

Sticky Note

#36

When clicking ‘Test workflow’

Manual Trigger

#37

Get Sheet Details

HTTP Request

#38

Only Clusters With 3+ points

Filter

#39

Apply K-means Clustering Algorithm

Code

#40

Qdrant Vector Store

Vector Store Qdrant

#41

Survey Insights Agent

Information Extractor

#42

Similar Templates

Analyze data with AI and auto-post to Twitter

7 nodes

Collect Hacker News, analyze with AI, and log to Google Sheets

36 nodes

Process Telegram Messages with AI and Log to Google Sheets

40 nodes

Extract and Process Notion Ideas with AI Intelligence

11 nodes

Intelligent search engine powered by AI with web discovery and content extraction

17 nodes

Automate Google Sheets data processing with intelligent agent

11 nodes