Step 2: Connect Google Sheets

Configure your sheet read and update nodes to pull product data and write the generated copy back to the same rows.

1. Open Fetch Sheet Records and select your spreadsheet in Document ID (currently [YOUR_ID]).
2. In Fetch Sheet Records, set Sheet Name to Sheet1 (value gid=0).
3. Open Update Sheet Rows and confirm Operation is set to update.
4. In Update Sheet Rows > Columns, map the values exactly as follows: seo_name to {{ $json.output.seo_name }}, product name to {{ $('Resize Product Image').item.json['product name'] }}, seo_description to {{ $json.output.seo_description }}, shopify_description to {{ $json.output.shopify_description }}, and shopify_product_name to {{ $json.output.shopify_product_name }}.
5. Set Matching Columns in Update Sheet Rows to product name.
6. Credential Required: Connect your Google Sheets OAuth2 API credentials in Fetch Sheet Records and Update Sheet Rows.

Step 3: Validate and Prepare Image Inputs

This step checks for missing image URLs, batches items, downloads the image, and resizes it before analysis.

1. Open Image Link Check and confirm the condition checks for empty image links using Left Value set to {{ $json['image link'] }} with the Operator empty.
2. In Batch Through Items, keep default Options unless you want to change batch size.
3. Open Download Image File and set URL to {{ $('Fetch Sheet Records').item.json["image link"] }}.
4. In Download Image File, keep Response Format set to file.
5. Open Resize Product Image and set Operation to resize, Resize Option to percent, Width to 40, and Height to 40.

Step 4: Set Up Vision and Shopify Copy Generation

These nodes analyze the product image and generate Shopify-ready copy using the AI model and structured output.

1. Open Vision Analysis and set Resource to image, Input Type to base64, and Operation to analyze.
2. In Vision Analysis, set Text to the full system prompt provided in the workflow (starting with <system_prompt> YOU ARE A HIGH-PRECISION VISION MODEL... and ending with </system_prompt>).
3. Open Shopify Chat Model and select the model gpt-4.1-mini.
4. Open Shopify Output Parser and set JSON Schema Example to {"shopify_description":"FULL PARAGRAPH CONSUMER COPY","shopify_product_name":"Name"}.
5. Open Shopify Copy Agent and set Text to **AI Generated Vision Description of Product:** {{ $json.content }} **Name of Product:** {{ $('Fetch Sheet Records').item.json['product name'] }} **User Provided Description (If available):** {{ $('Fetch Sheet Records').item.json['user generated description'] }} **Brand Voice:** {{ $('Fetch Sheet Records').item.json['brand voice'] }} **Target Market:** {{ $('Fetch Sheet Records').item.json['target market'] }}.
6. Ensure Shopify Chat Model is connected as the language model for Shopify Copy Agent, and Shopify Output Parser is connected as the output parser for Shopify Copy Agent.
7. Credential Required: Connect your OpenAI credentials in Vision Analysis and Shopify Chat Model.

Step 5: Set Up Merchant Copy Generation and Sheet Updates

This step refines copy with brand voice and writes the final outputs back to Google Sheets.

1. Open Merchant Chat Model and select the model gpt-4.1-mini.
2. Open Merchant Output Parser and set JSON Schema Example to {"shopify_description":"FULL PARAGRAPH CONSUMER COPY","seo_description":"SEO-OPTIMIZED DESCRIPTION, ≤700 CHARACTERS","seo_name":"SEARCHABLE, DESCRIPTIVE TITLE WITH KEYWORDS","shopify_product_name":"Name"}.
3. Open Merchant Copy Agent and set Text to **AI Generated Vision Description of Product:** {{ $('Vision Analysis').item.json.content }} **Name of Product:** {{ $('Resize Product Image').item.json['product name'] }} **User Provided Description (If available):** {{ $('Resize Product Image').item.json['user generated description'] }} **USER PROVIDED BRAND VOICE:** {{ $('Resize Product Image').item.json['brand voice'] }} **PROVIDED SHOPIFY DESCRIPTION:** {{ $json.output.shopify_description }} **PROVIDED SHOPIFY PRODUCT TITLE:** {{ $json.output.shopify_product_name }}.
4. Ensure Merchant Chat Model is connected as the language model for Merchant Copy Agent, and Merchant Output Parser is connected as the output parser for Merchant Copy Agent.
5. Verify the execution flow: Vision Analysis → Shopify Copy Agent → Merchant Copy Agent → Update Sheet Rows → Batch Through Items to loop through items.
6. Credential Required: Connect your OpenAI credentials in Merchant Chat Model.

Step 6: Test and Activate Your Workflow

Run a test to confirm the image processing, AI copy generation, and sheet updates work end-to-end.

1. Click Execute Workflow and ensure a test row in your sheet contains product name, image link, and optional brand fields.
2. Confirm that Download Image File fetches the image and Resize Product Image outputs a resized file.
3. Verify that Shopify Copy Agent and Merchant Copy Agent return structured JSON through their output parsers.
4. Check your sheet to confirm Update Sheet Rows writes to shopify_description, shopify_product_name, seo_description, and seo_name.
5. Once validated, toggle the workflow to Active to enable scheduled and row-added processing.