AI Content Generation Agent for WordPress using DeepSeek & DALL-E

Unlock Automated Content Creation for Your WordPress Site with this AI Agent

This n8n AI Agent streamlines your entire content creation pipeline. It starts by pulling content ideas or prompts directly from your Google Sheet. Then, it employs DeepSeek's powerful language model to generate SEO-optimized articles and compelling titles. To make your posts visually appealing, it uses OpenAI's DALL-E 3 to create unique cover images. Finally, it assembles everything into a draft post within your WordPress site and updates your Google Sheet for easy tracking. This is AI-driven automation designed to save you time and scale your content production.

Key Features & Benefits

• Idea Ingestion from Google Sheets: Seamlessly pulls your content prompts from a designated Google Sheet.
• DeepSeek-Powered Article Generation: Leverages the DeepSeek R1 language model to craft well-structured, SEO-friendly articles based on your prompts.
• AI-Generated Titles: Utilizes DeepSeek R1 to create catchy, SEO-optimized titles for your blog posts.
• DALL-E 3 Image Creation: Automatically generates unique, high-quality cover images using OpenAI's DALL-E 3, perfectly matched to your article's theme.
• Automated WordPress Posting: Creates draft posts in your WordPress site, populating them with the AI-generated title and content.
• Featured Image Handling: Uploads the DALL-E generated image to your WordPress media library and sets it as the featured image for the new post.
• Content Tracking: Updates the source Google Sheet with the new WordPress Post ID and generation date, keeping your content calendar organized.
• Scalable Content Production: Ideal for solopreneurs, founders, and content teams looking to automate and scale their WordPress blogging efforts.

• An n8n instance (Cloud or self-hosted).
• Google Sheets API credentials (OAuth2 configured in n8n).
• A DeepSeek API Key.
• An OpenAI API Key (for DALL-E image generation).
• WordPress site with REST API enabled and Application Password credentials.
• A Google Sheet with columns: 'PROMPT' (for article ideas/topics), and optionally 'DATA', 'TITOLO', 'ID POST', 'row_number' for tracking updates by the workflow. The 'row_number' column is used by the template to update the correct row.

1. Download the n8n workflow JSON file.
2. Import the workflow into your n8n instance.
3. Configure 'Get Ideas' (Google Sheets) Node:
   • Authenticate your Google Sheets account.
   • Enter your Google Sheet ID and the specific sheet/tab name (e.g., Sheet1).
   • Ensure your sheet has a column named PROMPT containing your article ideas. The workflow also expects to update columns DATA, TITOLO, ID POST and uses row_number to identify the row.
   • Important: To avoid reprocessing, ensure this node fetches only prompts that need content. You might filter in the node's options (e.g., where 'TITOLO' is empty) or manage this in your sheet.
4. Configure 'Generate article with DeepSeek' Node:
   • Select or create new 'DeepSeek' credentials using your DeepSeek API Key.
   • The model is pre-set to deepseek-reasoner. You can change this if needed.
   • Review and customize the system prompt for article generation to match your desired style and depth.
5. Configure 'Generate title with DeepSeek' Node:
   • Ensure the DeepSeek credentials (from step 4) are selected.
   • Review and customize the prompt for title generation.
6. Configure 'Generate Image with DALL-E' (OpenAI) Node:
   • Select or create new 'OpenAI account' credentials using your OpenAI API Key.
   • Review the prompt for image generation; it uses the AI-generated title as input.
   • Adjust DALL-E settings (e.g., size, style, quality) as needed.
7. Configure 'Create post on Wordpress' Node:
   • Select or create new 'WordpressApi' credentials for your WordPress site (Site URL, Username, Application Password).
   • The post is created as a 'draft' by default; change if necessary.
8. Configure 'Upload image' (HTTP Request) Node:
   • Ensure the WordPress credentials (from step 7) are selected.
   • Update the URL from https://YOURSITE.com/wp-json/wp/v2/media to your actual WordPress site URL.
9. Configure 'Set Image' (HTTP Request) Node:
   • Ensure the WordPress credentials (from step 7) are selected.
   • Update the URL in the expression from https://wp.test.7hype.com/wp-json/wp/v2/posts/... to your actual WordPress site URL.
10. Configure 'Update Sheet' (Google Sheets) Node:
    • Ensure your Google Sheets credentials are selected.
    • Verify the correct Document ID and Sheet Name are used for updating the processed row.
11. Test the Workflow: Run it manually with a sample prompt in your Google Sheet.
12. Automate (Optional): Replace the 'When clicking ‘Test workflow’' trigger with a 'Schedule' trigger (or any other trigger) to fully automate your content generation.
13. Activate the workflow.