Trustpilot Insights Scraper: Auto Reviews via Bright Data + Google Sheets Sync
Description
Categories
🤖 AI & Machine Learning
Nodes Used
n8n-nodes-base.ifn8n-nodes-base.ifn8n-nodes-base.waitn8n-nodes-base.stickyNoten8n-nodes-base.stickyNoten8n-nodes-base.stickyNoten8n-nodes-base.stickyNoten8n-nodes-base.stickyNoten8n-nodes-base.stickyNoten8n-nodes-base.stickyNote
PriceGratuit
Views0
Last Updated11/28/2025
workflow.json
{
"id": "LVt5qJz73ARtrzki",
"meta": {
"instanceId": "bc8ca75c203589705ae2e446cad7181d6f2a7cc1766f958ef9f34810e53b8cb2",
"templateCredsSetupCompleted": true
},
"name": "Trustpilot Insights Scraper: Auto Reviews via Bright Data + Google Sheets Sync",
"tags": [],
"nodes": [
{
"id": "692eb2f7-b579-4df6-b3a0-d98d9ab8981b",
"name": "If",
"type": "n8n-nodes-base.if",
"position": [
1120,
-100
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "f01bd215-c406-493c-a6e4-2b8ec5686b44",
"operator": {
"type": "number",
"operation": "notEquals"
},
"leftValue": "={{ $json.records }}",
"rightValue": "={{ 0 }}"
}
]
}
},
"typeVersion": 2.2
},
{
"id": "f70d4133-f80a-4836-a312-7f5bb0396ad1",
"name": "Sticky Note",
"type": "n8n-nodes-base.stickyNote",
"position": [
-320,
-200
],
"parameters": {
"color": 3,
"height": 340,
"content": "1. 📝 **Form Trigger Node**\n - Accepts manual input from the user.\n - Field: `Trustpilot Website URL`"
},
"typeVersion": 1
},
{
"id": "d202eb3f-2807-4678-94d9-3ec456b8f9ef",
"name": "Sticky Note1",
"type": "n8n-nodes-base.stickyNote",
"position": [
300,
-220
],
"parameters": {
"color": 5,
"width": 260,
"height": 360,
"content": "3. ⌛ **Snapshot Progress Check**\n - Receives a `snapshot_id` from Bright Data.\n - Sends a GET request to check if the snapshot (scraped data) is ready."
},
"typeVersion": 1
},
{
"id": "6baef22b-c091-4da0-ad6f-86f6522c2799",
"name": "Sticky Note2",
"type": "n8n-nodes-base.stickyNote",
"position": [
-60,
-240
],
"parameters": {
"color": 4,
"width": 320,
"height": 380,
"content": "2. 🌐 **HTTP Request (Trigger Scraping on Bright Data)**\n - Sends a POST request to Bright Data's dataset trigger API.\n - Initiates scraping for the given Trustpilot URL using a specific dataset ID."
},
"typeVersion": 1
},
{
"id": "8023a4fa-f019-4fc9-b266-1b549aaf4fc7",
"name": "Sticky Note3",
"type": "n8n-nodes-base.stickyNote",
"position": [
600,
-240
],
"parameters": {
"color": 6,
"width": 320,
"height": 360,
"content": "5. ✅ **IF Node (Check Completion)**\n - Checks if the snapshot status is `\"ready\"`.\n - If yes, proceeds to fetch data.\n - If no, loops back to the wait/check cycle."
},
"typeVersion": 1
},
{
"id": "6368fcdb-265f-43da-b35e-a2d222abafe4",
"name": "Sticky Note4",
"type": "n8n-nodes-base.stickyNote",
"position": [
1000,
100
],
"parameters": {
"color": 3,
"width": 340,
"height": 220,
"content": "4. 🕒 **Wait Node**\n - If the snapshot is not ready, pauses for 1 minute before re-checking."
},
"typeVersion": 1
},
{
"id": "be4cb244-46b8-418e-b37c-59944429ccb1",
"name": "Sticky Note5",
"type": "n8n-nodes-base.stickyNote",
"position": [
960,
-220
],
"parameters": {
"width": 420,
"height": 300,
"content": "5. ✅ **IF Node (Check Completion)**\n - Checks if the snapshot status is `\"ready\"`.\n - If yes, proceeds to fetch data.\n - If no, loops back to the wait/check cycle."
},
"typeVersion": 1
},
{
"id": "328afff1-c3a8-4f15-8a97-21f6da451661",
"name": "Sticky Note6",
"type": "n8n-nodes-base.stickyNote",
"position": [
1400,
-220
],
"parameters": {
"color": 2,
"width": 320,
"height": 280,
"content": "6. 📥 **Download Final Snapshot**\n - Once ready, pulls the complete review data using the snapshot ID."
},
"typeVersion": 1
},
{
"id": "f827fd07-db39-41c6-930b-d97a8871f7e5",
"name": "Sticky Note7",
"type": "n8n-nodes-base.stickyNote",
"position": [
1740,
-320
],
"parameters": {
"color": 4,
"width": 440,
"height": 420,
"content": "7. 📊 **Google Sheets (Append)**\n - Appends the extracted review data into a connected Google Sheet.\n - Sheet name: `Trustpilot`\n - Fields mapped include: \n - `company_name`, `review_rating`, `review_title`, `review_content`, `review_date`, `reviewer_name`, `company_location`, `company_overall_rating`, etc."
},
"typeVersion": 1
},
{
"id": "d3ec88b4-d50e-4a79-a4d2-64d3d3ba2149",
"name": "Form Trigger",
"type": "n8n-nodes-base.formTrigger",
"position": [
-260,
-80
],
"webhookId": "1723fa3f-8043-4c18-b55d-0f6ee38fb14b",
"parameters": {
"options": {},
"formTitle": "Website URL",
"formFields": {
"values": [
{
"fieldLabel": "Trustpilot Website URL"
}
]
}
},
"typeVersion": 2.2
},
{
"id": "168ee4eb-7b55-4f85-9a29-639d46037548",
"name": "POST to Bright Data",
"type": "n8n-nodes-base.httpRequest",
"position": [
20,
-80
],
"parameters": {
"url": "https://api.brightdata.com/datasets/v3/trigger",
"method": "POST",
"options": {},
"jsonBody": "={\n \"input\": [\n {\n \"url\": \"{{ $json['Trustpilot Website URL'] }}\"\n }\n ],\n \"custom_output_fields\": [\n \"company_name\",\n \"review_id\",\n \"review_date\",\n \"review_rating\",\n \"review_title\",\n \"review_content\",\n \"is_verified_review\",\n \"review_date_of_experience\",\n \"reviewer_location\",\n \"reviews_posted_overall\",\n \"review_replies\",\n \"review_useful_count\",\n \"reviewer_name\",\n \"company_logo\",\n \"url\",\n \"company_rating_name\",\n \"company_overall_rating\",\n \"is_verified_company\",\n \"company_total_reviews\",\n \"5_star\",\n \"4_star\",\n \"3_star\",\n \"2_star\",\n \"1_star\",\n \"company_about\",\n \"company_email\",\n \"company_phone\",\n \"company_location\",\n \"company_country\",\n \"breadcrumbs\",\n \"company_category\",\n \"company_id\",\n \"company_website\",\n \"company_other_categories\",\n \"review_url\",\n \"date_posted\"\n ]\n}\n",
"sendBody": true,
"sendQuery": true,
"sendHeaders": true,
"specifyBody": "json",
"queryParameters": {
"parameters": [
{
"name": "dataset_id",
"value": "gd_lm5zmhwd2sni130p"
},
{
"name": "include_errors",
"value": "true"
},
{
"name": "limit_multiple_results",
"value": "2"
}
]
},
"headerParameters": {
"parameters": [
{
"name": "Authorization",
"value": "Bearer BRIGHT_DATA_API_KEY"
}
]
}
},
"typeVersion": 4.2
},
{
"id": "01ec7dc1-1eb8-40bc-ba3b-17c3d4835a91",
"name": "GET - snapshot status",
"type": "n8n-nodes-base.httpRequest",
"position": [
380,
-80
],
"parameters": {
"url": "=https://api.brightdata.com/datasets/v3/progress/{{ $json.snapshot_id }}",
"options": {},
"sendQuery": true,
"sendHeaders": true,
"queryParameters": {
"parameters": [
{
"name": "format",
"value": "json"
}
]
},
"headerParameters": {
"parameters": [
{
"name": "Authorization",
"value": "Bearer BRIGHT_DATA_API_KEY"
}
]
}
},
"typeVersion": 4.2
},
{
"id": "ec1923d4-4db3-4c29-8857-0c833fc3f28d",
"name": "Wait_1_mins",
"type": "n8n-nodes-base.wait",
"position": [
1120,
180
],
"webhookId": "d11ab78e-c0c9-4dca-a9ba-b750f5555cf7",
"parameters": {
"unit": "minutes",
"amount": 1
},
"typeVersion": 1.1
},
{
"id": "a0fd1234-8e57-478d-91de-e20d0dab35f4",
"name": "IF snapshot_id not ready than wait",
"type": "n8n-nodes-base.if",
"position": [
660,
-80
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "b9213a26-9b0d-4742-8b38-5b839da95875",
"operator": {
"name": "filter.operator.equals",
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $json.status }}",
"rightValue": "ready"
}
]
}
},
"typeVersion": 2.2
},
{
"id": "6319106e-d597-46ce-8904-5c91495973b4",
"name": "GET - snapshot download",
"type": "n8n-nodes-base.httpRequest",
"position": [
1520,
-120
],
"parameters": {
"url": "=https://api.brightdata.com/datasets/v3/snapshot/{{ $json.snapshot_id }}",
"options": {},
"sendQuery": true,
"sendHeaders": true,
"queryParameters": {
"parameters": [
{
"name": "format",
"value": "json"
}
]
},
"headerParameters": {
"parameters": [
{
"name": "Authorization",
"value": "Bearer BRIGHT_DATA_API_KEY"
}
]
}
},
"typeVersion": 4.2
},
{
"id": "82343dcd-53bb-47a1-989a-c25854fad4cf",
"name": "Google Sheets (Append)",
"type": "n8n-nodes-base.googleSheets",
"position": [
1820,
-120
],
"parameters": {
"columns": {
"value": {},
"schema": [
{
"id": "company_name",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "company_name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "review_id",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "review_id",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "review_date",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "review_date",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "review_rating",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "review_rating",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "review_title",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "review_title",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "review_content",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "review_content",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "is_verified_review",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "is_verified_review",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "review_date_of_experience",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "review_date_of_experience",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "reviewer_location",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "reviewer_location",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "reviews_posted_overall",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "reviews_posted_overall",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "review_replies",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "review_replies",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "review_useful_count",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "review_useful_count",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "reviewer_name",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "reviewer_name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "company_logo",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "company_logo",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "url",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "url",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "company_rating_name",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "company_rating_name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "company_overall_rating",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "company_overall_rating",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "is_verified_company",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "is_verified_company",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "company_total_reviews",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "company_total_reviews",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "5_star",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "5_star",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "4_star",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "4_star",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "3_star",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "3_star",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "2_star",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "2_star",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "1_star",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "1_star",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "company_about",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "company_about",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "company_email",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "company_email",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "company_phone",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "company_phone",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "company_location",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "company_location",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "company_country",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "company_country",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "breadcrumbs",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "breadcrumbs",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "company_category",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "company_category",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "company_id",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "company_id",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "company_website",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "company_website",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "review_url",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "review_url",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "date_posted",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "date_posted",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "autoMapInputData",
"matchingColumns": [],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "append",
"sheetName": {
"__rl": true,
"mode": "list",
"value": 517712189,
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1yQ10Q2qSjm-hhafHF2sXu-hohurW5_KD8fIv4IXEA3I/edit#gid=517712189",
"cachedResultName": "Trustpilot "
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1yQ10Q2qSjm-hhafHF2sXu-hohurW5_KD8fIv4IXEA3I",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1yQ10Q2qSjm-hhafHF2sXu-hohurW5_KD8fIv4IXEA3I/edit?usp=drivesdk",
"cachedResultName": "BrightData"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "XCL97my4dJfPlzXS",
"name": "Google Sheets [email protected]"
}
},
"typeVersion": 4.6
}
],
"active": false,
"pinData": {},
"settings": {
"executionOrder": "v1"
},
"versionId": "dd3afc3c-91fc-474e-99e0-1b25e62ab392",
"connections": {
"If": {
"main": [
[
{
"node": "GET - snapshot download",
"type": "main",
"index": 0
}
]
]
},
"Wait_1_mins": {
"main": [
[
{
"node": "GET - snapshot status",
"type": "main",
"index": 0
}
]
]
},
"Form Trigger": {
"main": [
[
{
"node": "POST to Bright Data",
"type": "main",
"index": 0
}
]
]
},
"POST to Bright Data": {
"main": [
[
{
"node": "GET - snapshot status",
"type": "main",
"index": 0
}
]
]
},
"GET - snapshot status": {
"main": [
[
{
"node": "IF snapshot_id not ready than wait",
"type": "main",
"index": 0
}
]
]
},
"GET - snapshot download": {
"main": [
[
{
"node": "Google Sheets (Append)",
"type": "main",
"index": 0
}
]
]
},
"IF snapshot_id not ready than wait": {
"main": [
[
{
"node": "If",
"type": "main",
"index": 0
}
],
[
{
"node": "Wait_1_mins",
"type": "main",
"index": 0
}
]
]
}
}
}