workflows.fit
Back to n8n workflows
n8n templateFreeBy Davide Boizza

Automate content generator for WordPress with DeepSeek R1

This workflow is designed to generate SEO-friendly content with DeepSeek R1 (or V3), publish it on WordPress, and update a Google Sheets document with the details of the created post. Below is a detailed analysis of w...

Data & StorageProductivityDevelopmentCore NodesMarketingAILangchainManual Trigger
Loading interactive preview...

Template notes

This workflow is designed to generate SEO-friendly content with DeepSeek R1 (or V3), publish it on WordPress, and update a Google Sheets document with the details of the created post. Below is a detailed analysis of what each node in the workflow does:

--- How It Works 1. Triggering the Workflow: - The workflow starts with a Manual Trigger node, which is activated when the user clicks "Test workflow" in the n8n interface.

2. Fetching Data: - The Get Ideas node retrieves data from a Google Sheets document. It reads a specific sheet and filters the data based on the "ID POST" column, returning the first matching row.

3. Setting the Prompt: - The Set your prompt node extracts the PROMPT field from the Google Sheets data and assigns it to a variable for use in subsequent steps.

4. Generating Content: - The Generate article node uses an AI model (DeepSeek) to create an SEO-friendly article based on the prompt. The article includes an introduction, 2-3 chapters, and a conclusion, formatted in HTML. - The Generate title node uses the same AI model to generate a concise, SEO-optimized title for the article.

5. Publishing on WordPress: - The Create post on WordPress node creates a new draft post on WordPress using the generated title and article content.

6. Generating and Uploading an Image: - The Generate Image node creates a photorealistic image based on the article title using an AI model (OpenAI). - The Upload image node uploads the generated image to WordPress as a media file. - The Set Image node assigns the uploaded image as the featured image for the WordPress post.

7. Updating Google Sheets: - The Update Sheet node updates the original Google Sheets document with the post details, including the title, post ID, creation date, and row number.