January 22, 2026

Brave Search to Google Sheets, clean research rows

Lisa Granqvist Partner Workflow Automation Expert

Get a free AI assessment → ⬇️ Use template

Your research starts clean. Then it falls apart. Links pasted into a doc, screenshots saved “for later”, messy SERP exports with missing fields, and a spreadsheet that somehow has five different “Source” columns.

This Brave Sheets automation hits market researchers first, because you are constantly collecting and comparing. But SEO analysts and agency strategists feel it too when the “quick scan” becomes hours of cleanup.

This workflow pulls Brave Search results (news, images, videos, or all), extracts consistent fields with an LLM, and writes tidy rows into Google Sheets. You will see how it works, what you need, and where teams usually trip up.

How This Automation Works

The full n8n workflow, from trigger to final output:

n8n Workflow Template: Brave Search to Google Sheets, clean research rows

Click to explore

flowchart LR

    subgraph sg0["Manual Start Flow"]
        direction LR
        n0@{ icon: "mdi:play-circle", form: "rounded", label: "Manual Start Trigger", pos: "b", h: 48 }
        n1@{ icon: "mdi:brain", form: "rounded", label: "Gemini Chat Engine", pos: "b", h: 48 }
        n2@{ icon: "mdi:robot", form: "rounded", label: "Structured Info Extractor", pos: "b", h: 48 }
        n3@{ icon: "mdi:swap-vertical", form: "rounded", label: "Define Image Search Input", pos: "b", h: 48 }
        n4@{ icon: "mdi:robot", form: "rounded", label: "Structured Output Reader", pos: "b", h: 48 }
        n5@{ icon: "mdi:cog", form: "rounded", label: "BrightData Image Search Client", pos: "b", h: 48 }
        n6@{ icon: "mdi:swap-horizontal", form: "rounded", label: "Route by Search Type", pos: "b", h: 48 }
        n7@{ icon: "mdi:swap-vertical", form: "rounded", label: "Define Video Search Input", pos: "b", h: 48 }
        n8@{ icon: "mdi:cog", form: "rounded", label: "BrightData Video Search Client", pos: "b", h: 48 }
        n9@{ icon: "mdi:swap-vertical", form: "rounded", label: "Capture Search Response", pos: "b", h: 48 }
        n10@{ icon: "mdi:swap-vertical", form: "rounded", label: "Define News Search Input", pos: "b", h: 48 }
        n11@{ icon: "mdi:swap-vertical", form: "rounded", label: "Configure Search Criteria", pos: "b", h: 48 }
        n12@{ icon: "mdi:cog", form: "rounded", label: "BrightData News Search Client", pos: "b", h: 48 }
        n13@{ icon: "mdi:cog", form: "rounded", label: "BrightData All Search Client", pos: "b", h: 48 }
        n14@{ icon: "mdi:swap-vertical", form: "rounded", label: "Define All Search Input", pos: "b", h: 48 }
        n15@{ icon: "mdi:database", form: "rounded", label: "Update Google Spreadsheet", pos: "b", h: 48 }
        n16@{ icon: "mdi:code-braces", form: "rounded", label: "Build Binary Payload", pos: "b", h: 48 }
        n17@{ icon: "mdi:cog", form: "rounded", label: "Write Structured File", pos: "b", h: 48 }
        n18["<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/>Send Webhook Summary"]
        n6 --> n3
        n6 --> n7
        n6 --> n10
        n6 --> n14
        n9 --> n2
        n1 -.-> n2
        n4 -.-> n2
        n11 --> n6
        n2 --> n15
        n2 --> n16
        n2 --> n18
        n3 --> n5
        n7 --> n8
        n0 --> n11
        n14 --> n13
        n10 --> n12
        n13 --> n9
        n12 --> n9
        n5 --> n9
        n8 --> n9
        n16 --> n17
    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 n2,n4 ai
    class n1 aiModel
    class n6 decision
    class n15 database
    class n18 api
    class n16 code
    classDef customIcon fill:none,stroke:none
    class n18 customIcon

The Problem: Search research turns into spreadsheet cleanup

Search results are easy to skim and surprisingly hard to operationalize. You can grab a few links fast, sure. But once you need repeatable tracking across content types (news, images, videos), the format chaos starts: different layouts, missing snippets, inconsistent sources, and URLs that break your downstream dashboards. Worse, teams end up debating the data instead of using it. One person’s “top story” is another person’s “random blog”, because nothing is normalized and nobody has time to structure it properly.

