📊 Weekly SEO watchlist audit to Google Sheets with Gemini and Decodo
⚡ 172 views · 📊 Market Research & Insights
Description
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 and prioritization.
How it works
- Weekly trigger loads the Google Sheet of URLs.
- Split in Batches processes each URL.
- Decodo fetches page content (markdown + status).
- Gemini produces a strict JSON audit via the AI Chain + Output Parser.
- Code nodes flatten data for two tabs.
- Google Sheets nodes append Summary and All Issues rows.
- Split in Batches continues to the next URL.
Setup
- Add credentials for Google Sheets, Decodo, and Gemini.
- Set sheet_id and Sheet GIDs in the Set node.
- Ensure input sheet has a URL column.
- Configure your Google Sheets tabs with proper headers matching each field being appended (e.g., URL, Decodo Score, Priority, etc.).
- Adjust schedule as needed.
- Activate the workflow.
Additional info
Published by Fahmi Fahreza, Indonesia’s first official n8n Brand Ambassador and founder of WithMi Automation, built from real client implementations, not tutorials. → Let us build it for you: withmiautomation.com → Learn to build it yourself: academy.withmiautomation.com → Bring Fahmi to your team (training, workshop, talkshow): fahmiiireza.com
🔗 Nodes Used
Google Sheets, Schedule Trigger, Basic LLM Chain, Structured Output Parser, Google Gemini Chat Model
📥 Import
Download workflow.json and import into n8n:
Workflow menu → Import from File