Automate Shopify product CSV from images using Gemini, GPT-4o, Google Drive & Sheets

by MANISH KUMAR ✓ · 309 views · created 2025-12-24 · Content Creation, Multimodal AI

What this workflow does

This AI workflow has 139 nodes and runs on a schedule (every day) (plus 5 other triggers). Along the way it connects Google Drive, Google Gemini, Google Sheets and Google Gemini Chat Model and 1 more. It also calls 1qzkpy-1s.myshopify.com and shopify-staged-uploads.storage.googleapis.com over HTTP.

How it runs

Trigger: On a schedule (every day) (plus 5 other triggers).

1. Get row(s) in sheet (Google Sheets): uses Google Sheets
2. query_folder_name (Edit Fields (Set)): sets 1 field: folder_name
3. pending_image_to analyze (Google Sheets): uses Google Sheets
4. Get row(s) in sheet (Google Sheets): uses Google Sheets
5. get product data (Google Sheets): uses Google Sheets
6. get finalized data (Google Sheets): uses Google Sheets
7. Loop Over Items (Loop Over Items (Split in Batches)): loops over the items in batches
8. Search_folders (Google Drive): work with file folder
9. Loop Over Items (Loop Over Items (Split in Batches)): loops over the items in batches
10. Loop Over Items (Loop Over Items (Split in Batches)): loops over the items in batches

…plus 65 more steps. See the full node list below.

Services it uses

Google DriveGoogle GeminiGoogle SheetsGoogle Gemini Chat ModelOpenAI Chat Model

HTTP calls to: 1qzkpy-1s.myshopify.com, shopify-staged-uploads.storage.googleapis.com

Before you upgrade to n8n 3.0

Nodes used (20)

• Manual Triggern8n-nodes-base.manualTrigger
• HTTP Requestn8n-nodes-base.httpRequest
• Google Driven8n-nodes-base.googleDrive
• Google Gemini@n8n/n8n-nodes-langchain.googleGemini
• Schedule Triggern8n-nodes-base.scheduleTrigger
• Loop Over Items (Split in Batches)n8n-nodes-base.splitInBatches
• Google Sheetsn8n-nodes-base.googleSheets
• Coden8n-nodes-base.code
• No Operation, do nothingn8n-nodes-base.noOp
• Edit Fields (Set)n8n-nodes-base.set
• Sortn8n-nodes-base.sort
• n8n Form Triggern8n-nodes-base.formTrigger
• AI Agent@n8n/n8n-nodes-langchain.agent
• Simple Memory@n8n/n8n-nodes-langchain.memoryBufferWindow
• Auto-fixing Output Parser@n8n/n8n-nodes-langchain.outputParserAutofixing
• Structured Output Parser@n8n/n8n-nodes-langchain.outputParserStructured
• Google Gemini Chat Model@n8n/n8n-nodes-langchain.lmChatGoogleGemini
• Waitn8n-nodes-base.wait
• Switchn8n-nodes-base.switch
• OpenAI Chat Model@n8n/n8n-nodes-langchain.lmChatOpenAi

From the author

Shopify AI Automation Image-to-Product CSV Bulk Upload Automation This Shopify AI automation is an advanced n8n-powered workflow that converts raw product images into a Shopify-ready product CSV. It uses AI image analysis, Google Drive, Google Sheets, and…

View the original on n8n.io → Check your own copy