It adds up fast. Here’s where it usually breaks down.

Pulling Brave results for four content types means repeating the same manual work several times per query.
You lose context when you copy links without a consistent title, source, snippet, and result type.
Spreadsheet columns drift over time, which means trend comparisons become guesswork.
Raw HTML or unstructured exports are “data”, but not the kind you can confidently filter, chart, or hand to a teammate.

The Solution: Brave Search results extracted into consistent Sheet rows

This n8n workflow turns Brave Search into something you can actually use. You choose a query and a search type (news, images, videos, or all). The workflow runs the correct Brave Search request via Bright Data’s MCP setup, captures the raw response, and then asks an LLM to extract structured fields like title, URL, source, and snippet in a predictable shape. From there, it updates Google Sheets with clean rows (so your columns stay stable), saves a structured file to disk for backup or reuse, and sends a summary to a webhook endpoint for notifications or dashboards. No more “copy, paste, fix, repeat”.

The workflow starts with criteria you define, routes the run based on the search type, then funnels all result formats into one structured extractor. Finally, it persists the same schema everywhere (Sheet, file, webhook), so your research stays comparable from week to week.

What You Get: Automation vs. Results

What This Workflow Automates

Results You’ll Get

You select a Brave query and choose news, images, videos, or all.
Bright Data MCP runs the right Brave search pattern and returns the raw response.
An LLM extracts consistent fields into structured rows you can trust.
n8n writes to Google Sheets, saves a file copy, and pings a webhook with a summary.

Most teams get about 2–4 hours back per week per tracked topic because cleanup disappears.
Consistent columns across multimedia results, so charts and filters stop breaking.
Cleaner competitive monitoring, since “source” and “result type” are always captured.
Fewer “did we already look at this?” moments, because results are logged in one place.
A dataset you can reuse for briefs, reports, or even model training without reformatting.

Example: What This Looks Like

Say you track one topic across news, images, videos, and all once a week. Manually, you might spend about 10 minutes per search type collecting links and another 20 minutes cleaning columns and sources, so roughly an hour per topic. With this workflow, you kick it off in a couple minutes, wait a few minutes for extraction, and the tidy rows land in Google Sheets automatically. That’s close to an hour back per topic, and your sheet stays consistent for trend comparisons.

What You’ll Need

n8n instance (try n8n Cloud free)
Self-hosting option if you prefer (Hostinger works well)
Google Sheets for storing clean research rows.
Bright Data to run Brave searches via MCP.
Google Gemini API key (get it from Google AI Studio).

Skill level: Intermediate. You will connect accounts, paste API keys, and be comfortable with a couple of configuration screens for MCP.

Don’t want to set this up yourself? Talk to an automation expert (free 15-minute consultation).

How It Works

You define the search criteria. A manual start kicks things off, and you set the query plus the search type you care about (news, images, videos, or all).

The workflow routes the request. Based on that search type, n8n selects the right input template and sends it to the matching Bright Data MCP search client so Brave results come back in the correct format.

Raw results get structured. The response is captured, then the Gemini chat model and structured extractor turn “messy SERP output” into predictable fields like title, URL, source, snippet, and type. This is the part that keeps your spreadsheet clean, honestly.

Everything is saved and shared. Google Sheets is updated with tidy rows, a structured file is written to disk for backup or reuse, and a webhook summary is sent so another system can react (Slack, a dashboard, an internal tool).

You can easily modify the extracted fields to match your reporting format based on your needs. See the full implementation guide below for customization options.

Step-by-Step Implementation Guide

Step 1: Configure the Manual Trigger

Start the workflow with a manual trigger so you can test the search extraction end-to-end before activating it.

Add and keep Manual Start Trigger as the first node in the workflow.
Connect Manual Start Trigger to Configure Search Criteria to kick off the search setup path.

Use Manual Start Trigger during setup to verify each search type route without scheduling or external triggers.

Step 2: Connect BrightData Search Clients

Configure the Brave search endpoints and attach BrightData credentials for image, video, news, and all searches.

