🔎 Web Scraping & ResearchIntermediate🧠 AI-powered

Dellas Kelso Keyword Research

A 30-step web scraping & research automation, triggered by schedule, connecting HTTP / REST API, OpenRouter (LLM), Google Sheets, with built-in AI reasoning.

⬇ Download workflow JSON
💡

What this does for your business

In plain terms: this gathers information from the web for you. It collects and organises data from OpenRouter (LLM), Google Sheets on a set schedule (e.g. daily) — competitor tracking, research, monitoring — and hands you the result.

30
Nodes
3
Integrations
30
Connections
Schedule
Trigger

🚀 Deploy this workflow

Deploy this automation in minutes

Log in and we'll walk you through every key step by step, then deploy it for you.

Get started free Log in

🏗️ Architecture diagram

The real node graph exported from n8n — triggers (green), AI nodes (violet), services and logic — laid out as they run.

🌐SERP GooglehttpRequestFilter GooglecodeAggregateaggregate🌐DataforSEO Location C…httpRequest🧠AI Agentagent🧠OpenRouter Chat ModellmChatOpenRouter🌐HTTP RequesthttpRequestTool🧠Structured Output Par…outputParserStructu…Loop Over ItemssplitInBatches📊Append row in sheetgoogleSheetsSchedule TriggerscheduleTrigger📊Get row(s) in sheetgoogleSheets📊Update row in sheetgoogleSheets📊Append or update row …googleSheetsSchedule Trigger1scheduleTrigger📊Get row(s) in sheet1googleSheets📊Update row in sheet1googleSheets🧠Competitor Analystagent🧠Output1outputParserStructu…🌐URL_searchhttpRequestTool🧠ThinktoolThink🧠OpenRouterlmChatOpenRouter📊Append row in sheet1googleSheets📊Append or update row …googleSheets🌐HTTP Request1httpRequest🧠AI Agent1agent🧠OpenRouter Chat Model1lmChatOpenRouter🧠Structured Output Par…outputParserStructu…Ifif📊Append or update row …googleSheets

⚙️ How it works

  1. OpenRouter Chat Model · lmChatOpenRouter
  2. HTTP Request · httpRequestTool
  3. Structured Output Parser · outputParserStructured
  4. Schedule Trigger · scheduleTrigger
  5. Schedule Trigger1 · scheduleTrigger
  6. URL_search · httpRequestTool
  7. Think · toolThink
  8. OpenRouter · lmChatOpenRouter
  9. OpenRouter Chat Model1 · lmChatOpenRouter
  10. Structured Output Parser1 · outputParserStructured
  11. AI Agent · agent
  12. Get row(s) in sheet · googleSheets
  13. Get row(s) in sheet1 · googleSheets
  14. Competitor Analyst · agent

💼 Business analysis

🎯

Business use case

An automated research/monitoring workflow that gathers external data (HTTP / REST API, OpenRouter (LLM), Google Sheets), structures it, and delivers insight on a schedule — competitor tracking, market monitoring, data collection.

📈

Market need

Timely external data (competitors, prices, trends) drives decisions, but collecting it by hand is impractical. Automated research is a durable need.

💰

Market value

Data/monitoring subscriptions run $50–$500/mo; the collection engine is the defensible core.

🧩 Integrations & stack

🌐HTTP / REST API🧠OpenRouter (LLM)📊Google Sheets
Node typeshttpRequest, code, aggregate, agent, lmChatOpenRouter, httpRequestTool, outputParserStructured, splitInBatches, googleSheets, scheduleTrigger, toolThink, ifWorkflow IDKls5xQBQJQ2BkSYz
⬇ Download workflow JSON ← Back to library