Bright Data to Google Sheets, Trustpilot reviews logged
Review research sounds simple until you’re copying Trustpilot snippets into a spreadsheet at 11pm, trying not to miss dates, ratings, or “verified” badges. It’s slow. It’s messy. And the moment you track more than one brand, it turns into a weekly chore.
This Trustpilot Sheets automation hits marketing leads first, honestly, but product teams and small agency owners feel it too. You get every review captured as clean rows in Google Sheets, ready for analysis, reporting, and copy. No more “we’ll update it later.”
Below you’ll see how the workflow pulls Trustpilot reviews through Bright Data, waits until the scrape is actually finished, then logs everything into a sheet your whole team can use.
How This Automation Works
The full n8n workflow, from trigger to final output:
n8n Workflow Template: Bright Data to Google Sheets, Trustpilot reviews logged
flowchart LR
subgraph sg0["Form Flow"]
direction LR
n0@{ icon: "mdi:swap-horizontal", form: "rounded", label: "If", pos: "b", h: 48 }
n1["<div style='background:#f5f5f5;padding:10px;border-radius:8px;display:inline-block;border:1px solid #e0e0e0'><img src='https://flowpast.com/wp-content/uploads/n8n-workflow-icons/form.svg' width='40' height='40' /></div><br/>Form Trigger"]
n2["<div style='background:#f5f5f5;padding:10px;border-radius:8px;display:inline-block;border:1px solid #e0e0e0'><img src='https://flowpast.com/wp-content/uploads/n8n-workflow-icons/httprequest.dark.svg' width='40' height='40' /></div><br/>POST to Bright Data"]
n3["<div style='background:#f5f5f5;padding:10px;border-radius:8px;display:inline-block;border:1px solid #e0e0e0'><img src='https://flowpast.com/wp-content/uploads/n8n-workflow-icons/httprequest.dark.svg' width='40' height='40' /></div><br/>GET - snapshot status"]
n4@{ icon: "mdi:cog", form: "rounded", label: "Wait_1_mins", pos: "b", h: 48 }
n5@{ icon: "mdi:swap-horizontal", form: "rounded", label: "IF snapshot_id not ready tha..", pos: "b", h: 48 }
n6["<div style='background:#f5f5f5;padding:10px;border-radius:8px;display:inline-block;border:1px solid #e0e0e0'><img src='https://flowpast.com/wp-content/uploads/n8n-workflow-icons/httprequest.dark.svg' width='40' height='40' /></div><br/>GET - snapshot download"]
n7@{ icon: "mdi:database", form: "rounded", label: "Google Sheets (Append)", pos: "b", h: 48 }
n0 --> n6
n4 --> n3
n1 --> n2
n2 --> n3
n3 --> n5
n6 --> n7
n5 --> n0
n5 --> n4
end
%% Styling
classDef trigger fill:#e8f5e9,stroke:#388e3c,stroke-width:2px
classDef ai fill:#e3f2fd,stroke:#1976d2,stroke-width:2px
classDef aiModel fill:#e8eaf6,stroke:#3f51b5,stroke-width:2px
classDef decision fill:#fff8e1,stroke:#f9a825,stroke-width:2px
classDef database fill:#fce4ec,stroke:#c2185b,stroke-width:2px
classDef api fill:#fff3e0,stroke:#e65100,stroke-width:2px
classDef code fill:#f3e5f5,stroke:#7b1fa2,stroke-width:2px
classDef disabled stroke-dasharray: 5 5,opacity: 0.5
class n1 trigger
class n0,n5 decision
class n7 database
class n2,n3,n6 api
classDef customIcon fill:none,stroke:none
class n1,n2,n3,n6 customIcon
The Problem: Trustpilot review tracking doesn’t scale
When you’re relying on Trustpilot reviews for positioning, competitive research, or customer insights, “just check the page” isn’t a process. Someone has to open the site, scroll, copy content, grab the rating, find the date, then paste it somewhere that won’t break later. Do that across a few competitors and it turns into a recurring task that steals hours and still produces incomplete data. Worse, manual copy-paste misses context (like verified status or replies), so you end up arguing about accuracy instead of acting on what customers are telling you.
It adds up fast. Here’s where it breaks down in real teams.
- You lose about 2 hours a week just collecting reviews, before you’ve analyzed anything.
- Ratings and dates get entered inconsistently, which makes trend charts useless later.
- You can’t reliably compare competitors because you never capture the same fields for every company.
- Good quotes get buried in Slack messages, and nobody can find them when it’s time to write ads or landing pages.
The Solution: Scrape Trustpilot via Bright Data, log to Google Sheets
This n8n workflow turns a Trustpilot business page into structured data in Google Sheets. You start by pasting a Trustpilot website URL into a simple form (no complicated UI). n8n sends that URL to Bright Data’s dataset trigger endpoint, asking for a rich set of fields: company details, review text, rating, dates, reviewer metadata, “verified” status, and more. Bright Data returns a snapshot ID, and the workflow checks progress until the scrape is marked ready. Once it’s done, n8n downloads the results and appends them to your “Trustpilot” sheet as clean rows, so everything is searchable, filterable, and easy to share.
The workflow starts with a form submission. Then Bright Data runs the scrape while n8n polls politely (with a built-in wait) until the dataset is ready. Finally, Google Sheets gets a structured append so your sheet becomes a live review log instead of a one-off export.
What You Get: Automation vs. Results
| What This Workflow Automates | Results You’ll Get |
|---|---|
|
|
Example: What This Looks Like
Say you track 5 competitors, and you log 20 new reviews a week for each. Manually, even a quick “copy rating + date + title + text” takes maybe 2 minutes per review, which is about 3 hours weekly. With this workflow, you paste each Trustpilot URL into the form (around 5 minutes total), then wait while Bright Data runs the scrape and n8n polls in the background. Your Google Sheet fills with rows automatically, so those 3 hours turn into a short check-in and actual analysis.
What You’ll Need
- n8n instance (try n8n Cloud free)
- Self-hosting option if you prefer (Hostinger works well)
- Bright Data for triggering Trustpilot dataset scrapes
- Google Sheets to store reviews as structured rows
- Bright Data API key (get it from your Bright Data dashboard)
Skill level: Intermediate. You’ll connect credentials, paste a dataset ID, and confirm your sheet columns match the incoming fields.
Don’t want to set this up yourself? Talk to an automation expert (free 15-minute consultation).
How It Works
You submit a Trustpilot business URL. A simple n8n form trigger collects the URL you want to track, so you don’t need to edit nodes every time you switch brands.
Bright Data starts the scrape. n8n sends a POST request to Bright Data’s dataset trigger endpoint with your Trustpilot URL and a long list of requested output fields (company info, review text, rating, reviewer details, and rating distribution).
The workflow waits until the snapshot is ready. Bright Data returns a snapshot ID, then n8n checks progress. If the status isn’t ready yet, it waits about a minute and checks again. Boring, but important.
Results land in Google Sheets. Once ready, the workflow downloads the dataset snapshot and appends each item as a new row in your “Trustpilot” sheet, using consistent column mapping.
You can easily modify the output fields to match your reporting needs, or switch the destination from Google Sheets to Microsoft Excel 365 based on your team’s habits. See the full implementation guide below for customization options.
Common Gotchas
- Bright Data credentials can expire or need specific permissions. If things break, check your Bright Data API token status in the dashboard and confirm your dataset access first.
- If you’re using Wait nodes or external scraping, processing times vary. Bump up the wait duration if downstream requests fail because the snapshot is still empty.
- Google Sheets appends can “work” while still creating messy data if your header row changes. Lock the column names in your Trustpilot sheet so new fields don’t shift everything to the right.
Frequently Asked Questions
About 30 minutes if your Bright Data and Google credentials are ready.
No. You’ll paste in your API key, connect Google, and map fields once. After that, it runs from a simple form submission.
Yes. n8n has a free self-hosted option and a free trial on n8n Cloud. Cloud plans start at $20/month for higher volume. You’ll also need to factor in Bright Data usage costs based on how much you scrape.
Two options: n8n Cloud (managed, easiest setup) or self-hosting on a VPS. For self-hosting, Hostinger VPS is affordable and handles n8n well. Self-hosting gives you unlimited executions but requires basic server management.
Yes, and it’s a common tweak. Add a “competitor_name” field right after the form trigger (using an Edit Fields/Set node) and append it with each row, so filters and pivot tables stay clean. You can also adjust the Bright Data request to pull fewer or more fields depending on what your reporting actually uses. If you want separate tabs per competitor, route rows based on the submitted URL and write to different sheet names.
Usually it’s an expired or incorrect bearer token. Regenerate your Bright Data API key, update the Authorization header in the HTTP Request nodes, and run one test scrape. If it still fails, check dataset access (the dataset_id must be valid for your account) and watch for rate limiting if you’re triggering a lot of snapshots back-to-back.
A lot, but it depends on your Bright Data limits and your n8n execution capacity.
For this use case, n8n is usually the better fit because the polling loop (wait, check status, repeat) is straightforward and doesn’t rack up extra “tasks” the way some platforms do. You also get more control over the HTTP requests, headers, and payload, which matters with Bright Data. Zapier or Make can still work if you’re comfortable building a multi-step scenario and you don’t mind paying for frequent checks. If you only scrape occasionally, the difference is smaller. Talk to an automation expert if you want help choosing.
Once this is running, review tracking stops being a recurring chore and turns into a reliable input for decisions. The workflow collects the data. You use it.
Need Help Setting This Up?
Our automation experts can build and customize this workflow for your specific needs. Free 15-minute consultation—no commitment required.
