{"product_id":"n8n-seo-blog-draft-automation-google-sheets-claude-docs","title":"n8n SEO Blog Draft Automation: Google Sheets → Claude → Docs","description":"\u003ch3\u003eTurn new SEO keywords into Google Doc blog drafts automatically—every Monday\u003c\/h3\u003e\n\u003cp\u003eThis n8n SEO Blog Draft Automation workflow pulls “New” keywords from Google Sheets, asks Anthropic Claude to generate a strict-JSON blog skeleton, saves the draft to a Google Doc, and pings your \u003cstrong\u003eSlack\u003c\/strong\u003e channel for human review—then marks each keyword as \u003cstrong\u003eDrafted\u003c\/strong\u003e in Sheets.\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 at \u003cstrong\u003e8:00am\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReads Google Sheets\u003c\/strong\u003e from the \u003cem\u003e“Keywords”\u003c\/em\u003e tab and selects rows where \u003cstrong\u003eStatus = “New”\u003c\/strong\u003e (e.g., Keyword and Intent, along with KD).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eProcesses keywords one at a time\u003c\/strong\u003e and sends the keyword + intent to the \u003cstrong\u003eAnthropic Claude API\u003c\/strong\u003e to generate a \u003cstrong\u003estrict-JSON\u003c\/strong\u003e blog post skeleton.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eParses Claude’s JSON output\u003c\/strong\u003e to prepare a structured draft including the \u003cstrong\u003etitle\u003c\/strong\u003e, \u003cstrong\u003emeta description\u003c\/strong\u003e, \u003cstrong\u003esections\u003c\/strong\u003e, \u003cstrong\u003eFAQs\u003c\/strong\u003e, and a \u003cstrong\u003eschema suggestion\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCreates a Google Doc\u003c\/strong\u003e in your specified folder and inserts the generated blog skeleton content.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNotifies Slack\u003c\/strong\u003e with the keyword, title, and the \u003cstrong\u003eGoogle Doc link\u003c\/strong\u003e so your team can review.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eUpdates Google Sheets\u003c\/strong\u003e by setting the matching row’s \u003cstrong\u003eStatus to “Drafted”\u003c\/strong\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eFor SaaS operators managing an SEO pipeline: queue new keywords in Google Sheets and review drafts in Slack.\u003c\/li\u003e\n  \u003cli\u003eFor automation engineers: standardize blog structure generation with Anthropic Claude while keeping a human-in-the-loop approval step.\u003c\/li\u003e\n  \u003cli\u003eFor content teams: rapidly produce consistent blog outlines (title\/meta\/FAQs\/schema) from a keyword backlog.\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\/integrations:\u003c\/strong\u003e code, http request, google sheets, google docs, slack, sticky note.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGoogle OAuth:\u003c\/strong\u003e required for Google Sheets + Google Docs access (use your \u003cstrong\u003eYOUR_GOOGLE_SHEET_ID\u003c\/strong\u003e and \u003cstrong\u003eYOUR_DRAFTS_FOLDER_ID\u003c\/strong\u003e).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAnthropic HTTP Header Auth:\u003c\/strong\u003e configure \u003cstrong\u003ex-api-key\u003c\/strong\u003e for Claude API requests.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSlack OAuth:\u003c\/strong\u003e post to your target channel via \u003cstrong\u003eYOUR_SLACK_CHANNEL_ID\u003c\/strong\u003e (ensure the workflow has permission).\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45899969790131,"sku":"N8N-18687","price":36.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/RRSakp-ccsaQxdpiSn__9_w3IjqxrK.png?v=1787735949","url":"https:\/\/buyflowscripts.com\/products\/n8n-seo-blog-draft-automation-google-sheets-claude-docs","provider":"N8N Commerce","version":"1.0","type":"link"}