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.
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
What it does
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 !image.png(fileId:1819) 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 serpapi 3. Add this to your account If you have any questions, feel free to reach out via linkedin