Bright Data to Google Sheets, clean SERP reports
Your competitor tracking shouldn’t live in a messy mix of browser tabs, screenshots, and “I’ll paste it later” notes. But that’s usually how it goes. One missed copy-paste, one wrong country setting, and your “SERP report” turns into a guessing game.
SEO leads feel it when reporting day hits. Marketing managers feel it when they need answers fast. Agency operators feel it when a client asks, “Did we move this week?” This SERP report automation pulls rankings into Google Sheets so you can compare keywords and countries without the manual grind.
Below you’ll see exactly what the workflow does, what you get out of it, and what to watch for when you plug in Bright Data and Sheets.
How This Automation Works
The full n8n workflow, from trigger to final output:
n8n Workflow Template: Bright Data to Google Sheets, clean SERP reports
flowchart LR
subgraph sg0["When clicking 'Execute workflow' Flow"]
direction LR
n0@{ icon: "mdi:play-circle", form: "rounded", label: "When clicking 'Execute workf..", pos: "b", h: 48 }
n1@{ icon: "mdi:database", form: "rounded", label: "Get Keywords from Sheet", pos: "b", h: 48 }
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/code.svg' width='40' height='40' /></div><br/>URL Encode Keywords"]
n3@{ icon: "mdi:swap-vertical", form: "rounded", label: "Process Keywords in Batches", pos: "b", h: 48 }
n4["<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/>Fetch Google Search Results"]
n5["<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/code.svg' width='40' height='40' /></div><br/>Extract Competitor Data from.."]
n2 --> n3
n1 --> n2
n4 --> n5
n3 --> n4
n0 --> n1
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 n0 trigger
class n1 database
class n4 api
class n2,n5 code
classDef customIcon fill:none,stroke:none
class n2,n4,n5 customIcon
The Problem: SERP tracking turns into copy-paste ops
Checking rankings for a few keywords is easy. Checking them for multiple countries, week after week, is where things fall apart. Someone searches Google, scrolls, copies URLs, grabs titles, then pastes into a sheet that never quite stays consistent. Even when you’re careful, the “same” report ends up with different formats, missing rows, and results that are hard to compare. The real cost isn’t just the time. It’s the mental load of knowing your data is kind of fragile, which makes decisions slower and less confident.
The friction compounds. Here’s where it usually breaks down.
- You spend about 10 minutes per keyword per country just gathering the basic results.
- Your sheet ends up with inconsistent columns, so analysis turns into cleanup work.
- People forget to change location settings, which quietly skews the whole dataset.
- When you need to scale from 10 keywords to 50, the process simply doesn’t scale with you.
The Solution: Bright Data SERPs into a structured Google Sheet
This workflow turns SERP collection into a repeatable system. You keep a simple input sheet called “Keywords” with two columns: the keyword and the target country code (US, GB, DE, and so on). When you run the workflow, n8n reads those rows, safely encodes each search term, then processes them in batches so you don’t hammer the API. For every keyword-country pair, it calls Bright Data’s SERP API to fetch the Google results HTML. Then a parsing step extracts the competitor details you actually care about (domain/name, URL, title, snippet) and prepares clean fields for your spreadsheet. The end result is a “Competitor Results” sheet filled with consistent rows you can filter, pivot, chart, and share.
The workflow starts with a manual launch in n8n. It pulls your keywords and countries from Google Sheets, loops through them one-by-one (or in small batches), calls Bright Data, then writes structured results back to Sheets as tidy records.
What You Get: Automation vs. Results
| What This Workflow Automates | Results You’ll Get |
|---|---|
|
|
Example: What This Looks Like
Say you track 20 keywords across 3 countries. Manually, if it takes about 10 minutes to capture results for one keyword-country pair, that’s roughly 10 hours of tedious work every cycle. With this workflow, you update the “Keywords” sheet once, click run, and let it process. Expect around a minute per keyword (plus built-in waiting to avoid rate limits), so you’re closer to about an hour of hands-off processing while you do other work.
What You’ll Need
- n8n instance (try n8n Cloud free)
- Self-hosting option if you prefer (Hostinger works well)
- Google Sheets for keyword input and saved results
- Bright Data SERP API to fetch Google result pages
- Bright Data API token (get it from your Bright Data dashboard)
Skill level: Intermediate. You’ll connect credentials, confirm sheet columns, and paste an API token.
Don’t want to set this up yourself? Talk to an automation expert (free 15-minute consultation).
How It Works
You run it manually when you need fresh data. The workflow begins with a manual trigger inside n8n, so you can run it on demand (for example, every Monday before reporting).
Your keyword list comes from Google Sheets. n8n reads the “Keywords” tab, pulling the keyword text and the 2-letter country code that determines where the results should be collected.
Each keyword is prepared and processed in batches. Search terms are URL-encoded so characters like “&” or “/” don’t break requests. Then the workflow loops through items using a batch iterator, which is the difference between “works once” and “works every week.”
Bright Data returns the SERP HTML, then it gets parsed into clean fields. The HTTP request grabs the Google results via Bright Data’s SERP API, and a parsing step extracts consistent data points like website URL, title, and description for your “Competitor Results” sheet.
You can easily modify the fields you extract to include more SERP details based on your needs. See the full implementation guide below for customization options.
Step-by-Step Implementation Guide
Step 1: Configure the Manual Trigger
This workflow starts manually, so you’ll trigger it on demand to fetch and process SERP keyword data.
- Add the Manual Launch Trigger node as the workflow trigger.
- Leave default settings as-is in Manual Launch Trigger (no parameters required).
Step 2: Connect Google Sheets
Pull keyword inputs from your spreadsheet so each row becomes a keyword record.
- Add the Retrieve Sheet Keywords node and connect it to Manual Launch Trigger.
- Credential Required: Connect your googleSheetsOAuth2Api credentials.
- Set Document to
YOUR_GOOGLE_SHEET_ID. - Set Sheet Name to
Keywords(the sheet withgid=0).
Step 3: Set Up Processing Nodes
Encode keywords for safe URL usage, then iterate through them in batches.
- Add Encode Search Terms and connect it to Retrieve Sheet Keywords.
- In Encode Search Terms, set JavaScript Code to
const encode = encodeURIComponent; for (const item of $input.all()) { item.json.Keyword = encode(item.json.Keyword); } return $input.all();. - Add Batch Keyword Iterator and connect it to Encode Search Terms.
Encode Search Terms outputs to Batch Keyword Iterator, which prepares each keyword for the API request loop.
Step 4: Configure SERP API Request and Parsing
Send each encoded keyword to the SERP API, then parse the competitor HTML response.
- Add SERP API Request and connect it to Batch Keyword Iterator.
- Credential Required: Connect your httpHeaderAuth credentials.
- Set URL to
https://api.brightdata.com/request. - Set Method to
POST, enable Send Body, Send Query, and Send Headers. - In Body Parameters, add: zone =
serp_api1, url ==https://www.google.com/search?q={{ $json.Keyword }}, format =raw, country == {{ $json['Target Country'] }}. - In Query Parameters, set async to
true. - In Header Parameters, set Accept to
application/json. - Add Parse Competitor HTML and connect it to SERP API Request.
- Set JavaScript Code in Parse Competitor HTML to
const html = $input.first().json.data || ''; return [{json: {websiteName: 'demo', websiteUrl: 'https://example.com', websiteTitle: 'Example Title', websiteDescription: 'Example description'}}];.
SERP API Request outputs to Parse Competitor HTML to transform the raw SERP response into structured competitor data.
⚠️ Common Pitfall: If your spreadsheet doesn’t include the Keyword and Target Country fields, the API request expressions will fail. Ensure both columns exist in the sheet.
Step 5: Test and Activate Your Workflow
Run a manual test to validate API responses and parsing output, then activate for production use.
- Click Execute Workflow to run Manual Launch Trigger and process a sample batch.
- Confirm Retrieve Sheet Keywords outputs rows with
KeywordandTarget Countryfields. - Verify SERP API Request returns a JSON response and Parse Competitor HTML outputs structured competitor data.
- When results look correct, switch the workflow to Active for ongoing use.
Common Gotchas
- Bright Data credentials can expire or need specific permissions. If things break, check your Bright Data dashboard token and plan access first.
- If you’re using Wait nodes or external rendering, processing times vary. Bump up the wait duration if downstream nodes fail on empty responses.
- Default prompts in AI nodes are generic. Add your brand voice early or you’ll be editing outputs forever.
Frequently Asked Questions
About 30 minutes if your Sheets and Bright Data accounts are ready.
No. You’ll connect accounts and paste an API token. The only “code” here is already packaged inside the workflow.
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 SERP API usage costs based on how many keywords you run.
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, but you’ll swap the Manual Trigger for a Schedule trigger in n8n and keep the rest mostly the same. Common tweaks include adding extra extracted fields in the “Parse Competitor HTML” step, filtering out your own domain, and changing batch sizes in the iterator so you match your Bright Data limits. If you need separate tabs per country, you can also route outputs based on the Country column.
Usually it’s an invalid or expired API token in the HTTP header. Confirm your Bright Data SERP API is enabled, you still have credits, and the Authorization header is exactly what Bright Data expects. If it works for one keyword and fails for many, you may be hitting rate limits, so keep the built-in waiting and reduce batch size.
Plenty for most teams. The workflow typically runs about a minute per keyword with the recommended 30-second delay, so 50 keywords can take close to an hour. On n8n Cloud, your monthly execution limits depend on your plan; if you self-host, you’re mostly limited by your server and your Bright Data usage limits.
Often, yes. This workflow leans on batching, looping, and HTML parsing, which are awkward (or expensive) in many Zapier-style tools. n8n also gives you more control over request headers, retry behavior, and data shaping before it hits Google Sheets. If you only run a couple of keywords and want a quick two-step zap, Zapier or Make may be simpler. If you’re building a real reporting process you’ll trust, n8n is a better long-term home, honestly. Talk to an automation expert if you want help choosing.
Once this is running, your SERP tracking stops being a recurring chore and becomes a dataset you can actually trust. Set it up, run it when you need it, and use the time you get back for decisions instead of data entry.
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.
