Skip to main content

Weekly SEO watchlist audit to Google Sheets with Gemini and Decodo

n8n Cloud
$20/month : Unlimited workflows
2500 executions/month
Try free
Bright Data
THE #1 IN WEB SCRAPING
Scrape any website without limits
Try free
HOSTINGER 🎉 Early Black Friday Deal
DISCOUNT 20%
Self-hosted n8n
Unlimited workflows - from $4.99/mo
Try free
Apify
#1 hub for scraping, AI & automation
6000+ actors - $5 credits/mo
Try free

Weekly SEO Watchlist Audit to Google Sheets (Gemini + Decodo)

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.

Who’s it for?

Content/SEO teams that want lightweight, scheduled audits of key pages with actionable next steps and spreadsheet reporting.

How it works

  1. Weekly trigger loads the Google Sheet of URLs.
  2. Split in Batches processes each URL.
  3. Decodo fetches page content (markdown + status).
  4. Gemini produces a strict JSON audit via the AI Chain + Output Parser.
  5. Code nodes flatten data for two tabs.
  6. Google Sheets nodes append Summary and All Issues rows.
  7. Split in Batches continues to the next URL.

How to set up

  • 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.