The problem

Cooler Master’s marketing team wanted to spotlight trending products and clear slow-moving inventory with content marketing. But selecting items manually, briefing writers, and producing blogs or social posts took too long, leaving opportunities on the table.

What we built

1. Data audit — Pulled Shopify product and inventory data, focusing on two signals:

   • Best sellers (high order velocity in the past 14 days)

   • Slow movers (stock >30 days with low sell-through rate).

2. Automated selection — Each week, the workflow flagged 3–5 products that fit these criteria.

3. AI content generation — For each product:

   • Draft blog post ideas and outlines.

   • Generate short-form social captions (Instagram, TikTok, Facebook).

   • Align tone and style with Cooler Master’s brand guidelines.

4. Review stage — All AI outputs landed in Google Sheets with a Review/Production toggle.

   • “Review” = content awaiting human edit/approval.

   • “Production” = content cleared for publishing.

5. Content routing — Approved content automatically pushed to a second Google Sheet structured for publishing workflows (blog upload, social media scheduler).

6. Iteration — Weekly edits from the content team fed back into the AI prompt, refining product descriptions and tone alignment.

Results (after 6 weeks)

• Content output increased by 3×, with consistent weekly blogs and posts tied directly to product performance.

• Two slow-moving SKUs cleared 20% of inventory after being featured in content.

• Over 85% of AI-generated captions approved with minimal edits, cutting copywriting time in half.

Stack

Shopify + Google Sheets + n8n + OpenAI 4o mini