Analyze Google Ads competitors with Bright Data, OpenRouter and OpenAI

Workflow preview

100%

Open on n8n.io

$20/month : Unlimited workflows

2500 executions/month

Try free

THE #1 IN WEB SCRAPING

Scrape any website without limits

Try free

HOSTINGER

Early Deal
DISCOUNT 20%

Self-hosted n8n

Unlimited workflows - from $4.99/mo

Try free

#1 hub for scraping, AI & automation

6000+ actors - $5 credits/mo

Try free

1. Workflow Overview

Quick Overview This workflow runs daily, reads keywords from Google Sheets, scrapes Google SERP ads via the Bright Data API, analyzes ad messaging and sitelinks with OpenRouter, and generates an HT...

Best for

Automation automation workflows
advanced n8n builders looking for reusable templates

Tools used

n8n-nodes-base.splitinbatches, @n8n/n8n-nodes-langchain.lmchatopenrouter, @n8n/n8n-nodes-langchain.chainllm, @n8n/n8n-nodes-langchain.agent, n8n-nodes-rapiwa.rapiwa, n8n-nodes-base.googlesheets, n8n-nodes-base.scheduletrigger, n8n-nodes-base.filter

Source and attribution

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

Original n8n.io source

1.1 Workflow description

Title: Analyze Google Ads competitors with Bright Data, OpenRouter and OpenAI
Workflow name: Analyze Google Ads competitors with Bright Data, OpenRouter and OpenAI

Quick Overview

This workflow runs daily, reads keywords from Google Sheets, scrapes Google SERP ads via the Bright Data API, analyzes ad messaging and sitelinks with OpenRouter, and generates an HTML report with OpenAI that is delivered via Gmail, WhatsApp (Rapiwa), and Telegram.

How it works

Runs on a daily schedule and loads keywords and country codes from Google Sheets.
Iterates through each keyword, requests Google Search results in JSON format from Bright Data, and routes failures to a WhatsApp error alert via Rapiwa.
Extracts top and bottom ads from the SERP response, splits them into individual ad items, and appends selected ad fields to a Google Sheets “Top ADS” tab.
Aggregates the ad dataset and uses OpenRouter to generate structured insights for value propositions/messaging, sitelink extension strategies, and keyword-to-advertiser mapping.
Combines the three analysis outputs and uses OpenAI to turn them into an HTML-formatted executive report.
Sends the report to the configured Gmail recipient and posts the same output to WhatsApp (Rapiwa) and Telegram, while also sending a WhatsApp completion message.

Setup

Connect Google Sheets OAuth2 credentials and update the spreadsheet ID and sheet tabs used to read keywords and append ad data.
Add Bright Data HTTP Header Auth credentials and replace the zone value (and any required headers) for your Bright Data Scraper API setup.
Add OpenRouter API credentials for the analysis models and an OpenAI API credential for HTML report generation.
Connect Gmail OAuth2 and set the recipient email address and subject format for the report.
Add Rapiwa credentials and replace the WhatsApp number placeholder, then add Telegram credentials and replace the Telegram chat ID placeholder.

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 - Loop Over Items

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

Block 2 - OpenRouter Chat Model

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

Block 3 - Value Proposition & Messaging Analysis

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

Block 4 - OpenRouter Chat Model1

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

Block 5 - Site Link Extension Mining

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

Block 6 - OpenRouter Chat Model2

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

Block 7 - Keyword-Ad Mapping

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

Block 8 - OpenRouter Chat Model3

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

Block 9 - Generate HTML

Type / Role: @n8n/n8n-nodes-langchain.agent - agent
Config choices: Version 2.1

Block 10 - Rapiwa (Send WhatsApp Error Alert)

Type / Role: n8n-nodes-rapiwa.rapiwa - rapiwa
Config choices: Version 1

Block 11 - Rapiwa (Send WhatsApp Complete Message)

Type / Role: n8n-nodes-rapiwa.rapiwa - rapiwa
Config choices: Version 1

Block 12 - Google Sheet (Get Keywords)

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

Block 13 - Schedule (Trigger Every Day)

Type / Role: n8n-nodes-base.scheduleTrigger - scheduleTrigger
Config choices: Version 1.3

Block 14 - Filter (KeyWords)

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

