This workflow automates the process of scraping Trustpilot reviews, parsing review data, and exporting it to Google Sheets. Designed for managing customer feedback, it simplifies collection and organization of reviews for analysis or display. Users can customize the company name and maximum pages to scrape, making it flexible for different business needs.
The automation begins with a manual trigger or schedule trigger, allowing for on-demand or scheduled review scraping. A sticky note provides instructions to modify the company name and page limit. The workflow then makes an HTTP request to Trustpilot, fetching reviews with pagination support, controlled by the maximum pages setting.
The fetched HTML content is parsed using a code node that utilizes Cheerio to extract reviews from JSON data embedded within the page. It iterates over each page of reviews, collecting data such as date, author, review body, rating, and location.
The reviews are then split into individual items. For each review, data is normalized and prepared for upload. Some reviews are processed through a helper ‘HelpfulCrowd edits’ node, which formats the review data into a specified schema. The final step involves appending or updating the review data in Google Sheets, enabling continuous review management and analysis.
This workflow is ideal for businesses seeking to automate the collection of recent customer reviews from Trustpilot, streamline review analysis, or populate reviews into WordPress sites or CRMs for display or further processing.
Reviews
There are no reviews yet.