🎨 ITBlogPros Article Studio

Complete web-based article generation, preview, and publishing workflow

Transform your article creation process from scattered scripts to a beautiful, streamlined web application.


✨ Features

🚀 One-Click Article Generation

👁️ Integrated Preview System

📤 Git Publishing Integration

📊 Article Management Dashboard


🚦 Quick Start

1. Install Dependencies

cd C:\dev\itblogpros\_automation\article-studio
npm install

2. Start the Server

npm start

The server will start on http://localhost:3000

3. Open in Browser

Navigate to: http://localhost:3000

You'll see the Article Studio dashboard! 🎉


📖 How to Use

Generate Your First Article

  1. Enter a Keyword

  2. Click "Generate Article"

  3. Review Results

Preview the Article

  1. Start Preview Server

  2. Navigate Your Site

  3. Make Edits if Needed

Publish to GitHub

  1. Click "Publish" on Article

  2. Confirm Publish

  3. Monitor Status


🔧 Configuration

Environment Variables

Create a .env file in the article-studio directory:

GEMINI_API_KEY=your_gemini_key_here
BING_WEBMASTER_API_KEY=your_bing_key_here

Or use the existing .env in the root project directory.

File Locations


📊 API Endpoints

The web app provides these REST API endpoints:

Articles

Generation

Preview

Publishing


🗄️ Database Schema

Articles are stored in SQLite database:

articles Table

id                INTEGER PRIMARY KEY
keyword           TEXT (original search keyword)
title             TEXT (article title)
content           TEXT (full markdown content)
filename          TEXT (YYYY-MM-DD-slug.md)
quality_score     INTEGER (0-100)
amazon_links      INTEGER (total Amazon links)
valid_amazon_links INTEGER (verified ASINs)
status            TEXT ('draft' or 'published')
created_at        DATETIME
published_at      DATETIME

amazon_links Table

id            INTEGER PRIMARY KEY
article_id    INTEGER (foreign key)
asin          TEXT (Amazon product ID)
product_name  TEXT
is_valid      BOOLEAN
last_checked  DATETIME

🎯 Quality Score Breakdown

The quality score (0-100) is calculated from:

Score Interpretation:


🛠️ Development Mode

Run with automatic restart on file changes:

npm install -g nodemon
npm run dev

📁 Project Structure

article-studio/
├── server.js                 # Express server
├── package.json              # Dependencies
├── public/
│   ├── index.html           # Main UI
│   ├── styles.css           # Styling
│   └── app.js               # Frontend logic
├── services/
│   ├── article-generator.js # Gemini integration
│   ├── amazon-validator.js  # ASIN validation
│   ├── bing-submitter.js    # Bing IndexNow
│   ├── git-publisher.js     # Git operations
│   └── database.js          # SQLite database
└── database/
    └── articles.db          # Article storage

🚀 Workflow Comparison

Before (Manual Process)

  1. Research Bing keywords manually
  2. Run node gemini-article-generator.js
  3. Wait, check for errors
  4. Manually validate Amazon ASINs
  5. Build site: npx @11ty/eleventy --serve
  6. Open browser, navigate to article
  7. Make edits if needed
  8. Stop server
  9. Git add, commit, push manually
  10. Wait for Cloudflare deploy
  11. Submit to Bing manually

Total Time: 15-20 minutes
Steps: 11
Terminal Commands: 4-5

After (Article Studio)

  1. Enter keyword in web UI
  2. Click "Generate Article"
  3. Wait 2-3 minutes (coffee break ☕)
  4. Click "Preview Article"
  5. Click "Publish"

Total Time: 5-7 minutes
Steps: 5
Terminal Commands: 0


🐛 Troubleshooting

Server Won't Start

# Check if port 3000 is in use
netstat -ano | findstr :3000

# Kill process if needed
taskkill /PID <process_id> /F

# Try different port
# Edit server.js line: const PORT = 3001;

Preview Server Stuck

# Stop preview server from UI
# Or manually kill Eleventy:
taskkill /F /IM node.exe

Database Locked

# Close all Article Studio instances
# Delete database lock file:
del C:\dev\itblogpros\_automation\article-studio\database\articles.db-journal

Git Push Fails

# Check git status manually:
cd C:\dev\itblogpros
git status

# If conflicts, resolve manually
git pull
git push

Amazon Validation Slow


🔮 Future Enhancements

Planned Features


📞 Support

Questions? Open an issue or email [email protected]

Bugs? Check article-studio/logs/ directory

Ideas? Submit a feature request!


📝 License

MIT License - Use freely for your ITBlogPros projects!


Built with ❤️ for ITBlogPros by Claude & Grahamm

Making article creation effortless since 2025