Generate structured research reports with OpenAI, Wikipedia, Google Sheets, and Slack
Ready for 3.0What this workflow does
This AI workflow has 16 nodes and runs when an HTTP POST request hits its webhook URL. Along the way it connects OpenAI, Slack and Google Sheets.
How it runs
Trigger: When an HTTP POST request hits its webhook URL.
- Receive Research Topic (Edit Fields (Set)): sets 1 field: topic
- Validate Research Topic (If): checks a condition and branches into true / false
- z (OpenAI): uses OpenAI
- Parse Search Queries (Code): runs custom JavaScript code
- Search Web (HTTP Request): calls an HTTP API
- Prepare Search Results (Code): runs custom JavaScript code
- Process Search Results (Loop Over Items (Split in Batches)): loops over the items in batches
- Extract Website Content (HTTP Request): calls an HTTP API
- Clean Website Content (Code): runs custom JavaScript code
- Merge: merges the data from its input branches
…plus 5 more steps. See the full node list below.
Services it uses
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 (11)
- Edit Fields (Set)
n8n-nodes-base.set - If
n8n-nodes-base.if - HTTP Request
n8n-nodes-base.httpRequest - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - Merge
n8n-nodes-base.merge - OpenAI
@n8n/n8n-nodes-langchain.openAi - Code
n8n-nodes-base.code - Webhook
n8n-nodes-base.webhook - Respond to Webhook
n8n-nodes-base.respondToWebhook - Slack
n8n-nodes-base.slack - Google Sheets
n8n-nodes-base.googleSheets
From the author
Quick overview This workflow receives a research topic via webhook, uses OpenAI to generate Wikipedia search queries, pulls and cleans matching Wikipedia extracts, then synthesizes a structured report with OpenAI, stores the results in Google Sheets, notifies…