# AI Shopify Product Builder with Review

**Category:** E-commerce  
**Tools:** Shopify, Google Sheets, n8n  
**Nodes:** 37  
**Built by:** Forgent Systems

Creates complete Shopify products from a photo or a brief. AI writes the copy, generates images and saves everything for review, and approved products are published automatically.

![Workflow](preview.webp)

## How it works

1. A form (or a schedule) supplies the product idea and image.
2. AI vision analyzes the image and drafts the product data.
3. Image prompts are created and a main image plus 3 extra images are generated.
4. The product is saved to a review sheet and the reviewer is emailed.
5. Approved products are published to Shopify and a confirmation is sent.

## Use cases

- Dropshipping and new stores
- Large catalog uploads
- Print-on-demand

## Data setup

**Google Sheets** (tab: columns)

- **AI Product Review → Sheet1**: `title`, `brand`, `price`, `stock`, `description`, `sku`, `vendor`, `product_type`, `tags`, `main_image`, `sub1`, `sub2`, `sub3`, `status`

## Setup

1. In n8n open **Workflows → Import from File** and choose `workflow.json`.
2. Connect these credentials:
   - Gmail account
   - Google Sheets account
   - OpenAI account
   - Shopify account
3. Point the Sheets / Airtable / Drive / Slack nodes at your own resources (structure above).
4. Replace placeholder emails, phone numbers and `YOUR-FORM-ID` links with your own.
5. Times use the America/New_York timezone and dates use MM/DD/YYYY. Adjust if needed.
6. Run a test execution, then activate.

## Nodes

- **Normalize Product Data** — `n8n-nodes-base.set`
- **Download Product Image** — `n8n-nodes-base.httpRequest`
- **Generate Product Data** — `@n8n/n8n-nodes-langchain.openAi`
- **Generate Image Prompts** — `@n8n/n8n-nodes-langchain.openAi`
- **Generate Main Image** — `@n8n/n8n-nodes-langchain.openAi`
- **Generate Sub Image 1** — `@n8n/n8n-nodes-langchain.openAi`
- **Generate Sub Image 2** — `@n8n/n8n-nodes-langchain.openAi`
- **Generate Sub Image 3** — `@n8n/n8n-nodes-langchain.openAi`
- **Publish Product** — `n8n-nodes-base.shopify`
- **Product Input Form** — `n8n-nodes-base.formTrigger`
- **Analyze Product Image (AI Vision)** — `@n8n/n8n-nodes-langchain.openAi`
- **Extract Image Insights** — `n8n-nodes-base.code`
- **Extract Product Data** — `n8n-nodes-base.code`
- **Extract Image Prompts** — `n8n-nodes-base.code`
- **Merge All Generated Images** — `n8n-nodes-base.merge`
- **Prepare Final Product Payload** — `n8n-nodes-base.code`
- **Save Product to Review Sheet** — `n8n-nodes-base.googleSheets`
- **Send Review Email Notification** — `n8n-nodes-base.gmail`
- **Auto Trigger (Every 5 Minutes)** — `n8n-nodes-base.scheduleTrigger`
- **Filter Approved Products** — `n8n-nodes-base.if`
- **Create Product in Shopify** — `n8n-nodes-base.shopify`
- **Add Product Images (Shopify)** — `n8n-nodes-base.httpRequest`
- **Update Variant (Price & SKU)** — `n8n-nodes-base.httpRequest`
- **Set Inventory Quantity** — `n8n-nodes-base.httpRequest`
- **Mark as Published (Google Sheet)** — `n8n-nodes-base.googleSheets`
- **Send Product Published Email** — `n8n-nodes-base.gmail`
- **Sticky Note2** — `n8n-nodes-base.stickyNote`
- **Sticky Note** — `n8n-nodes-base.stickyNote`
- **Sticky Note1** — `n8n-nodes-base.stickyNote`
- **Fetch Pending Products (Google Sheets)** — `n8n-nodes-base.googleSheets`
- **Upload Main Image to cloudinary** — `n8n-nodes-base.httpRequest`
- **Upload Sub Image 1 to cloudinary** — `n8n-nodes-base.httpRequest`
- **Upload Sub Image 2 to cloudinary** — `n8n-nodes-base.httpRequest`
- **Upload Sub Image 3 to cloudinary** — `n8n-nodes-base.httpRequest`
- **Wait** — `n8n-nodes-base.wait`
- **Get Locations** — `n8n-nodes-base.httpRequest`
- **Prepare Product Images Payload** — `n8n-nodes-base.code`