In Define Image Search Input, set search_base_url to https://search.brave.com/images.
In Define Video Search Input, set search_base_url to https://search.brave.com/video.
In Define News Search Input, set search_base_url to https://search.brave.com/news.
In Define All Search Input, set search_base_url to https://search.brave.com/search.
For BrightData Image Search Client, BrightData Video Search Client, BrightData News Search Client, and BrightData All Search Client, keep Operation as executeTool and Tool Name as scrape_as_html.
Set each BrightData node’s Tool Parameters to { "url": "{{$json.search_base_url}}?q={{encodeURI($('Configure Search Criteria').item.json.search_query))}}" } (note the slight variation in BrightData News Search Client and BrightData All Search Client uses encodeURI($('Configure Search Criteria').item.json.search_query)).
Credential Required: Connect your mcpClientApi credentials in each BrightData client node.

⚠️ Common Pitfall: If search_query contains spaces or special characters, ensure the encodeURI(...) expression remains intact to avoid malformed URLs.

Step 3: Set Up Search Criteria and Routing

Define the query and route searches to the correct BrightData client based on search type.

In Configure Search Criteria, set search_type to news, search_query to bright+data&source=web&lang=en-in, and json_search_query to { "query": "What are the latest funding rounds for AI startups?", "include_domains": [ "crunchbase.com", "techcrunch.com", "pitchbook.com" ] }.
In Route by Search Type, confirm the four rules match search_type values: images, videos, news, and all using the expression {{ $json.search_type }}.
Connect Route by Search Type outputs to Define Image Search Input, Define Video Search Input, Define News Search Input, and Define All Search Input as shown in the workflow.

You can switch search modes by changing search_type in Configure Search Criteria without modifying any other nodes.

Step 4: Configure AI Extraction with Gemini

Use Gemini to extract structured data from the scraped HTML, then parse it into a consistent schema.

In Capture Search Response, set search_response to {{ $json.result.content[0].text }} to capture HTML text from the BrightData response.
In Structured Info Extractor, set Text to Extract structured data from the search result. {{ $json.search_response }} and keep Prompt Type as define.
In Structured Output Reader, keep Schema Type as manual and paste the full JSON schema provided in the node.
Structured Info Extractor uses Gemini Chat Engine as its language model and Structured Output Reader as its output parser—add credentials on Gemini Chat Engine, not on the parser.
Credential Required: Connect your googlePalmApi credentials in Gemini Chat Engine.

⚠️ Common Pitfall: If the schema in Structured Output Reader is edited, ensure required fields like title, url, and description remain consistent to avoid parser failures.

Step 5: Configure Output Destinations

Store the structured results in Google Sheets, write a JSON file, and send a webhook summary.

In Update Google Spreadsheet, keep Operation as appendOrUpdate, set Document to [YOUR_ID], and Sheet Name to Sheet1.
Map the Output column value to {{ $json.output.search_results.toJsonString() }}.
Credential Required: Connect your googleSheetsOAuth2Api credentials in Update Google Spreadsheet.
In Build Binary Payload, keep the function code as provided to convert JSON into a binary base64 payload.
In Write Structured File, set Operation to write and File Name to d:\Brave-Search-Result-{{new Date().toISOString().replaceAll(":",".")}}.json.
In Send Webhook Summary, set URL to https://example.com/webhook and summary body parameter to {{ $json.output.search_results.toJsonString() }}.
Structured Info Extractor outputs to Update Google Spreadsheet, Build Binary Payload, and Send Webhook Summary in parallel.

If you don’t need file output, you can disable Build Binary Payload and Write Structured File without affecting the Google Sheets or webhook paths.

Step 6: Test and Activate Your Workflow

Run the workflow manually, confirm outputs, and then activate it for production use.

Click Execute Workflow from Manual Start Trigger to run a test.
Verify Capture Search Response contains HTML text and Structured Info Extractor returns structured fields under search_results.
Confirm updates in Update Google Spreadsheet, the JSON file generated by Write Structured File, and the HTTP response from Send Webhook Summary.
When results are correct, toggle the workflow to Active for production use.

🔒

Unlock Full Step-by-Step Guide

Get the complete implementation guide + downloadable template

Common Gotchas

Google Sheets credentials can expire or need specific permissions. If things break, check the n8n Credentials panel and the target spreadsheet’s sharing settings 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.
Bright Data MCP setup is unforgiving if the API_TOKEN or zone name is off. If the search clients return nothing, confirm your Bright Data Web Unlocker zone and the MCP server environment variables match exactly.