Block 15 - Edit Fields (Set keyword)

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

Block 16 - HTTPS (Fetch Google Search Results JSON)

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

Block 17 - Edit Fields (Ads found)

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

Block 18 - Filter (Ads)

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

Block 19 - Code (Extract Ads)

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

Block 20 - Filter (keyword)

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

Block 21 - Google Sheet (Save Top Ads)

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

Block 22 - Split Out (Ads)

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

Block 23 - Aggregate (value proposition)

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

Block 24 - Aggregate (Extensions)

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

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

3. Summary Table

Workflow	Analyze Google Ads competitors with Bright Data, OpenRouter and OpenAI
Complexity	advanced
Nodes	49
Categories	Automation
Author	SpaGreen Creative
Published	16 Jun 2026

4. Reproducing the Workflow from Scratch

1. Download the workflow JSON

Use the JSON export at /data/workflows/16413/16413.json as the source template for this automation.
2. Import the template into n8n

Open n8n, import the downloaded JSON, and review each node before activating the workflow.
3. Configure credentials and variables

Replace placeholder credentials, API keys, webhook URLs, account IDs, and environment-specific values with your own settings.
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. 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.

Download workflow JSON Original n8n.io source Automation workflows

Frequently asked questions

What does Analyze Google Ads competitors with Bright Data, OpenRouter and OpenAI do?

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 Automation use case.

SpaGreen Creative

60 workflows

Nodes

n8n-nodes-base.splitinbatches @n8n/n8n-nodes-langchain.lmchatopenrouter @n8n/n8n-nodes-langchain.chainllm @n8n/n8n-nodes-langchain.agent n8n-nodes-rapiwa.rapiwa n8n-nodes-base.googlesheets n8n-nodes-base.scheduletrigger n8n-nodes-base.filter

Complexity

advanced

Published 16 Jun 2026

Likes 0

View on n8n.io Download Workflow

Install path: /data/workflows/16413/16413.json

Share Your Workflow

Have a useful automation to share? Publish it and help the community.

Submit Your Template How to Submit

Related Workflows

Generate and publish AI home cam Shorts with OpenAI, kie.ai and YouTube

## Quick overview This workflow runs three times daily to generate an AI “home cam” short video concept with OpenAI, create the video via kie.ai, then download and archive it to Google Drive, upload it to YouTube as a public video, and send a confirmation email via Gmail. ## How it works 1. Runs on a schedule three times a day (08:00, 12:00, and 18:00). 2. Selects a random scenario number from the configured range and asks OpenAI (GPT-4.1-mini) to generate a title, description, tags, and a detailed text-to-video prompt as structured JSON. 3. Builds a kie.ai Sora-2 text-to-video job request using the generated prompt and submits it to the kie.ai API. 4. Waits and repeatedly polls kie.ai until the job succeeds and returns a result payload containing a video download URL. 5. Downloads the generated video file from the returned URL. 6. Uploads the video to a specified Google Drive folder, publishes it to YouTube with the AI-generated metadata, and emails you a notification containing the prompt and video link. ## Setup 1. Add an OpenAI API credential, a kie.ai API key using HTTP Header Auth, and OAuth credentials for Google Drive, YouTube, and Gmail. 2. In the workflow variables, set your notification email address, the target Google Drive folder ID, and the callback URL value used in the kie.ai request. 3. Review or adjust the random scenario range (videoIdeaMin/videoIdeaMax) and YouTube upload settings (for example, privacyStatus and notifySubscribers) before activating the workflow. ## Requirements - OpenAI API credential - kie.ai API key - OAuth credentials for Google Drive, YouTube, and Gmail

View

Score company ad spend from Meta, Google and LinkedIn Ads with Google Sheets

