Generate and push AI SEO product content to PrestaShop with Google Gemini and Sheets
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 Gemini Chat Model and Google Sheets.
How it runs
Trigger: Manually, when you click “Execute workflow”.
- Get Products (Google Sheets): uses Google Sheets
- Filter: keeps only the items that match a condition
- Limit: keeps the first few items
- Get Product ID (Code): runs custom JavaScript code
- Data (Edit Fields (Set)): sets 3 fields: row_number, Previous, productId
- Loop Over Items (Loop Over Items (Split in Batches)): loops over the items in batches
- AI Agent: runs an AI agent, with model: Google Gemini Chat Model; output parser: Structured Output Parser
- Arrange Data (Edit Fields (Set)): sets 9 fields: title, short_description, long_description…
- Update Product (HTTP Request): calls an HTTP API (PATCH)
- Log In Sheet (Google Sheets): update
…plus 1 more step. 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 (12)
- Filter
n8n-nodes-base.filter - AI Agent
@n8n/n8n-nodes-langchain.agent - Google Gemini Chat Model
@n8n/n8n-nodes-langchain.lmChatGoogleGemini - Limit
n8n-nodes-base.limit - Structured Output Parser
@n8n/n8n-nodes-langchain.outputParserStructured - Edit Fields (Set)
n8n-nodes-base.set - Google Sheets
n8n-nodes-base.googleSheets - Manual Trigger
n8n-nodes-base.manualTrigger - Code
n8n-nodes-base.code - HTTP Request
n8n-nodes-base.httpRequest - Wait
n8n-nodes-base.wait - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches
From the author
Who Is This For? This workflow is built for PrestaShop store owners, eCommerce managers, and digital agencies who need to bulk-generate professional, SEO-optimized product content in Spanish or any other language — without writing a single word manually. ---…