What This Workflow Does
This automation solves the time-consuming challenge of manually categorizing and tagging blog posts in Astro/Next.js projects. When new content is pushed to GitHub, the workflow automatically analyzes the post using OpenAI GPT-4 to suggest relevant categories and tags based on the content's themes and topics.
The system maintains consistency across your blog by matching new posts to your existing taxonomy. It outputs the results to Google Sheets for easy review and integration with your CMS. This eliminates hours of manual work while improving SEO through consistent, relevant tagging.
How It Works
1. GitHub Trigger
The workflow activates when new markdown files are pushed to your blog repository. It extracts the post content and metadata for processing.
2. AI Analysis
OpenAI GPT-4 analyzes the post content to identify key themes, topics, and technical concepts. The AI references your existing category structure to maintain consistency.
3. Category Assignment
The system assigns primary and secondary categories based on content relevance scores. It also generates relevant tags for SEO optimization.
4. Google Sheets Output
Results are logged in a Google Sheet with the post title, suggested categories, tags, and confidence scores. This creates an auditable record and allows for easy CMS integration.
Pro tip: Use the confidence scores to identify posts that might need manual review. Scores below 80% often benefit from human verification.
Who This Is For
This workflow is ideal for:
- Technical content teams publishing multiple posts weekly
- Developers maintaining documentation blogs
- Marketing teams needing consistent SEO tagging
- Editors managing contributor content
- Teams transitioning between CMS platforms
What You'll Need
- n8n instance (cloud or self-hosted)
- OpenAI API key
- GitHub repository with blog content
- Google Sheets for output
- Existing category taxonomy (recommended)
Quick Setup Guide
- Download the JSON template file
- Import into your n8n instance
- Connect your GitHub, OpenAI, and Google Sheets accounts
- Configure your repository path and output sheet
- Optionally provide sample categorized posts to train the AI
- Test with a new blog post commit
Key Benefits
Saves 2-3 hours per post by eliminating manual categorization work. Editors can focus on content quality rather than taxonomy management.
Improves SEO consistency through standardized tagging across all posts. The AI maintains your category structure even as new contributors join.
Reduces human error in classification. The system objectively analyzes content rather than relying on subjective human judgment.
Creates audit trails in Google Sheets for tracking categorization decisions and model improvements over time.
Adapts to your content by learning from corrections. The more you use it, the better it understands your specific taxonomy needs.