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

Input: Google Sheets keyword list → Process: n8n AI Agent generates content + featured image → Output: Webflow drafts + result tracking

Who

Content marketers and SEO specialists who need bulk SEO-optimized articles for long-tail keyword variations

You get

Automatically turn keywords into 600+ word SEO articles with featured images, save as Webflow drafts, and log success/failure results

You need

n8n · google-sheets · google-drive · webflow

Steps

1. Import the main workflow and the image sub-workflow

   Import both workflows into n8n: the main workflow 'Bulk SEO content generation and Webflow draft creation with AI images' and the sub-workflow 'AI image generation for automatic content creation'. The sub-workflow must exist as an individual workflow and be referenced later from the AI Agent Tool node.

   Execution prompt · Source text。Confirm the destination, input variables and output format before use.

   Copy prompt

   =Current date and time: {{$now}}
   
   TASK: Create high-quality SEO content and generate a relevant featured image for the keyword below.
   
   Keyword: {{ $json['main keyword'] }}
   
   Requirements:
   1. Write 600-800 words of engaging, professional but accessible content.
   2. Include the keyword naturally 2-3 times: once in the introduction, once in a subheading, and once in the conclusion.
   3. Create a compelling title (50-60 characters).
   4. Write a meta description (150-160 characters).
   5. Structure the article with clear sections:
      - Introduction
      - Key Benefits
      - How It Works / Practical Advice
      - Conclusion / Next Steps
   6. Target audience: general readers searching for this keyword (not academic or overly technical).
   7. Generate ONE relevant professional image. The image should:
      - Visually represent the keyword topic (not generic SEO/marketing visuals)
      - Use a clean, modern, professional style
      - Be suitable as a blog featured image
      - IMPORTANT: Generate only ONE image per article
   
   CRITICAL: Call the image generation tool exactly ONCE per article. Do not generate multiple images or variations.
   
   8. Provide descriptive **alt text** for the image, optimized for accessibility and SEO.
   
   Output Format:
   Return ONLY this valid JSON structure as raw JSON (no markdown code blocks, no json tags, no extra text, notes, or explanations):
   {
   "title": "SEO optimized title here",
   "slug": "{{ $('Load Pending Keywords').item.json.slug }}", 
   "metaDescription": "Compelling meta description here",
   "content": "Full article content here (600-800 words). CRITICAL FORMATTING REQUIREMENTS: Start with ### Introduction as the first heading. Use ### for ALL section headings (Key Benefits, How It Works / Practical Advice, Conclusion / Next Steps). Write complete paragraphs separated by blank lines. Never mix plain text with markdown formatting. Each section must have substantial content with specific examples and actionable advice. Include the target keyword naturally 2-3 times throughout the content. Ensure consistent markdown structure from start to finish.",
   "main keyword": "{{ $json['main keyword'] }}",
   "imageUrl": "URL from image generation tool", 
   "altText": "Descriptive and SEO-friendly alt text here"
   }
   
   FORMATTING VALIDATION: Before returning JSON, verify that:
   1. Content starts with ### Introduction 
   2. All headings use ### format consistently
   3. Each paragraph is properly separated with blank lines
   4. No mixing of plain text and markdown syntax
   5. Content flows logically between sections
   6. Target keyword appears naturally in introduction and conclusion
   
   CRITICAL: Your response must start with { and end with }. Do not wrap the JSON in markdown formatting or code blocks. Return the raw JSON object only.

   Execution prompt · Source text。Confirm the destination, input variables and output format before use.

   Copy prompt

   You are an expert SEO content writer and AI coordinator. Your responsibilities: Always follow the Agent Prompt exactly. Always generate both content and a relevant professional image. Always return valid JSON only, with no extra commentary or notes. Never skip image generation. Never output incomplete or invalid JSON. Ensure the content is engaging, structured, and optimized for readers searching for the keyword.

2. Configure the Google Sheets structure

   Create or clone the Google Sheet with three tabs: - `keywords`: id, main keyword, head terms, modifiers, slug, status (use status=pending for rows to process) - `content_created`: id, slug, meta description, content, generatedAt, updated on - `webflow_error_logs`: keyword, error, timestamp, status Set the status column to 'pending' for keywords you want to process.

3. Add API credentials

   Configure credentials in n8n: - OpenAI API (content generation) - OpenRouter API or equivalent Gemini access (image generation sub-workflow) - Webflow OAuth2 API (create app in Webflow first: copy Client ID/Secret and OAuth Redirect URL) - Google Sheets OAuth2 - Google Drive OAuth2 Webflow OAuth setup: in n8n, create Webflow OAuth2 API credential and copy the Redirect URL → in Webflow, go to Workspace Settings → Apps & Integrations → Develop → create app → enable Data Client REST API → paste Redirect URL → select CMS collections read-write permissions → paste Client ID/Secret back into n8n.

4. Update workflow node configurations

   Replace placeholder values across nodes: - All Google Sheets nodes: update documentId and sheetName to your sheet - Webflow Create/Update Post nodes: enter your siteId and collectionId - Sub-workflow Google Drive node: set your folderId - AI Image Generation Tool node: verify workflowId points to your imported sub-workflow - Optional: adjust Loop Over Items batch size, Content Quality Check word threshold (default 600), and Schedule Trigger frequency (default monthly)

5. Test with a single keyword

   Keep only one row with status=pending in the keywords sheet and run the workflow manually. Verify: - AI Agent produces valid JSON output with article data - Image sub-workflow returns a Google Drive image link - Content Quality Check passes (≥600 words) - Webflow draft is created successfully - Results are logged to content_created or webflow_error_logs If content is under 600 words, the Expand Content node will automatically call gpt-4o-mini to expand it.

6. Enable scheduled production runs

   After successful testing, enable the Schedule Trigger (default: monthly). The workflow will automatically read all pending keywords, generate articles and images one by one, convert markdown to HTML, create Webflow drafts, update keyword status, and log outcomes. Monitor the webflow_error_logs tab early on.

You are an n8n workflow setup assistant. The user wants to replicate the 'Generate SEO blog posts from a keyword list and publish to Webflow' template. Assist in this order:
1. Confirm the user has an n8n instance and all API credentials ready (OpenAI, OpenRouter/Gemini, Webflow OAuth2, Google Sheets, Google Drive).
2. Guide them to import both the main workflow and the image generation sub-workflow, emphasizing the sub-workflow must remain separate and be selected via the AI Agent Tool node.
3. Help configure the three-sheet Google Sheets structure and sample data.
4. Step through replacing critical parameters: documentId, siteId, collectionId, folderId, and sub-workflow workflowId.
5. Recommend testing with a single keyword first, observing the full chain: Process Agent Output → Content Quality Check → Expand Content (if needed) → Convert to HTML → Create New Post.
6. If JSON parse errors occur, verify the AI Agent output is not wrapped in markdown code blocks; the Process Agent Output node includes cleanup logic, but manual verification is useful.