Activate this automation on N8nPort with one click
We have completed the workflow installation, node configuration, and setup for you, so the automation is ready to activate without a manual import or node-by-node configuration.
Quick answers
What platforms does this workflow publish to?
This workflow publishes content to WordPress, Twitter, and dev.to, helping you reach a wider audience across different channels.
How does the workflow gather content ideas?
It gets content ideas and source material by reading RSS news feeds and specific data from Google Sheets, which can include company profiles, online profiles, and categories.
What role do AI agents play in content creation?
AI agents in the workflow handle tasks like defining content tasks, writing articles, performing quality checks, modifying content, and generating blog titles, meta descriptions, and tweets.
Does this workflow store content data?
Yes, it uses MongoDB to store and manage data like news snippets, chat history, and generated articles, which is useful for tracking and retrieval.
Overview
This n8n workflow automates creating and sharing blog posts across WordPress, Twitter, and dev.to. It pulls ideas from RSS feeds and Google Sheets, then uses AI agents powered by ChatGPT and Gemini to write articles, headlines, and social media updates. The process includes quality checks and content adjustments before anything goes live. It's a great tool for content creators and marketers who want to produce a steady stream of content efficiently.
What This Workflow Does
This workflow offers a clear way to create and publish content on multiple platforms. It starts by getting information from RSS feeds and Google Sheets, which can supply relevant news, company data, or content categories. After collecting the data, AI agents turn it into ready-to-publish content.
The AI agents do several key things:
Analyze articles to understand them.
Define specific content writing tasks.
Draft blog articles.
Check the quality of the generated content.
Edit content based on set rules.
Generate creative blog titles.
Write meta descriptions for SEO.
Write tweets for social media promotion.
Once the content is written and polished, the workflow publishes it. This includes creating new posts on WordPress, updating existing posts, sending tweets via Twitter, and publishing articles to dev.to. The whole process is designed to run on a schedule, allowing for consistent content output.
How It Works
The workflow runs through a series of connected nodes, started by a schedule. Multiple Schedule Trigger nodes kick off different parts of the content generation and publishing cycle, ensuring regular updates.
Data comes from RSS Feed Read for news articles and Google Sheets nodes for structured data like company profiles, online profiles, and content categories. This raw data is then processed and normalized.
The core of the workflow is its AI nodes, including Agent, Chain Llm, Lm Chat Open Ai (using models like 'gpt-5-mini', 'gpt-5-nano', and 'chat gpt 4o'), and Embeddings Open Ai. These nodes work together to:
Break down text into smaller pieces using Recursive Character Text Splitter.
Store and pull up background information using MongoDB Atlas Vector Store and MongoDB nodes, which act as a knowledge base and memory for the AI agents.
Handle specific jobs with specialized AI agents like the 'Article Intelligence Agent', 'Task Definition Agent', 'Content Writer Agent', 'Quality Check Agent', 'Content modifier', 'Blog title generator', and 'Meta data generator'.
MongoDB is used a lot in this workflow to save data, storing everything from news snippets and chat history to generated articles and metadata. This lets the AI agents use past information and conversations.
To publish content, the workflow uses WordPress nodes to create and update blog posts, Twitter to create tweets, and HTTP Request nodes to interact with platforms like dev.to and to set images or metatags.
Logic (If nodes) and data handling tools (Code, Set, Split Out, Aggregate, Loop Over Items nodes) make sure content flows correctly, is checked for quality, and is formatted properly for each target platform.
Prerequisites
Before you start, you'll need accounts and credentials for a few services. These are needed for the workflow to get information, use AI to process it, and publish the final content.
Required Applications
Agent
Aggregate
Chain Llm
Crypto
Document Default Data Loader
Embeddings Open Ai
Google Sheets
Http Request
Lm Chat Open Ai
Mongo Db
Rss Feed Read
Split Out
Text Splitter Recursive Character Text Splitter
Tool Think
Tool Workflow
Twitter
Vector Store Mongo DBAtlas
Wordpress
Required Credentials
You'll need to set up these credentials in your n8n account:
Google Sheets OAuth2: This lets the workflow read data from your Google Sheets. You'll set this up by connecting your Google account and giving n8n permission to access your spreadsheets.
OpenAI API key: This key gives you access to OpenAI's language models, which are the brains behind the AI agents. You can get this from your OpenAI account dashboard.
Service-specific API credential (if configured): You might also need API keys or connection strings for MongoDB or other services you connect to with the HTTP Request node. For MongoDB, you'll usually need a connection string from your MongoDB Atlas account. For dev.to or other platforms, you'll need their specific API tokens.
Always keep your API keys and other secrets safe in n8n's credential manager. Don't put them directly in your workflow.
Ready to automate?
The complete installation and configuration are already prepared for your workspace. Activate the preconfigured workflow on N8nPort with one click.
Step-by-Step Setup
To set up this workflow, you'll import it into n8n and then set up each node with your own details and credentials. Here's a general guide:
Import the Workflow: Download the workflow JSON from the source URL and import it into your n8n instance.
Configure Credentials: Go to 'Credentials' in n8n and add your Google Sheets OAuth2, OpenAI API key, and any needed MongoDB or other service credentials. Connect these credentials to the right nodes in the workflow.
Set Up Data Sources:
RSS Feeds: In the 'Read RSS News Feeds' node, add the URLs for the RSS feeds you want to follow.
Google Sheets: Set up the 'Get rss feed', 'Get categories', 'get company profile', and 'get online profiles' Google Sheets nodes to connect to your spreadsheets and the specific data ranges you want to use.
Customize AI Prompts and Logic: Check the 'Agent' and 'Lm Chat Open Ai' nodes. You might want to change the prompts to match your brand's voice and content style.
Configure Publishing Platforms:
WordPress: Set up the 'Create a post1' and 'Update a post' WordPress nodes with your site's URL and authentication details.
Twitter: Set up the 'Create Tweet' node with your Twitter API credentials.
dev.to: Set up the 'dev.to' HTTP Request node with your dev.to API key.
MongoDB Configuration: Make sure all 'MongoDB' nodes are set up with your connection details (e.g., connection string, database name, collection names). This is key for saving and getting your content data.
Review and Activate: Check all the nodes and their settings. When you're ready, activate the workflow. It will then run based on its schedule.
Customization Ideas
You can customize this workflow in a few ways to fit your needs:
Adjust RSS Feeds: Change the RSS feed URLs to focus on topics relevant to your blog.
Expand Google Sheet Inputs: Add more data to your Google Sheets, like keywords or content ideas, to give the AI more context.
Refine AI Prompts: Try different prompts in the AI nodes to adjust the tone and style of the content.
Integrate More AI Models: The workflow uses ChatGPT and Gemini, but you can add other AI models if they fit your strategy better.
Modify Quality Check Criteria: Change the rules in the 'Quality Check Agent' to match your quality standards.
Add More Publishing Platforms: Add more nodes to publish content to other platforms like different social media sites.
Implement A/B Testing: Try out different headlines or summaries to see what gets more engagement.
Limitations and Troubleshooting
This workflow is powerful, but it depends on external services, so there are a few things to keep in mind:
API Rate Limits: Watch out for API rate limits from services like OpenAI and Twitter. Too many requests can cause errors.
AI Output Quality: AI content quality can vary. It's a good idea to check the output regularly and tweak the prompts or quality checks.
Credential Management: If your credentials are wrong or expired, the workflow will fail. Always double-check your API keys and connections.
Data Consistency: Make sure your Google Sheets data is formatted correctly and easy to access. Errors in sheet names or ranges can cause the workflow to fail.
Debugging: If you run into problems, check the n8n execution logs to see which node failed and why. This can help you find issues with credentials, API responses, or data processing.
Frequently Asked Questions
Can I use different AI models than ChatGPT or Gemini?
The workflow is set up with OpenAI models and a call to Gemini. You can change the 'Lm Chat Open Ai' nodes or add new AI model nodes to use other language models that n8n supports.
How often does this workflow run?
The workflow starts with 'Schedule Trigger' nodes. You can set how often they run to match your publishing schedule, whether it's daily, weekly, or something else.
Is it possible to review content before it's published?
Yes, you can add a manual approval step or a notification to the workflow. For example, you could send the content to an email or a chat app for review before it gets published.
What kind of data should I put in Google Sheets?
You can use Google Sheets to store things like RSS feed URLs, content categories, company info, or keywords for the AI to use.
Source and Next Steps
This workflow was first shared by the n8n community. You can find the original workflow and more details at the source URL below:
https://n8n.io/workflows/10079
Explore the workflow, customize it to your specific needs, and begin automating your content creation and distribution.
Activate this workflow on N8nPort
Choose your workspace and activate the fully prepared automation with one click.