Workflow Library
← LibraryPricingLog in
🔎 Web Scraping & ResearchAdvanced🧠 AI-powered

Keyword Researcher

A 227-step web scraping & research automation, triggered by schedule, manual, connecting OpenAI (LLM), Google Sheets, HTTP / REST API, Google Gemini, 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 OpenAI (LLM), Google Sheets, Google Gemini on a set schedule (e.g. daily) — competitor tracking, research, monitoring — and hands you the result.

227
Nodes
4
Integrations
205
Connections
Schedule, Manual
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.

▶Schedule TriggerscheduleTrigger•Google_trends searchserpApi🧠AI Agentagent🧠OpenAI Chat ModellmChatOpenAi🧠Structured Output Par…outputParserStructu…📊Get row(s) in sheet i…googleSheetsTool•Edit Fieldsset📊Append row in sheet1googleSheets🧠AI Agent1agent🧠OpenAI Chat Model1lmChatOpenAi🧠Structured Output Par…outputParserStructu…📊Get row(s) in sheet i…googleSheetsTool•Edit Fields1set📊Append row in sheet2googleSheets•TechnologyserpApi•Engineering and Scien…serpApi▶Schedule Trigger2scheduleTrigger🧠AI Agent2agent🧠OpenAI Chat Model2lmChatOpenAi🧠Structured Output Par…outputParserStructu…📊Get row(s) in sheet i…googleSheetsTool•Edit Fields2set📊Append row in sheetgoogleSheets•Fang Companies leaksserpApi•Future productsserpApi▶Schedule Trigger3scheduleTrigger🧠AI Agent3agent🧠OpenAI Chat Model3lmChatOpenAi🧠Structured Output Par…outputParserStructu…📊Get row(s) in sheet i…googleSheetsTool•Edit Fields3set📊Append row in sheet3googleSheets•Property buy in EuropeserpApi▶Schedule Trigger4scheduleTrigger🧠AI Agent4agent🧠OpenAI Chat Model4lmChatOpenAi🧠Structured Output Par…outputParserStructu…📊Get row(s) in sheet i…googleSheetsTool•Edit Fields4set📊Append row in sheet4googleSheets•Search Engine Optimis…serpApi•BloggingserpApi•Article WritingserpApi•RankingserpApi•SEO toolsserpApi▶Schedule Trigger5scheduleTrigger🧠AI Agent5agent🧠OpenAI Chat Model5lmChatOpenAi🧠Structured Output Par…outputParserStructu…📊Get row(s) in sheet i…googleSheetsTool•Edit Fields5set📊Append row in sheet5googleSheets•Graphics DesignserpApi•UI ToolsserpApi•UX ToolsserpApi•WebsitesserpApi•ApplicationsserpApi▶Schedule Trigger6scheduleTrigger🧠AI Agent6agent🧠OpenAI Chat Model6lmChatOpenAi🧠Structured Output Par…outputParserStructu…📊Get row(s) in sheet i…googleSheetsTool•Edit Fields6set📊Append row in sheet6googleSheets•Elon MuskserpApi•Elon Musk NewsserpApi•InventionsserpApi•StartupsserpApi▶Schedule Trigger1scheduleTrigger▶Schedule Trigger7scheduleTrigger🧠AI Agent7agent🧠OpenAI Chat Model7lmChatOpenAi🧠Structured Output Par…outputParserStructu…📊Get row(s) in sheet i…googleSheetsTool•Edit Fields7set📊Append row in sheet7googleSheets•Inventions1serpApi•Startups1serpApi•Bill Gates NewsserpApi•Bill GatesserpApi▶Schedule Trigger8scheduleTrigger🧠AI Agent8agent🧠OpenAI Chat Model8lmChatOpenAi🧠Structured Output Par…outputParserStructu…📊Get row(s) in sheet i…googleSheetsTool•Edit Fields8set📊Append row in sheet8googleSheets•Inventions2serpApi•Startups2serpApi•Jeff Bezos NewsserpApi•Jeff BezosserpApi•Technology1serpApi▶Schedule Trigger9scheduleTrigger🧠AI Agent9agent🧠OpenAI Chat Model9lmChatOpenAi🧠Structured Output Par…outputParserStructu…📊Get row(s) in sheet i…googleSheetsTool•Edit Fields9set📊Append row in sheet9googleSheets•AI SEOserpApi•SEOserpApi•How To SEOserpApi•SEO Tools ComparisonserpApi▶Schedule Trigger10scheduleTrigger🧠AI Agent10agent🧠OpenAI Chat Model10lmChatOpenAi🧠Structured Output Par…outputParserStructu…📊Get row(s) in sheet i…googleSheetsTool•Edit Fields10set📊Append row in sheet10googleSheets•Web HostingserpApi•cloud platformsserpApi•NetworkingserpApi•CloudserpApi▶Schedule Trigger11scheduleTrigger🧠AI Agent11agent🧠OpenAI Chat Model11lmChatOpenAi🧠Structured Output Par…outputParserStructu…📊Get row(s) in sheet i…googleSheetsTool•Edit Fields11set📊Append row in sheet11googleSheets•Web Hosting1serpApi•cloud platforms1serpApi•Networking1serpApi•Cloud1serpApi▶Schedule Trigger12scheduleTrigger🧠AI Agent12agent🧠OpenAI Chat Model12lmChatOpenAi🧠Structured Output Par…outputParserStructu…📊Get row(s) in sheet i…googleSheetsTool•Edit Fields12set📊Append row in sheet12googleSheets•ProgrammingserpApi•How ToserpApi▶Schedule Trigger13scheduleTrigger🧠AI Agent13agent🧠OpenAI Chat Model13lmChatOpenAi🧠Structured Output Par…outputParserStructu…📊Get row(s) in sheet i…googleSheetsTool•Edit Fields13set📊Append row in sheet13googleSheets•CRM PlatformsserpApi•How To CRMserpApi▶Schedule Trigger14scheduleTrigger🧠AI Agent14agent🧠OpenAI Chat Model14lmChatOpenAi🧠Structured Output Par…outputParserStructu…📊Get row(s) in sheet i…googleSheetsTool•Edit Fields14set📊Append row in sheet14googleSheets•Properties in EuropeserpApi•DestinationsserpApi•TravelserpApi•TicketsserpApi▶Schedule Trigger15scheduleTrigger🧠AI Agent15agent🧠OpenAI Chat Model15lmChatOpenAi🧠Structured Output Par…outputParserStructu…📊Get row(s) in sheet i…googleSheetsTool•Edit Fields15set📊Append row in sheet15googleSheets•Travel1serpApi•Properties in AsiaserpApi•Destinations in AsiaserpApi▶Schedule Trigger16scheduleTrigger🧠AI Agent16agent🧠OpenAI Chat Model16lmChatOpenAi🧠Structured Output Par…outputParserStructu…📊Get row(s) in sheet i…googleSheetsTool•Edit Fields16set📊Append row in sheet16googleSheets•Travel2serpApi•Rental PropertiesserpApi•Properties for SaleserpApi▶Schedule Trigger17scheduleTrigger🧠AI Agent17agent🧠OpenAI Chat Model17lmChatOpenAi🧠Structured Output Par…outputParserStructu…📊Get row(s) in sheet i…googleSheetsTool•Edit Fields17set📊Append row in sheet17googleSheets•Home InteriorserpApi•Home DecorationserpApi▶Schedule Trigger18scheduleTrigger🧠AI Agent18agent🧠OpenAI Chat Model18lmChatOpenAi🧠Structured Output Par…outputParserStructu…📊Get row(s) in sheet i…googleSheetsTool•Edit Fields18set📊Append row in sheet18googleSheets•Tech TrendsserpApi•AIserpApi•GamingserpApi•iphoneserpApi•androidserpApi▶Schedule Trigger19scheduleTrigger🧠AI Agent19agent🧠OpenAI Chat Model19lmChatOpenAi🧠Structured Output Par…outputParserStructu…📊Get row(s) in sheet i…googleSheetsTool•Edit Fields19set📊Append row in sheet19googleSheets•openAi newsserpApi•Apple NewsserpApi•tech newsserpApi•newsserpApi▶Schedule Trigger20scheduleTrigger🧠AI Agent20agent🧠OpenAI Chat Model20lmChatOpenAi🧠Structured Output Par…outputParserStructu…📊Get row(s) in sheet i…googleSheetsTool•Edit Fields20set📊Append row in sheet20googleSheets•Gaming1serpApi•game comparisonsserpApi•games walkthroughsserpApi•gaming newsserpApi▶When clicking ‘Execut…manualTrigger🌐Related KeywordshttpRequest•Filter Keywordscode•Aggregate1aggregate🌐Related Keywords1httpRequest•Filter Keywords1code•Aggregateaggregate🧠AI Agent21agent✨Google Gemini Chat Mo…lmChatGoogleGemini📊Get row(s) in sheet i…googleSheetsTool

