AI Agents

Customer insights with Qdrant and Information Extractor

37 nodes 239 160 Automatic trigger
Download

Workflow Description

An advanced automation workflow that extracts and analyzes customer data from multiple sources using AI, stores insights in Qdrant vector database, and populates analytics reports in spreadsheets with social media integration.

How it works

  1. 1.Load documents and partition text using Text Splitter for processing
  2. 2.Generate vector embeddings via OpenAI and persist them in Qdrant
  3. 3.Extract structured insights using Information Extractor and large language models
  4. 4.Query the vector store and retrieve relevant customer data based on searches
  5. 5.Export extracted intelligence to Google Sheets for reporting and analysis
  6. 6.Integrate with Twitter/X to publish insights or monitor customer conversations

Use cases

  • Analyze customer feedback and sentiments from documents and social channels
  • Build a searchable semantic knowledge base for rapid customer intelligence retrieval
  • Automate comprehensive reporting on customer behavior and market trends
  • Discover hidden patterns and actionable insights in large-scale customer datasets

Requirements

  • Valid API keys for OpenAI, Qdrant, Google Sheets, and Twitter/X
  • Customer documents or data in supported formats (PDF, text, local files)
  • Understanding of vector embeddings and semantic search principles
  • Proper access permissions for spreadsheets and social media accounts

Service Value

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

Apps Used

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

Details

Trigger Automatic trigger
Nodes 37
Apps 6
Views 239
Downloads 160

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

/

When clicking ‘Test workflow’

Manual Trigger

#1

Zip Entries

Set

#2

Extract Reviews

HTML Page

#3

Reviews to List

Split Out

#4

Default Data Loader

Document Default Data Loader

#5

Recursive Character Text Splitter

Text Splitter Recursive Character Text Splitter

#6

Embeddings OpenAI

OpenAI

#7

Set Variables

Set

#8

Get Payload of Points

HTTP Request

#9

Clusters To List

Split Out

#10

OpenAI Chat Model

OpenAI

#11

Only Clusters With 3+ points

Filter

#12

Set Variables1

Set

#13

Find Reviews

HTTP Request

#14

Prep Output For Export

Set

#15

Export To Sheets

Google Sheets

#16

Clear Existing Reviews

HTTP Request

#17

Trigger Insights

Execute Workflow

#18

Prep Values For Trigger

Set

#19

Execute Workflow Trigger

Execute Workflow Trigger

#20

Sticky Note

Sticky Note

#21

Sticky Note1

Sticky Note

#22

Get TrustPilot Page

HTTP Request

#23

Sticky Note2

Sticky Note

#24

Qdrant Vector Store

Vector Store Qdrant

#25

Sticky Note3

Sticky Note

#26

Sticky Note4

Sticky Note

#27

Sticky Note5

Sticky Note

#28

Sticky Note7

Sticky Note

#29

Sticky Note8

Sticky Note

#30

Sticky Note6

Sticky Note

#31

Sticky Note9

Sticky Note

#32

Apply K-means Clustering Algorithm

Code

#33

Sticky Note10

Sticky Note

#34

Customer Insights Agent

Information Extractor

#35

Sticky Note12

Sticky Note

#36

Sticky Note11

Sticky Note

#37