Auto-generate blog posts to GitHub from sheet
Content: 01486.zip (44.81 KB)
Uploaded: 11.01.2026
Positive responses: 0
Negative responses: 0
Sold: 0
Refunds: 0
$7
# Generate technical blog posts from Google Sheets to GitHub on schedule
This automation template enables fully autonomous creation and publishing of technical blog posts in Markdown format for Jekyll-based websites. Triggered by a cron schedule, it requires only adding a topic to Google Sheets — the rest is handled automatically.
## Who it´s for
- Technical bloggers who want to publish content regularly without manual effort.
- Website owners using Jekyll/GitHub Pages seeking automated publishing.
- Marketers running educational or expert tech blogs.
- Developers creating documentation or educational content.
## What the automation does
- Finds a row with a ´pending´ status in Google Sheets.
- Performs a deep web search using Tavily and Wikipedia to gather context.
- Sends data to Google Gemini via LangChain to generate a structured Markdown post with YAML front matter.
- Commits the file to a GitHub repository with correct naming and directory structure for Jekyll.
- Updates the topic’s status in the sheet to ´done´ upon successful publication.
- Runs on a scheduled basis (e.g., daily via cron).
## What´s included
- Ready-to-use n8n workflow with LangChain agent integration.
- Trigger logic based on cron schedule.
- Integrations with Google Sheets, Tavily, Wikipedia, Google Gemini, and GitHub.
- Basic text instructions for setup and adaptation.
## Requirements for setup
- n8n instance with workflow execution capability.
- API keys for Google Gemini, Tavily, and Wikipedia (public endpoints).
- Access to a Google Sheet with columns: ´topic´, ´status´.
- Access to a private or public GitHub repository with write permissions.
## Benefits and outcomes
- Full automation from idea to published article.
- Time saved on manual research and formatting.
- Consistent content delivery on schedule.
- Jekyll-compatible output with proper metadata.
- Simple content pipeline managed via Google Sheets.
## Important: template only
Important: you are purchasing a ready-made automation workflow template only. Rollout into your infrastructure, connecting specific accounts and services, 1:1 setup help, custom adjustments for non-standard stacks and any consulting support are provided as a separate paid service at an individual rate. To discuss custom work or 1:1 help, contact via chat
This automation template enables fully autonomous creation and publishing of technical blog posts in Markdown format for Jekyll-based websites. Triggered by a cron schedule, it requires only adding a topic to Google Sheets — the rest is handled automatically.
## Who it´s for
- Technical bloggers who want to publish content regularly without manual effort.
- Website owners using Jekyll/GitHub Pages seeking automated publishing.
- Marketers running educational or expert tech blogs.
- Developers creating documentation or educational content.
## What the automation does
- Finds a row with a ´pending´ status in Google Sheets.
- Performs a deep web search using Tavily and Wikipedia to gather context.
- Sends data to Google Gemini via LangChain to generate a structured Markdown post with YAML front matter.
- Commits the file to a GitHub repository with correct naming and directory structure for Jekyll.
- Updates the topic’s status in the sheet to ´done´ upon successful publication.
- Runs on a scheduled basis (e.g., daily via cron).
## What´s included
- Ready-to-use n8n workflow with LangChain agent integration.
- Trigger logic based on cron schedule.
- Integrations with Google Sheets, Tavily, Wikipedia, Google Gemini, and GitHub.
- Basic text instructions for setup and adaptation.
## Requirements for setup
- n8n instance with workflow execution capability.
- API keys for Google Gemini, Tavily, and Wikipedia (public endpoints).
- Access to a Google Sheet with columns: ´topic´, ´status´.
- Access to a private or public GitHub repository with write permissions.
## Benefits and outcomes
- Full automation from idea to published article.
- Time saved on manual research and formatting.
- Consistent content delivery on schedule.
- Jekyll-compatible output with proper metadata.
- Simple content pipeline managed via Google Sheets.
## Important: template only
Important: you are purchasing a ready-made automation workflow template only. Rollout into your infrastructure, connecting specific accounts and services, 1:1 setup help, custom adjustments for non-standard stacks and any consulting support are provided as a separate paid service at an individual rate. To discuss custom work or 1:1 help, contact via chat
No feedback yet