n8n Weekly SEO Opportunity Briefs: GSC CTR Radar + Webflow

Turn Google Search Console data into weekly SEO quick wins—automatically.

This n8n workflow pulls your latest Google Search Console Search Analytics (28-day) performance, finds pages/queries with low CTR but meaningful rankings (positions 4–20), and then creates or updates a draft SEO Opportunity Radar brief in your Webflow CMS every week.

What this workflow does

• Runs weekly (or manually): Scheduled for Mondays at 08:00, with a manual trigger option.
• Loads your configuration: Uses settings for your Search Console property, thresholds, and the Webflow collection ID.
• Pulls two 28-day windows from Google Search Console: Fetches page/query performance for the most recent finalized period, then repeats for the preceding 28-day comparison period using the same dimensions.
• Filters and ranks CTR opportunities: Considers non-branded queries with sufficient impressions and targets positions 4–20. Ranks opportunities by estimated click upside and recent impression trend.
• Generates a date-based brief: Builds an HTML brief plus summary metrics and creates an item slug based on the generated date.
• Creates or patches a Webflow draft CMS item: Looks up a matching CMS item by the date-based slug; if it exists, it patches it, otherwise it creates a new draft entry.

Use cases

• SEO teams and SaaS operators who want a weekly pipeline of “CTR lift” opportunities without manual spreadsheet work.
• Automation engineers setting up an ongoing SEO reporting workflow between Google Search Console and Webflow.
• Content teams who need structured briefs stored in Webflow CMS for fast turnaround.

Technical details

• Integrations: Google Search Console Search Analytics API (OAuth2 with webmasters.readonly) and Webflow API (Bearer token via HTTP Header Auth).
• n8n nodes / components used: Schedule Trigger, Manual Trigger, HTTP Request, Code, Set, Sticky Note.