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

Description

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:

Loads keywords from Google Sheets with structured format (main keyword + slug)
AI generates articles - Creates 600+ word content following SEO best practices
Creates custom images - Calls a sub-workflow using Gemini 2.5 Flash to generate relevant featured images
Quality validation - Ensures minimum word count; expands content if needed
HTML conversion - Transforms markdown to Webflow-ready HTML
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, content_created, webflow_error_logs
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"

2. Configure your Google Sheet with the recommended structure
Required sheets:
keywords: id, main keyword, head terms, modifiers, slug, status
content_created: id, slug, meta description, content, generatedAt, updated on
webflow_error_logs: keyword, error, timestamp, status

3. Add API credentials:
OpenAI API
OpenRouter API with Gemini access or similar (for image generation)
Webflow OAuth2 API (see Webflow setup instructions in sticky note)
Google Sheets
Google Drive

4. Update workflow configuration:
Google Sheets: Update document IDs in all Google Sheets nodes
Webflow: Set your Site ID and Collection ID in Create/Update Post nodes
Google Drive: Set folder ID in the image generation sub-workflow
AI Image Tool: Verify the "AI Image Generation Tool1" node points to your imported sub-workflow

5. Test with a single keyword:


6. Schedule for production:
Enable the Schedule Trigger (currently set to monthly)
How to customize

Content customization:
Adjust article length in AI Agent prompt (currently 600-800 words)
Modify article structure/sections in the system prompt
Change content tone by editing the AI Agent system message
Add/remove content sections in the prompt template

Image customization:
Change AI model in sub-workflow (currently Gemini 2.5 Flash)
Modify image style/prompt in the AI Image Generation Tool parameters
Update Google Drive destination folder

Webflow customization:
Add custom CMS fields by updating Create/Update Post nodes
Modify field mappings to match your Webflow collection structure
Change draft behavior or add auto-publish logic

Workflow behavior:
Adjust batch size in Loop Over Items node
Modify quality threshold (currently 600 words minimum)
Change error handling/retry logic
Update scheduling frequency in Schedule Trigger