workflows.fit
Back to n8n workflows
n8n templateFreeBy Dahiana

Generate SEO blog posts from a keyword list and publish to Webflow

Who's it for Content marketers and SEO specialists who need to generate multiple SEO-optimized articles targeting keyword variations. Ideal for affiliate sites, niche blogs, or service-based businesses creating locati...

Data & StorageProductivityDevelopmentCore NodesMarketingAILangchainAgent
Loading interactive preview...

Template notes

Who's it for Content marketers and SEO specialists who need to generate multiple SEO-optimized articles targeting keyword variations. Ideal for affiliate sites, niche blogs, or service-based businesses creating location/product-specific landing pages.

How it works This workflow automates bulk content creation from keyword list to Webflow draft:

1. Loads keywords from Google Sheets with structured format (main keyword + slug) 2. AI generates articles - Creates 600+ word content following SEO best practices 3. Creates custom images - Calls a sub-workflow using Gemini 2.5 Flash to generate relevant featured images 4. Quality validation - Ensures minimum word count; expands content if needed 5. HTML conversion - Transforms markdown to Webflow-ready HTML 6. Result tracking - Logs success/errors to separate Google Sheets

The workflow includes automatic content expansion, error handling, and uses a separate sub-workflow as a tool for AI image generation.

Important: The subworkflow should be created as an individual one. Then, in the Agent Tool node, you need to select it as the tool. DON'T try to run it inside the same workflow.

Requirements - OpenAI API key (for content generation) - OpenRouter API key or similar (for Gemini image generation via sub-workflow) - Google Sheets with three tabs: keywords, contentcreated, webflowerrorlogs - Webflow site with CMS collection configured - Google Drive folder for image storage - Companion workflow: "AI image generation for automatic content creation" (imported separately and called as a tool)

How to set up

1. Import both workflows separately: - Main workflow: "Bulk SEO content generation and Webflow draft creation with AI images" - Sub-workflow: "AI image generation for automatic content creation"