Weekly SEO watchlist audit to Google Sheets with Gemini and Decodo
UnknownUnknown. This template uses community nodes we can't verify statically. Uses community nodes that can't be verified statically (unverified community packages are off by default in 3.0). Static check, last run 2026-10-19.
What this workflow does
This AI workflow has 14 nodes and runs on a schedule (every week). Along the way it connects Google Sheets, Google Gemini Chat Model and Decodo (community).
How it runs
Trigger: On a schedule (every week).
- Set: Configure Workflow (Edit Fields (Set)): sets 1 field: sheet_id
- Read Input URLs (Google Sheets) (Google Sheets): uses Google Sheets
- Loop URLs (Split in Batches) (Loop Over Items (Split in Batches)): loops over the items in batches
- Decodo: uses Decodo
- Generate SEO Audit (Basic LLM Chain): sends a prompt to an LLM, with model: AI Model: Google Gemini; output parser: Output Parser: Enforce SEO JSON
- Transform: Summary Row (Code): runs custom JavaScript code
- Transform: Explode Issues (Code): runs custom JavaScript code
- Google Sheets: append
- Google Sheets: append
- Join Summary + Issues (Merge): merges the data from its input branches
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: Fetch Page Content).
Nodes used (11)
- No Operation, do nothing
n8n-nodes-base.noOp - Google Sheets
n8n-nodes-base.googleSheets - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - Google Gemini Chat Model
@n8n/n8n-nodes-langchain.lmChatGoogleGemini - Structured Output Parser
@n8n/n8n-nodes-langchain.outputParserStructured - Schedule Trigger
n8n-nodes-base.scheduleTrigger - Decodo
@decodo/n8n-nodes-decodo.decodo - Basic LLM Chain
@n8n/n8n-nodes-langchain.chainLlm - Code
n8n-nodes-base.code - Merge
n8n-nodes-base.merge - Edit Fields (Set)
n8n-nodes-base.set
From the author
Quick overview Sign up for Decodo HERE for Discount Automatically fetches page content, generates a compact SEO audit (score, issues, fixes), and writes both a per-URL summary and a normalized “All Issues” table to Google Sheets—great for weekly monitoring…