Automatically discover and extract reports from websites using GPT and Google Sheets
Ready for 3.0Ready 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 15 nodes and runs manually, when you click “Execute workflow” (plus 2 other triggers). Along the way it connects Google Sheets and OpenAI Chat Model.
How it runs
Trigger: Manually, when you click “Execute workflow” (plus 2 other triggers).
- Read Active Sources (Google Sheets): uses Google Sheets
- Loop Over Sources (Loop Over Items (Split in Batches)): loops over the items in batches
- Completion Summary (Edit Fields (Set)): sets 2 fields: sourcesChecked, completedAt
- Fetch Publication Page (HTTP Request): calls an HTTP API
- Convert HTML to Markdown (Markdown): converts between Markdown and HTML
- AI Report Discovery Agent (AI Agent): runs an AI agent, with model: OpenAI GPT-5.; output parser: Structured Output Parser
- Validate & Normalize Output (Code): runs custom JavaScript code
- Valid Report Found? (If): checks a condition and branches into true / false
- Save Discovered Report (Google Sheets): append or update
- Log No Report Found (Google Sheets): append or update
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 (13)
- Manual Trigger
n8n-nodes-base.manualTrigger - Schedule Trigger
n8n-nodes-base.scheduleTrigger - Execute Workflow Trigger
n8n-nodes-base.executeWorkflowTrigger - Google Sheets
n8n-nodes-base.googleSheets - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - HTTP Request
n8n-nodes-base.httpRequest - Markdown
n8n-nodes-base.markdown - AI Agent
@n8n/n8n-nodes-langchain.agent - Structured Output Parser
@n8n/n8n-nodes-langchain.outputParserStructured - Code
n8n-nodes-base.code - If
n8n-nodes-base.if - Edit Fields (Set)
n8n-nodes-base.set - OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi
From the author
An intelligent AI-powered agent that automatically browses publication websites, analyzes page content with natural language understanding, and identifies the latest downloadable reports, research papers, and data files across multiple sources using advanced…