Automation library · Lead generation

Scrape & analyze Google Ads with Bright Data API

Started by an event in a connected app, and works across Gmail and Google Sheets. It hands the judgement calls to Gemini and OpenRouter. 36 steps, 1 loop or waits: large, and worth reading before you trust it with anything live.

LargeCalls a model: Gemini, OpenRouter

Download free
36 stepsLarge: read it before trusting it with anything live
0Branches: places the flow splits
1Loop or waits
2Services it connects to

The flow

Starts it 1Model 15Logic 16Service 4

The steps in the order they run, from what starts it.

  1. 1When clicking ‘Execute workflow’Manual triggerStarts it
  2. 2OpenRouter Chat ModelLm Chat Open RouterModel
  3. 3Structured Output Parser3Output Parser StructuredModel
  4. 4Google Gemini Chat Model3Lm Chat Google GeminiModel
  5. 5OpenRouter Chat Model1Lm Chat Open RouterModel
  6. 6Google Gemini Chat Model4Lm Chat Google GeminiModel
  7. 7Structured Output Parser4Output Parser StructuredModel
  8. 8OpenRouter Chat Model2Lm Chat Open RouterModel
  9. 9Google Gemini Chat Model5Lm Chat Google GeminiModel
  10. 10Structured Output Parser5Output Parser StructuredModel
  11. 11Google Gemini Chat Model6Lm Chat Google GeminiModel
  12. 12OpenRouter Chat Model3Lm Chat Open RouterModel
  13. 13Get KeywordsGoogle SheetsService
  14. 14Value Proposition & Messaging AnalysisChain LlmModel
  15. 15Site Link Extension MiningChain LlmModel
  16. 16Keyword-Ad MappingChain LlmModel
  17. 17Generate HTMLAgentModel
  18. 18Filter1FilterLogic
  19. 19value propositionSetLogic
  20. 20site linksSetLogic
  21. 21keywords1SetLogic
  22. 22Send a messageGmailService
  23. 23Loop Over ItemsSplit In BatchesLogic
  24. 24Merge1MergeLogic
  25. 25set keywordSetLogic
  26. 26Fetch Google Search Results JSONHttp RequestService
  27. 27filter adsFilterLogic
  28. 28No Operation, do nothing1No OpLogic
  29. 29ads foundSetLogic
  30. 30extract adsCodeLogic
  31. 31value proposition1AggregateLogic
  32. 32extensionsAggregateLogic
  33. 33keywordsAggregateLogic
  34. 34Split adsSplit OutLogic
  35. 35Edit FieldsSetLogic
  36. 36Top adsGoogle SheetsService

How it's built

Starts on
An event in a connected app
Steps
36, 1 loop or waits
Size
Large: read it before trusting it with anything live
Connects to
Gmail, Google Sheets
Model
Gemini, OpenRouter

Questions

What does it need to run?

An n8n account, plus your own Gmail and Google Sheets accounts, and a key for Gemini and OpenRouter. You connect your own accounts after importing it; none are included.

What starts it?

It starts on an event in a connected app.

Does it use AI?

Yes. It calls Gemini and OpenRouter. Model calls are billed by the provider, not by n8n.

How long does it take to set up?

Take your time. At 36 steps it is large: read it before trusting it with anything live.

How do I import it?

Copy the workflow, open a new workflow in n8n and paste. The steps appear on the canvas, ready for your own accounts.

Before you run it

Nothing here has been tested by us. It is somebody's working automation, read and described from its own steps. Treat the connections it wants as a list of accounts it will touch, and read the 36 steps before you point it at anything that matters.