Weekly Google Search Console Reports to Slack & Google Sheets

Weekly Google Search Console performance—automatically reported to Slack and saved in Google Sheets

Get a clear weekly snapshot of your Google Search Console Search Analytics (two comparable weeks), including verified metrics and AI-written insights—then deliver it straight to Slack and track KPIs in Google Sheets.

What this workflow does

• Runs weekly every Monday morning (or manually), loading your reporting settings such as the Search Console property, date range, output language, and thresholds (e.g., site_url, days, lag_days, min_impressions).
• Builds two date windows (last full week and the prior week) to enable clean comparisons.
• Fetches Search Analytics by making six Google Search Console Search Analytics API requests—covering totals plus breakdowns by query and page for each period.
• Computes metrics and deltas in code, then compiles a numbered “facts” list (including top/new/lost queries and pages).
• Generates observations with Claude (via Anthropic), producing 3–5 short insights that cite the fact IDs they rely on.
• Validates AI output in code by checking that referenced fact IDs are real and that any quoted numbers/queries/pages exist in the cited facts.
• Posts a formatted Slack report to your selected channel and appends/updates a weekly row in Google Sheets.

Use cases

• Marketing and SEO teams who want consistent Google Search Console updates without manual exports.
• SaaS operators tracking organic search trends weekly and sharing results with stakeholders in Slack.
• Automation engineers who need a production-ready n8n workflow that verifies AI-generated insights before publishing.

Technical details

• n8n nodes: set, code, Slack, HTTP request, Google Sheets, sticky note.
• Integrations: Google OAuth2 + Google Search Console API (Search Analytics), Anthropic Claude for observations, Slack for delivery, Google Sheets for KPI tracking.
• Setup requirements: enable the Search Console API in Google Cloud, add Search Console credentials in n8n for the HTTP requests, and configure Google Sheets access.