How I Automated a Shopify Store with n8n + OpenAI
A deep-dive into building a content automation pipeline that generates SEO-optimized product descriptions at scale.
The Challenge
Managing a Shopify store with thousands of products means writing thousands of product descriptions, meta titles, and blog posts. Doing this manually is slow, inconsistent, and nearly impossible to scale. The store I worked with had over 2,000 SKUs and was spending 40+ hours a week just on content.
The Automation Pipeline
I built an n8n workflow that listens for new products via Shopify webhooks. When a product is added, the workflow pulls its raw data — title, category, images — and sends it to OpenAI's GPT-4 API with a carefully crafted prompt. The prompt includes SEO guidelines, brand voice rules, and formatting instructions. The result is a polished product description, a meta title, and a meta description — all generated in seconds.
Adding a Review Layer
Fully autonomous publishing is risky, so I added a human-in-the-loop step. Generated content lands in a Supabase-backed review dashboard built with Next.js. The team can approve, tweak, or reject each piece before it gets pushed back to Shopify via the Admin API. This gives the team full control while eliminating 85% of the manual effort.
Results
Within the first month, the store saw a 140% increase in organic traffic. Content creation time dropped by 85%, and the team could process over 500 products per week. The automation paid for itself in the first week.
Want to automate something like this?
Let's discuss how automation and AI can transform your business workflows.