Skip to main content

Scrape & analyze Google Ads with Bright Data API and AI for email reports

Workflow preview

Workflow preview
100%
Scrape & analyze Google Ads with Bright Data API and AI for email reports preview
Open on n8n.io

Important notice

This workflow is provided as-is. Please review and test before using in production.

1. Workflow Overview

This workflow contains community nodes that are only compatible with the self hosted version of n8n. This workflow is a gem for all PPC managers and experts out there looking to keep track of compe...

Best for

  • Market Research automation workflows
  • AI Summarization automation workflows
  • advanced n8n builders looking for reusable templates

Tools used

n8n-nodes-base.manualtrigger, n8n-nodes-base.httprequest, n8n-nodes-base.googlesheets, n8n-nodes-base.splitinbatches, n8n-nodes-base.stickynote, n8n-nodes-base.set, n8n-nodes-base.noop, n8n-nodes-base.splitout

Source and attribution

This workflow is cataloged by N8N Workflows and links back to its original n8n.io source page by Zacharia Kimotho.

Original n8n.io source

1.1 Workflow description

Title
Scrape & analyze Google Ads with Bright Data API and AI for email reports
Workflow name
Scrape & analyze Google Ads with Bright Data API and AI for email reports

This workflow contains community nodes that are only compatible with the self-hosted version of n8n.

This workflow is a gem for all PPC managers and experts out there looking to keep track of competitor ads and the campaigns they are running and generate an email report How does it work

  1. We use Bright Data API to scrap Google for a given keyword that can trigger an ad. We then extract and analyse different components of the ads to get insights and data rekevant for our processes

Setting it up

  1. Make a copy of this workflow to your canvas

  2. Make a copy of this google sheet

  3. Add high intent commercial keywords to your google sheet. These are relevant to trigger ads

  4. Set your Bright Data API credentials and update the zone to your respective zone as set on your Bright Data account

  5. We filter only if ads are found and if true extract the top and botton ads

  6. This routes the results via different paths

    1. Store raw Ad results
    2. Process the Ads to get new insights and data
  7. Map the raw data to match your account

  8. You can adjust the prompt to provide any data as needed

  9. Connect your emailing platform or tool and update the to email

Setting up Bright Data serp API and Zone

  1. On Bright Data, go to the Proxies & Scraping tab
  2. Under SERP API, create a new zone
  3. Give it a suitable name and description. The default is serp_api
  4. Add this to your account

If you have any questions, feel free to reach out via linkedin

1.2 Logical Blocks

This catalog entry is organized from the workflow JSON. The node-level section below shows the executable blocks available for review before importing the template.

2. Block-by-Block Analysis

Block 1 - When clicking ‘Execute workflow’

Type / Role
n8n-nodes-base.manualTrigger - manualTrigger
Config choices
Version 1

Block 2 - Fetch Google Search Results JSON

Type / Role
n8n-nodes-base.httpRequest - httpRequest
Config choices
Version 4.2

Block 3 - Get Keywords

Type / Role
n8n-nodes-base.googleSheets - googleSheets
Config choices
Version 4.6

Block 4 - Loop Over Items

Type / Role
n8n-nodes-base.splitInBatches - splitInBatches
Config choices
Version 3

Block 5 - Sticky Note4

Type / Role
n8n-nodes-base.stickyNote - stickyNote
Config choices
Version 1

Block 6 - Sticky Note5

Type / Role
n8n-nodes-base.stickyNote - stickyNote
Config choices
Version 1

Block 7 - set keyword

Type / Role
n8n-nodes-base.set - set
Config choices
Version 3.4

Block 8 - Sticky Note6

Type / Role
n8n-nodes-base.stickyNote - stickyNote
Config choices
Version 1

Block 9 - Sticky Note7

Type / Role
n8n-nodes-base.stickyNote - stickyNote
Config choices
Version 1

Block 10 - ads found

Type / Role
n8n-nodes-base.set - set
Config choices
Version 3.4

