Automate Trustpilot Review Collection to Google Sheets
detail.loadingPreview
Effortlessly gather customer feedback from Trustpilot and organize it directly into a Google Sheet. This workflow automates the scraping process, saving you valuable time and providing instant insights into your customer sentiment.
About This Workflow
This n8n workflow is designed to streamline the process of collecting customer reviews from Trustpilot. It begins by prompting you to specify the company name and the maximum number of pages to scrape. Then, it sends HTTP requests to Trustpilot to fetch the review data, handling pagination automatically. The raw HTML is parsed using Cheerio to extract crucial review details such as publication date, author, review body, heading, rating, and location. Finally, the extracted data is prepared for export, allowing you to easily populate your Google Sheets with valuable customer feedback for analysis and strategic decision-making.
Key Features
- Automated Scraping: Connects to Trustpilot and retrieves reviews without manual intervention.
- Configurable Parameters: Easily set the company name and the number of pages to scrape.
- Intelligent Data Extraction: Parses complex HTML to pull out key review components.
- Organized Output: Structures review data for seamless import into Google Sheets.
- Flexible Integration: Adaptable for various data analysis and CRM needs.
How To Use
- Configure Company and Page Limit: In the 'Sticky Note' node, update the
company_idto the name of the company on Trustpilot and set themax_pagevalue to the desired number of pages to scrape. - Test the Workflow: Click the 'Test workflow' button to initiate the scraping process.
- Review Extracted Data: Examine the output of the 'Parse reviews' node to ensure the data has been extracted correctly.
- Integrate with Google Sheets: Connect the output of this workflow to a Google Sheets node (or any other desired destination) using n8n's extensive connector library to store and manage your review data.
Apps Used
Workflow JSON
{
"id": "3aaa4aca-07f9-4341-bc49-22ee69ce9475",
"name": "Automate Trustpilot Review Collection to Google Sheets",
"nodes": 24,
"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: 3aaa4aca-07f9...
About the Author
N8N_Community_Pick
Curator
Hand-picked high quality workflows from the global community.
Statistics
Related Workflows
Discover more workflows you might like
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.
Automated Multi-Platform Social Media Publisher
Streamline your social media content creation and publishing with this n8n workflow. Simply fill out a web form with your caption, media (image or video), and target platforms, and let n8n automate the posting process across multiple social networks.
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.