{"product_id":"n8n-workflow-seo-refresh-tasks-with-gsc-glasser-claude-sheets","title":"n8n Workflow: SEO Refresh Tasks with GSC, Glasser, Claude \u0026 Sheets","description":"\u003ch3\u003eRefresh your SEO with source-backed edits—automatically\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow identifies pages worth updating using \u003cstrong\u003eGoogle Search Console (GSC)\u003c\/strong\u003e, benchmarks competitors with \u003cstrong\u003eGlasser\u003c\/strong\u003e, generates \u003cstrong\u003eClaude\u003c\/strong\u003e editing tasks, and logs everything in \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e—including before\/after performance comparisons over equal 28-day windows.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns on a schedule or on demand:\u003c\/strong\u003e manual trigger or a weekly run every Monday.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003ePulls SEO opportunities from GSC:\u003c\/strong\u003e requests two adjacent \u003cstrong\u003e28-day\u003c\/strong\u003e performance windows for a configured GSC property and country via the Search Analytics API.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eManages a task ledger in Google Sheets:\u003c\/strong\u003e reads an existing Tasks tab, selects up to a configured number of \u003cem\u003enon-brand\u003c\/em\u003e page\/query candidates in a target position and impression range, and also finds tasks due for review.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eResearches competitor SERPs with Glasser:\u003c\/strong\u003e 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.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGenerates evidence-backed edit actions with Claude:\u003c\/strong\u003e if enough own-and-competitor evidence is available, sends evidence to Anthropic Claude to produce a JSON content brief containing \u003cstrong\u003e1–5 edit actions\u003c\/strong\u003e. If not, flags the task for manual review.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eUpdates tasks and preserves IDs:\u003c\/strong\u003e appends or updates rows in Google Sheets using \u003cstrong\u003etask_id\u003c\/strong\u003e to keep continuity across runs.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCompares equal windows for due reviews:\u003c\/strong\u003e for recorded edits, queries GSC for \u003cstrong\u003e28-day before\/after\u003c\/strong\u003e metrics and updates the same row with review status and comparison metrics.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eWeekly SEO content refresh planning for SaaS sites using GSC click\/impression and position data.\u003c\/li\u003e\n  \u003cli\u003eGenerating structured, source-backed optimization tasks instead of manual SERP research.\u003c\/li\u003e\n  \u003cli\u003eMeasuring the real impact of content edits with consistent 28-day before\/after windows.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eTrigger:\u003c\/strong\u003e manual trigger or weekly schedule (Mondays).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNodes:\u003c\/strong\u003e if, code, no op, sticky note, \u003cstrong\u003en8n-nodes-glasserglasser\u003c\/strong\u003e, HTTP Request.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegrations:\u003c\/strong\u003e Google Search Console API, \u003cstrong\u003eGlasser\u003c\/strong\u003e (Serper + Firecrawl), \u003cstrong\u003eAnthropic Claude\u003c\/strong\u003e, and \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e (Tasks tab).\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46275701375155,"sku":"N8N-21366","price":40.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/Pa98gLI4ZsWDLb3xnlb7a_QjnKgY9B.png?v=1792833633","url":"https:\/\/buyflowscripts.com\/products\/n8n-workflow-seo-refresh-tasks-with-gsc-glasser-claude-sheets","provider":"N8N Commerce","version":"1.0","type":"link"}