Competitor intelligence agent: SERP monitoring + summary with Thordata + OpenAI
Ready for 3.0What this workflow does
This AI workflow has 17 nodes and runs manually, when you click “Execute workflow”. Along the way it connects OpenAI Chat Model, HTTP Request and Google Sheets. It also calls scraperapi.thordata.com over HTTP.
How it runs
Trigger: Manually, when you click “Execute workflow”.
- Set the Input Fields (Edit Fields (Set)): sets 1 field: search_query
- AI Agent: runs an AI agent, with model: OpenAI Chat Model; 4 tools (Bing Search, Google Search, Yandex Search, DuckDuckGo Search)
- Summarize the content (Basic LLM Chain): sends a prompt to an LLM, with model: OpenAI Chat Model; output parser: Structured Output Parser
- Keyword and Topic Analysis (Information Extractor): extracts structured fields from text with AI, with model: OpenAI Chat Model
- SEO Analyst (Information Extractor): extracts structured fields from text with AI, with model: OpenAI Chat Model
- Merge: merges the data from its input branches
- Append or update row in sheet (Google Sheets): append or update
Services it uses
HTTP calls to: scraperapi.thordata.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 (10)
- AI Agent
@n8n/n8n-nodes-langchain.agent - OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi - Http Request Tool
n8n-nodes-base.httpRequestTool - Manual Trigger
n8n-nodes-base.manualTrigger - Edit Fields (Set)
n8n-nodes-base.set - Basic LLM Chain
@n8n/n8n-nodes-langchain.chainLlm - Information Extractor
@n8n/n8n-nodes-langchain.informationExtractor - Structured Output Parser
@n8n/n8n-nodes-langchain.outputParserStructured - Google Sheets
n8n-nodes-base.googleSheets - Merge
n8n-nodes-base.merge
From the author
Who this is for? This workflow is designed for: Marketing analysts, SEO specialists, and content strategists who want automated intelligence on their online competitors. Growth teams that need quick insights from SERP (Search Engine Results Pages) without…