This n8n workflow automates the process of fetching Google search results via Bright Data, analyzing paid ads, extracting core messaging, and mapping keywords to advertisers. It begins with a manual trigger to start the process, then fetches search result data using an HTTP request to Bright Data’s API, passing search terms and country codes dynamically. The workflow retrieves keywords from a Google Sheet and loops through each keyword to perform multiple analytical steps. Each iteration involves setting the keyword, fetching top and bottom ads, and splitting ad data for granular analysis.

The workflow further extracts and categorizes ad extensions, particularly site links, to identify strategic CTA destinations, such as service pages or blogs. It also processes ads to analyze messaging strategies, value propositions, and key phrases using language models like OpenRouter, Google Gemini, and custom scripts. These AI-powered analyses generate structured insights about advertiser positioning, messaging tone, and competitive differentiation.

Results are compiled into comprehensive HTML reports, highlighting ad strategies, link patterns, and keyword-ad relationships. These reports can be emailed to marketing teams for strategic review. The workflow is ideal for digital marketing agencies, SEO specialists, or businesses conducting competitive ad intelligence and keyword strategy optimization, providing deep insights into paid search tactics and messaging trends.

Node Count	>20 Nodes
Nodes Used	@n8n/n8n-nodes-langchain.agent, @n8n/n8n-nodes-langchain.chainLlm, @n8n/n8n-nodes-langchain.lmChatGoogleGemini, @n8n/n8n-nodes-langchain.lmChatOpenRouter, @n8n/n8n-nodes-langchain.outputParserStructured, aggregate, code, filter, gmail, googleSheets, httpRequest, manualTrigger, merge, noOp, set, splitInBatches, splitOut, stickyNote