Wöchentliche Search-Console-Berichte mit Claude Haiku an Slack und Sheets senden

## Search Console weekly, with numbers you can trust Every Monday the workflow pulls last week and the week before from the Google Search Console API. Code computes every number (clicks, impressions, CTR, average position, top / new / lost queries and pages) as a numbered list of facts. Claude writes 3–5 short observations from those facts only, and code checks each one: every number must be in the facts it cites, every quoted query or page must exist. The report goes to Slack and one row per week to Google Sheets. ### How it works 1. Six API calls (totals, by query, by page, for both weeks). Data is 3 days behind, so the week ends 3 days ago. 2. Code builds the facts, and says how many impressions have a known query (Search Console hides rare ones). 3. Claude writes observations with the fact ids it used. A failed check is shown with a warning, never hidden. ### Setup 1. In Google Cloud, enable the Google Search Console API in the project of your OAuth client. 2. Create a Google OAuth2 API credential with the scope https://www.googleapis.com/auth/webmasters.readonly. 3. Put your property in Config (sc-domain:example.com or https://www.example.com/). 4. Blank Google Sheet: paste its ID in Spreadsheet ID, run Run once, select the sheet. Pick a Slack channel. ### Customization Change the language, the period, the minimum impressions and the list length in Config.