Generate multilingual Shopify product descriptions with Gemini 2.5 Vision AI

Shopify Multilingual Product Copy with n8n & Gemini 2.5 Flash-Lite Use for free

Created by <Weiser22> · Last update 2025-09-02 Categories: E-commerce, Product Content, Translation, Computer Vision

Description Generate language-specific Shopify product copy (ES, DE, EN, FR, IT, PT) from each product’s main image and metadata. The workflow performs a vision analysis to extract objective, verifiable details, then produces product names, descriptions, and handles per language, and stores the results in Google Sheets for review or publishing.

Good to know - Model: models/gemini-2.5-flash-lite (supports image input). Confirm pricing/limits in your account before scaling. - Image requirement: products should have images[0].src; add a fallback if some products lack a primary image. - Sheets mapping: the sheet node uses Auto-map; ensure your matching column aligns with the field you emit (id vs productid). - Strict output: the Agent enforces a multilingual JSON contract (es,de,en,fr,it,pt), each with shopifyproductname, shopifydescription, handle.

How it works - Manual Trigger: start a test run on demand. - Get many products (Shopify): fetch products and their images. - Analyze image (Gemini Vision): send images[0].src with an objective, 3–5 sentence prompt. - AI Agent (Gemini Chat): merge Shopify fields + vision text under anti-hallucination rules and a strict JSON schema. - Structured Output Parser: validates the exact JSON shape. - Expand Languages & Sanitize (Code): split into 6 items and normalize handles/HTML content as needed. - Append row in sheet (Google Sheets): add one row per language to your spreadsheet.

Requirements - Shopify Access Token with product read permissions. - Google AI Studio (Gemini) API key for Vision + Chat Model nodes. - Google Sheets credentials (OAuth or Service Account) with access to the target spreadsheet.

How to use 1. Connect credentials: Shopify, Gemini (same key for Vision and Chat), and Google Sheets. 2. Configure nodes: - Get many products: adjust limit/filters. - Analyze image: verify ={{ $json.images[0].src }} resolves to a public image URL. - AI Agent & Parser: keep the strict JSON contract as provided. - Code (Expand & Sanitize): emits productid, lang, handle, shopifyproductname, shopifydescription, basehandlees. - Google Sheets (Append): set documentId and tab name; confirm the matching column. 3. Run a test: execute the workflow and confirm six rows per product (one per language) appear in the sheet.

Data contract (Agent output) json { "es": {"shopifyproductname": "", "shopifydescription": "", "handle": ""}, "de": {"shopifyproductname": "", "shopifydescription": "", "handle": ""}, "en": {"shopifyproductname": "", "shopifydescription": "", "handle": ""}, "fr": {"shopifyproductname": "", "shopifydescription": "", "handle": ""}, "it": {"shopifyproductname": "", "shopifydescription": "", "handle": ""}, "pt": {"shopifyproductname": "", "shopifydescription": "", "handle": ""} }