Seo blog publishing for Jekyll with GPT-4, GitHub & social sharing

🤖 Auto-Publish SEO Blog Posts for Jekyll with AI + GitHub + Social Sharing

This workflow automates the entire process of publishing SEO-optimized blog posts (e.g., recipes) to a Jekyll site hosted on GitHub. It uses LangChain + OpenAI to write long-form Markdown articles, and commits them directly to your repository. Optional steps include posting to X (Twitter) and LinkedIn.

🔧 Features

- 📅 Scheduled Execution: Runs daily or manually. - 📥 CSV Input: Reads from a local CSV (/data/recipes.csv) with fields like title, description, keywords, and publish date. - ✍️ AI Copywriting: Uses a GPT-4 model to generate a professional, structured blog post optimized for SEO in Markdown format. - 🧪 Custom Prompting: Includes a detailed, structured prompt tailored for Italian food blogging and SEO rules. - 🗂 Markdown Generation: - Automatically builds the Jekyll front matter. - Generates a clean SEO-friendly slug. - Saves to posts/YYYY-MM-DD-title.md. - ✅ Commits to GitHub: Auto-commits new posts using GitHub node. - 🧹 Post-Processing: Removes processed lines from the source CSV. - 📣 (Optional) Social media sharing: Can post title to X (Twitter) and LinkedIn.

📁 CSV Format Example

csv titolo;promptdescrizione;keywordprincipale;keywordsecondarie;datapubblicazione Pasta alla Norma;Classic Sicilian eggplant pasta...;pasta alla norma;melanzane, ricotta salata;2025-07-04T08:00:00