Automate Trustpilot Review Export to Google Sheets
detail.loadingPreview
Effortlessly capture and organize customer feedback by automatically scraping Trustpilot reviews and exporting them to Google Sheets. Gain valuable insights into customer sentiment and identify areas for improvement.
About This Workflow
This workflow automates the process of collecting valuable customer feedback from Trustpilot and consolidating it into a structured Google Sheet. By leveraging n8n, you can set up a reliable system to continuously gather reviews, saving you manual effort and providing real-time access to customer opinions. The workflow is designed to be easily configurable, allowing you to specify the company you want to scrape and the desired number of review pages. It then intelligently parses the review data, extracting key information such as the review date, author, rating, heading, and body, making it ready for analysis and action. This is an essential tool for businesses looking to actively manage their online reputation and understand their customer base better.
Key Features
- Automatically scrape Trustpilot reviews for any company.
- Configure the number of pages to retrieve for comprehensive data.
- Extract key review details including author, rating, date, and content.
- Save valuable time and resources with a fully automated process.
- Prepare your data for in-depth analysis and reporting.
How To Use
- Trigger the Workflow: Start by clicking the 'Test workflow' button.
- Configure Company & Pages: Locate the 'Sticky Note' node and update the
company_idto the name of the company you wish to scrape (e.g.,n8n.io). Adjust themax_pagevalue in the 'Global' node to set the maximum number of pages you want to scrape. - Review and Adjust: The 'Get reviews' node fetches data from Trustpilot. The 'Parse reviews' node, using Cheerio and JavaScript, extracts the relevant review information. You can review and modify the parsing logic within this node if needed.
- Data Transformation (Optional): The 'HelpfulCrowd edits' node (and potentially subsequent nodes not shown) can be used to further format or map the extracted review data to your desired output format for Google Sheets or other destinations.
Apps Used
Workflow JSON
{
"id": "b69d0779-e6e3-477d-94a7-326a33fdac93",
"name": "Automate Trustpilot Review Export 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: b69d0779-e6e3...
About the Author
Free n8n Workflows Official
System Admin
The official repository for verified enterprise-grade workflows.
Statistics
Related Workflows
Discover more workflows you might like
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.
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.