Zum Inhalt springen
ai-agentPro — €97

Ai Product Writer (SEO Titles & Description) for Shopify, Google Merchant Center)

100/100
17 Nodes

Beschreibung

Workflow with 17 nodes using Google Sheets, Split In Batches, HTTP Request...

Setup-Anleitung

## Using This Workflow

This workflow analyzes product images and metadata to generate detailed Shopify and Google Merchant Center (GMC) optimized product descriptions and SEO-enhanced titles.

### How It Works:

1. **Trigger**  
   - Automatically trigger when user uploads product data in Sheet. 

2. **Google Sheets Input**  
   - Loads product data from **Product Description Writer → Sheet1**.

3. **Eligibility Filter (If1 Node)**  
   - Skips products without an `image link`.  
   - Only products **with images** proceed to analysis.

4. **Loop Over Items**  
   - Batches products for sequential processing to prevent rate limits and manage API load.

5. **Image Download**  
   - Downloads the product image using the URL from the `image link` column.

6. **Image Resize**  
   - Resizes the image to 40% for faster AI processing without significant quality loss.

7. **AI Image Analysis (OpenAI Vision Model)**  
   - Uses a specialized GPT-4o-mini agent with a **strict product vision prompt**.  
   - Generates a detailed, objective description of the product’s visual features, including:
     - Product type & function
     - Shape & structure
     - Materials & textures
     - Color scheme
     - Size/scale indicators
     - Surface details
     - Features & usability clues
     - Unique attributes

8. **Shopify Copywriting Agent**  
   - Takes the AI-generated visual description and user-provided metadata.  
   - Generates:
     - **SEO-enhanced Shopify product name**
     - **HTML-formatted Shopify product description**  
   - Optimized for readability, sensory language, and conversion.

9. **Google Merchant Copywriting Agent**  
   - Uses the same inputs to generate:
     - **Google Merchant SEO-optimized description** (≤700 characters, plain tone, no promotional hype).
     - **SEO-rich GMC product title**.

10. **Structured Output Parsing**  
    - Both AI agents’ outputs are parsed into a strict JSON structure before updating the sheet.

11. **Google Sheets Update**  
    - Writes the following fields to Google Sheets:
      - `google product category` (from the original data, if available)
      - `age group` (if available)
      - `color` (if available)
      - AI-generated:
        - `shopify_description`
        - `shopify_product_name`
        - `google_merchant_description`
        - `seo_product_name`

---

Benötigte Integrationen (12)

Google API

Google Sheets

API Key

Split In Batches

Split In Batches

HTTP Request

HTTP Request

API Key

OpenAI

OpenAI

API Key

Lm Chat Open AI

Lm Chat OpenAI

Output Parser Structured

Output Parser Structured

Edit Image

Edit Image

If

If

Sticky Note

Sticky Note

Agent

Agent

Schedule Trigger

Schedule Trigger

Google API

Google Sheets Trigger

API Key

Workflow freischalten

Kaufe das Pro Bundle für €97 — erhalte sofortigen Zugang zu diesem und allen weiteren Starter + Pro Workflows als ZIP-Datei zum Import in n8n.

Sichere Zahlung via Stripe. 7-Tage Geld-zurück-Garantie.
← Zurück zum Marketplace