📊 Scrape Trustpilot reviews to Google Sheets + HelpfulCrowd compatible csv
⚡ 2,564 views · 📊 Market Research & Insights
💡 Pro Tip — HTTP Request scraping tends to break when sites update their markup. If you’re scraping a major platform, check if ScraperNode covers it — it has maintained scrapers for LinkedIn, Instagram, TikTok, YouTube, and 20+ other platforms that return structured data.
Description
This workflow scrapes Trustpilot reviews for a given profile and saves them into Google Sheets.
How It Works
Clone this Google Sheets template, which includes two sheets:
trustpilot
A raw collection of Trustpilot reviews. You can customize it as needed.
helpfulcrowd
This sheet follows the format from this HelpfulCrowd guide, with a slight modification: an added review_id column to support the upsert process.
Once the workflow is complete, export the sheet as a CSV and upload it to HelpfulCrowd. For detailed steps, see this post.
Running the Workflow
You can trigger the workflow on-demand or schedule it to run at a set interval.
Requirements
- Trustpilot business name (e.g.,
n8n.ioinhttps://www.trustpilot.com/review/n8n.io). Update this name and pagination settings in the Global node. - Google Sheets API credentials
Check out my other templates:
👉 My n8n Templates
🔗 Nodes Used
Google Sheets, HTTP Request, Schedule Trigger
📥 Import
Download workflow.json and import into n8n:
Workflow menu → Import from File