Generate AI product marketing photos from Google Sheets with Google Gemini and Drive
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
What this workflow does
This AI workflow has 14 nodes and runs manually, when you click “Execute workflow”. Along the way it connects Google Sheets, Google Drive, Google Gemini Chat Model and Google Gemini.
How it runs
Trigger: Manually, when you click “Execute workflow”.
- Read Image URLs (Google Sheets): uses Google Sheets
- Download Images (HTTP Request): calls an HTTP API
- Merge: merges the data from its input branches
- Download model image (Google Drive): download
- Analyze an image (Google Gemini): analyze (image)
- Merge: merges the data from its input branches
- Product Photography Prompt (Basic LLM Chain): sends a prompt to an LLM, with model: Google Gemini Chat Model
- Loop Over Items (Loop Over Items (Split in Batches)): loops over the items in batches
- Edit an image (Google Gemini): edit (image)
- Upload to Drive (Google Drive): uses Google Drive
…plus 2 more steps. See the full node list below.
Services it uses
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (10)
- Merge
n8n-nodes-base.merge - Google Sheets
n8n-nodes-base.googleSheets - HTTP Request
n8n-nodes-base.httpRequest - Basic LLM Chain
@n8n/n8n-nodes-langchain.chainLlm - Google Drive
n8n-nodes-base.googleDrive - Manual Trigger
n8n-nodes-base.manualTrigger - Google Gemini Chat Model
@n8n/n8n-nodes-langchain.lmChatGoogleGemini - Google Gemini
@n8n/n8n-nodes-langchain.googleGemini - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - Edit Fields (Set)
n8n-nodes-base.set
From the author
1. How it works Reads product image links from a Google Sheet. Analyzes each image, generates an AI prompt, and combines the product with a human model image. Creates final AI advertising photos and: Saves images to Google Drive. Saves prompts + result links…