## Quick Overview This workflow pulls Pending companies from Google Sheets, checks their ad activity via Adyntel for Meta (Facebook), Google Ads, and LinkedIn Ads, calculates a budget signal score from ad volume and channel diversity, and writes the results back to the same sheet. ## How it works 1. Runs when you manually execute the workflow in n8n. 2. Reads rows from Google Sheets where the Status column is set to Pending. 3. Processes each company domain in sequence and queries Adyntel for Meta (Facebook) ads, Google Ads, and LinkedIn Ads. 4. Combines the three ad search results into a single dataset for the current company. 5. Calculates per-platform ad counts, total ads, active platforms, channel diversity, and a composite budget_signal_score. 6. Updates the matching row in Google Sheets (by domain), writes the scoring fields, and sets Status to Done before moving to the next company. ## Setup 1. Connect Google Sheets OAuth credentials and set the target spreadsheet and sheet where your company list lives. 2. Add Adyntel API credentials so the workflow can query Meta (Facebook), Google Ads, and LinkedIn Ads by company domain. 3. Ensure your Google Sheet includes at least company_name, domain, and Status columns, with Status set to Pending for rows you want to process.

View

Prioritize exception queues with Gemini, Google Sheets, Slack and Gmail

## Quick Overview This workflow receives a webhook trigger, reads exception records from Google Sheets, uses Google Gemini (Generative Language API) to rank and summarize them, posts a prioritized report to Slack, writes summary metrics back to Google Sheets, and emails a critical alert via Gmail when needed. ## How it works 1. Receives a webhook request to start an exception-queue analysis run. 2. Reads the current exception list from a Google Sheets worksheet and stops with a “No open exceptions found” webhook response if there are no rows. 3. Formats the sheet rows into a structured text list and sends it to the Google Gemini API to generate a ranked, scored priority list plus summary counts. 4. Parses the Gemini response and builds Slack Block Kit content, an HTML email body for critical items, and fields for saving analysis metadata. 5. Appends or updates a summary row in a second Google Sheets worksheet with the AI summary and severity counts. 6. Posts the ranked exception report to a Slack channel. 7. If any critical exceptions are detected, sends an alert email via Gmail, then returns a JSON “Done” response to the original webhook caller with processing statistics. ## Setup 1. Add credentials for Google Sheets OAuth2, Slack OAuth2, and Gmail OAuth2 in n8n. 2. Provide a Google Gemini API key and update the HTTP request to use it (preferably via an n8n credential or environment variable rather than hard-coding). 3. Update the Google Sheets document ID and ensure Sheet1 contains columns like ExceptionID, Title, Severity, System, and ReportedAt, and Sheet2 has columns for summary and count fields used by the workflow. 4. Select the target Slack channel in the Slack node and confirm it matches where you want the priority report posted. 5. Configure the Gmail node with the recipient(s) and ensure your webhook URL (path: /exception-trigger) is used by the system that should trigger the analysis.

View

Need Custom Automation?

Get help designing a custom n8n workflow that connects your stack and fits your process.

Analyze Google Ads competitors with Bright Data, OpenRouter and OpenAI

Workflow preview

1. Workflow Overview

Best for

Tools used

Source and attribution

1.1 Workflow description

Quick Overview

How it works

Setup

1.2 Logical Blocks

2. Block-by-Block Analysis

Block 1 - Loop Over Items

Block 2 - OpenRouter Chat Model

Block 3 - Value Proposition & Messaging Analysis

Block 4 - OpenRouter Chat Model1

Block 5 - Site Link Extension Mining

Block 6 - OpenRouter Chat Model2

Block 7 - Keyword-Ad Mapping

Block 8 - OpenRouter Chat Model3

Block 9 - Generate HTML

Block 10 - Rapiwa (Send WhatsApp Error Alert)

Block 11 - Rapiwa (Send WhatsApp Complete Message)

Block 12 - Google Sheet (Get Keywords)

Block 13 - Schedule (Trigger Every Day)

Block 14 - Filter (KeyWords)

Block 15 - Edit Fields (Set keyword)

Block 16 - HTTPS (Fetch Google Search Results JSON)

Block 17 - Edit Fields (Ads found)

Block 18 - Filter (Ads)

Block 19 - Code (Extract Ads)

Block 20 - Filter (keyword)

Block 21 - Google Sheet (Save Top Ads)

Block 22 - Split Out (Ads)

Block 23 - Aggregate (value proposition)

Block 24 - Aggregate (Extensions)

3. Summary Table

4. Reproducing the Workflow from Scratch

1. Download the workflow JSON

2. Import the template into n8n

3. Configure credentials and variables

4. Test with sample data

5. Activate and monitor

5. General Notes & Resources

Frequently asked questions