Automated structured data extract & summary via Decodo + Gemini & Google Sheets
UnknownWhat this workflow does
This AI workflow has 10 nodes and runs manually, when you click “Execute workflow”. Along the way it connects Google Sheets, Google Gemini Chat Model and Decodo (community).
How it runs
Trigger: Manually, when you click “Execute workflow”.
- Set the Input Fields (Edit Fields (Set)): sets 1 field: url
- Decodo: uses Decodo
- Structured Data Extractor (Basic LLM Chain): sends a prompt to an LLM, with model: Google Gemini Chat Model
- Summarize Content (Basic LLM Chain): sends a prompt to an LLM, with model: Google Gemini Chat Model
- Extract the JSON (Code): runs custom JavaScript code
- Merge: merges the data from its input branches
- Append or update row in sheet (Google Sheets): append or update
Services it uses
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 @decodo/n8n-nodes-decodo is verified or supports 3.0 (used in Decodo).
Nodes used (8)
- Manual Trigger
n8n-nodes-base.manualTrigger - Decodo
@decodo/n8n-nodes-decodo.decodo - Edit Fields (Set)
n8n-nodes-base.set - Basic LLM Chain
@n8n/n8n-nodes-langchain.chainLlm - Code
n8n-nodes-base.code - Merge
n8n-nodes-base.merge - Google Sheets
n8n-nodes-base.googleSheets - Google Gemini Chat Model
@n8n/n8n-nodes-langchain.lmChatGoogleGemini
From the author
Who this is for This workflow is designed for: - Automation engineers building AI-powered data pipelines - Product managers & analysts needing structured insights from web pages - Researchers & content teams extracting summaries from documentation or articles…