Frequently Asked Questions

How long does it take to set up this Brave Sheets automation automation?

Plan for about an hour if your Bright Data MCP setup is new.

Do I need coding skills to automate Brave Sheets automation?

No. You will mostly paste credentials and edit a few “Set” fields. The only tricky part is the MCP server setup if you have never done it before.

Is n8n free to use for this Brave Sheets automation 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 usage plus LLM API costs for Gemini (usually pennies per run for typical research volumes).

Where can I host n8n to run this automation?

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.

Can I customize this Brave Sheets automation workflow for weekly competitor tracking?

Yes, and it is a smart tweak. You can keep the same extractor, then adjust the “Configure Search Criteria” and the “Define News/Image/Video/All Search Input” nodes to include competitor brand terms and a consistent naming convention. Many teams also add a timestamp column before “Update Google Spreadsheet”, so each run becomes a clean time series. If you want a roll-up, modify the webhook payload to send only the top 10 results and a short summary for Slack.

Why is my Bright Data connection failing in this workflow?

Usually it’s the MCP server not seeing your Bright Data API_TOKEN environment value, or the Web Unlocker zone name not matching what you configured in Bright Data. Recheck the MCP client (STDIO) credentials in n8n and confirm the zone exists and is active. If it works once and then fails later, you may be hitting account limits or temporary blocks, so reducing run frequency can help.

How many search results can this Brave Sheets automation automation handle?

A lot, as long as your plan limits and sheet size allow it. On n8n Cloud, the practical cap is your monthly execution allowance and how often you run it, not a hard “results” limit. Google Sheets will eventually slow down with very large files, so many teams split by topic or month. If you self-host, you can scale executions based on your server, and the main cost driver becomes Bright Data plus LLM calls.

Is this Brave Sheets automation automation better than using Zapier or Make?

For this kind of workflow, n8n is usually the better fit because you can branch by search type, parse and reshape data, and keep the logic in one place without paying extra for every path. Self-hosting is also a big deal if you plan to run a lot of research jobs. Zapier or Make can work, but the moment you add “run one of four routes, then structure with an LLM, then write rows and send a webhook”, it gets pricey and brittle. If you want help choosing, Talk to an automation expert and we’ll sanity-check your use case. Bring your current spreadsheet.

Clean rows change the whole game because you can finally compare week over week without reformatting. Set this up once, then spend your research time on decisions instead of cleanup.

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.

Lisa Granqvist

Workflow Automation Expert

Expert in workflow automation and no-code tools.

