# product-generator

> Generate digital products like workbooks, printables, and templates using AI. Use when creating products for Ghost/Gumroad, generating workbook pages, or processing the product queue.

- Author: Shawn Garland
- Repository: shawngarlandgit/neuro-pipeline
- Version: 20260129223835
- Stars: 0
- Forks: 0
- Last Updated: 2026-02-06
- Source: https://github.com/shawngarlandgit/neuro-pipeline
- Web: https://mule.run/skillshub/@@shawngarlandgit/neuro-pipeline~product-generator:20260129223835

---

---
name: product-generator
description: Generate digital products like workbooks, printables, and templates using AI. Use when creating products for Ghost/Gumroad, generating workbook pages, or processing the product queue.
---

# Product Generator Skill

## Overview

Creates digital products (workbooks, printables, templates) using Gemini AI for image generation, ready for sale on Ghost or Gumroad.

## Quick Commands

```bash
# Process pending products in queue
node api/services/product-generator/index.js

# Process limited batch
node api/services/product-generator/index.js --limit=5

# Preview without generating
node api/services/product-generator/index.js --dry-run

# Show queue statistics
node api/services/product-generator/index.js stats
```

## Product Queue

Products are queued in `product_queue` table with:
- `name`: Product name
- `product_type`: printable, template, workbook, etc.
- `design_prompt`: AI generation instructions
- `brand`: Target brand
- `status`: pending, generating, completed, failed

## Image Generation

Uses Gemini AI models:
1. **Gemini 3 Pro** (primary): Better text rendering
2. **Gemini 2 Flash** (fallback): Faster but less accurate text

### For Workbook Pages

The generator creates full 8.5x11 inch printable pages with:
- Large title at top
- 3-4 sections with headers
- Checkbox lists or lined writing spaces
- Minimal visual accents
- Page numbers
- Print-ready layout

## Output Location

Generated images saved to:
```
content-photos/products/
```

File naming: `{type}-{id-prefix}-{timestamp}.{ext}`

## Creating a Workbook

### 1. Add Pages to Queue
```javascript
// Example: Add 5 workbook pages
const pages = [
  { name: 'Page 1: Self-Assessment', design_prompt: 'Create assessment with checkboxes...' },
  { name: 'Page 2: Strategy Framework', design_prompt: 'Create framework with sections...' },
  // ... more pages
];

for (const page of pages) {
  await supabase.from('product_queue').insert({
    name: page.name,
    product_type: 'printable',
    design_prompt: page.design_prompt,
    brand: 'awakened_systems',
    status: 'pending'
  });
}
```

### 2. Generate Images
```bash
node api/services/product-generator/index.js --limit=5
```

### 3. Create PDF
Combine generated images into PDF using any PDF tool.

### 4. Upload to Ghost
- Go to blog.awakenedai.online/ghost
- Create new post
- Add product as paid content

## Fee Comparison

| Platform | Fees | $7 Product Net |
|----------|------|----------------|
| **Ghost + Stripe** | 2.9% + 30¢ | $6.50 |
| Gumroad | 10% + 50¢ + 2.9% + 30¢ | $5.50 |

**Savings**: ~$1 per sale (15% more revenue)

## Key Files

| File | Purpose |
|------|---------|
| `api/services/product-generator/index.js` | Main generator service |
| `content-photos/products/` | Output directory |

## Database

```sql
-- Check queue status
SELECT status, COUNT(*) FROM product_queue GROUP BY status;

-- View pending products
SELECT id, name, product_type, brand FROM product_queue WHERE status = 'pending';

-- Reset failed products
UPDATE product_queue SET status = 'pending' WHERE status = 'failed';
```

## Troubleshooting

- **Garbled text**: Use Gemini 3 Pro instead of 2 Flash
- **Generation failed**: Check GOOGLE_API_KEY in .env.local
- **Rate limited**: Add delay between generations (default 3s)