n8n Workflow: SEO Refresh Tasks with GSC, Glasser, Claude & Sheets

Refresh your SEO with source-backed edits—automatically

This n8n workflow identifies pages worth updating using Google Search Console (GSC), benchmarks competitors with Glasser, generates Claude editing tasks, and logs everything in Google Sheets—including before/after performance comparisons over equal 28-day windows.

What this workflow does

• Runs on a schedule or on demand: manual trigger or a weekly run every Monday.
• Pulls SEO opportunities from GSC: requests two adjacent 28-day performance windows for a configured GSC property and country via the Search Analytics API.
• Manages a task ledger in Google Sheets: reads an existing Tasks tab, selects up to a configured number of non-brand page/query candidates in a target position and impression range, and also finds tasks due for review.
• Researches competitor SERPs with Glasser: for each candidate, fetches SERP results (Serper provider), selects competitor URLs ahead of your page, and scrapes your page plus competitor pages (Firecrawl provider) for readable content.
• Generates evidence-backed edit actions with Claude: if enough own-and-competitor evidence is available, sends evidence to Anthropic Claude to produce a JSON content brief containing 1–5 edit actions. If not, flags the task for manual review.
• Updates tasks and preserves IDs: appends or updates rows in Google Sheets using task_id to keep continuity across runs.
• Compares equal windows for due reviews: for recorded edits, queries GSC for 28-day before/after metrics and updates the same row with review status and comparison metrics.

Use cases

• Weekly SEO content refresh planning for SaaS sites using GSC click/impression and position data.
• Generating structured, source-backed optimization tasks instead of manual SERP research.
• Measuring the real impact of content edits with consistent 28-day before/after windows.

Technical details

• Trigger: manual trigger or weekly schedule (Mondays).
• Nodes: if, code, no op, sticky note, n8n-nodes-glasserglasser, HTTP Request.
• Integrations: Google Search Console API, Glasser (Serper + Firecrawl), Anthropic Claude, and Google Sheets (Tasks tab).