{
"id": null,
"meta": {
"instanceId": "4cd0e5f72ece919d5b4dc22eb0ce34e590f7050d4be12c0513ee065055467762",
"templateCredsSetupCompleted": null,
"templateId": null
},
"name": "Automated Brave Search Data Extraction",
"tags": [],
"nodes": [
{
"id": "flowpast-topbar-4497",
"name": "Flowpast Branding",
"type": "n8n-nodes-base.stickyNote",
"position": [
0,
20
],
"parameters": {
"color": 7,
"width": 1500,
"height": 80,
"content": "## Flowpast.com | Automation Workflow Library\n**\ud83d\udcd6 Full tutorial & setup guide:** flowpast.com"
},
"typeVersion": 1
},
{
"id": "70d29e8e-3e2d-4177-abdc-d3da8d6b60e4",
"name": "Manual Start Trigger",
"type": "n8n-nodes-base.manualTrigger",
"position": [
1400,
270
],
"parameters": [],
"typeVersion": 1
},
{
"id": "e3b06669-954e-494f-8b59-080d9d7083a8",
"name": "Gemini Chat Engine",
"type": "@n8n/n8n-nodes-langchain.lmChatGoogleGemini",
"position": [
300,
520
],
"parameters": {
"options": [],
"modelName": "models/gemini-2.0-flash-exp"
},
"credentials": {
"googlePalmApi": {
"id": "credential-id",
"name": ""
}
},
"typeVersion": 1
},
{
"id": "2c8c3b3a-edaf-42f2-8f3b-1c3a96bd4c7d",
"name": "Structured Info Extractor",
"type": "@n8n/n8n-nodes-langchain.chainLlm",
"position": [
320,
345
],
"parameters": {
"text": "=Extract structured data from the search result. \n\n{{ $json.search_response }}",
"promptType": "define",
"hasOutputParser": true
},
"retryOnFail": true,
"typeVersion": 1.6
},
{
"id": "b2cb439e-eccc-40ad-97db-265bcd9f7a73",
"name": "Define Image Search Input",
"type": "n8n-nodes-base.set",
"position": [
460,
120
],
"parameters": {
"options": [],
"assignments": {
"assignments": [
{
"id": "0b0e9335-56d4-4705-b61b-de0dc9c8ae6d",
"name": "search_base_url",
"type": "string",
"value": "https://search.brave.com/images"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "df89cc2e-1b75-4176-a66d-f17d5076bb17",
"name": "Structured Output Reader",
"type": "@n8n/n8n-nodes-langchain.outputParserStructured",
"position": [
330,
640
],
"parameters": {
"schemaType": "manual",
"inputSchema": "{\n  \"type\": \"object\",\n  \"properties\": {\n    \"search_results\": {\n      \"type\": \"array\",\n      \"description\": \"A list of search results related to the query.\",\n      \"items\": {\n        \"type\": \"object\",\n        \"properties\": {\n          \"title\": {\n            \"type\": \"string\",\n            \"description\": \"The title of the search result or webpage.\"\n          },\n          \"url\": {\n            \"type\": \"string\",\n            \"format\": \"uri\",\n            \"description\": \"The URL of the result.\"\n          },\n          \"description\": {\n            \"type\": \"string\",\n            \"description\": \"A short description or snippet summarizing the content of the URL.\"\n          }\n        },\n        \"required\": [\"title\", \"url\", \"description\"]\n      }\n    },\n    \"related_queries\": {\n      \"type\": \"array\",\n      \"description\": \"A list of queries related to the original search, often used for refining or expanding the search.\",\n      \"items\": {\n        \"type\": \"string\"\n      }\n    }\n  },\n  \"required\": [\"search_results\"]\n}\n"
},
"typeVersion": 1.2
},
{
"id": "919833cb-1add-4670-86a4-466f3df925f3",
"name": "BrightData Image Search Client",
"type": "n8n-nodes-mcp.mcpClient",
"position": [
220,
175
],
"parameters": {
"toolName": "scrape_as_html",
"operation": "executeTool",
"toolParameters": "={\n  \"url\": \"{{$json.search_base_url}}?q={{encodeURI($('Configure Search Criteria').item.json.search_query))}}\"\n} "
},
"credentials": {
"mcpClientApi": {
"id": "credential-id",
"name": ""
}
},
"typeVersion": 1
},
{
"id": "d90b79cc-b878-4210-8380-794cd378ec73",
"name": "Route by Search Type",
"type": "n8n-nodes-base.switch",
"position": [
900,
335
],
"parameters": {
"rules": {
"values": [
{
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "235f2abd-b5fd-4c0a-aa63-9d8655d02dfc",
"operator": {
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $json.search_type }}",
"rightValue": "images"
}
]
}
},
{
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "4b6eb7ce-5683-48cf-8ab9-81b25693c280",
"operator": {
"name": "filter.operator.equals",
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $json.search_type }}",
"rightValue": "videos"
}
]
}
},
{
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "312a7726-33a4-4294-9103-5a5017f36909",
"operator": {
"name": "filter.operator.equals",
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $json.search_type }}",
"rightValue": "news"
}
]
}
},
{
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "e84e037f-89a3-48ef-b509-2ca70844ad27",
"operator": {
"name": "filter.operator.equals",
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $json.search_type }}",
"rightValue": "all"
}
]
}
}
]
},
"options": []
},
"typeVersion": 3.2
},
{
"id": "f20fde43-bfb3-447a-9f43-51bf952c9d7e",
"name": "Define Video Search Input",
"type": "n8n-nodes-base.set",
"position": [
440,
285
],
"parameters": {
"options": [],
"assignments": {
"assignments": [
{
"id": "0b0e9335-56d4-4705-b61b-de0dc9c8ae6d",
"name": "search_base_url",
"type": "string",
"value": "https://search.brave.com/video"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "b25da743-0d4b-46a2-bb51-2b8e1c533ac5",
"name": "BrightData Video Search Client",
"type": "n8n-nodes-mcp.mcpClient",
"position": [
240,
335
],
"parameters": {
"toolName": "scrape_as_html",
"operation": "executeTool",
"toolParameters": "={\n  \"url\": \"{{$json.search_base_url}}?q={{encodeURI($('Configure Search Criteria').item.json.search_query))}}\"\n} "
},
"credentials": {
"mcpClientApi": {
"id": "credential-id",
"name": ""
}
},
"typeVersion": 1
},
{
"id": "28e51b1c-a4f3-4d95-af12-d4bd1219cfa2",
"name": "Capture Search Response",
"type": "n8n-nodes-base.set",
"position": [
0,
340
],
"parameters": {
"options": [],
"assignments": {
"assignments": [
{
"id": "74d82a2b-0219-4966-80f2-3144c7c5e4c7",
"name": "search_response",
"type": "string",
"value": "={{ $json.result.content[0].text }}"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "a5afb97c-0fbf-48b1-b598-fbca46e3df96",
"name": "Define News Search Input",
"type": "n8n-nodes-base.set",
"position": [
470,
475
],
"parameters": {
"options": [],
"assignments": {
"assignments": [
{
"id": "0b0e9335-56d4-4705-b61b-de0dc9c8ae6d",
"name": "search_base_url",
"type": "string",
"value": "https://search.brave.com/news"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "0dcd6a1b-7968-40da-ad27-4d39fadc243a",
"name": "Configure Search Criteria",
"type": "n8n-nodes-base.set",
"position": [
1160,
315
],
"parameters": {
"options": [],
"assignments": {
"assignments": [
{
"id": "9852f865-49b9-4672-9454-4bcc51173445",
"name": "search_type",
"type": "string",
"value": "news"
},
{
"id": "643626c4-6d3e-4609-be12-5e7c0c7afe1d",
"name": "search_query",
"type": "string",
"value": "bright+data&source=web&lang=en-in"
},
{
"id": "4a0fc0eb-2638-4441-9eb1-51c29dd7d1b4",
"name": "json_search_query",
"type": "string",
"value": "{     \"query\": \"What are the latest funding rounds for AI startups?\",     \"include_domains\": [ \"crunchbase.com\", \"techcrunch.com\", \"pitchbook.com\" ]  }"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "2c686701-f3fa-4bf4-bdea-b11dce7b2862",
"name": "BrightData News Search Client",
"type": "n8n-nodes-mcp.mcpClient",
"position": [
230,
500
],
"parameters": {
"toolName": "scrape_as_html",
"operation": "executeTool",
"toolParameters": "={\n  \"url\": \"{{$json.search_base_url}}?q={{encodeURI($('Configure Search Criteria').item.json.search_query)}}\"\n} "
},
"credentials": {
"mcpClientApi": {
"id": "credential-id",
"name": ""
}
},
"typeVersion": 1
},
{
"id": "725c7c7e-6422-4bcb-8bb1-441766741c96",
"name": "BrightData All Search Client",
"type": "n8n-nodes-mcp.mcpClient",
"position": [
250,
665
],
"parameters": {
"toolName": "scrape_as_html",
"operation": "executeTool",
"toolParameters": "={\n  \"url\": \"{{$json.search_base_url}}?q={{encodeURI($('Configure Search Criteria').item.json.search_query)}}\"\n} "
},
"credentials": {
"mcpClientApi": {
"id": "credential-id",
"name": ""
}
},
"typeVersion": 1
},
{
"id": "a6843bfe-f649-4ab8-9208-1d3119e811c5",
"name": "Define All Search Input",
"type": "n8n-nodes-base.set",
"position": [
430,
640
],
"parameters": {
"options": [],
"assignments": {
"assignments": [
{
"id": "0b0e9335-56d4-4705-b61b-de0dc9c8ae6d",
"name": "search_base_url",
"type": "string",
"value": "https://search.brave.com/search"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "c8fa6490-f0db-400c-8283-e8f9120e6481",
"name": "Update Google Spreadsheet",
"type": "n8n-nodes-base.googleSheets",
"position": [
720,
170
],
"parameters": {
"columns": {
"value": {
"Output": "={{ $json.output.search_results.toJsonString() }}"
},
"schema": [
{
"id": "Output",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Output",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"Output"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": [],
"operation": "appendOrUpdate",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "",
"cachedResultName": "Sheet1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "[YOUR_ID]",
"cachedResultUrl": "",
"cachedResultName": "Brave Search Results"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "credential-id",
"name": ""
}
},
"typeVersion": 4.5
},
{
"id": "6d51e57a-1303-46a0-95ce-80d3a17c30db",
"name": "Build Binary Payload",
"type": "n8n-nodes-base.function",
"position": [
740,
340
],
"parameters": {
"functionCode": "items[0].binary = {\n  data: {\n    data: new Buffer(JSON.stringify(items[0].json, null, 2)).toString('base64')\n  }\n};\nreturn items;"
},
"typeVersion": 1
},
{
"id": "7f5d181b-18bc-4bb4-8ae9-bc2e05137127",
"name": "Write Structured File",
"type": "n8n-nodes-base.readWriteFile",
"position": [
1020,
325
],
"parameters": {
"options": [],
"fileName": "=d:\\Brave-Search-Result-{{new Date().toISOString().replaceAll(\":\",\".\")}}.json",
"operation": "write"
},
"typeVersion": 1
},
{
"id": "fa6143c9-3312-4890-a490-3bc3db355c53",
"name": "Send Webhook Summary",
"type": "n8n-nodes-base.httpRequest",
"position": [
780,
480
],
"parameters": {
"url": "https://example.com/webhook",
"options": [],
"sendBody": true,
"bodyParameters": {
"parameters": [
{
"name": "summary",
"value": "={{ $json.output.search_results.toJsonString() }}"
}
]
}
},
"typeVersion": 4.2
}
],
"active": false,
"pinData": [],
"settings": {
"executionOrder": "v1"
},
"versionId": null,
"connections": {
"Route by Search Type": {
"main": [
[
{
"node": "Define Image Search Input",
"type": "main",
"index": 0
}
],
[
{
"node": "Define Video Search Input",
"type": "main",
"index": 0
}
],
[
{
"node": "Define News Search Input",
"type": "main",
"index": 0
}
],
[
{
"node": "Define All Search Input",
"type": "main",
"index": 0
}
]
]
},
"Capture Search Response": {
"main": [
[
{
"node": "Structured Info Extractor",
"type": "main",
"index": 0
}
]
]
},
"Gemini Chat Engine": {
"ai_languageModel": [
[
{
"node": "Structured Info Extractor",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"Structured Output Reader": {
"ai_outputParser": [
[
{
"node": "Structured Info Extractor",
"type": "ai_outputParser",
"index": 0
}
]
]
},
"Configure Search Criteria": {
"main": [
[
{
"node": "Route by Search Type",
"type": "main",
"index": 0
}
]
]
},
"Structured Info Extractor": {
"main": [
[
{
"node": "Update Google Spreadsheet",
"type": "main",
"index": 0
},
{
"node": "Build Binary Payload",
"type": "main",
"index": 0
},
{
"node": "Send Webhook Summary",
"type": "main",
"index": 0
}
]
]
},
"Define Image Search Input": {
"main": [
[
{
"node": "BrightData Image Search Client",
"type": "main",
"index": 0
}
]
]
},
"Define Video Search Input": {
"main": [
[
{
"node": "BrightData Video Search Client",
"type": "main",
"index": 0
}
]
]
},
"Manual Start Trigger": {
"main": [
[
{
"node": "Configure Search Criteria",
"type": "main",
"index": 0
}
]
]
},
"Define All Search Input": {
"main": [
[
{
"node": "BrightData All Search Client",
"type": "main",
"index": 0
}
]
]
},
"Define News Search Input": {
"main": [
[
{
"node": "BrightData News Search Client",
"type": "main",
"index": 0
}
]
]
},
"BrightData All Search Client": {
"main": [
[
{
"node": "Capture Search Response",
"type": "main",
"index": 0
}
]
]
},
"BrightData News Search Client": {
"main": [
[
{
"node": "Capture Search Response",
"type": "main",
"index": 0
}
]
]
},
"BrightData Image Search Client": {
"main": [
[
{
"node": "Capture Search Response",
"type": "main",
"index": 0
}
]
]
},
"BrightData Video Search Client": {
"main": [
[
{
"node": "Capture Search Response",
"type": "main",
"index": 0
}
]
]
},
"Build Binary Payload": {
"main": [
[
{
"node": "Write Structured File",
"type": "main",
"index": 0
}
]
]
}
}
}