What I let Claude write, and what I made n8n compute

说明与用途

使用 n8n 的自动化流程，结合 Claude 生成 SEO 页面，经过 Slack 审核和 GitHub 发布，页面成本降低 50%。

问题

Automating the creation and review of SEO pages while minimizing cost and avoiding errors.

结果

The pipeline processes ~50 keywords/month, reduces AI cost per page from $0.23 to $0.11, and ensures only valid pages reach review stages.

工作流

• Read new rows from Google Sheet
• Loop over keywords
• Send keyword to Claude API
• Parse Claude response
• Validate filename, slug, placeholders, memory entry, resource card, read-next block, internal links
• Send approved pages to Slack for SEO review
• If approved, open GitHub branch, commit page, memory, sitemap, resources, token log
• Open pull request
• Web developer merges or returns
• Update status in Google Sheet
• Handle errors: log cost, delete branch, alert via Slack
• Continue loop

证据

A schedule trigger reads the new rows from a Google Sheet. A Loop Over Items node processes keywords one at a time.

来源

A created page goes to the SEO specialist in Slack (send-and-wait form: approve or request changes).

来源

The change that halved the cost: ... output dropped by about two thirds, input context by about 30% (29,142 to 20,660 tokens), and cost per page went from $0.23 to $0.11.

来源