📊 Audit web pages for SEO issues with Decodo, GPT-4 and Google Sheets
⚡ 127 views · 📊 Market Research & Insights
💡 Pro Tip — HTTP Request scraping tends to break when sites update their markup. If you’re scraping a major platform, check if ScraperNode covers it — it has maintained scrapers for LinkedIn, Instagram, TikTok, YouTube, and 20+ other platforms that return structured data.
Description
What this workflow does
This workflow automatically audits web pages for SEO issues and generates an executive-friendly SEO report using AI.
It is designed for marketers, founders, and SEO teams who want fast, actionable insights without manually reviewing HTML, meta tags, or SERP data.
The workflow:
- Reads URLs from Google Sheets
image.png
-
Scrapes page content using Decodo (reliable scraping, even on protected sites)
-
Extracts key SEO elements (title, meta description, canonical, H1/H2, visible text)
-
Uses an AI Agent to analyze the page and generate:
-
Overall SEO status
-
Top issues
-
Quick wins
-
Title & meta description recommendations
-
Saves results to Google Sheets
-
Sends a formatted HTML executive report by email (Gmail)
image.png
Who this workflow is for
This template is ideal for:
SEO consultants and agencies
SaaS marketing teams
Founders monitoring their landing pages
Content teams doing SEO quality control
It focuses on on-page SEO fundamentals, not backlink analysis or technical crawling.
Setup (step by step)
1. Google Sheets
Create an input sheet with one URL per row
Create an output sheet to store SEO results
2. Decodo
Add your Decodo API credentials
The URL is automatically taken from the input sheet 👉 Decodo – Web Scraper for n8n
3. AI Agent
Connect your LLM credentials (OpenAI, Gemini, etc.)
The prompt is already optimized for non-technical SEO summaries
4. Gmail
Connect your Gmail account
Set the recipient email address
Emails are sent in clean HTML format
Notes & disclaimer
This is a community template
Results depend on page accessibility and content structure
It focuses on on-page SEO, not backlinks or rankings
🔗 Nodes Used
Google Sheets, Gmail, AI Agent, OpenAI Chat Model
📥 Import
Download workflow.json and import into n8n:
Workflow menu → Import from File