{"product_id":"weekly-google-search-console-reports-to-slack-google-sheets","title":"Weekly Google Search Console Reports to Slack \u0026 Google Sheets","description":"\u003ch3\u003eWeekly Google Search Console performance—automatically reported to Slack and saved in Google Sheets\u003c\/h3\u003e\n\u003cp\u003eGet 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 \u003cstrong\u003eSlack\u003c\/strong\u003e and track KPIs in \u003cstrong\u003eGoogle Sheets\u003c\/strong\u003e.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns weekly\u003c\/strong\u003e every Monday morning (or manually), loading your reporting settings such as the Search Console property, date range, output language, and thresholds (e.g., \u003ccode\u003esite_url\u003c\/code\u003e, \u003ccode\u003edays\u003c\/code\u003e, \u003ccode\u003elag_days\u003c\/code\u003e, \u003ccode\u003emin_impressions\u003c\/code\u003e).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eBuilds two date windows\u003c\/strong\u003e (last full week and the prior week) to enable clean comparisons.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFetches Search Analytics\u003c\/strong\u003e by making \u003cstrong\u003esix\u003c\/strong\u003e Google Search Console Search Analytics API requests—covering totals plus breakdowns by \u003cem\u003equery\u003c\/em\u003e and \u003cem\u003epage\u003c\/em\u003e for each period.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eComputes metrics and deltas in code\u003c\/strong\u003e, then compiles a numbered “facts” list (including top\/new\/lost queries and pages).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGenerates observations with Claude\u003c\/strong\u003e (via Anthropic), producing 3–5 short insights that cite the fact IDs they rely on.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eValidates AI output in code\u003c\/strong\u003e by checking that referenced fact IDs are real and that any quoted numbers\/queries\/pages exist in the cited facts.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003ePosts a formatted Slack report\u003c\/strong\u003e to your selected channel and \u003cstrong\u003eappends\/updates a weekly row\u003c\/strong\u003e in Google Sheets.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eMarketing and SEO teams who want consistent \u003cstrong\u003eGoogle Search Console\u003c\/strong\u003e updates without manual exports.\u003c\/li\u003e\n  \u003cli\u003eSaaS operators tracking organic search trends weekly and sharing results with stakeholders in \u003cstrong\u003eSlack\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003eAutomation engineers who need a production-ready \u003cstrong\u003en8n workflow\u003c\/strong\u003e that verifies AI-generated insights before publishing.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n nodes\u003c\/strong\u003e: set, code, Slack, HTTP request, Google Sheets, sticky note.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegrations\u003c\/strong\u003e: Google OAuth2 + Google Search Console API (Search Analytics), Anthropic Claude for observations, Slack for delivery, Google Sheets for KPI tracking.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSetup requirements\u003c\/strong\u003e: enable the Search Console API in Google Cloud, add Search Console credentials in n8n for the HTTP requests, and configure Google Sheets access.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46232384864435,"sku":"N8N-21067","price":26.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/URMKmZgShvdjztbzQwtVi_4LB2EzxY.png?v=1792141586","url":"https:\/\/buyflowscripts.com\/products\/weekly-google-search-console-reports-to-slack-google-sheets","provider":"N8N Commerce","version":"1.0","type":"link"}