Automated blog generation with Gemini AI, GitHub & Jekyll publishing
## 📝 Use Case
This n8n workflow automates the creation and publication of technical blog posts based on a list of topics stored in Google Sheets. It fetches context using **Tavily** and **Wikipedia**, generates Markdown-formatted content with **Gemini AI**, commits it to a **GitHub repository**, and updates a **Jekyll-powered blog** — all without manual intervention.
Ideal for developers, bloggers, or content teams who want to streamline technical content creation and publishing.
---
## ⚙️ Setup Instructions
### 🔑 Prerequisites
- n8n (cloud or self-hosted)
- Tavily API key
- Google Sheets with blog topics
- Gemini (Google Palm) API key
- GitHub repository (Jekyll enabled)
- GitHub OAuth2 credentials
- Google OAuth2 credentials
### 🧩 Setup Steps
1. **Import** the workflow JSON into your n8n instance.
2. Set up the following credentials in n8n:
- `Tavily API`
- `Google Sheets OAuth2`
- `Google Palm/Gemini AI`
- `GitHub OAuth2`
3. Prepare your **Google Sheet**:
- Columns: `Title`, `status`, `row_number`
- Set `status` to blank for topics to be picked up.
4. Configure:
- GitHub repo and `_posts/` path
- Jekyll setup (front matter, `_config.yml`, GitHub Pages)
5. Adjust prompt/custom parameters if needed.
6. Enable and deploy the workflow. Schedule it daily or trigger manually.
---
## 🔄 Workflow Details
| Node | Function |
|------|----------|
| **Schedule Trigger** | Triggers the flow at a set interval |
| **Google Sheets (Get Topic)** | Fetches the next incomplete blog topic |
| **Extract Topic** | Parses topic text from the sheet |
| **Tavily Search** | Gathers up-to-date content related to the topic |
| **Wikipedia Tool** | Optionally adds more context or images |
| **Summarize Results** | Formats the context for the AI |
| **Gemini AI Agent (LangChain)** | Generates a Markdown blog post with YAML front matter |
| **Set File Parameters** | Prepares the filename, content, and commit message |
| **GitHub Commit** | Uploads the `.md` file to the `_posts/` directory |
| **Update Google Sheet** | Marks topic as `done` after successful commit |
---
## 🛠️ Customization Options
- Change LLM prompt (e.g. tone, depth, format).
- Use OpenAI instead of Gemini by switching nodes.
- Modify filename pattern or GitHub repo path.
- Add Slack/Discord notifications after publish.
- Extend flow to upload images or embed YouTube links.
---
## ⚠️ Community Nodes Used
This workflow uses the following **community nodes**:
- `@tavily/n8n-nodes-tavily.tavily` – for deep search
> ⚠️ Ensure these are installed and enabled in your n8n instance.
---
## 💡 Pro Tips
- Use GitHub Actions to trigger an automatic Jekyll build post-commit.
- Structure blog posts with front matter, headings, and table of contents for SEO.
- Set `Schedule Trigger` to daily at a fixed time to keep content flowing.
- Enhance formatting in AI output using code blocks, images, and lists.
---
## ✅ Example Output
```markdown
---
title: "How LLMs Are Changing Web Development"
date: "2025-07-25"
categories: [webdev, AI]
tags: [LLM, Gemini, n8n, automation]
excerpt: "Learn how LLMs like Gemini are transforming how we generate and deploy developer content."
author: "Saswat Saubhagya"
---
## Table of Contents
- [Introduction](#introduction)
- [Understanding LLMs](#understanding-llms)
- [Use Cases in Web Development](#use-cases-in-web-development)
- [Challenges](#challenges)
- [Conclusion](#conclusion)
...
