Automated Blog Post Generation with AI and WordPress Integration
detail.loadingPreview
Automate blog post creation from Google Sheets ideas, using AI for content and image generation, and publishing to WordPress.
About This Workflow
This workflow automates the entire process of blog post creation, starting from fetching unprocessed ideas from a Google Sheet. It leverages AI models (specifically Google Gemini) to generate engaging article content and relevant image keywords. The workflow then searches for suitable images on Pexels, uploads them to WordPress, creates a new post with the generated content and featured image, and finally updates the Google Sheet to mark the post as generated. It also includes a feature to generate new blog topics based on user input and add them to the Google Sheet.
Key Features
- Automated Content Generation: Generates articles based on prompts from a Google Sheet.
- AI-Powered Writing: Utilizes Google Gemini for high-quality, SEO-friendly content generation.
- Image Discovery & Integration: Finds relevant images using Pexels API and sets them as featured images in WordPress.
- WordPress Publishing: Creates and publishes posts directly to WordPress.
- Idea Generation: Can generate multiple blog post topics based on a given theme.
- Workflow Management: Updates a Google Sheet to track processed ideas and provides options to add more topics or end the process.
- Customizable Prompts: Allows for detailed instructions to guide AI content creation (e.g., article structure, formatting, tone).
How To Use
- Google Sheet Setup: Ensure your Google Sheet has the following columns:
Date,Prompt,Title,Post ID,Generated,row_number. TheGeneratedcolumn should initially be set to 'no' for unprocessed ideas. - WordPress Integration: Replace
<YOUR_WORDPRESS_URL>in theUpload ImageandSet Featured Imagenodes with your actual WordPress site URL. - Pexels API Key: In the
Search Pexels Imagenode, replace<YOUR_PEXELS_API_KEY>with your Pexels API key in theAuthorizationheader. - Google Gemini API Key: Configure your Google Gemini API key in the
Gemini Modelnodes. - Workflow Execution:
- The workflow starts with the
Form Trigger: Select Actionnode. Choose 'Generate Content' to process existing ideas or 'Add Ideas' to generate new topics. - If 'Generate Content' is selected, the workflow will fetch unprocessed ideas from your Google Sheet, generate content, find an image, publish to WordPress, and update the sheet.
- If 'Add Ideas' is selected, you'll be prompted to enter a general topic. The workflow will then generate 5 blog topics, add them to your Google Sheet, and ask if you want to add more topics.
- The workflow starts with the
- Monitoring: The
Update Google Sheetnode marks each processed idea as 'yes', and theForm: End Post Generationnode provides a summary of the published posts.
Apps Used
Workflow JSON
{
"id": "e9a01a76-cc45-4463-8bd7-ca26e478133e",
"name": "Automated Blog Post Generation with AI and WordPress Integration",
"nodes": 5,
"category": "Content Creation",
"status": "active",
"version": "1.0.0"
}Note: This is a sample preview. The full workflow JSON contains node configurations, credentials placeholders, and execution logic.
Get This Workflow
ID: e9a01a76-cc45...
About the Author
N8N_Community_Pick
Curator
Hand-picked high quality workflows from the global community.
Statistics
Related Workflows
Discover more workflows you might like
Automated News to Newsletter AI Agents
This workflow automates the process of news aggregation, summarization, and newsletter creation using AI agents.
Automated Content Creation: Google Drive to Social Media with Airtable Tracking
Automatically transcribe audio from videos in Google Drive, generate social media descriptions using AI, and upload to TikTok, Instagram, and YouTube, with detailed tracking in Airtable.
Hacker News to Video Template
Automate content creation by transforming Hacker News articles into engaging videos.