Automate blog content creation from topics to WordPress with AI, Google Drive & Sheets
Transform your editorial calendar into a high-speed publishing engine that handles everything from brand research to SEO-optimized drafting. By linking Google Sheets, OpenRouter, and WordPress, this workflow generates high-quality HTML articles and stores them safely in Google Drive. Stay informed with a final Slack notification once your entire batch of blog posts is ready for review.
Start BuildingWhat This Recipe Does
The Blog Post Content Creation automation streamlines the entire editorial process from initial research to final notification. By integrating Google Sheets for topic management and Google Drive for document storage, this workflow eliminates the manual overhead of managing content pipelines. It automatically processes content requests, handles complex data formatting, and generates structured blog posts based on your specific parameters. Once a draft is prepared and stored, the system instantly notifies your team via Slack, ensuring that stakeholders can review and publish content without delay. This automation is designed to scale your content marketing efforts by removing the friction between ideation and production, allowing your creative team to focus on strategy and refinement rather than administrative tasks and file management.
What You'll Get
Forms, dashboards, and UI components ready to use
Background automations that run on your schedule
REST APIs for external integrations
Google Drive, Bot for Slack, Google Sheets configured and ready
How It Works
- 1
Click "Start Building" and connect your accounts
Runwork will guide you through connecting Google Drive and Bot for Slack
- 2
Describe any customizations you need
The AI will adapt the recipe to your specific requirements
- 3
Preview, test, and deploy
Your app is ready to use in minutes, not weeks
Who Uses This
- Marketing teams looking to scale their organic search presence by maintaining a consistent publishing schedule without increasing headcount.
- Content agencies managing multiple client deliverables who need to centralize draft creation and automate client notifications.
- Internal communications departments that need to transform spreadsheet-based announcements into formal blog posts for company intranets.
Frequently Asked Questions
How do I provide the initial topics for the blog posts?
The automation pulls data directly from a designated Google Sheet where you can list your titles, keywords, and specific instructions.
Where are the final blog drafts stored?
All generated content is automatically saved as new documents in a specified Google Drive folder for easy access and editing.
Can I customize the notification channel?
Yes, you can configure the Slack integration to post updates to specific project channels or send direct messages to editors.
Does this automation handle multiple posts at once?
The workflow includes batch processing capabilities, allowing it to work through a list of multiple content requests in a single execution.
Importing from n8n?
This recipe uses nodes like Set, Code, GoogleDrive, HttpRequest and 8 more. With Runwork, you don't need to learn n8n's workflow syntax. Just describe what you want in plain English.
Based on n8n community workflow. View original
Related Recipes
Local document question answering with Ollama AI, Agentic RAG & PGVector
The n8n Local AI Agentic RAG (Retrieval-Augmented Generation) Template transforms your private business documents into an intelligent, searchable knowledge base. By combining local file processing with advanced AI reasoning, this automation allows your team to query complex internal datasets and receive precise, context-aware answers instantly. Unlike standard search tools, this system understands the nuances of your specific documentation, extracting and summarizing relevant information to provide actionable insights. It eliminates the time wasted manually searching through folders and files, ensuring that your organization's collective intelligence is always accessible. This solution is particularly valuable for businesses that prioritize data privacy, as it manages the ingestion and retrieval process locally while providing a seamless interface for users to interact with their data through a web-based portal.
Local document question answering with Ollama AI, Agentic RAG & PGVector
The n8n Local AI Agentic RAG (Retrieval-Augmented Generation) Template transforms your private business documents into an intelligent, searchable knowledge base. By combining local file processing with advanced AI reasoning, this automation allows your team to query complex internal datasets and receive precise, context-aware answers instantly. Unlike standard search tools, this system understands the nuances of your specific documentation, extracting and summarizing relevant information to provide actionable insights. It eliminates the time wasted manually searching through folders and files, ensuring that your organization's collective intelligence is always accessible. This solution is particularly valuable for businesses that prioritize data privacy, as it manages the ingestion and retrieval process locally while providing a seamless interface for users to interact with their data through a web-based portal.
Generate data pipeline blueprints with Claude 3.5, Slack, and Tavily Search
The ArchitectureAgent automation transforms Slack from a simple messaging tool into a powerful technical design hub. By connecting your Slack workspace directly to your planning workflows, this automation allows teams to capture architectural requirements, system designs, and infrastructure decisions the moment they are discussed. Instead of letting critical technical decisions get buried in chat threads, this agent systematically processes Slack triggers to document and organize complex project structures. This ensures that every stakeholder has immediate access to the latest architectural blueprints, reducing friction between design and implementation phases. For businesses, this means faster project kickoffs, fewer miscommunications during the development lifecycle, and a centralized source of truth for technical documentation that evolves alongside your team's conversations.
Generate data pipeline blueprints with Claude 3.5, Slack, and Tavily Search
The ArchitectureAgent automation transforms your Slack workspace into a collaborative design and technical consultation hub. By bridging the gap between initial concepts and structured execution, this tool automatically processes architectural inquiries or project requirements shared within Slack. Instead of manually documenting discussions or chasing technical specifications, the agent analyzes incoming requests and provides immediate, structured feedback to your team. This ensures that every project starts with a clear technical foundation, reducing the risk of miscommunication and accelerating the transition from planning to development. For businesses managing complex systems or rapid product iterations, this automation eliminates the bottleneck of manual architectural review, allowing senior technical staff to focus on high-level strategy while the AI handles initial scoping and documentation tasks.
Ready to build this?
Start with this recipe and customize it to your needs.
Start Building Now