Templates / Generate structured research reports with OpenAI, Wikipedia, Google Sheets, and Slack

Generate structured research reports with OpenAI, Wikipedia, Google Sheets, and Slack

Ready for 3.0

by WeblineIndia ✓ · 14 views · created 2026-09-18 · Market Research, AI RAG

Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.

What 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.

  1. Receive Research Topic (Edit Fields (Set)): sets 1 field: topic
  2. Validate Research Topic (If): checks a condition and branches into true / false
  3. z (OpenAI): uses OpenAI
  4. Parse Search Queries (Code): runs custom JavaScript code
  5. Search Web (HTTP Request): calls an HTTP API
  6. Prepare Search Results (Code): runs custom JavaScript code
  7. Process Search Results (Loop Over Items (Split in Batches)): loops over the items in batches
  8. Extract Website Content (HTTP Request): calls an HTTP API
  9. Clean Website Content (Code): runs custom JavaScript code
  10. Merge: merges the data from its input branches

…plus 5 more steps. See the full node list below.

Services it uses

OpenAISlackGoogle Sheets

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)

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…

Excerpt from WeblineIndia's description on n8n.io.

View the original on n8n.io → Check your own copy

Get the weekly “what broke” email

New templates, newly broken ones, and n8n release changes. One short email a week.

Form not loading? Subscribe here.