Automate niche research with Wikipedia, GPT-4o-mini, and Google Sheets
UnknownWhat this workflow does
This AI workflow has 9 nodes and runs manually, when you click “Execute workflow”. Along the way it connects Google Sheets, OpenAI and Scrapeops (community). It also calls en.wikipedia.org over HTTP.
How it runs
Trigger: Manually, when you click “Execute workflow”.
- Set Topic (Edit Fields (Set)): sets or maps fields
- Wikipedia Search API (HTTP Request): calls en.wikipedia.org
- Construct Page URL (Code): runs custom JavaScript code
- Scrape Ops: uses Scrape Ops
- Extract History Section (Code): runs custom JavaScript code
- Message a model (OpenAI): uses OpenAI
- Format AI Output (Code): runs custom JavaScript code
- Append row in sheet (Google Sheets): append
Services it uses
HTTP calls to: en.wikipedia.org
Scraping pages by hand? Firecrawl is a simpler option (10% off for new users).
Before you upgrade to n8n 3.0
We can't fully verify this one: it relies on 1 community package, and n8n 3.0 turns unverified community packages off by default (N8N_UNVERIFIED_PACKAGES_ENABLED=false).
- Check that @scrapeops/n8n-nodes-scrapeops is verified or supports 3.0 (used in ScrapeOps Scraper).
Nodes used (7)
- Manual Trigger
n8n-nodes-base.manualTrigger - Edit Fields (Set)
n8n-nodes-base.set - HTTP Request
n8n-nodes-base.httpRequest - Scrape Ops
@scrapeops/n8n-nodes-scrapeops.ScrapeOps - Google Sheets
n8n-nodes-base.googleSheets - OpenAI
@n8n/n8n-nodes-langchain.openAi - Code
n8n-nodes-base.code
From the author
Overview This n8n template automates the process of researching niche topics. It searches for a topic on Wikipedia, scrapes the relevant page using ScrapeOps, extracts the history or background section, and uses AI to generate a concise summary and timeline.…