LetMeCrawl
✍️

Content Publishing Automation

Keywords in → SEO articles out. Fully automated from Google Sheets to WordPress, via Claude AI and Google Docs.

12 nodes Every 6 hours Claude claude-opus-4-5 Yoast SEO ready
All Automations
✍️

Content Publishing Automation

This workflow reads keywords from a Google Sheet, generates a full SEO-optimised article (1,200+ words) using Claude AI, saves it as a Google Doc, then creates a WordPress draft post with Yoast SEO metadata pre-filled. After each run it writes the doc link and WP draft link back into the sheet — so the same keyword is never processed twice.

12 nodes Scheduled — every 6 hrs✍️ Claude claude-opus-4-5📊 Google Sheets🌐 WordPress REST API
Download Workflow JSON

How it works — step by step

01
Schedule Trigger — Every 6 Hours
The workflow wakes up automatically every 6 hours and kicks off the pipeline.
02
Read Google Sheet
Reads all rows from your "All Keywords" sheet — each row has a Keyword, Category, Content Type, and search volume.
03
Filter Unprocessed Keywords
Only rows with an empty "Content Link" column pass through — already-processed keywords are skipped automatically.
04
Process 1 Keyword Per Run
A Limit node ensures only a single keyword is processed each run to keep API costs low and avoid rate limits.
05
Claude AI — Generate SEO Article
Sends the keyword, category, and content type to Claude claude-opus-4-5 via the Anthropic API. Claude returns a structured response with title, meta description, slug, focus keyphrase, and full HTML article (1200+ words).
06
Parse Claude Output
A JS Code node extracts the structured fields (TITLE, META_DESCRIPTION, SLUG, FOCUS_KEYPHRASE, ARTICLE) from Claude's plain-text response using regex.
07
Create Google Doc
Creates a new Google Doc in your specified Drive folder, titled with the generated article title.
08
Write Content to Google Doc
Inserts the full article HTML, SEO metadata block, and all fields into the newly created document.
09
Build Doc URL
Constructs the shareable Google Doc URL from the document ID for use in the sheet update.
10
Create WordPress Draft Post
POSTs to the WordPress REST API, creating a draft with the title, HTML content, slug, excerpt, and Yoast SEO meta fields pre-filled.
11
Build WordPress URLs
Constructs the WP admin edit link for the new draft post.
12
Update Google Sheet
Writes the Google Doc link, WP draft link, status ("Done"), and generated title back into the matching row — so that row is skipped on the next run.

What you need

🤖
Anthropic API KeyClaude claude-opus-4-5
📊
Google Sheets OAuthKeywords spreadsheet
📄
Google Docs OAuthOutput folder access
🌐
WordPress REST APIApplication password
⚙️
n8n InstanceSelf-hosted or cloud

Setup guide

  1. 1Import the JSON into n8n via Workflows → Import from file.
  2. 2In the Claude node, replace YOUR_ANTHROPIC_API_KEY with your real key (or use n8n credentials).
  3. 3In Read Google Sheet, connect your Google Sheets OAuth credential and point it to your keyword spreadsheet.
  4. 4In Create Google Doc, set your Drive folder ID where articles should be saved.
  5. 5In Create WordPress Draft Post, replace the URL with your site and update the Authorization header with a Base64-encoded username:application_password.
  6. 6Make sure your Google Sheet has columns: #, Keyword, Category, Content Type, Search Volume, Content Link, WP Draft Link, Status, Generated Title.
  7. 7Activate the workflow — it will run automatically every 6 hours and process one keyword per run.
Never commit your API keys to Git. Use n8n's built-in Credentials manager or environment variables to store sensitive values securely.
Download Workflow JSON