⚙️ How it works

  1. Schedule Trigger · scheduleTrigger
  2. OpenAI Chat Model · lmChatOpenAi
  3. Structured Output Parser · outputParserStructured
  4. Get row(s) in sheet in Google Sheets · googleSheetsTool
  5. OpenAI Chat Model1 · lmChatOpenAi
  6. Structured Output Parser1 · outputParserStructured
  7. Get row(s) in sheet in Google Sheets1 · googleSheetsTool
  8. Schedule Trigger2 · scheduleTrigger
  9. OpenAI Chat Model2 · lmChatOpenAi
  10. Structured Output Parser2 · outputParserStructured
  11. Get row(s) in sheet in Google Sheets2 · googleSheetsTool
  12. Schedule Trigger3 · scheduleTrigger
  13. OpenAI Chat Model3 · lmChatOpenAi
  14. Structured Output Parser3 · outputParserStructured

💼 Business analysis

🎯

Business use case

An automated research/monitoring workflow that gathers external data (OpenAI (LLM), Google Sheets, HTTP / REST API, Google Gemini), 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

🧠OpenAI (LLM)📊Google Sheets🌐HTTP / REST API✨Google Gemini
Node typesscheduleTrigger, serpApi, agent, lmChatOpenAi, outputParserStructured, googleSheetsTool, set, googleSheets, manualTrigger, httpRequest, code, aggregate, lmChatGoogleGeminiWorkflow IDU9Aho9VyNmcNRw7d
⬇ Download workflow JSON ← Back to library