Automate the content generator for WordPress using
Workflow Description
An automation template that retrieves content data from Google Sheets, processes it through OpenAI to generate optimized articles, and automatically publishes them to WordPress without manual intervention or delays.
How it works
- 1.Trigger the automation manually or on a scheduled interval
- 2.Fetch content topics and keywords from Google Sheets
- 3.Send data to OpenAI API for intelligent content generation
- 4.Format the generated text and add metadata (title, excerpt, tags)
- 5.Publish the completed article to WordPress with proper status and categories
- 6.Log execution results and update the source spreadsheet with publication status
Use cases
- Generate hundreds of marketing articles monthly at minimal cost
- Create SEO-optimized blog content using pre-defined keyword strategies
- Maintain consistent publishing schedule without manual effort
Requirements
- Active OpenAI API key with sufficient credit balance
- WordPress site with proper API permissions for creating posts and managing content
- Organized Google Sheets with content topics, keywords, and target categories
Service Value
Ideal as a smart automation service combining integrations and AI to produce ready-to-use results.
Apps Used
Details
How to Use
- 1.Click "Download Template"
- 2.Open your n8n dashboard
- 3.Go to Workflows > Import from File
- 4.Select downloaded file and configure credentials
Nodes Used (17)
When clicking ‘Test workflow’
Manual Trigger
Get Ideas
Google Sheets
Set your prompt
Set
Create post on Wordpress
Wordpress
Upload image
HTTP Request
Set Image
HTTP Request
Update Sheet
Google Sheets
Sticky Note
Sticky Note
Sticky Note1
Sticky Note
Generate article with DeepSeek
OpenAI
Generate title with DeepSeek
OpenAI
Sticky Note2
Sticky Note
Sticky Note3
Sticky Note
Generate Image with DALL-E
OpenAI
Sticky Note4
Sticky Note
Sticky Note5
Sticky Note
Sticky Note6
Sticky Note