Scrape & analyze Google Ads with Bright Data API and AI for email reports
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
What this workflow does
This AI workflow has 36 nodes and runs manually, when you click “Execute workflow”. Along the way it connects Google Sheets, OpenRouter Chat Model, Google Gemini Chat Model and Gmail. It also calls api.brightdata.com over HTTP.
How it runs
Trigger: Manually, when you click “Execute workflow”.
- Get Keywords (Google Sheets): uses Google Sheets
- Filter: keeps only the items that match a condition
- Loop Over Items (Loop Over Items (Split in Batches)): loops over the items in batches
- set keyword (Edit Fields (Set)): sets 2 fields: search_term, country code
- Fetch Google Search Results JSON (HTTP Request): calls api.brightdata.com (POST)
- Filter: keeps only the items that match a condition
- ads found (Edit Fields (Set)): sets 2 fields: top_ads, bottom_ads
- extract ads (Code): runs custom JavaScript code
- value proposition (Aggregate): combines items into one
- extensions (Aggregate): combines items into one
…plus 13 more steps. See the full node list below.
Services it uses
HTTP calls to: api.brightdata.com
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (17)
- Manual Trigger
n8n-nodes-base.manualTrigger - HTTP Request
n8n-nodes-base.httpRequest - Google Sheets
n8n-nodes-base.googleSheets - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - Edit Fields (Set)
n8n-nodes-base.set - No Operation, do nothing
n8n-nodes-base.noOp - Split Out
n8n-nodes-base.splitOut - Filter
n8n-nodes-base.filter - Code
n8n-nodes-base.code - OpenRouter Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenRouter - Basic LLM Chain
@n8n/n8n-nodes-langchain.chainLlm - Structured Output Parser
@n8n/n8n-nodes-langchain.outputParserStructured - Google Gemini Chat Model
@n8n/n8n-nodes-langchain.lmChatGoogleGemini - Aggregate
n8n-nodes-base.aggregate - Merge
n8n-nodes-base.merge - AI Agent
@n8n/n8n-nodes-langchain.agent - Gmail
n8n-nodes-base.gmail
From the author
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…