{"product_id":"n8n-research-report-workflow-openai-wikipedia-google-sheets","title":"n8n Research Report Workflow: OpenAI + Wikipedia + Google Sheets","description":"\u003ch3\u003eTurn any research topic into a structured report—automatically\u003c\/h3\u003e\n\u003cp\u003eThis n8n Research Report Workflow accepts a topic via Webhook, uses \u003cstrong\u003eOpenAI\u003c\/strong\u003e to generate targeted \u003cstrong\u003eWikipedia\u003c\/strong\u003e search queries, extracts and cleans matching Wikipedia content, then synthesizes a multi-section research report and saves it to \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e—while notifying \u003cstrong\u003eSlack\u003c\/strong\u003e and returning the result to the caller.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReceives a POST webhook\u003c\/strong\u003e request with a JSON body containing a \u003ccode\u003etopic\u003c\/code\u003e value.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eValidates the topic\u003c\/strong\u003e and uses OpenAI (model noted as \u003cstrong\u003egpt-4o-mini\u003c\/strong\u003e) to generate \u003cstrong\u003efive focused Wikipedia search queries\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSearches Wikipedia\u003c\/strong\u003e for each query, iterates through top results, and fetches the \u003cstrong\u003eplaintext extracts\u003c\/strong\u003e for matching pages.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCleans and normalizes\u003c\/strong\u003e the extracted Wikipedia content, then \u003cstrong\u003emerges\u003c\/strong\u003e it into a single research context.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGenerates a structured report\u003c\/strong\u003e with OpenAI, covering sections such as summary, findings, facts, benefits, challenges, trends, outlook, and references.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eParses output into structured JSON\u003c\/strong\u003e, then \u003cstrong\u003eappends or updates\u003c\/strong\u003e a row in Google Sheets.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003ePosts a completion message to Slack\u003c\/strong\u003e and \u003cstrong\u003ereturns the structured report\u003c\/strong\u003e in the webhook response.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eSaaS operators generating quick “research briefs” for product decisions.\u003c\/li\u003e\n  \u003cli\u003eAutomation engineers building topic-to-report pipelines for internal teams.\u003c\/li\u003e\n  \u003cli\u003eContent and analyst workflows that need consistent report structure with sources.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWebhook\u003c\/strong\u003e (input: \u003ccode\u003etopic\u003c\/code\u003e; output: structured JSON report)\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eOpenAI\u003c\/strong\u003e (query generation + report synthesis; \u003cstrong\u003egpt-4o-mini\u003c\/strong\u003e noted)\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWikipedia extraction\u003c\/strong\u003e (search results + plaintext page extracts)\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e (store Topic, Date, Summary, Result—columns must exist)\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSlack\u003c\/strong\u003e notification on completion\u003c\/li\u003e\n  \u003cli\u003en8n nodes mentioned: \u003cstrong\u003eif\u003c\/strong\u003e, \u003cstrong\u003eset\u003c\/strong\u003e, \u003cstrong\u003ecode\u003c\/strong\u003e, \u003cstrong\u003emerge\u003c\/strong\u003e, \u003cstrong\u003eslack\u003c\/strong\u003e, \u003cstrong\u003ewebhook\u003c\/strong\u003e\n\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46063675506867,"sku":"N8N-19710","price":56.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/KF8RbQI_MNDNs3qKg-k0_Yqy9SZuY.png?v=1789808974","url":"https:\/\/buyflowscripts.com\/products\/n8n-research-report-workflow-openai-wikipedia-google-sheets","provider":"N8N Commerce","version":"1.0","type":"link"}