Last updated: June 2026
SEO & Marketing Automation

Get a Weekly SEO Report Without Lifting a Finger

Your site is audited every week — titles, H1s, schema, canonical URLs, word count, alt text — all scored, logged, and emailed to you with AI-generated fix priorities. No Semrush required.

6+ hrs
Saved per month on manual SEO page auditing

What this automation does

  • Fetches your sitemap.xml and crawls up to 20 pages per run
  • Scores each page 0–100 across 10 SEO signals
  • Logs full audit data to Google Sheets — full history retained
  • AI (GPT-4o-mini) generates a prioritised weekly recommendations report
  • Emails report every Monday morning — zero manual steps
  • Replaces Semrush ($129/mo) — one-time $79
$79 one-time
No subscription. Lifetime access. Instant download.
Get This Template — $79
  • n8n workflow JSON — ready to import
  • Make.com blueprint — ready to import
  • Setup guide PDF + Markdown
  • Personal commercial licence
  • Email support included
n8n Make.com

Secure checkout via Gumroad

How It Works

Every Monday, the workflow wakes up, fetches your sitemap, and crawls each page one by one. A code node extracts and scores 10 SEO signals per page. All findings go into your Google Sheets audit log. Then GPT-4o-mini analyses all the data and writes you a plain-English recommendations report.

1

Weekly schedule fetches your sitemap.xml

The workflow fires every Monday at 7 AM (configurable). It makes an HTTP request to your sitemap.xml and parses all page URLs.

2

Each page is crawled and scored

The workflow crawls up to 20 pages per run. For each page, a code node extracts SEO signals and calculates a score from 0–100. Each issue costs 12 points.

3

Findings logged to Google Sheets

Every page's score, issues, title, description, H1, schema status, word count, and audit date are appended to your SEO Audit Log sheet. You have a full history over time.

4

AI writes your prioritised recommendations report

GPT-4o-mini analyses the audit data and identifies the top 3 critical issues, quick wins, and your overall site health trend. The full report is emailed to you immediately.

What's Included

n8n workflow8-node workflow — Schedule trigger, HTTP Request (sitemap), Code (parse URLs), HTTP Request (crawl), Code (extract signals), Google Sheets (log), OpenAI (recommendations), Gmail (report)
Make.com blueprintFull scenario JSON — Scheduler, HTTP fetch, Text parser, Google Sheets log, OpenAI, Gmail report
SEO signals checkedTitle (presence + length), meta description (presence + length), H1 tag, canonical URL, noindex check, og:title, JSON-LD schema, images missing alt text, word count
Setup guide (PDF)Plain-English walkthrough — sitemap config, Google Sheets setup, OpenAI key, Gmail, and score interpretation guide
Setup time15–20 minutes with the guide
RequirementsPublic sitemap.xml, Google Sheets, Gmail, OpenAI API key (~$0.02/week), n8n or Make.com

Frequently Asked Questions

What SEO signals does the workflow check?

The workflow checks 10 signals per page: title tag (presence, length), meta description (presence, length), H1 tag, canonical URL, robots noindex flag, og:title, JSON-LD structured data, images missing alt text, and word count. Each issue found deducts 12 points from a 100-point score.

How many pages does it crawl per week?

By default, up to 20 pages per run. You can increase this by changing MAX_PAGES in the Parse Sitemap URLs code node. For large sites, running daily on batches is more practical than crawling hundreds of pages in one run.

Do I need an OpenAI API key?

Yes — but a report costs under $0.02 in OpenAI credits. GPT-4o-mini is the cheapest capable model available. You need an account at platform.openai.com with a small credit balance ($5 minimum). The setup guide walks through this step.

How do I read the SEO score?

90–100: Excellent. 70–89: Good — a few items to address. 50–69: Needs work. Under 50: Critical — immediate attention required. Each issue deducts exactly 12 points. Fix 3 issues on a 50-score page and it becomes 86.

Can this replace Semrush or Ahrefs?

For technical on-page SEO auditing of your own site, yes. Semrush costs $129/month. This template covers the most impactful on-page signals for a one-time $79. It does not cover keyword research, competitor analysis, or backlink tracking.

What does the Google Sheets audit log include?

Each row records: URL, SEO score, title content, meta description, H1, issue count, full issue list, word count, schema presence, images missing alt, and date checked. You get a full history — track score improvements week over week as you fix issues.

Know Your SEO Health Every Week — Automatically

One-time $79. No monthly fees. Set up in under 20 minutes.

Get the Template — $79

Instant download via Gumroad  ·  Includes n8n + Make.com workflows  ·  Email support