n8n SEO Blog Draft Automation: Google Sheets → Claude → Docs

Turn new SEO keywords into Google Doc blog drafts automatically—every Monday

This 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 Slack channel for human review—then marks each keyword as Drafted in Sheets.

What this workflow does

• Runs weekly every Monday at 8:00am.
• Reads Google Sheets from the “Keywords” tab and selects rows where Status = “New” (e.g., Keyword and Intent, along with KD).
• Processes keywords one at a time and sends the keyword + intent to the Anthropic Claude API to generate a strict-JSON blog post skeleton.
• Parses Claude’s JSON output to prepare a structured draft including the title, meta description, sections, FAQs, and a schema suggestion.
• Creates a Google Doc in your specified folder and inserts the generated blog skeleton content.
• Notifies Slack with the keyword, title, and the Google Doc link so your team can review.
• Updates Google Sheets by setting the matching row’s Status to “Drafted”.

Use cases

• For SaaS operators managing an SEO pipeline: queue new keywords in Google Sheets and review drafts in Slack.
• For automation engineers: standardize blog structure generation with Anthropic Claude while keeping a human-in-the-loop approval step.
• For content teams: rapidly produce consistent blog outlines (title/meta/FAQs/schema) from a keyword backlog.

Technical details

• n8n nodes/integrations: code, http request, google sheets, google docs, slack, sticky note.
• Google OAuth: required for Google Sheets + Google Docs access (use your YOUR_GOOGLE_SHEET_ID and YOUR_DRAFTS_FOLDER_ID).
• Anthropic HTTP Header Auth: configure x-api-key for Claude API requests.
• Slack OAuth: post to your target channel via YOUR_SLACK_CHANNEL_ID (ensure the workflow has permission).