Block 11 - No Operation, do nothing1

Type / Role
n8n-nodes-base.noOp - noOp
Config choices
Version 1

Block 12 - Split ads

Type / Role
n8n-nodes-base.splitOut - splitOut
Config choices
Version 1

Block 13 - Edit Fields

Type / Role
n8n-nodes-base.set - set
Config choices
Version 3.4

Block 14 - Top ads

Type / Role
n8n-nodes-base.googleSheets - googleSheets
Config choices
Version 4.6

Block 15 - Filter1

Type / Role
n8n-nodes-base.filter - filter
Config choices
Version 2.2

Block 16 - extract ads

Type / Role
n8n-nodes-base.code - code
Config choices
Version 2

Block 17 - OpenRouter Chat Model

Type / Role
@n8n/n8n-nodes-langchain.lmChatOpenRouter - lmChatOpenRouter
Config choices
Version 1

Block 18 - Value Proposition & Messaging Analysis

Type / Role
@n8n/n8n-nodes-langchain.chainLlm - chainLlm
Config choices
Version 1.7

Block 19 - Structured Output Parser3

Type / Role
@n8n/n8n-nodes-langchain.outputParserStructured - outputParserStructured
Config choices
Version 1.3

Block 20 - Google Gemini Chat Model3

Type / Role
@n8n/n8n-nodes-langchain.lmChatGoogleGemini - lmChatGoogleGemini
Config choices
Version 1

Block 21 - extensions

Type / Role
n8n-nodes-base.aggregate - aggregate
Config choices
Version 1

Block 22 - OpenRouter Chat Model1

Type / Role
@n8n/n8n-nodes-langchain.lmChatOpenRouter - lmChatOpenRouter
Config choices
Version 1

Block 23 - Google Gemini Chat Model4

Type / Role
@n8n/n8n-nodes-langchain.lmChatGoogleGemini - lmChatGoogleGemini
Config choices
Version 1

Block 24 - Structured Output Parser4

Type / Role
@n8n/n8n-nodes-langchain.outputParserStructured - outputParserStructured
Config choices
Version 1.3

Showing the first 24 of 45 workflow blocks. Download the JSON for the full node graph.

3. Summary Table

Workflow Scrape & analyze Google Ads with Bright Data API and AI for email reports
Complexity advanced
Nodes 45
Categories Market Research, AI Summarization
Author Zacharia Kimotho
Published 22 Jul 2025

4. Reproducing the Workflow from Scratch

  1. 1. Download the workflow JSON

    Use the JSON export at /data/workflows/6256/6256.json as the source template for this automation.

  2. 2. Import the template into n8n

    Open n8n, import the downloaded JSON, and review each node before activating the workflow.

  3. 3. Configure credentials and variables

    Replace placeholder credentials, API keys, webhook URLs, account IDs, and environment-specific values with your own settings.

  4. 4. Test with sample data

    Run the workflow manually or in a staging workspace, inspect node output, and confirm downstream systems receive the expected data.

  5. 5. Activate and monitor

    Enable the workflow only after testing, then monitor executions, errors, and rate limits during the first production runs.

5. General Notes & Resources

Review imported nodes carefully before activation. This catalog entry is intended to help you inspect the workflow structure, understand required services, and find related templates faster.

Node names, credentials, schedules, webhook paths, and external service limits may need adjustment for your workspace.

Frequently asked questions

What does Scrape & analyze Google Ads with Bright Data API and AI for email reports do?

This workflow contains community nodes that are only compatible with the self hosted version of n8n. This workflow is a gem for all PPC managers and experts out there looking to keep track of compe...

What do I need before importing this workflow?

Review the workflow JSON, configure any required credentials in n8n, and test the automation in a safe workspace before using it in production.

Can I customize this workflow?

Yes. Use the block-by-block analysis and the downloadable JSON to inspect each node, then adjust credentials, prompts, schedules, filters, or destinations for your Market Research, AI Summarization use case.