Automated Review Analysis and Insight Generation
detail.loadingPreview
Scrapes Trustpilot reviews, analyzes them for sentiment and themes, and stores insights in Google Sheets.
About This Workflow
This workflow automates the process of collecting customer reviews from Trustpilot, processing them using vector embeddings and clustering, and then generating insights. It stores the processed reviews and derived insights in a Google Sheet for further analysis.
Key Features
- Automated Review Scraping: Fetches recent reviews from a specified company on Trustpilot.
- Data Cleaning and Structuring: Organizes raw review data into a structured format.
- Vector Embedding and Storage: Utilizes OpenAI embeddings and Qdrant vector store for efficient storage and similarity search of reviews.
- Review Clustering: Groups similar reviews using clustering algorithms to identify common themes, feedback, and pain points.
- Insight Generation: Processes clustered reviews to extract key insights, sentiment, and suggested improvements.
- Google Sheets Integration: Appends processed data and generated insights to a Google Sheet.
How To Use
- Set Company ID: Update the
Set Variablesnode (f0ea6b63-c96d-4b3f-8a21-d0f2dbb4efc3) with the company's Trustpilot URL (e.g.,www.freddiesflowers.com). - Configure Qdrant: Ensure your Qdrant vector store is running and accessible, and update the
qdrantApicredentials in relevant nodes (0188986f-fbe9-4c06-892a-3cb71b52a309,a4f82a1b-5a76-46b6-a7a3-84ab09b46699,85cb48b1-0ab9-4f88-88f3-82fcfb041ebe,1f60c3a5-a47a-4313-9b29-8ea652d573f7). The collection name istrustpilot_reviews. - Configure OpenAI: Set up your OpenAI API credentials in the
OpenAI Chat Model(f21369b9-1bde-42aa-9d02-2e70234f11ed) andEmbeddings OpenAI(e22d92b8-e8e9-42aa-9d02-2e70234f11ed) nodes. - Configure Google Sheets: Update the
Export To Sheetsnode (d77daa23-6acf-4daa-bf4c-33da4d05a54c) with your Google Sheet document ID and ensure correct OAuth2 credentials are set. - Set Date Range: The
Set Variables1node (f6a6209c-d269-4238-8e92-230df7b41df9) defines the date range for fetching reviews. By default, it uses the current month. Adjustreview_date_fromandreview_date_toas needed. - Execute Workflow: Trigger the workflow using the
When clicking ‘Test workflow’node (63501cc8-77c9-4037-9f70-da23b6d20b03). - Review Output: Check the specified Google Sheet for the extracted reviews and generated insights.
Apps Used
Workflow JSON
{
"id": "fee7b8c7-7627-411d-aa5c-1ef5bf2864c0",
"name": "Automated Review Analysis and Insight Generation",
"nodes": 26,
"category": "Marketing",
"status": "active",
"version": "1.0.0"
}Note: This is a sample preview. The full workflow JSON contains node configurations, credentials placeholders, and execution logic.
Get This Workflow
ID: fee7b8c7-7627...
About the Author
SaaS_Connector
Integration Guru
Connecting CRM, Notion, and Slack to automate your life.
Statistics
Related Workflows
Discover more workflows you might like
WhatsApp AI Assistant: LLaMA 4 & Google Search for Real-Time Insights
Instantly deploy a smart AI assistant on WhatsApp, powered by Groq's lightning-fast LLaMA 4 model. This workflow enables real-time conversations, remembers context, and provides up-to-date answers by integrating live Google Search results.
AI-Powered On-Page SEO Audit & Report Automation
Instantly generate comprehensive on-page SEO technical and content audits for any website URL. This AI-powered workflow automates the entire process, from scraping the page to delivering a detailed report directly to your inbox, empowering you to optimize for better search rankings and user engagement.
Automated AI Motion Illustration Workflow with Midjourney and Kling
Unleash your creativity with this n8n workflow that automates the generation of stunning motion illustrations. It leverages the power of Midjourney for static image creation and Kling AI to transform them into dynamic videos, all managed through the PiAPI. Perfect for content creators, marketers, and social media professionals looking to produce engaging visuals at scale.