Analyze Google Ads competitors with Bright Data, OpenRouter and OpenAI
UnknownUnknown. This template uses community nodes we can't verify statically. Uses community nodes that can't be verified statically (unverified community packages are off by default in 3.0). Static check, last run 2026-10-19.
What this workflow does
This AI workflow has 39 nodes and runs on a schedule (every day). Along the way it connects OpenRouter Chat Model, Google Sheets, OpenAI Chat Model and Gmail and 2 more.
How it runs
Trigger: On a schedule (every day).
- Google Sheet (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
- Rapiwa: uses Rapiwa
- Edit Fields (Set): sets or maps fields
- HTTPS (Fetch Google Search Results JSON) (HTTP Request): calls an HTTP API
- Filter: keeps only the items that match a condition
- Rapiwa: uses Rapiwa
- Edit Fields (Ads found) (Edit Fields (Set)): sets or maps fields
- Code: runs custom JavaScript code
…plus 17 more steps. See the full node list below.
Services it uses
Before you upgrade to n8n 3.0
We can't fully verify this one: it relies on 1 community package, and n8n 3.0 turns unverified community packages off by default (N8N_UNVERIFIED_PACKAGES_ENABLED=false).
- Check that n8n-nodes-rapiwa is verified or supports 3.0 (used in Rapiwa (Send WhatsApp Error Alert), Rapiwa (Send WhatsApp Complete Message), Rapiwa (Send WhatsApp Alert)).
Nodes used (20)
- Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - OpenRouter Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenRouter - Basic LLM Chain
@n8n/n8n-nodes-langchain.chainLlm - AI Agent
@n8n/n8n-nodes-langchain.agent - Rapiwa
n8n-nodes-rapiwa.rapiwa - Google Sheets
n8n-nodes-base.googleSheets - Schedule Trigger
n8n-nodes-base.scheduleTrigger - Filter
n8n-nodes-base.filter - Edit Fields (Set)
n8n-nodes-base.set - HTTP Request
n8n-nodes-base.httpRequest - Code
n8n-nodes-base.code - Split Out
n8n-nodes-base.splitOut - Aggregate
n8n-nodes-base.aggregate - Merge
n8n-nodes-base.merge - Structured Output Parser
@n8n/n8n-nodes-langchain.outputParserStructured - OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi - Code Tool
@n8n/n8n-nodes-langchain.toolCode - Simple Memory
@n8n/n8n-nodes-langchain.memoryBufferWindow - Gmail
n8n-nodes-base.gmail - Telegram
n8n-nodes-base.telegram
From the author
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…