Audit Web Pages for SEO Issues with Decodo, GPT-4 and Google Sheets

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:

1. Reads URLs from Google Sheets

1. Scrapes page content using Decodo (reliable scraping, even on protected sites)

2. Extracts key SEO elements (title, meta description, canonical, H1/H2, visible text)

3. 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)

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