AI-Powered SEO Blog Post Generation for Jekyll and GitHub - n8n Workflow

Markdown-formatted text.
Content marketers and bloggers who manage static sites (like Jekyll or Hugo).
Developers looking for advanced n8n templates integrating AI agents and GitHub for CI/CD.
Users needing a scheduled n8n workflow to process structured data (CSV) and create custom files.
Anyone seeking to leverage the n8n node ecosystem for end-to-end content automation.

Managing high-volume content for static sites requires consistent scheduling and formatting. This sophisticated n8n workflow solves the content production bottleneck by using advanced AI to generate highly structured, SEO-optimized articles based on input data stored in a simple CSV file.

The system starts with an n8n trigger (schedule or manual run), pulls the required inputs (title, keywords, prompt description), passes them to a specialized Copywriter AI Agent powered by GPT-4o-mini, and then meticulously formats the output with appropriate Jekyll front matter.

Finally, this powerful n8n automation uses the GitHub n8n node to commit the fully prepared Markdown file directly to the Jekyll repository's _posts directory, ensuring immediate deployment. The n8n workflow also includes a critical cleanup step, removing the published entry from the source CSV file, making this n8n template reliable for continuous operation.

Markdown-formatted text.

1. Initiation: The n8n workflow is typically initiated by the Schedule Trigger (running daily at 8:00 AM) or manually via the Start n8n node.


2. Data Ingestion: The Read CSV n8n node fetches the /data/recipes.csv file, and the Extract from File n8n node parses its semicolon-delimited contents.


3. Batch Processing: The Split In Batches n8n node ensures that each recipe entry is processed individually, preventing system overload and ensuring isolated execution.


4. AI Generation: The Copywriter AI Agent n8n node, configured with the gpt-4o-mini model, receives the SEO parameters (title, main keyword, secondary keywords) and executes a detailed prompt to generate a long-form, structured Markdown article.


5. Post Assembly: A crucial Code n8n node calculates the SEO slug, generates the required Jekyll front matter, and merges it with the AI-generated content to create the final, deployable Markdown file. It also defines the exact markdownPath.


6. Scheduling (Optional Delay): The Wait Until Publish n8n node (currently disabled) allows for scheduling publication based on a specific date found in the CSV, pausing the n8n workflow until the specified time.


7. Publication via GitHub: The Commit Markdown n8n node pushes the final, compiled Markdown file to the designated GitHub repository and branch, triggering the static site build process (Jekyll).


8. Cleanup: A second Code n8n node (Remove the processed csv line) reads the original CSV file, identifies the recipe title that was just published, and rewrites the CSV file, excluding the processed entry. This ensures the n8n trigger doesn't process the same content repeatedly.

Markdown-formatted text.

1. Import the n8n workflow: Copy the provided JSON data and paste it into your n8n instance using the 'New' -> 'Import from JSON' option.


2. Credentials Setup: You must provide credentials for the following services:

1. File Preparation: Ensure the recipes.csv file is available in the specified path (/data/recipes.csv) in your n8n environment (or adjust the file path in the Read CSV n8n node).


2. Configuration: Update the GitHub node parameters with your specific repository owner, name, and target branch. Review the AI Agent prompt for specific tone or structure adjustments. Activate the Schedule n8n trigger if you intend for the n8n template to run automatically.

Markdown-formatted text.
Schedule Trigger: The primary n8n trigger, configured to run daily at 8 AM, initiating the content generation cycle.
Read CSV & Extract from File: Reads the raw input CSV file and parses it using a semicolon (;) delimiter, making the raw data accessible to subsequent nodes in the n8n workflow.
Split In Batches: A control flow n8n node that ensures the remaining workflow processes one complete recipe record at a time.
Copywriter AI Agent (with gpt-4o-mini): The core intelligence n8n node. It utilizes a highly detailed, proprietary system prompt specializing in SEO food writing, ensuring the output adheres to specific length, structure, and keyword density guidelines. It leverages the OpenAI n8n node for processing.
Code (Markdown Assembly): This custom n8n node is crucial. It uses JavaScript to generate an SEO-friendly slug, dynamically create the correct Jekyll front matter (title, date, layout), and combine it with the AI output to form the final Markdown content.
Wait Until Publish (n8n node): Designed to pause the n8n workflow until a specific future date derived from the input data, useful for scheduled posts.
Commit Markdown (GitHub): This n8n node performs the deployment action. It takes the compiled Markdown content and commits it to the designated repository path (_posts/YYYY-MM-DD-slug.md), completing the automated publication process.
Remove the processed csv line (Code): A critical file operation n8n node that reads, filters, and overwrites the source CSV file, managing the queue of content and preventing reprocessing.