Customer insights with Qdrant and Information Extractor
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.Load documents and partition text using Text Splitter for processing
- 2.Generate vector embeddings via OpenAI and persist them in Qdrant
- 3.Extract structured insights using Information Extractor and large language models
- 4.Query the vector store and retrieve relevant customer data based on searches
- 5.Export extracted intelligence to Google Sheets for reporting and analysis
- 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
Details
How to Use
- 1.Click "Download Template"
- 2.Open your n8n dashboard
- 3.Go to Workflows > Import from File
- 4.Select downloaded file and configure credentials
Nodes Used (37)
When clicking ‘Test workflow’
Manual Trigger
Zip Entries
Set
Extract Reviews
HTML Page
Reviews to List
Split Out
Default Data Loader
Document Default Data Loader
Recursive Character Text Splitter
Text Splitter Recursive Character Text Splitter
Embeddings OpenAI
OpenAI
Set Variables
Set
Get Payload of Points
HTTP Request
Clusters To List
Split Out
OpenAI Chat Model
OpenAI
Only Clusters With 3+ points
Filter
Set Variables1
Set
Find Reviews
HTTP Request
Prep Output For Export
Set
Export To Sheets
Google Sheets
Clear Existing Reviews
HTTP Request
Trigger Insights
Execute Workflow
Prep Values For Trigger
Set
Execute Workflow Trigger
Execute Workflow Trigger
Sticky Note
Sticky Note
Sticky Note1
Sticky Note
Get TrustPilot Page
HTTP Request
Sticky Note2
Sticky Note
Qdrant Vector Store
Vector Store Qdrant
Sticky Note3
Sticky Note
Sticky Note4
Sticky Note
Sticky Note5
Sticky Note
Sticky Note7
Sticky Note
Sticky Note8
Sticky Note
Sticky Note6
Sticky Note
Sticky Note9
Sticky Note
Apply K-means Clustering Algorithm
Code
Sticky Note10
Sticky Note
Customer Insights Agent
Information Extractor
Sticky Note12
Sticky Note
Sticky Note11
Sticky Note