Stats
Links
Categories
Auto-discovered marketplace from jithinbathula/shopify-blog-writer-marketplace
npx claudepluginhub jithinbathula/shopify-blog-writer-marketplaceEnd-to-end Shopify blog pipeline — draft posts from an Excel tracker, generate AI featured images, and upload to your store
An end-to-end Shopify blog pipeline plugin — draft posts from an Excel tracker with detailed content briefs, generate AI featured images, and upload everything to your store.
This plugin uses the right component type for each job:
| Component | Type | Purpose |
|---|---|---|
| brand-setup | Skill | Complete plugin setup — company info, credentials, tracker, product docs |
| company-info | Skill | Brand knowledge — product catalog, website URL, brand voice guidelines |
| blog-drafting | Skill | Writing expertise — SEO rules, format templates, content brief interpretation |
| blog-pipeline | Command | Orchestrator — reads tracker, coordinates drafting/image/upload, updates status |
| image-generator | Agent | Autonomous image creation — analyzes blog, crafts prompt, calls API |
| shopify-uploader | Agent | Autonomous upload — assembles payload, pushes to Shopify API |
Three Python scripts handle all deterministic work (API calls, Excel read/write):
| Script | What It Does |
|---|---|
scripts/read_tracker.py | Read next eligible row, update status, mark done |
scripts/generate_image.py | Call OpenRouter API, extract base64 PNG, save to disk |
scripts/upload_to_shopify.py | Authenticate with Shopify, upload article with image and SEO metadata |
The main way to use this plugin. Add rows to your Excel tracker, then run:
/blog-pipeline — process the next pending blog/blog-pipeline all — process all pending blogs sequentially/blog-pipeline 3 — process 3 blogs from the queueThe pipeline reads from Blog Articles/blog-tracker.xlsx, picks the next row by Publishing Priority, drafts the post, generates a featured image, uploads to Shopify, and marks the row as done.
Ask Claude to write a blog post and it will load the company-info and blog-drafting skills automatically:
Ask Claude to generate a featured image and the image-generator agent handles it:
Ask Claude to upload and the shopify-uploader agent handles it:
The pipeline is driven by Blog Articles/blog-tracker.xlsx. Each row is a blog post.
| Column | Description |
|---|---|
| # | Row number |
| Title | Blog post title |
| Author | Author name |
| Length | short / standard / medium-form / long-form |
| Status | planned / pending / in-progress / done |
| Shopify ID | Article ID (filled by pipeline) |
| Shopify URL | URL handle (filled by pipeline) |
| Completed Date | Date processed (filled by pipeline) |
| Column | Description |
|---|---|
| Format | Comparison, Ranked list, How-to guide, Topic guide |
| Target Keyword | Primary and secondary SEO keywords (separated by " / ") |
| Gap Type | Content gap: Competitive, Audience, Depth, Timing |
| Strategic Rationale | Why this article matters for the brand |
| Hidden Intent | The emotional undercurrent driving the searcher |
| Key Arguments | Mandatory talking points (must all appear in the article) |
| Product Tie-In | Which products and protocol bundles to feature |
| Recommended Word Count | Target word count (overrides Length if both present) |
| Recommended Structure | Structural blueprint for the article |
| Publishing Priority | Numeric priority (1 = publish first) |
Add a row with at minimum: Title, Author, and Status = pending or planned. The content brief columns are optional but produce much better results when filled in.
Run the complete setup by saying:
This walks you through everything in one go: