AutomationMart
Home/Browse/Generate SEO blog posts from a keyword list and publish to Webflow
n8n

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

n8nn8n28 modulesv1.0
Google SheetsWebflowOpenAIGoogle DriveGemini

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

At a glance

Generate SEO blog posts from a keyword list and publish to Webflow is a ready-made n8n workflow you import as a workflow JSON file — no build required. It connects Google Sheets, Webflow, OpenAI, Google Drive. It's free to download. Follow the 5-step import below to go live in minutes.

Platform
n8n
Connects
Google Sheets, Webflow, OpenAI, Google Drive, Gemini
Modules
28
Price
Free
Version
v1.0
Generate SEO blog posts from a keyword list and publish to Webflow     workflow diagram

About this workflow

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" 2. Configure your Google Sheet with the recommended structure Required sheets: - keywords: id, main keyword, head terms, modifiers, slug, status - contentcreated: id, slug, meta description, content, generatedAt, updated on - webflowerrorlogs: 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

n8n

How to import this n8n workflow

  1. 1

    Download the workflow JSON file after purchase.

  2. 2

    Open n8n → click the menu → Import from File.

  3. 3

    Select the downloaded JSON and import.

  4. 4

    Set up credentials for each node that requires them.

  5. 5

    Click Execute Workflow to test, then activate.

Setup guide

Setup guide included

Purchase to unlock the full step-by-step guide

Related N8n workflows

Extract key information from Google Drive files via ComPDF AI and save it as form data

Automatically retrieve files from Google Drive, process them with ComPDF AI to extract key information from unstructured content, and convert the results into structured form data. The completed form is then saved back to your Google Drive workspace for easy review, automation, or downstream processing. This template is ideal for workflows that need to turn reports, PDFs, or text-heavy documents into actionable data — without manual copy-paste or form filling. Before you start: Make sure your

Free

Automate email filtering & AI summarization. 100% free & effective, works 7/24

Good to know: This workflow automatically processes incoming emails (you can filter them base on your needs) and creates concise AI-powered summaries, then logs them to a Google Sheets spreadsheet for easy tracking and analysis. Who is this for? ➖Business professionals who receive many emails and need quick summaries ➖Customer service teams tracking email communications ➖Project managers monitoring email correspondence ➖Anyone who wants to automatically organize

Free

Bulk delete HubSpot contacts from uploaded Excel/CSV file

Bulk Contact Deletion from HubSpot via Uploaded Excel / CSV File This workflow allows you to automate the deletion of HubSpot contacts based on email addresses provided in an uploaded Excel (.xlsx) file. It's ideal for bulk-cleaning outdated or invalid contact data. --- ✅ Prerequisites Before using this workflow, ensure you have the following: - A valid HubSpot App Token with permissions to search and delete contacts. - An Excel (.xlsx) file with a column labeled emails containing the contact em

Free

Add people to Capsule CRM from new Google Sheets spreadsheet rows

Every time a new row is added to your Google Sheets spreadsheet, Make will automatically create a new person in Capsule CRM. The template uses this [example spreadsheet](https://bit.ly/2J7Eado).

Free

Automate blog content creation with GPT-4, Perplexity & WordPress

Who Is This For This workflow is ideal for content creators, solo founders, marketers, and AI enthusiasts who want to automate the full process of blog content creation. It is especially useful for professionals in tech, AI, and automation who publish frequently and need SEO-ready content fast. What Problem Does This Workflow Solve - Creating SEO-optimized blog content is time-consuming and requires consistency. - M

Free

AI email assistant: Prioritize Gmail with ChatGPT summaries and Slack digests

This n8n workflow acts as an AI-powered Inbox Assistant that automatically summarizes and classifies Gmail emails, prioritizes important messages, and sends a daily digest to Slack. It’s ideal for startup founders and small teams juggling investor intros, customer leads, and support queries — all from a busy Gmail inbox. Each email is processed using ChatGPT to generate a concise summary, classify the message (e.g., Support, Investor, Spam), and determine its urgency. High and medium priority m

Free

Ads Factory: Generate Unlimited Length UGC AI Video Pipeline

UGC Ads Factory — Automated AI Video Pipeline This n8n workflow tu

Free

Smart CSM assignment & AI welcome emails for HubSpot deal wins with Gmail

Who's it for This template is for Customer Success and Sales teams who use HubSpot. It automates the critical handoff from sales to success, ensuring every new customer gets a fast, personalized welcome. It's perfect for anyone looking to standardize their onboarding process, save time on manual tasks, and improve the new customer experience using AI. What it does This workflow triggers when a deal's "Is closed won" property is set to True in HubSpot. It assigns a Customer Success Manager (CSM)

Free

Reviews

No reviews yet

Be the first to buy and share your experience.

Leave a review

Sign in to share your experience with this workflow.

Log in to review
Free
No ratings yet

Create a free account to purchase workflows.

  • JSON blueprint — instant download
  • Setup guide PDF included
  • 5 downloads · valid 30 days
  • Works with n8n

Need help setting this up?

Book a 3-hour live setup session with an Agility consultant.

₹2,499/ session
3 hrs · video call
  • Configure live on Google Meet / Zoom
  • Free follow-up if workflow has defects
  • Platform expert assigned to you
Book installation session
Free