Import WooCommerce products with AI-driven SEO optimization
Workflow Description
Automate product imports from a spreadsheet through advanced language models to generate SEO-optimized descriptions and keywords, then synchronize them directly to WooCommerce in batches with instant Telegram notifications for tracking progress and error handling.
How it works
- 1.Trigger the automation manually and fetch product data from Google Sheets
- 2.Process products through LLM chain to generate optimized descriptions and keywords
- 3.Split products into batches and import them incrementally into WooCommerce
- 4.Send success or error reports via Telegram
Use cases
- Import hundreds of products with search-optimized descriptions in a single workflow
- Update an e-commerce store with new inventory and professional SEO metadata automatically
- Generate diverse or multilingual product content powered by AI without manual editing
Requirements
- Active Google Sheets document with product data (name and base description minimum)
- Live WooCommerce store with API credentials configured
- Telegram account or channel to receive status notifications
- Access to a language model via Open Router
Service Value
Ideal as a smart automation service combining integrations and AI to produce ready-to-use results.
Apps Used
Details
How to Use
- 1.Click "Download Template"
- 2.Open your n8n dashboard
- 3.Go to Workflows > Import from File
- 4.Select downloaded file and configure credentials
Nodes Used (16)
When clicking ‘Test workflow’
Manual Trigger
OpenRouter Chat Model
Lm Chat Open Router
SEO Expert
LLM Chain
Get products
Google Sheets
Map categories
Code
Create product
Woo Commerce
Creation done
Google Sheets
Update meta
Google Sheets
Set SEO meta
Woo Commerce
Loop products
Split In Batches
Send message
Set
Structured Output Parser
Output Parser Structured
Sticky Note
Sticky Note
Sticky Note1
Sticky Note
Sticky Note2
Sticky Note
Sticky Note3
Sticky Note